Checklists with screenshot-style diagrams for the spreadsheet and database parts of the SBA: formulae, functions, absolute references, pivot tables, charts, linked sheets, queries, forms and reports.
4 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.
These two components are 20 of the 50 SBA marks. Both are checklists, so follow the list and print the evidence.
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 sheets; 3 functions; 3 formulae; 2 absolute; sort; filter; pivot; chart; link.
≤ 3 tables; 2 queries; calculation; form + sub-form; grouped report.
Values + formulas; design + results.
Name the feature on each printout.
Primary and foreign keys with relationship.
Query field or spreadsheet formula.
Save copies.
On every page.
3 quick games on this lesson. Earn XP and badges as you play — your best score for each game is saved. Games are for practice and do not change your exam readiness. More games in the Information Technology Arcade.
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 (10 marks in total). Show all your working — method marks count. Your answers are saved on this device.
Question 1 [10 marks]
A candidate builds a spreadsheet and a database for a school canteen.
(a) (a) List four features required in the SBA spreadsheet. [4]
(b) (b) List four objects required in the SBA database. [4]
(c) (c) State two ways of presenting evidence of the formulae. [2]
Everything in this lesson is based on these parts of the CXC syllabus and papers.