Summary

• Description:

  The MS Word document comprises KCSE 2024 Computer Studies Paper 2 Prediction Paper with Answers (Set 5). 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 rigorously tests hands-on competence in database management and desktop publishing design. Candidates are evaluated on relational database design, data manipulation through advanced queries and grouped reports, and desktop publishing layouts requiring precise page setup and typography.

  • Month Administered: July/August 2024
  • Duration: 2½ Hours
  • Number of Questions: 2 (Questions 1 - 2)
  • Structure: Two practical tasks; Question 1 on Database Systems and Question 2 on Desktop Publishing

  It covers the following topics:

  • Question 1: Database Management Systems (BIASHARA Sacco Database)
    • Database Creation, Field Definition, Data Types, and Currency Formatting
    • Primary Key Assignment and Relational Table Linkages
    • Data Entry Automation using Interactive Forms
    • Information Retrieval: Select Queries with Filtering Criteria
    • Calculated Query Expressions for Trip Earnings
    • Summary and Grouped Financial Reporting (INCOME Report) and Print Setup
  • Question 2: Desktop Publishing (Event Invitation Card Design)
    • Publication Setup: Orientation, Measurement Units, Custom Margins, and Multi-Fold Card Geometry
    • Typography, Decorative Frames, Text Formatting, and Text Boxes
    • Graphic Layout Composition: Two-Page Front and Back Symmetrical Event Card Printing
• File Size:

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