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.