Summary

• Description:

  The MS Word document comprises ELITE EXAMINATIONS Computer Paper 2 2026 Mock Exam with Answers (Marking Scheme). The PDF version is also available upon your request. The marking scheme is in a different document.

  It was a KCSE Computer 451/2 examination.

  This practical examination provides rigorous hands-on assessment in relational database management systems and electronic spreadsheet modeling. It tests essential practical competencies including advanced query building, custom database form and report generation, multi-criteria nested formulas, cell formatting, and workbook management.

  • Month Administered: July, 2026
  • Duration: 2 ½ Hours
  • Total Marks: 100 Marks
  • Number of Questions: 2 Questions (Question 1 and Question 2)
  • Structure: The paper consists of two compulsory practical questions carrying 50 marks each.

  It covers the following topics:

  • Database Management Systems (MS Access):
    • Table design, field definitions, and data entry for employee records
    • Constructing select queries using relational criteria, logical operators (AND/OR), and wildcards
    • Building calculated query fields for percentage salary increments and complex age filtering
    • Designing datasheet forms and customized design-view forms with calculated totals and dynamic headers
    • Designing and formatting printable summary reports
  • Spreadsheets (MS Excel):
    • Worksheet construction, data entry, and structural modeling of voter registration records
    • Formulas for computing un-registered voter counts and rounded percentages
    • Nested logical IF functions for dynamic conditional remarks
    • Statistical aggregation functions including COUNTIF, SUM, and AVERAGE
    • Advanced cell formatting with compound border styles and merged headers
    • Worksheet duplication, sheet renaming, and custom header insertion
• Category:

  Mock Past Papers
• Level:

  Form 4
• Subject:

  COMPUTER STUDIES

Enter your details below to initiate a payment using MPESA.