GCSE Design and Technology 9-1 Tracker Spreadsheet to show pupil progress and grade

A spreadsheet to help staff and pupils to keep a track on pupil progress in the NEW Technology GCSE from AQA. Coursework, Exam results and exam questions will all accumulate to give a predicted grade for the pupil.
The grade boundaries are based on previous ones released by AQA I have spoken to them and unsurprisingly they do not as yet have any idea what these will be, but suggested that the one I have used will ‘do for now’. If you go to the LOOKUPS page you can edit these yourself if you feel they are too high or too low.

I have found that pupils appreciate being able to graphically see the progress they are making, and this enables them to take more ownership of the project and become more independent.

For the 1-9 GCSE. As this is still a new GCSE there is going to be confusion amongst both teachers and pupils. AQA have not provided any great depth of information for anyone, and so I think this will be the best way to go forward.