Summary

• Description:

  The PDF document comprises the Computer Studies Paper 2 (Practical) Maseno School Mock Exam as a KCSE Trial Exam, administered on Wednesday, 17th July 2024. The marking scheme is in a different document.

  This practical paper consists of two compulsory questions, one on Spreadsheets and the other on Databases. Each question is worth 50 marks, making a total of 100 marks for the paper, which has a duration of 2 hours.

  The paper assesses the following practical skills:

  • 1. Spreadsheets (50 marks): This question requires candidates to create and manage a business worksheet. The tasks involved test a wide range of skills, including:
    • Data entry and worksheet formatting.
    • Using formulae and functions (such as PRODUCT and nested IF functions).
    • Applying data validation rules to specific cells.
    • Creating and formatting charts (line graph) on a separate worksheet.
    • Managing data by inserting rows, copying worksheets, and filtering records based on specific criteria.
  • 2. Databases (50 marks): This question requires candidates to create and manage a database for a firm. The tasks assess the ability to:
    • Create a database with multiple tables.
    • Define appropriate data types and set primary keys.
    • Establish relationships between tables and enforce referential integrity.
    • Create forms for user-friendly data entry.
    • Modify table structures by adding new fields.
    • Perform data manipulation by creating and running queries to extract specific information.
    • Generate and format a professional report based on the database content.
• File Size:

  1.27 MB
• 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.