GCSE 9-1 AQA Art & Design Mock Exam Tracking Spreadsheet 2018

Want a quick and simple way of entering your unit marks for each unit and seeing how your students are doing at an individual unit level and overall? Want an efficient way to show how your students are performing compared to their targets? Designed in excel this spreadsheet needs minimal input from you, just the marks, student names (and targets if you want target comparisons), it will then do the rest for you. (video preview is for a 2 unit exam but spreadsheets are designed specifically for each subject, exam board and specification)

Designed for AQA GCSE Art & Design 9-1 specifications.

The spreadsheet can be used for mock exams and monitoring. Simply enter the unit marks for your students and (optional) target grades to give you quick and efficient analysis and results based on the 2018 Grade Boundaries.

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

Unit 1 Grade
Unit 1 Scaled Score
Unit 2 Grade
Unit 2 Scaled Score
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 graphs 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
If you find this resource useful, please leave a review.
Thank you

Save for later
  • Art---Design-AQA-2018.xlsx

About this resource


Created: Jan 28, 2019

Updated: Oct 29, 2020

xlsx, 105 KB


Report a problem

Categories & Ages

Tes Paid Licence

How can I re-use this?