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.

Related guides

• Bulk mark scanned papers by question
• What to look for in exam marking software
• Reduce marking workload without lowering standards