Summary

• Description:

  The PDF document comprises STAREHE GIRLS' CENTRE Computer Studies Paper 2 Pre Mock Exam with Answers (Marking Scheme). The marking scheme is in a different document.

  It was a Pre-mock Computer Studies Paper 2 (Practical) examination.

  This hands-on practical paper assesses core competencies in spreadsheet manipulation and desktop publishing design. Candidates are evaluated on complex data analysis, formula calculations, conditional logic, publication formatting, and print preparation.

  • Duration: 2 1/2 Hours
  • Total Marks: 100
  • Number of Questions: 2 (Questions 1 - 2)
  • Structure: Two compulsory practical tasks carrying 50 marks each: Question 1 covers advanced spreadsheet data processing and filtering, while Question 2 covers desktop publishing (DTP) layout and design.

  It covers the following topics:

  • Section A:
    • Spreadsheet data entry, row insertions, header centering, and formatting
    • Statistical formulas and functions (Mean formatted to two decimal places, Position ranking, Maximum and Minimum values)
    • Logical IF and nested condition testing for recruitment qualification criteria
    • Counting criteria using functions (COUNTIF)
    • Worksheet management, data duplication, and record filtering
    • Data visualization (bar chart generation, titles, axis labels, and legends)
    • Desktop publishing using Microsoft Publisher (page margins, A4 portrait setup, and typography tracking/spacing)
    • Page layout styling (multi-column text flow, bulleted content boxes, graphic borders, and promotional flyer design)
• File Size:

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