AQA GCSE Design and Technology NEA and mock exam tracker

This tracker is for the new AQA GCSE Design and Technology course. The tracker has the NEA broken down into the 6 areas and will add up the total as you input the marks and predict an estimated grade (grade boundaries can be edited on tab bar three) - it also provided an estimated grade for each section of the NEA - this can be edited on the third tab bar. Also I have set this to make the cell go red to indicate that the mark put in is higher than the section mark. I have included 4 mock (PPE) entries and it works out the average mark of the four mocks and an estimated grade. Then the last section adds the NEA and the average mock together and provides an estimated overall grade.