Intelligent GCSE Maths Tracker FOUNDATION - White Rose v3
Automated individual GCSE Maths tracker aligned to White Rose v3. Tick coverage, RAG rate confidence and then auto-generate 8 priority topics and a 9–1 working grade. IDEAL FOR TUTORS
This is a powerful, fully automated individual student progress tracker designed for tutors following the White Rose Maths GCSE v3 Scheme of Work (Foundation/Higher).
It goes far beyond a basic RAG spreadsheet.
The tracker uses intelligent analysis to help you decide:
What to teach next
What to revise
Where weaknesses truly lie
What working grade the student is currently operating at
HOW IT WORKS
Each Year 10 and Year 11 module is broken down into small steps.
For each small step, simply:
✔ Tick when covered
✔ Enter a RAG confidence score (1–3)
RAG Scale:
1 = Low confidence (needs significant revision)
2 = Developing (partially secure)
3 = Secure (confident & exam ready)
Everything else updates automatically.
** Intelligent Priority Generator**
The tracker analyses:
Topic coverage
Confidence (RAG score)
GCSE exam weighting
Topic frequency
It automatically generates: Top 8 Priority Topics to Revise
These update dynamically when:
Confidence improves
Topics are revisited
Coverage increases
No manual sorting required.
Built-In Dashboard Includes
Overall Coverage %
Average Confidence Score
Exam Readiness (Coverage × Confidence)
Year 10 / Year 11 split
Strand breakdown (Number, Algebra, Ratio, Geometry, Statistics)
Average Quiz Score
Calculated 9–1 Working Grade
This makes parent conversations and intervention decisions data-driven and professional.
Optional Quiz Tracker Tab
Record:
Homework scores
Past paper percentages
Small step codes assessed
The tracker calculates an average quiz score which feeds into the working grade calculation.
Ideal For
GCSE Maths Tutors
1:1 Tuition
Intervention Leads
Small Group Revision
Structured Exam Preparation
Data-Driven Progress Tracking
Those who follow WRM Scheme of Work (and those who don’t!)
Important
This resource is designed for individual student use.
You will need one copy per student.
All formulas are automated. Only enter data in tick boxes and designated RAG/quiz input cells.
⚠ Disclaimer
This resource is designed to align with the White Rose Maths GCSE v3 Scheme of Work.
It is not affiliated with or endorsed by White Rose Maths.







