Excel QLA Markbook

A QLA (Question Level Analysis) excel markbook to easily input and show the areas of strength and weakness in your students.

This markbook is tailored for Geography AQA GCSE, however the amount of papers and total marks can be easily edited and the formulas will update automatically.

Features:

• Automatically calculate total and percentage for each section of the paper and the overall total, percentage, grade.
• Creates a residual mark (grade - target) for each paper and an average residual of all 3.
• Average residuals for each paper are also calculated based on males, females, HAP, MAP, LAP, EAL, SEN, PP.
• Can easily add/extend more classes.