How To... Question Level Analysis

Empower students and teachers to make data-driven decisions with this step-by-step video tutorial on creating a question-level analysis spreadsheet. Perfect for exam preparation, assessment tracking, and targeted revision planning.

This tutorial clearly demonstrates how to set up, populate, and use a spreadsheet to analyse exam or test results at the question level, making it easy to identify strengths, weaknesses, and patterns in student performance. Presented in a clear, accessible format, it’s suitable for teachers of all abilities and can also support student-led revision analysis.

✔ Step-by-step demonstration for creating a question-level analysis spreadsheet
✔ Practical guidance on formulas, formatting, and data organisation
✔ Highlights how to identify trends, gaps, and key focus areas
✔ Suitable for teacher use or as a student-led learning tool
✔ Perfect for exam preparation, tracking progress, and targeted intervention

This resource saves planning time and empowers teachers to use assessment data more effectively, helping students focus on the areas that will have the most impact on their results. A practical, ready-to-use video tutorial that combines technical guidance with actionable insights.