Warm-up (30 seconds): Open your Digital Portfolio folder from Lesson 6. Find your Numbers Sheet (budget, timeline, survey, or inventory). What's one formula you used? Does it do real work for your project?
Today you'll upgrade your spreadsheet from Lesson 6 into KA1-quality evidence. Every formula must solve a real problem for your Something Real project.
| Formula | Purpose | Example |
|---|---|---|
| {{formula:=SUM(range)}} | Total costs/items | {{formula:=SUM(B2:B10)}} — total budget |
| {{formula:=AVERAGE(range)}} | Average cost per item | {{formula:=AVERAGE(C2:C10)}} — avg price |
| {{formula:=IF(condition, true, false)}} | Decision trigger | {{formula:=IF(B11>500, "Over budget", "OK")}} |
| {{formula:=ROUND(number,0)}} | Clean numbers | {{formula:=ROUND(B11,0)}} — no decimals |
| {{formula:=CEILING(number,significance)}} | Round up to next whole | {{formula:=CEILING(23/5,1)}} = 5 |
Sample: School talent show. Goal: Check if €400 budget covers 23 tickets × €5.
Sample: 10 survey responses in column B. Goal: Average > 7/10?
See img_009 (budget), img_010 (survey) showing column insertion.
Next step: Pick one example that matches YOUR project type.
Review your Lesson 6 Numbers Sheet using this diagnostic checklist. Fix errors as you find them. Google Sheets users: Do all your edits here first. Download final .xlsx version at end of lesson (step 6).
You're previewing this lesson. Get full access to this lesson and hundreds more — each one ready to teach, with interactive activities, printable resources and pupil progress tracking built in.