AQA Design and Technology GCSE 9-1 Assessment and Tracker (with comment banks) UPDATED for 2020!

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.

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.
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 2019 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
  • GCSE-DT-2020-AQA-with-Student-Feedback-AtoZ.xlsx

About this resource


Created: Mar 2, 2018

Updated: Aug 24, 2019

xlsx, 8 MB


Report a problem

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

Tes Paid Licence

How can I re-use this?