AQA AS and A Level Assessment tracker with predictions 2019 onwards

UPDATE The May/June 2019 exams have been added so this is up to date and the grade boundaries have also been updated from the results on 15th August 2019.
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’.

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

About this resource


Created: Jan 3, 2017

Updated: Aug 15, 2019

xls, 2 MB


Report a problem

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

Tes Paid Licence

How can I re-use this?