Summary

• Description:

  The MS Word document comprises RCEA JOINT Computer Studies 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 Studies Paper 2 practical mock examination designed to test hands-on skills in word processing and spreadsheet applications. It assesses document layout design, chart integration, complex spreadsheet modeling, nested conditional logic, data filtering, and summary statistics under timed conditions.

  • Duration: 2 Hours 30 Minutes
  • Total Marks: 100
  • Number of Questions: 2 (Question 1 and Question 2)
  • Structure: Question 1 (50 marks, advanced word processing and embedded charting) and Question 2 (50 marks, spreadsheet analysis, logical functions, and data validation).

  It covers the following topics:

  • Word Processing:
    • File management and document formatting (drop caps, bolding, typography)
    • Multi-row and multi-column table creation and cell alignment
    • Headers and footers insertion, styling, and center alignment
    • Section breaks and mixed page orientations (Portrait and Landscape sections)
    • Data visualization: inserting and formatting bar charts with custom backgrounds and captions
    • Page borders and page numbering configurations
  • Spreadsheets:
    • Worksheet creation, renaming, and cell data entry
    • Date and time arithmetic: age computation derived from application and birth dates
    • Data validation rules restricting application dates
    • Cell formatting: currency formats (Ksh) and numerical display settings
    • Nested logical functions (IF, AND) for multi-condition eligibility evaluation
    • Automated loan awarding calculations based on eligibility thresholds
    • Data filtering and conditional extraction into dedicated summary sheets
    • Conditional aggregation using COUNTIF/SUMIF for gender-based loan totals
    • Chart design: generating proportional pie charts for comparative loan distribution
• File Size:

  24.80 KB
• Category:

  Mock Past Papers
• Level:

  Form 4
• Subject:

  Computer Studies
• Posted By:

  Caleb_Peter

Enter your details below to initiate a payment using MPESA.