AQA A Level tracking with lesson plans and ongoing assessment data

This is a comprehensive tracker for AQA A Level Product Design although it could be adapted for other courses/exam boards.
If you complete the Student information tab, all the relevant data will be copied to the corresponding tabs. The same with the Grade boundary sheet which sets last year’s grade boundaries for every aspect of the course.
There is an outline for delivering the course content spread over 50 weeks which will have supporting presentations at a later date. Teachers can choose the past papers to use for reinforcing learning and these are all mapped to the new content on the Content tab.
For ongoing assessments, put the total score for the question in the top of the column for each lesson or unit and as you complete the score for the student, it will give an average of their results over the year and compare these to their mock results.
All this data is copied to the front page where the results from the NEA are added to give an accurate grade prediction based on the previous year’s grade boundaries.
There is scope for teachers to tweak this resource to suit but for now, cells that have formula or references are locked to prevent any errors. Each worksheet can be unlocked with the password ‘advanced’.

Save for later
  • AQA-Advanced-Level-DT-2020.xls

About this resource


Created: Feb 5, 2020

xls, 3 MB


Report a problem

Tes Paid Licence

How can I re-use this?