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.


Popular posts from this blog

Area of 2D Shapes: Always Boils Down To 'width × height'

We need to stop saying the area of rectangles is 'length × width'. There are so many ways we Maths teachers have made life difficult for ourselves by muddling up the language. Yes, we're trying our best to wean ourselves off saying 'minus', and specifying more clearly whether we're talking about subtraction or negative values. But we can do better than that. (And let's face it, the word 'division' isn't always exactly helpful either - are we talking about grouping or sharing?) The area of rectangles is another example. We say 'length × width' for the very first area formula we teach, and then change the words we use for all the others just as they're getting their heads around the concept. And to start with, 'length' tends to imply 'the longer side', meaning 'width' must be 'the shorter side', but then width turns into 'the distance across from left to right' for all the other shapes that follow