Markbook Template
A free editable markbook template for Excel and Google Sheets that records every assessment score, current grade, target grade and gap — across every class you teach.
A free editable markbook template for Excel and Google Sheets that records every assessment score, current grade, target grade and gap — across every class you teach.
Raw scores aren't useful on their own. What matters is the trajectory: are students moving towards their target, holding steady, or sliding back? This markbook surfaces that automatically with simple formulae you can adapt to your school's grading.
Use it alongside the OES For Teaching marking tools to feed in detailed feedback themes per assessment — so by parents' evening you have a full, evidenced picture of every student.
What you'll learn
- Pre-built columns for assessment, current, target and gap
- Auto-colour-coded progress against target
- Class summary view with averages and gap analysis
- Excel and Google Sheets versions
Who this is for
- Classroom teachers wanting a single place for assessment data
- Heads of department analysing performance across classes
- ECTs building a reliable assessment workflow
How OES helps
AI Lesson Planner
Generate full, differentiated lesson plans aligned to the spec you teach in seconds.
Batch Marking
Upload a class set and get mark-scheme aware feedback on every paper in minutes.
Exam-Style Paper Generator
Build fresh practice papers in the style of real exams across every topic and tier.
Report Writer
Turn end-of-term reports from a weekend into a coffee break — personalised and on tone.
Explore more
Related pages
Parent topics
Frequently asked questions
Does this replace my school's MIS?
No — your MIS is the official record. This is a working markbook for analysis between data drops, and for the formative assessment your MIS may not capture.
Can I share it with parents?
Yes, with care. Most teachers share a filtered view (current vs target) rather than the full sheet, which can show data on other students.
Ready to start?
Jump straight into the OES tools built for this topic.
Try OES marking tools