AQA Design and Technology GCSE exam paper analysis

This is an Excel spreadsheet with 4 worksheets on it - one for each of the exam papers AQA has brought out from 2019 to 2022.

Each one is a sheet that will allow you to put in your student’s names and marks for each question. There is a summary of the question’s theme or topic too. I have also highlighted the maths and drawing questions. This allows you to then see where there are any common areas of misconceptions and weaknesses. It is also gives a RAG/traffic light colour per question. So allows you to easily audit how students did. It also adds up thir marks for all 3 sections and adds up the totals. On each worksheet I have also put in the NEA and Exam grade boundaries. There is also a link to the PDF of the grade boundaries. Great to assess your students and saves you adding up their marks too. Particularly useful for mock exams.