AQA GCSE French Summer 2018 Grade Calculator / Converter Markbook

This spreadsheet uses the 2018 AQA grade boundaries to convert raw scores from each unit into overall grades.
The spreadsheet contains 4 tabs.

1. A mark book which generates an overall grade when you input the raw scores for listening, reading, speaking and writing. (Raw scores are automatically scaled up for the appropriate units)
2. Identical to the first tab but In the event of not having any speaking grades, this tab takes an average of the listening, reading and writing scores and uses the average as the speaking score when calculating the overall grade.
3. A more detailed mark book which also generates grades for each individual unit as well as an overall grade.
4. Identical to the third tab but generates a speaking grade in the same way as tab 2.

Foundation and Higher are on the same sheet. Only enter data in the columns specified.