Summary

• Description:

  The MS Word document comprises KCSE 2026 Computer Studies Paper 2 Prediction Paper with Answers (Set 2). 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 hands-on practical examination measures mastery of advanced spreadsheet processing and desktop publishing (DTP) design through structured, real-world data manipulation tasks and publication layouts.

  • Duration: 2 Hours 30 Minutes
  • Total Marks: 100
  • Number of Questions: 2 (Questions 1 and 2, 50 Marks Each)

  It covers the following topics:

  • Question 1: Spreadsheet Data Management (Electronic Spreadsheet)
    • Worksheet Setup, Title Formatting, Centering, and Bolding
    • Cell Bordering and Record Insertion
    • Arithmetic Formulas and Mathematical Functions
    • Logical Nested IF Functions for Dynamic Transport Rate Calculations
    • Absolute and Relative Cell Referencing in Deductions
    • Currency Formatting, Decimal Precision, and Custom Prefixes
    • Data Sorting and Ascending Alphabetical Order
    • Data Filtering using Relational Criteria
    • Subtotals Functionality by Grouping Areas
    • Embedded Chart Creation: Custom Pie Chart Formatting, Legends, and Titles
    • Page Setup and Print Orientation Configuration
  • Question 2: Desktop Publishing (DTP)
    • Page Setup: A4 Portrait Dimensions, Column Guides, Row Guides, and Margins
    • Geometric Shape Drawing and Precision Dimensioning
    • Graphic Fills, Line Styles, and Custom Color Formatting
    • Shape Effects: Outline Shadows, Newsprint Texture Fills, Glow Effects, and Transparency
    • Typography: Font Styling, Colors, Custom Line Spacing, Strikethrough, and Dotted Underlines
    • Object Manipulation: Layering, Alignment, and Object Grouping
    • Page Layout Elements: Headers, Layout Consistency, and Output Printing
• File Size:

  212.00 KB
• Length:

  4 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.