GCSE 9-1 Mock Exam Tracking Spreadsheet Video Preview

Video preview. Designed for 2 and 3 unit GCSE exam subjects with 9-1 Grades. Current Tracking spreadsheets are available to purchase from the links below (the grade boundaries within each one are subject and spec specific). Please check back, more subjects and exam boards coming soon.

Biology Foundation AQA https://www.tes.com/teaching-resource/gcse-9-1-aqa-biology-foundation-mock-exam-tracking-spreadsheet-12050668
Biology Higher AQA https://www.tes.com/teaching-resource/gcse-9-1-aqa-biology-higher-mock-exam-tracking-spreadsheet-12050687
Chemistry Foundation AQA https://www.tes.com/teaching-resource/gcse-9-1-aqa-chemistry-foundation-mock-exam-tracking-spreadsheet-12050693
Chemistry Higher AQA https://www.tes.com/teaching-resource/gcse-9-1-aqa-chemistry-higher-mock-exam-tracking-spreadsheet-12050695
Citizenship Studies AQA https://www.tes.com/teaching-resource/gcse-9-1-aqa-citizenship-studies-mock-exam-tracking-spreadsheet-12050391
Computer Science AQA https://www.tes.com/teaching-resource/gcse-9-1-aqa-computer-science-mock-exam-tracking-spreadsheet-12050561
Computer Science OCR https://www.tes.com/teaching-resource/gcse-9-1-ocr-computer-science-mock-exam-tracking-spreadsheet-12051304
English Language AQA https://www.tes.com/teaching-resource/gcse-9-1-aqa-english-language-mock-exam-tracking-spreadsheet-2018-12049057
English Language OCR https://www.tes.com/teaching-resource/gcse-9-1-ocr-english-language-exam-tracking-spreadsheet-12050956
English Literature AQA https://www.tes.com/teaching-resource/gcse-9-1-aqa-english-literature-mock-exam-tracking-spreadsheet-12050431
English Literature OCR https://www.tes.com/teaching-resource/gcse-9-1-ocr-english-literature-mock-exam-tracking-spreadsheet-12050957
English Language & Literature AQA Bundle https://www.tes.com/teaching-resource/gcse-9-1-aqa-english-language-and-literature-mock-exam-tracking-spreadsheet-12050435
English Language & Literature OCR Bundle https://www.tes.com/teaching-resource/gcse-9-1-ocr-english-language-and-literature-mock-exam-tracking-spreadsheet-12050966
Food Preparation & Nutrition AQA https://www.tes.com/teaching-resource/gcse-9-1-aqa-food-preparation-and-nutrition-mock-exam-tracking-spreadsheet-12050563
Physics Foundation AQA https://www.tes.com/teaching-resource/gcse-9-1-aqa-physics-foundation-mock-exam-tracking-spreadsheet-12050935
Physics Higher AQA https://www.tes.com/teaching-resource/gcse-9-1-aqa-physics-higher-mock-exam-tracking-spreadsheet-12050942

By simply entering your unit marks the spreadsheet will automatically calculate:

Unit 1 Grade
Unit 2 Grade
Unit 3 Grade (if applicable)
Overall Marks
Overall Grade
Distance from Target Grade (if target grade is entered)
Overall Grade and student name will RAG automatically compared to target grade
Grade distribution graph for each unit and overall
Average grade for each unit and overall
% of students on or above their target grades
Average mark for each unit and overall
Overall class performance against targets figure