AQA Lang and Lit Q by Q exam trackers, June 18 boundaries

Four spreadsheets, one for each of the AQA GCSE Language and Literature exam papers. Input the students’ scores Q by Q and the cells automatically turn shades of red, amber and green, enabling you to see at a glance individual or collective strengths and areas for further teaching or revision. These columns are protected so the formulae cannot be accidentally corrupted. There are 250 rows so it’s useful for either the individual teacher or for use across the Year group.

Simply input the scores, the rest is automatic: the raw total, expressed also as a percentage and then converting automatically to the grade equivalent based on AQA’s published grade boundaries FOR EACH PAPER (not overall!)

It might help inform your planning or to identify patterns of underperformance across a teaching group or across the department, so you can tailor interventions which target specific students on specific questions.

Hope you find them useful.