xls, 1.62 MB
xls, 1.62 MB

UPDATE 2: This tracker has been updated to support just A Level D&T and has new featres added. This version remains for those still running AS Level D&T or who want access to this particualr version of the tracker. You can still edit the grade boundaries as long as the AS exam is still available.

UPDATE1 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’.

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

A bundle is a package of resources grouped together to teach a particular topic, or a series of lessons, in one place.

Reviews

4

Something went wrong, please try again later.

bluepaint89

4 years ago
3

Really like this resource. It is expensive compared to other resources on the market. However it's worth it. It looks good and is clear. The only thing I'm not keen on is the revisionism. It appears like there are now a couple of versions of this and it is not clear the difference between/ what the updates are. This is something the author needs to streamline- make clear to others- especially since if you purchase this one is a part of a bundle whereas the more up to date isn't

MARTINKSI

5 years ago
5

thank you

Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.