Comprehensive AQA GCSE English Literature 2026 Excel assessment tracker with question-level marks, AO breakdowns, paper grades and overall GCSE grades.

Designed for teachers and English departments using the AQA GCSE English Literature specification (8702), this tracker provides a straightforward way to record and monitor student performance across both examination papers.

The tracker includes:

• Paper 1 – Shakespeare and The 19th-Century Novel
• Shakespeare question marks, including AO1, AO2, AO3 and AO4
• Shakespeare total and grade
• 19th-Century Novel question marks, including AO1, AO2 and AO3
• 19th-Century Novel total and grade
• Paper 1 total and grade

• Paper 2 – Modern Texts, Poetry and Unseen Poetry
• Modern Texts question marks, including AO1, AO2, AO3 and AO4
• Modern Texts total and grade
• Anthology Poetry marks, including AO1, AO2 and AO3
• Anthology Poetry total and grade
• Unseen Poetry marks, including the comparison question
• Unseen Poetry total and grade
• Paper 2 total and grade

• Combined Paper 1 and Paper 2 mark out of 160
• Automatically calculated overall GCSE grade
• Grade-boundary lookup tables

The tracker also includes student information fields for student name, UPN, English class, gender, SEND, FSM, EAL, disadvantaged status, reading age and KS2 English and Maths scaled scores.

Simply enter the marks achieved for each question or assessment component and the spreadsheet automatically calculates the relevant totals and grades.

Suitable for mock examinations, internal assessments, departmental tracking and monitoring student progress towards GCSE outcomes.

This is an Excel spreadsheet resource designed for use with AQA GCSE English Literature.