School Data Updates

Subscribe to receive email updates when new blog posts are published.

Converting 2019 KS2 scaled scores to standardised scores

By James Pembroke / November 11, 2019 / 0 Comments

Many schools are using standardised tests from the likes of NFER, GL and Rising Stars to monitor attainment and progress of pupils, and to predict outcomes; and yet there is lot of confusion about how standardised scores relate to scaled scores. The common misconception is that 100 on a standardised test (eg from NFER) is…

Read More

2019 ASP summary template

By James Pembroke / November 6, 2019 / 2 Comments

2019 version of ASP summary template free to download here. Some tweaks on last year’s template – now takes account of new ASP menus Feel free to modify, copy and share. Just credit the source and please download it first before attempting to complete it (it will open in Word online. To download, click on 3…

Read More

Quintiles (part 2): How to be above and below average at the same time

By James Pembroke / October 18, 2019 / 0 Comments

How you can you be above average and yet below average? It depends on what average we’re talking about. The mean? The median? The mode? In fact, in the world of school performance measures, what we commonly refer to as average is not an average at all; it is simply the national figure. For example,…

Read More

Don’t panic about quintiles

By James Pembroke / October 17, 2019 / 0 Comments

Ofsted have been placing schools into quintiles – bands comprising 20% of schools: bottom 20%, middle 20%, top 20% etc – in the IDSR for a few years now. Initially it was just based on progress scores but this year they have expanded the approach to include attainment at EYFS, KS1, KS2 and in phonics.…

Read More

Presenting progress data for pupils ‘working below’

By James Pembroke / September 17, 2019 / 0 Comments

One of the most common questions I get asked is ‘how do we show the progress of those pupils working below their year group?’ Historically, this would have been done using some kind of points system linked to stages of the curriculum – each increment being worth 0.5 or 1 point with average points calculated…

Read More

2019 VA Calculator (the last of its kind!)

By James Pembroke / September 2, 2019 / 0 Comments

Here it is: the final VA calculator for pupils with KS1 levels. As usual, please don’t attempt to edit the online version; download a copy to your computer. Main changes are: all estimates, lower threshold caps, standard deviations and nominal scores have been updates in line with latest primary accountability guidance. Also, I’ve built it…

Read More

Primary school results summary tool

By James Pembroke / July 1, 2019 / 11 Comments

You can download the tool here. I thought it would be useful to produce something that showed 4 years’ results against national figures for each statutory assessment – EYFS (GLD), phonics, KS1 and KS2 – in an easy to read format. I thought it’d be even better if it was free. The national figures are…

Read More

2019 VA Calculator: beta version

By James Pembroke / June 29, 2019 / 6 Comments

A beta version of the VA calculator can be downloaded here. PLEASE DOWNLOAD IT FIRST. ANY DATA ENTERED ONTO THE ONLINE VERSION WILL VISIBLE TO ALL AND WILL BE DELETED. Please note that in addition to the usual issues at this time of year – estimates and standard deviations will change – we also have…

Read More

Junior schools, the reception baseline, and a big question about the future of accountability.

By James Pembroke / June 10, 2019 / 0 Comments

Following on from this blog post, questioning the potential reliability of progress measures in 2020, when the first cohort without KS1 levels reach the end of KS2, I thought I’d write another post on something that’s bothering me. Progress measures for junior and middle schools have always been problematic. Despite these schools having higher attainment…

Read More

Building reports in Mosaic, Insight’s reporting tool for MATS

By James Pembroke / May 31, 2019 / 0 Comments

As well as providing a super-simple, highly-customisable tracking system for individual schools, Insight also offers an equally intuitive reporting tool for MATs. Called Mosaic, this clever system allows MATs to build reports that pull all their key data together in one place: current teacher judgements, standardised tests, results of statutory assessments, pupil contextual information, and…

Read More