AQA AS and A Level Assessment tracker with predictions 2019 onwards

An 8 page spreadsheet which tracks NEA progress and allows for mock and real examination analysis based on the AQA syllabus 7551 and 7552 but it can be adapted for other AO’s. It has been used to successfully predict final grades for many years and is a useful interactive tool to use in the classroom or during progression meetings. It uses a traffic light system to show weaker areas in performance and a look up table to predict final grades and to compare against targets.
A Level grade boundaries are not yet known but can be changed as needed. AS level boundaries from 2018 have been added to the AS tab.
This currently uses the standard 2/4 module boundaries for grades. This is for the new GCE syllabus with first AS exam in 2018.
It has been updated June 2019 to allow up to 26 students on one sheet and looks up student name and number from the information tabs. Cells not needed to be edited are locked off but the password to unlock each sheet is ‘advanced’.
The May/June 2019 exams have been added so this is up to date. Just change the grade boundaries when they are published each summer.

Save for later
  • Advanced-Level-D-T-Tracker-2020.xls

About this resource


Created: Jan 3, 2017

Updated: Jun 14, 2019


xls, 2 MB


Report a problem

Get this resource as part of a bundle and save up to 36%

Tes Paid Licence

How can I re-use this?