OCR AS Biology auto tracking spreadsheet

THANK YOU TO RCPAYNE for supplying the original which I have modified. This spreadsheet allows you to enter raw scores for each end of unit assessment, it then automatically converts this into a grade and works out value added (how much above or below their minimum target grade they are) There is also a running value added at the beginning which can quickly be used to highlight those that are falling behind. You will need to change the formulas slightly for your own centres test scores.