Exam/Assessment Question Level Analysis Tool (QLA)

This tool was designed to be used in a science department, however, it is suitable for most assessments, tests and subjects.

The tool will allow you to analyse the results of an exam or assessment. By inputting the results by question on the data input tab you will be able to generate 2 reports.

The Pupil Report can be given to a pupil in order to highlight their areas of strength and weakness, allowing them to focus any revision that they do independently.

The Class Report produces a prioritised list of question foci that is based on the performance of the whole class. The questions are sorted by class performance giving you a prioritised list of topics/foci and exam skills for you to use to select and justify choices taken in future lessons and revision sessions.

It also adds up the totals for each student at the bottom of the data input sheet making entering and recording data simple.

Save for later
  • Question-Level-Analysis-Tool.xlsx

About this resource


Created: Feb 10, 2019


xlsx, 280 KB


Report a problem

Tes Paid Licence

How can I re-use this?