Stages
Just playMission 1/5
Refuse the bad value
Nothing is scored here. Press things and see what changes.
Do thisMission 2/5
Marks refuse a bad value
Do thisMission 3/5
Attendance has limits too
Do thisMission 4/5
Find the right column first
Do thisMission 5/5
Tight limits for a quiz
★★★
Run cleared.
🚀 Push it
- 🟢Limit a column to sensible numbers.
- 🟡Try to type a wrong value and watch it refuse.
- 🔴Explain the difference between warning and refusing.
🌐 Make it for real
Open a blank Google Sheet and build the sample mark sheet from an empty grid.
Twist: make the mark rule reject bad input, then type 780 and watch the sheet refuse it.
🧑🏫 Teacher Guideclick to open
⏱ 52218
✅ Watch for
- Values typed right but no rule to stop the next typo
- Color used where a rule should refuse
- Limits left at 0 to 100 on every column