Summary

• Description:

  The MS Word document comprises Mangu High School 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 Mangu High School Endterm 2 Computer Studies Paper 2 practical examination.

  This hands-on examination evaluates practical proficiencies in relational database design, data validation, report generation, and desktop publishing document formatting.

  • Duration: 2 Hours
  • Number of Questions: 2 (Questions 1 and 2)
  • Structure: Compulsory practical paper consisting of two comprehensive tasks covering Database Management Systems (Question 1) and Desktop Publishing (Question 2).

  It covers the following topics:

  • Database Management Systems (Microsoft Access):
    • Creation of relational database structures and table schemas (DETAILS and PERFORMANCE tables)
    • Field property definitions, character validation rules, and lookup wizards
    • Relationship modeling using primary and foreign keys with enforced referential integrity
    • Data entry forms and custom action controls (print and close buttons)
    • Query design: wildcard text extraction, calculated total fields, descending sort orders, and multi-criteria filters
    • Grouped summary reports featuring dormitory averages and layout formatting
  • Desktop Publishing (Microsoft Publisher):
    • Page setup configuration (A4 portrait, 2cm margins) and graphic design styling
    • Typography: custom font sizes, text tracking, character spacing, alignment, and granite background textures
    • Layout formatting: multi-column setups, dashed column borders, vertical column dividing rules, and 4-line drop caps
    • Vector graphic banners, rotated text effects, and print layout preparation
• File Size:

  403.90 KB
• Length:

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