A comprehensive tracker that not only totals each unit but also an overall grade and a grade predictor. This resource is specifically for a Level 3 diploma/foundation diploma in Sport but can be adapted for any subject at an level of BTEC. The spreadsheet works by tracking each individual criteria in each unit and gives a grade and points score on completion of each section. This then tracks to an overall grade and gives a prediction of a course grade by averaging the points for each unit. In order to adapt this spreadsheet, save a copy and then play around with the formula. Enjoy!