Skip to main content

Topic and Skills By Grade, and Grade Boundary Calculators

This is one of my proudest creations as a Maths teacher and here I am setting it free. 

It's a spreadsheet I've put together from lots of documents around showing what skills came under old National Curriculum levels and GCSE letter grades. I've used those and my own judgment to give an overall idea where these skills fit into the new(ish) grading system.  

There are a few skills missing from this, especially towards the top end of the grades, and obviously many of the skills can be framed in a question to make them easier or harder than the grade suggested, so there's some professional judgement needed in using this.

In addition, in my old school we graded students in KS3 based on their "trajectory" - so, we graded them according to whether they were on course to eventually get a grade 6, for example. The mythical student making "average" progress all the way through school and ending up with a grade 6 in Year 11 should be getting a grade '7.6' in Year 7, then an '8.6' in Year 8, and a '9.6' in Year 9.

So there are also splits showing what the grades to award in KS3 if you have a similar system to that in your school.

The last tab of the spreadsheet is full of various grade boundary calculators. Between them, these allow you to:

- Convert GCSE grade thresholds into KS3 "trajectory" grade thresholds
- Convert old NC Level and GCSE (A*-G) grade thresholds into new GCSE (9-1) thresholds
- Count up the number of marks at each grade or level in a test and convert them into grade boundaries
- Convert actual grade boundaries into standardised scores (eg if you want to standardise all test scores so students always know 10 marks is grade 1, 20 marks is grade 2, 30 marks is grade 3, etc and can compare more easily with previous performance)

I've got three different versions of that last one so you can do KS3, Foundation GCSE and Higher GCSE differently if you want.

Mostly when setting my own tests, I would count up the number of marks I judged to be at different National Curriculum Levels, use the third calculator to calculate NC Level boundaries, and then paste those into the second calculator to get grade boundaries for each year group.

Having used (and tweaked) this consistently for at least two years, I've found it to be pretty consistent and accurate with the grades students have ended up with. I sometimes find I feel the grade 2 and 3 boundaries are a little on the low side, however, so you may adjust them accordingly if you don't agree with the calculators!

It's a Google Sheets document and you should be able to download it as an Excel file (or copy it to your own drive). This way if I update it, I don't have to reupload it somewhere, it will always automatically be the latest version. Let me know in the comments if that doesn't quite work.