What a spreadsheet is, how cells, rows, columns and sheets are addressed, how to enter data and build formulae with the correct order of operations, and how to use SUM, AVERAGE, MAX, MIN, COUNT, IF, ROUND and other built-in functions.
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.
A spreadsheet recalculates by itself. Change one number and every formula depending on it updates. This lesson shows how to build those formulae.
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.
File / one grid within it.
Column letter then row number: B3.
Block of cells: B2:B5.
Starts with =, uses cell addresses.
+ − * / ^ with BODMAS order.
SUM, AVERAGE, MAX, MIN, COUNT, ROUND, TODAY.
=IF(condition, true value, false value).
Changing a cell updates all formulae that use it.
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 (11 marks in total). Show all your working — method marks count. Your answers are saved on this device.
Question 1 [11 marks]
The spreadsheet below holds marks for four students: Maths in column B and English in column C, with Total in D and Average in E.
(a) (a) Write the formula for cell D2 to find Anil’s total mark. [2]
(b) (b) Write the formula for E2 using a function. [2]
(c) (c) Write a formula to find the highest Maths mark. [2]
(d) (d) Write a formula for F2 that shows “Pass” if the average is 50 or more and “Fail” otherwise. [3]
(e) (e) State two advantages of using a spreadsheet instead of a calculator for this task. [2]
Find these in your own past-paper booklets for extra timed practice. Items above are written in the style of these papers; any adapted from a specific question say so.