New AQA DT 9-1 NEA Tracker Sheet

I have created a spreadsheet that can be used to track pupils progress through the AQA NEA project. All you need to do it is insert students names and target grades. Once a score for each section is added it will automatically calculate a score then (using the look up sheet) insert an equivalent level and RAG rate appropriately. Please note that the grade boundaries can be easily changed on the look up sheet. I also predict scores for each section based on prior performance e.g. if they achieve 8/10 for section 1 I will assume they will perform similarly on subsequent sections so i will give them 8/10 for section 2 and 16/20 for section 3 and so on. , this makes it quick and easy to see expected outcomes. I find this very helpful to motivate students.