AQA GCSE Design and Technology 9-1 Tracker (with comment banks) UPDATED January 2021!

Updated January 2021 with all the AQA theory mapped over 50 lessons with ongoing assessments. Supporting presentations that match the lessons which are now available!
This enhanced version of the AQA GCSE tracker has been updated to generate comments from the marks awarded. It has been updated to have the two AQA specimen papers for reference and the 2019 GCSE paper to use as a mock examination which will be added to the NEA assessment to give an accurate prediction based on the previous years’s grade boundaries.
A PDF guide to using the tracker has now been added to the resource.

Please note the Grade Boundary sheet is up to date with the 2019 grade boundaries for both the paper and NEA as of 22/8/19.

To use:
Simply use the Context sheet to enter all student details including candidate number and attainment target.
Use the Comment sheet to award marks for each Assessment Objective and comments will be provided in the boxes for use in CRF’s or reports.
Use the Mock sheet to add the marks from the 2019 paper used as a mock exam.
Use the Theory sheet to help plan out your weekly lessons to ensure all the theory is covered. You can also use this to keep a track of ongoing assessments and it will show an average. It will also allow you to compare a test paper to the final mock to see if the students have improved.
Everything will then be transferred to the front Summary sheet, totals will be generated and levels awarded derived from the existing GCSE boundaries. Old type grades are also provided for reference.

All the cells that do not need editing are locked to avoid making mistakes but the sheet can be unlocked with the password ‘gcse’.

Updated May 2016 with room for 26 student names and added a pie chart to show percentage of students who were above/below target. More can be added if you are comfortable with editing Excel spreadsheets or simply make additional copies of the spreadsheet for the additional students.
If you have less than 26, ensure that there is nothing entered into the A8 column on the context sheet and the pie chart will ignore these when calculating the percentage of students above/below target.

Extra sheets for homework and assessments can be tailored to suit your needs and will not affect the Summary sheet or the predicted levels.

Save for later
  • AQA-GCSE-tracker-instructions.pdf
  • GCSE-DT-2021-AQA-with-feedback.xlsx

About this resource


Created: Mar 2, 2018

Updated: Jan 7, 2021

pdf, 534 KB


xlsx, 166 KB


Report a problem

Tes Paid Licence

How can I re-use this?