OCR GCSE Food Prep and Nutrition Y11 Tracker (1-9)

This tracker allows you to include the students names and as you enter the marks for the NEA 1 and NEA 2, it will add the two marks together and an indication to the grade (1-9) it could be. Grade boundaries are adjustable. Also I have included a feature that if you put a sub mark for example in the NEA 1 research and gave it a mark of 7 - then the cell would change to red to indicate it is outside the mark limit. I have also added two mock sections that works out the average of the two mocks and the 9-1 grade. Then the final section at the end adds up the NEA1 and NEA2 together with the average mock points to give a predication 9-1 and total score. Boundaries can be edited.