GCSE PE Grade predictor for Edexcel 2016

This is a very accurate grade predictor using all the data provided by Edexcel for the Summer 2016 Edexcel GCSE paper. You need to enter the results of the 4 sports, AOP and finally a mock exam grade (all raw marks). The spreadsheet then calculates the UMS score for each section and produces a a grade based on 2016 grade boundaries. To cap it all off, if you enter each student's target grades, it will identify if the student is On or Below their target and highlight it an appropriate colour. There is little else you can do to forecast more accurately than this.