How Paper 02 is built (four compulsory structured questions, 90 marks, 2 hours), command words, how to write steps for software tasks, how to answer algorithm and trace-table questions, and a mini mock to self-mark.
5 narrated scenes. Press play, listen and read along — the points appear as they are explained. Use ‹ Prev / Next › or the scene bar to jump to any scene.
Paper 02 carries 45% of your grade. Marks are won by precise terms, correct steps for software tasks, and neat algorithms and trace tables.
Narration uses your device’s built-in voice. No sound? Switch to “Captions only” — the captions advance on their own.
Copy these into your notebook in your own words — that is how they stick.
2 h; 4 compulsory questions; 90 marks; 45% of the grade.
Theory 35, Productivity tools 30, Problem solving and programming 25.
State, describe, explain, distinguish, justify, outline.
Tab/menu + tool + order.
Give the exact formula.
Pseudocode, flowchart, trace table.
Difference for BOTH items.
≈ 1.3 min per mark.
8 items modelled on real CSEC Paper 1 questions. Choose one answer for each, then check. Aim for 80% or better. Work each item on paper first.
Write full answers, then reveal the mark scheme and tick the points you earned (20 marks in total). Show all your working — method marks count. Your answers are saved on this device.
Question 1 [12 marks]
A club secretary stores members in a database table Member(MemberID, Name, Parish, Fee) and keeps fees in a spreadsheet with Fee in column C, rows 2 to 11.
(a) (a) Write a spreadsheet formula to find the total of all fees. [2]
(b) (b) Write a formula for D2 that adds 15% VAT stored in cell F1 so that it can be copied down. [2]
(c) (c) Describe how to produce a query listing members from “Kingston” who owe more than $500. [4]
(d) (d) State the primary key of the table and give a reason. [2]
(e) (e) Distinguish between a form and a report. [2]
Question 2 [8 marks]
Algorithm: 1) a ← 3; 2) b ← 0; 3) WHILE a <= 6: 4) b ← b + a; 5) a ← a + 1; 6) ENDWHILE; 7) OUTPUT b.
(a) (a) Complete a trace table with columns a, b and output. [5]
(b) (b) State what the algorithm does. [1]
(c) (c) State the type of error that gives a wrong total because the operator is < instead of <=. [2]
Everything in this lesson is based on these parts of the CXC syllabus and papers.