Stages
Just playMission 1/5
Ask the sheet questions
Nothing is scored here. Press things and see what changes.
Do thisMission 2/5
The middle of two marks
Do thisMission 3/5
The best and the worst
Do thisMission 4/5
Average every row with formulas
Do thisMission 5/5
A range that reaches the last row
★★★
Run cleared.
🚀 Push it
- 🟢Add a third test and keep every formula right.
- 🟡Find the best and worst in the second test too.
- 🔴Explain why an average of averages can mislead.
🌐 Make it for real
Open a blank Google Sheet and build the sample results sheet from an empty grid.
Twist: set Dara's Test 1 mark to 100, then 30, and watch her average, the best and worst follow.
🧑🏫 Teacher Guideclick to open
⏱ 52218
✅ Watch for
- Averages worked out by hand and typed in
- Ranges that miss the last row
- MIN and MAX pointed at the wrong column