Summary

• Description:

  The MS Word document comprises Form 3 Computer Studies Paper 2 End Term 3 2026 Exam with Marking Scheme. The PDF version is also available upon your request. The marking scheme is in a different document.

  This hands-on practical assessment rigorously tests competencies in advanced spreadsheet data manipulation, formula formulation, charting, relational database schema design, and query/report generation. It is ideal for end-of-year school-based national assessment preparation towards the end of the term, and can also be effectively administered as a mid-term assessment for schools that have completed the syllabus early at the beginning of the term.

  • Duration: 2½ Hours
  • Total Marks: 100 Marks
  • Number of Questions: 2 Questions (1 – 2)
  • Structure: Question 1 (Spreadsheets - 50 Marks) and Question 2 (Relational Databases - 50 Marks); both questions compulsory

  It covers the following topics:

  • Spreadsheet design, data validation rules, custom input error messages, and workbook sheet management
  • Application of mathematical formulas to compute individual and aggregated sales figures
  • Nested logical IF functions to calculate conditional bonus points and determine tiered performance awards
  • Text formatting, label rotation angles (-90°), and custom font styling
  • Generation, customization, and sheet placement of column charts from sales data
  • Relational database table creation, data typing (AutoNumber, Date/Time, Currency, Text), and primary key assignments
  • Form creation and data entry interface design for employee records
  • Table structure modification and setting up table relationships with referential integrity
  • Query formulation using complex criteria (multiple grade filters) and field sorting
  • Creation and styling of columnar reports featuring header customizations and grand total summary functions
• File Size:

  35.09 KB
• Category:

  Exams
• Level:

  Form 3
• Subject:

  Computer Studies
• Posted By:

  Caleb_Peter

Enter your details below to initiate a payment using MPESA.