A spreadsheet designed to track the academic progress of up to 30 A-Level drama students (you can do more, but you’d have to UNHIDE every hidden columns in order to make sure that the new cells work).
I have included the 2018 and 2019 grade boundaries (as published by AQA), and left both the room and the capacity for the spreadsheet to be updated with 2020 and 2021 grade boundaries.
The spreadsheet will tell you how many marks each student needs to achieve their target grade for each component of the course. The “Machine” calculates this on a section by section basis for each of the components. Additionally, there is room for up to 10 attempts for each of these components. The spreadsheet will then show you the BEST, AVERAGE and LAST marks each student achieved.
Hopefully, this will make it easier for drama teachers to keep track of where their students are.
NOTE: I’ve designed this with the best intentions, but if there is a “bug” or an improvement that you feel would be beneficial after purchase, then leave a note in the comments section and I will attend to it quick sharpish.