Quick ViewAssessment Tracker & Class Analysis Spreadsheet — 6 Assessments, Up to 32 Students
A ready-to-use Excel workbook for tracking a full year of class assessment data in one place. Designed by a secondary maths teacher, but built to be flexible enough for any subject, any age group, and any grading scale — from Key Stage 2 through to A-level, IGCSE, or your own custom levels.
Drop in your students once. Enter marks after each assessment. The workbook does the rest.
What you control (so it fits your class, not the other way round):
Rename every question (Q1–Q30) and add a topic description for each one — Adding Fractions, Photosynthesis, Causes of WWI, whatever your specification calls for
Set the marks available for each question individually — a 1-mark recall question and a 6-mark extended-response question can sit side by side
Adjust the percentage-to-level conversion table for each assessment independently — useful when an early assessment uses gentler grade boundaries than a mock or end-of-year paper
Use as many or as few levels as you need — the standard 0-9 GCSE scale is built in, but you can reduce it to A*–E, 1–4 mastery bands, P-scales, or whatever your school uses
Set individual student targets and track every student against their own goal
What it shows you automatically:
Each student’s percentage and level for every assessment
Progress over time — clearly flagged when a student moves up, stays the same, or slips back, even when not all six assessments are complete yet
On-target / above-target / below-target status based on each student’s most recent assessment
Per-question analysis — class mean, percentage of the marks available, percentage of students who attempted it, and an automatic flag for questions that were too hard or skipped by too many
Male vs Female comparison for every question and at whole-class level — useful for spotting topic-specific gaps in attainment
Level distribution graphs and counts so you can see the shape of the class briefly
A whole-class summary sheet that pulls it all together:
Every student’s progress across all six assessments on one page
Markers for LAC, Pupil Premium, SEND, FSM, EAL, EHCP and Gifted & Talented students so you can quickly see how different cohorts are tracking
Whole-class headline figures — what percentage are on or above target, gender breakdown, completion rates per assessment
Identifies students who haven’t yet been assessed so no one quietly slips off your radar
Includes a breakdown sheet for individual students
Helpful notes in cells so you know what to enter, if unsure
Built to be adaptable by a teacher. Whether you teach Year 7 mixed-ability or Year 13 Further Maths, whether your school uses GCSE 1-9, A-E, or in-house mastery bands, this workbook adjusts, whether you teach Maths, Geography or Science. Up to 32 students, up to 32 questions, up to 6 assessments per year.
Save the time you’d spend building your own tracker and spend it on the marking instead.
