Stages
Just playMission 1/6
Fifty answers waiting on one tab
- Fifty students answered a survey, and every answer sits on one tab.
- Fold them with a pivot, count by two tests, draw a chart.
Do thisMission 2/6
Responses on one tab, answers another
Do thisMission 3/6
Summarize first, then draw the chart
Do thisMission 4/6
Two tests inside one count
Do thisMission 5/6
The same number on every tab
Do thisMission 6/6
A chart and shading that agree
★★★
Run cleared.
🚀 Push it
- 🟢Add a sixth answer: Grade 9 students who walk, counted with two tests.
- 🟡Write one answer as a sentence, then name the cells its number stands on.
- 🔴Say why a corrected response is fixed on one tab only, and what breaks otherwise.
🌐 Make it for real
Build the sample survey report in Google Sheets from a blank spreadsheet, answers collected with a Google Form.
Twist: change one response and check that everything reading it moves, and the rest stays put.
🧑🏫 Teacher Guideclick to open
⏱ 53312
✅ Watch for
- Answers typed as sentences after reading down the rows
- A chart of summed minutes when the question asks for the average
- Count ranges that stop short of the last response