Summary

• Description:

  The PDF document comprises MUSJET Computer Studies Paper 2 2026 Pre-Mock Exam with Marking Scheme. The marking scheme is in a different document.

  It was a KCSE Computer Studies Paper 2 practical examination designed to test hands-on competence in database management systems and electronic spreadsheets. It offers ideal practice files and marking scheme guidance for students preparing for practical exams.

  • Month Administered: July 2026
  • Duration: 2 Hours 30 Minutes
  • Total Marks: 100
  • Number of Questions: 2 (Questions 1–2)
  • Structure: Practical computer laboratory exam consisting of two compulsory comprehensive scenarios (Database Management and Electronic Spreadsheets)

  It covers the following topics:

  • Question 1: Database Management Systems (MS Access)
    • Table creation and data structure design (Patients, Doctors, Consultations)
    • Primary key assignment and relational integrity establishment
    • Data entry form design
    • Parameter and calculated field queries (Age calculations, doctor-specific filtered details)
    • Grouped report generation with headers/footers and consultation summaries
  • Question 2: Electronic Spreadsheets (MS Excel)
    • Worksheet creation, formatting, merging, and cell styling
    • Data manipulation and row insertions
    • Statistical function applications (AVERAGE, MIN, COUNTIF)
    • Ranking and position calculation using formulas
    • Logical grading using nested IF statements
    • Subtotals feature application by category
    • Chart creation (Pie chart on a separate worksheet)
• Category:

  Mock Past Papers
• Level:

  Form 4
• Subject:

  COMPUTER STUDIES
• Posted By:

  Caleb_Peter

Enter your details below to initiate a payment using MPESA.