Summary

• Description:

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

  It was a KCSE Computer Studies Paper 2 (451/2) practical mock examination designed for Form Four students.

  This hands-on practical paper tests critical skills in advanced spreadsheet modeling, financial formula calculations, dynamic logic functions, data sorting and filtering, and desktop publishing layout design.

  • Month Administered: July 2026
  • Duration: 2 Hours 30 Minutes
  • Total Marks: 100 Marks (50 Marks per question)
  • Number of Questions: 2 Questions (Questions 1 and 2)
  • Structure: Two compulsory practical questions covering Spreadsheets (Question 1) and Desktop Publishing (Question 2)

  It covers the following topics:

  • Question 1 (Spreadsheets - Microsoft Excel):
    • Data entry, cell formatting, merging and centering titles, and table borders
    • Formula design: calculating item sales, gross sales, and net sales using arithmetic operators
    • Absolute cell referencing for conditional commission calculations
    • Built-in statistical functions: AVERAGE, MAX, MIN, and COUNTIF
    • Statistical ranking using the RANK function
    • Logical modeling using nested IF functions for performance grading
    • Data manipulation: worksheet replication, descending multi-criteria sorting, and auto-filtering
    • Conditional arithmetic using the SUMIF function
    • Data visualization: creating, titling, and labeling column charts
    • Page setup: landscape orientation, customized headers, and dynamic page footers
  • Question 2 (Desktop Publishing):
    • Page layout and setup: A4 portrait page setup, margin spacing, and unit measurement configuration
    • Graphic design: sports day invitation flyer design and formatting
    • Typography and text formatting: title styling, font hierarchy, alignment, and spacing
    • Layout scaffolding: structured event schedule tables, text boxes, and decorative borders
• File Size:

  917.89 KB
• Length:

  4 pages
• Category:

  Mock Past Papers
• Level:

  Form 4
• Subject:

  Computer Studies
• Posted By:

  Caleb_Peter

Enter your details below to initiate a payment using MPESA.