BTEC Business Level 3 Extended Diploma and Extended Cert results and grade calculator with formulas

I needed to keep all our BTEC Business Level 3 Extended Diploma and Extended Certificae grades in one place and have one shared spreadsheet for all teachers to demonstrate what criteria that the students have achieved, need a resubmission or have not achieved (expand the assignment based sections by clicking on the + then shade the boxes under each criteria, I use green for passed, yellow for resubmission and red for not attempted or not achieved. You enter the grades for examined units and the points earned and then the spreadsheet will show you their grade.