Auto-generate whole-class and individual GCSE Maths gap analysis from raw mock marks, colour-coded dashboards, heatmaps and printable reports.

Built for maths teachers and heads of department who want more than a percentage on a mark sheet. Enter your mock’s questions, your students’ names, and their raw marks, and the tracker instantly shows you:

• Class Dashboard: see whole-class performance question-by-question, colour-coded from red (weakest) to green (strongest), so you know exactly which topics need reteaching before results day

• Student Gaps Heatmap: every student, every question, at a glance, spot who’s struggling before it shows up in their next mock

• Individual Student Reports: a printable, ready-to-hand-out page for every student: their own marks, a performance chart, and reflection prompts for DIRT/feedback lessons

• Fully automatic: no macros, no VBA, just formulas. Enter marks once and every dashboard updates itself

Who this is for:

Maths teachers marking mocks, end-of-topic tests, or past papers
Heads of Department building an evidence base for intervention groups
Anyone tired of manually working out which topics a class actually needs to revise

What you get:

1 fully editable Excel (.xlsx) file, no locked cells, adapt it to your own scheme of work
Supports up to 60 questions and 60 students per mock
Works with any exam board: the topic list is fully customisable, not tied to a specific specification
A step-by-step Read Me tab that walks you through setup in 4 steps

Requirements: Microsoft Excel 365 or 2021+.

Reuse it every mock, all year: set it up once per assessment and it’s ready to go again next time.