The Computer Studies (ICT) Paper 2 Practical Examination is a high-scoring component of the ECZ Grade 9 junior secondary national exams. Candidates are tested on hands-on computer speed, document formatting, spreadsheet formulas, and slide design.
For ICT Candidates
Save your work every 5 minutes using Ctrl + S! Examiners cannot award marks for un-saved documents if power outages occur in the computer lab.
1. File Management & Lab Setup
- Folder Creation: Right-click Desktop $\rightarrow$ New Folder $\rightarrow$ Name with your Examination Index Number (e.g., `2600123456`).
- File Naming: Save each question response into your folder using exact filenames specified on the question paper (e.g., `Question1_Word.docx`).
2. Word Processing (MS Word) Tasks
Key Text Formatting Skills
- Font & Paragraphs: Changing font face, font size, bold, italics, underline, line spacing (1.5 / double), and paragraph justification.
- Page Layout: Setting page margins (1 inch), orientation (Portrait vs Landscape), page borders, headers and footers (inserting page numbers and candidate name).
- Tables & Images: Inserting tables, merging cells, applying cell shading, inserting pictures, and applying text wrapping (Square/Tight).
3. Spreadsheets (MS Excel) & Formulas
Essential Excel Operations
- Formulas: Always begin with an equal sign (`=`):
- `=SUM(B2:B10)` — Adds total values in range.
- `=AVERAGE(C2:C10)` — Calculates mean score.
- `=MAX(D2:D10)` and `=MIN(D2:D10)` — Finds highest and lowest values.
- `=IF(E2>=50, "PASS", "FAIL")` — Evaluates logical condition.
- Formatting & Charts: Formatting currency values (`K` for Kwacha), applying cell borders, and inserting 2D Column or Pie Charts with clear titles and legends.
Keyboard Shortcut Master List
Memorize speed shortcuts: **Ctrl + C** (Copy), **Ctrl + V** (Paste), **Ctrl + Z** (Undo), **Ctrl + A** (Select All), **Ctrl + B** (Bold), **Ctrl + S** (Save).
Teacher Strategy
Conduct timed 45-minute mock lab drills where students practice typing unformatted text sheets and applying specified formatting instructions rapidly.
Frequently Asked Questions
Q1: What software applications are tested in the ECZ Grade 9 ICT practical exam?
The exam tests three main applications: Word Processor (MS Word), Spreadsheet (MS Excel), and Presentation Software (MS PowerPoint), alongside Operating System file management (folder creation, renaming, saving).
Q2: What essential Excel formulas must Grade 9 candidates know?
Key formulas include =SUM(range), =AVERAGE(range), =MAX(range), =MIN(range), =COUNT(range), and simple logical =IF(condition, value_if_true, value_if_false).
Q3: How should candidates save their files during the ICT practical exam?
Candidates must create a folder on the Desktop named with their Exam Index Number, save all files into that folder using specified filenames, and press Ctrl + S regularly to avoid data loss.
Prepare for Grade 9 ICT Practical Exams
Download past practical question files, Excel data sheets, and lab revision guides on ECZ Solutions.
Get ICT Practical Resources