ASSESSMENT ANALYSIS GUIDE
GCSE assessment analysis without another spreadsheet
Capture useful question-level information as you mark, then turn it into decisions about reteaching, intervention and curriculum planning.
What useful analysis should show
- Total, percentage and grade for each student.
- Average performance by question and section.
- Questions with the largest class-wide mark loss.
- Students whose question profile differs from their total.
- Distribution across grade boundaries.
- Exportable evidence for department review.
Start with the decision, not the chart
A dashboard is only useful if it changes what happens next. Ask: Which concept needs whole-class reteaching? Which students need a focused intervention? Was poor performance caused by knowledge, command words, timing or the assessment itself? The most colourful chart cannot answer those questions without teacher interpretation.
Grade boundaries need context
Apply the boundaries appropriate to the exact paper and awarding context. For internal assessments, label grades as estimates and retain raw marks. Boundaries can support communication, but question-level performance usually gives the better teaching signal.
A better department workflow
Agree question labels and maximum marks before marking. Capture marks once, at source, rather than retyping totals later. Review the weakest questions alongside sample responses and the mark scheme. Record the teaching action next to the finding so analysis becomes a plan rather than an archive.
Capture useful information while marking
A total score tells you how a student performed, but question-level marks explain why. Use the exam structure to record marks by question or topic as the paper is marked. Keep absent students and missing scripts separate from zero scores so the class averages remain meaningful.
Read the class picture
Begin with the distribution rather than a single average. Look for clusters around grade boundaries, unusually difficult questions and topics where most students lost the same mark. Compare percentages only where the available marks are equivalent, and retain the raw marks so colleagues can inspect the original evidence.
Turn analysis into an action
Choose a small number of findings that change teaching. A low result on one extended-response item might suggest modelling structure; weak performance across several recall questions may indicate spaced retrieval is needed. Identify students who need individual support separately from whole-class misconceptions.
Share responsibly
- Use student IDs rather than names when circulating departmental reports.
- Keep the annotated script available to explain any score.
- Record the grade boundaries used and the date they were applied.
- Do not present a small class result as a reliable prediction of final grades.
The strongest assessment analysis remains traceable: a department should be able to move from a chart, to a question, to the teacher's annotation on the original response.
Build analysis as you mark
Teacher Marking Assistant calculates totals and question-level class insights from the marks you already award.
Try it free →