Let’s start with the obvious question: what is value added? Well, at its most basic – and at the risk of teaching people to suck eggs here – it is a comparison of pupils’ actual and expected outcomes. The ‘actual’ bit is fairly straightforward: it’s what a pupil gets in a test, obviously. Well, it’s quite straightforward except it’s actually the test score converted to a fine grade, and this is subject to change every year (more on this in a bit). But what is ‘expected’? Well, there is the common misconception that expected progress equates to 12 points of progress from KS1 to KS2; and value-added is therefore the difference between a pupil’s actual progress and the expected rate of 12 points. Unfortunately this is very wrong and I know of schools that been significantly below for VA despite the cohort having made just over 12 points of progress on average. This has come as a bit of a shock.
So, start again: what is expected progress? First, it should be pointed out that ‘the DfE does not define expected progress in terms of APS’ (see p6, paragraph 10 of Ofsted Subsidiary Guidance). However, this is not entirely true. Ofsted, in the same document (see p33) go on to define attainment gaps in terms of differences in ability i.e. a 3 point gap between groups of pupils (e.g. pupil premium/non-Pupil Premium) is stated as being a year’s difference. This implies that 3 points is equivalent to a year’s progress, thus reinforcing the misconception that 12 points equates to expected progress across KS2.
More pertinent to this discussion is the fact that VA involves the calculation of an APS estimate for the end of the key stage against which the actual KS2 outcome will be compared. This calculation is based on the prior attainment (APS) of the pupil at KS1 and the resulting difference (KS2 APS estimate - KS1 APS actual) is essentially the expected progress for that pupil. In other words, pupils with different prior attainment have different expectations. Essentially VA is the comparison of a pupil’s progress against that of pupils with similar prior attainment nationally, and variations can be rather surprising.
So how can you find out VA estimates for your pupils? The best place to start is RAISEonline. Most users tend to log in to RAISE, download the summary report and don’t log in again until the following autumn (by which time they’ve forgotten their password or the account has been locked). However, there is other useful stuff in RAISE if you know where to look, and top of the list is the KS1-2 VA Pupil list. Scroll down through that long list of interactive/dynamic reports and you’ll find it about two thirds of the way down the list in the VA section. Click on it and when it opens, export it to Excel. The report lists all pupils in the previous Year 6 cohort alongside pupil characteristics, their KS1 outcomes, and, most importantly in this case, their actual and expected KS2 outcomes in terms of APS. To calculate actual progress, subtract KS1 APS (Column Y) from the actual KS2 overall fine grade (column Z); to calculate expected progress, subtract KS1 APS (column Y) from the estimated KS2 overall point score (column AD). Do this for each child in columns at the end of the spreadsheet and then calculate the column averages. These will provide the average actual and average expected rates of progress. The difference between these two averages (actual – estimated) added on to 100 is essentially the school’s VA score (give or take some adjustments relating to cohort size (known as shrinkage factor)). The average expected progress rate is, for most schools, between 13.2-13.4 points, but could be lower or higher than this.
What shocks headteachers the most, upon performing the above exercise, are those pupils for whom VA expected progress is greater than 14 points. In extreme cases expected progress may be higher than 15 e.g. a pupil with 2c in Reading and writing, and L3 in maths at KS1 has expected progress rates of just 11.9 points in maths yet 15.98 points in reading. The next question is usually “how do I calculate estimates for my current pupils?” There is a tool in the RAISE library (the 2013 Key Stage 1 to Key Stage 2 pupil ready reckoner – see link below), which will do this but it’s a bit of a pain as you can only calculate estimates for one pupil and subject at a time, which is a tedious and time consuming process; and makes it difficult to calculate cohort averages. However, it is useful for converting test scores to fine grades (right click on any of the tabs and ‘unhide’ the fine grade lookup table). To download this tool, click on link below and go to the ‘How Ofsted analyse your data section’:
To address this, I’ve built an excel-based VA calculator tool, which will calculate KS2 estimates for reading, writing and maths for all pupils in a cohort. It will also calculate potential VA scores for a cohort and significance if end of KS2 targets/predictions are entered into the columns provided. Please get in touch if you’d like a copy of this tool.
So, what does this mean for target setting? Well, as mentioned previously, Ofsted do not overtly define expected progress in terms of APS (except they do when it comes to VA estimates!). Instead, they now expect schools to talk about percentages on track to make two and three levels of progress (again, see subsidiary guidance p6). However, many schools continue to set APS-based targets, often at 4 points per year (16 points across the key stage), and this is commonly prescribed by consultants et al. It is, therefore, worth pointing out, from my own analysis of schools’ VA pupil lists, that 16 points of progress on average would result in the school being ranked at the 2nd or 3rd percentile (a school at the 1st percentile had a cohort which made 17 points of progress on average). 16 points of progress is therefore highly aspirational and 97% of schools do not reach this lofty bar. Instead it may be more appropriate to aim a sublevel above the estimates generated by my VA calculator tool. Alternatively, considering schools ranked at or above the 20th percentile in RAISE are usually significantly above national average for VA, schools could use FFT PA 15-20th percentile estimates (or SE estimates if preferred, but be warned that this may be somewhat lower depending on your school context). Both of these methods are VA based and link to the prior attainment of the pupil, which is perhaps preferable to a one-size fits all approach to target setting currently employed in many schools.
So, those are some thoughts on KS2 value-added. What the future is for this measure is anyone’s guess but the Primary Assessment Consultation does suggest a VA floor standard in future, and a baseline at the start of reception as a possibility. With the removal of levels on the horizon, it may be that some sort of VA measure becomes a more useful measure of progress. Watch this space!
And what about KS4? Well, that’s a topic for another day.