Summary

• Description:

  The MS Word document comprises LANJET Computer Studies Paper 2 2026 Pre-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 LANJET Computer Studies Paper 2 examination.

  This practical paper evaluates hands-on application skills in complex spreadsheet analysis, statistical modelling, formula logic, and relational database management systems.

  • Month Administered: July 2026
  • Duration: 2 Hours
  • Total Marks: 100 Marks
  • Number of Questions: 2 Questions (Questions 1 and 2, 50 marks each)
  • Structure:
    • Question 1 (50 Marks): Advanced Spreadsheets practical (Kimakania High School KCSE results analysis)
    • Question 2 (50 Marks): Relational Database Management Systems practical (Mchango fundraising system)

  It covers the following topics:

  • Spreadsheets (Question 1):
    • Data entry, cell formatting, and workbook saving
    • Formula implementation for average points and student ranking
    • Logical nested IF grading criteria implementation
    • Statistical summary tables (grade counts, maximum/minimum grade occurrences, subject averages, and percentage pass rates)
    • Data visualization (bar chart creation and formatting)
    • Page setup, header/footer configuration, and spreadsheet printing
  • Databases (Question 2):
    • Relational database table creation and primary/foreign key relationships (Class List, Family Details, Pledge Contributions, Walk Form Contributions)
    • Table data entry and field validation
    • Parameter and calculation queries (promising criteria, full payment verification, balance calculations)
    • Tabular and grouped report generation based on multi-table queries
    • Form creation for user data entry and database documentation printing
• Category:

  Mock Past Papers
• Level:

  Form 4
• Subject:

  COMPUTER STUDIES
• Posted By:

  Caleb_Peter

Enter your details below to initiate a payment using MPESA.