Stages
Just playMission 1/6
Meet the class results sheet
Nothing is scored here. Press things and see what changes.
Do thisMission 2/6
Average every student, rounded
Do thisMission 3/6
Best, worst and how many
Do thisMission 4/6
Sort first, then chart
Do thisMission 5/6
Formulas that follow the marks
Do thisMission 6/6
Sort by average, freeze, shade
★★★
Run cleared.
🚀 Push it
- 🟢Build the same sheet for your own class.
- 🟡Add a fourth test and keep every formula right.
- 🔴Hand it over and have someone change one mark.
🌐 Make it for real
Open a blank Google Sheet and build the sample results sheet from an empty grid.
Twist: give one student full marks, watch the best and the chart follow, then sort again.
🧑🏫 Teacher Guideclick to open
⏱ 53010
✅ Watch for
- Averages or best marks typed instead of worked out
- A chart of the class in list order instead of best first
- Sorted by one test instead of the average