Summary

• Description:

  The MS Word document comprises KCSE 2026 Computer Studies Paper 2 Prediction Paper with Answers (Set 1). 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 prediction examination designed to prepare candidates for the national assessment.

  This practical paper evaluates hands-on mastery in advanced word processing, desktop typography, relational database design, data manipulation, calculated queries, and report generation.

  • Duration: 2 Hours 30 Minutes
  • Number of Questions: 2 (Questions 1 - 2)
  • Structure: Two compulsory practical questions carrying equal marks: Question 1 (Word Processing) and Question 2 (Relational Database Management System).

  It covers the following topics:

  • Question 1 (Word Processing - 21st Century Learning Design):
    • Document Layout and Text Formatting (Exact text transcription, typography, paragraph alignment, search and replace utility)
    • Document Organization and Navigation (Automated Table of Contents generation with customized heading levels)
    • Table Manipulation and Layout (Complex grid design, cell borders, text double spacing)
    • Formulae and Calculated Cells (Embedded spreadsheet table functions: AVERAGE, GRAND TOTAL, MIN/Lowest, MAX/Highest)
    • Mathematical Equation Typography (Insertion of formatted exponent and polynomial fraction expressions)
    • Page Setup and Document Output (Running headers, duplex printing specifications)
  • Question 2 (Database Management - Sinai Video Store):
    • Table Design and Schema Definition (Creating Members, Rental, and Movie tables with appropriate primary and foreign keys)
    • Data Integrity and Relationships (Establishing one-to-many entity relationships across tables)
    • Data Entry Interfaces (Designing customized user input forms for seamless data entry)
    • Calculated and Parameter Queries (New Monthly Charges calculation with 8% tariff increment, date-filtered Latest Movies query, Total Gain query aggregating movie income)
    • Report Generation and Summarization (Categorical grouping of film records, summary sub-totals and grand totals, header typography and report layout printing)
• File Size:

  117.00 KB
• Length:

  5 pages
• Category:

  KCSE Prediction Papers
• Level:

  Form 4
• Subject:

  Computer Studies
• Posted By:

  Caleb_Peter

Enter your details below to initiate a payment using MPESA.