>>
How SIMS can help...
Advanced, Assessment, Secondary

KS2 – KS4 Expected Progress Measures


Creative Commons License Photo Credit: josef.stuefer via Compfight

Some time ago I published instructions to help schools using Assessment Manager to calculate if their pupils were making acceptable progress between KS2 and KS4 based on the DfE guidance. Recently, @vikpaw emailed me a much more elegant method for using Assessment Manager to indicate the pupils who are (or are not) making expected progress. Here’s the resulting marksheet:

 

Here’s my summary of the DfE rules for expected progress:

 KS2 GCSE ‘E’ GCSE ‘D’ GCSE ‘C’ GCSE ‘B’ GCSE ‘A’ GCSE ‘A*’
Level 2 Yes Yes Yes Yes Yes Yes
Level 3 No Yes Yes Yes Yes Yes
Level 4 No No Yes Yes Yes Yes
Level 5 No No No Yes Yes Yes

 

So a level 5 pupil at KS2 is expected to make at least a grade B at KS4, while a level 2 pupil at KS2 is expected to make at least an E at GCSE.

As you know, both national curriculum levels and GCSE grades have a points value associated with them. For example, 4b has a points value of 27 and a GCSE grade C has a points score of 40. Hence there is a difference of 13 points between a level 4 and the expected progress of a level 4 pupil to grade C at GCSE. This ‘rule of 13 points’ holds for all the examples in the table above even though there is no official link between national curriculum sublevel points score and GCSE points scores. So we can create formulas in our marksheets to look for a difference of 13 points or more between the KS2 points score and the GCSE points score.

Assuming we already have a marksheet with a pupil’s KS2 result and GCSE expected grade, we just need to add two formula columns to our marksheet. The first column calculates the points difference between the KS2 result and our expected GCSE grade:

The second column uses a nested-if-then-else formula to decide if the value is greater than or equal to 13 and apply the relevant colour:

Once again, thanks to @vikpaw.

Similar Posts:

Discussion

3 Responses to “KS2 – KS4 Expected Progress Measures”

  1. Given that a single level of progress is worth 6 points, then for a student to achieve 3 levels of progress they need to progress by 18 points from ks2 to ks4.
    So a student acheiving a level 4b at key stage 2 will score 27 points. Add 18 points to this and they will have to score 45 points at ks4. If they achieve a Grade C (as indicated by DfE tables for expected progress) they will score 40 points. This is only an improvement of 13 points. Will they still be deemed to have made 3 levels of progress when league tables are produced?

    Posted by ppovey | June 1, 2012, 12:17 pm

Leave a Reply

Termly Newsletter Signup

Twitter

About

I've been working with ICT in schools and local government continuously since 1987 and over the years have made thousands of visits to schools in both the primary and secondary sector. I founded School Analytics Ltd in 2012 and in my spare time I'm also the Chair of Governors for my local primary school.
February 2012
M T W T F S S
« Jan   Mar »
 12345
6789101112
13141516171819
20212223242526
272829