xlsx, 173.64 KB
xlsx, 173.64 KB

This Microsoft Excel spreadsheet is the ideal way to store and analyse your KS4 students’ PPE data (AQA German 2018 specification).
You can use this spreadsheet to:

  • Keep track of students’ entry tiers and papers marked/yet to mark
  • Enter raw marks and have grades automatically calculated using the AQA grade boundaries for the 2018, 2019 and 2020 papers
  • Compare students’ performance with their target grade (colour coded, so you can instantly see your under- and over-performing students)
  • View students’ progress over time as they complete the three papers (please note, no speaking data available for 2020)
  • See how many marks are needed to reach the next grade boundary -** as well as** a breakdown by paper, to see where the most effective interventions are likely to be made

The document contains no macros, so it should open on any school device without issue. It’s also fully editable, so you can change formatting (to highlight PP/SEN students, for example), sort students by entry tier etc. If you made your own exam papers for 2021, you could even create a whole new sheet just for them, as if they were an official AQA paper - complete with your own grade boundaries!

Reviews

Something went wrong, please try again later.

This resource hasn't been reviewed yet

To ensure quality for our reviews, only customers who have purchased this resource can review it

Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.