Tuesday, 23 September 2014

Improving school improvement: how LAs use FFT to support and challenge schools

Despite the reduction in scale and scope of local authority education services over the past few years, their school improvement remit remains. LAs have a responsibility to support and challenge schools, to intervene where necessary and to help drive up standards; the aim being for all pupils to have access to a good standard of education. 

School improvement teams rely on a number sources of data to gain insight into school performance; and use that data to identify schools whose performance gives cause for concern. Such schools may be below or close to DfE floor standards, have key groups that are underperforming, or show a downward trend over the past three or more years. Data sources that feed into the school improvement process include those in the public domain such as the DfE school performance tables, Ofsted reports, Ofsted data dashboard, and statistical first releases, which all provide vital information. Then there are NCER systems such as Keypas and EPAS, which provide a huge amount of attainment and progress data from national level down to individual pupil test scores. These systems release data early in the autumn term, thus giving LAs an early look at standards and an often vital head start. Beyond that, LAs make good use of RAISEonline in order to gain an 'Ofsted-eye' view of standards; and issues arising from the RAISE report will often form the basis of a conversation with a school.

In Gloucestershire, the School Improvement team goes one stage further, going through every RAISE report as soon as they are published. Whilst the various sources of data mentioned above provide essential information on standards, they are generally no substitute for getting down to the nitty gritty of pulling a RAISE report apart. If you really want to know what Ofsted thinks about a school's performance then you need to do more than study headline figures. RAISE, however is somewhat lacking as a school improvement tool, and that's where FFT comes in.

The FFT Governor Dashboard

FFT's simple yet intuitive summary report has proved to be a real game changer for both schools and LAs. As its name suggests, it is aimed at school governors, and the report is already an essential element of our data training package for school governors. However, the dashboard has also become popular with school improvement colleagues and senior leaders, all of whom appreciate its simplicity, clarity and focus; and it has now woven itself into the fabric of school improvement. For myself and many of my colleagues it has become the preferred report to gain a snapshot of a school's performance. Despite its mere 4 pages (3 if you don't count the title page), you can gain almost as much from an FFT dashboard as from an entire RAISE report.

Key to its usefulness are the progress comparisons, whereby a school's results are compared against estimated outcomes based on progress made by pupils nationally with the same prior attainment. This is critical when trying to make sense of data from other sources. We may know that a school is above or below the floor standard but what does that mean in terms of that particular cohort? The FFT dashboard allows us to quickly differentiate between those schools that have low attainment due to poor progress and those that have low ability cohorts. It is always interesting to see a school whose attainment dial is in the red and whose progress dial is in the green. The reverse is perhaps even more interesting, from a school improvement point of view. Whilst you can get this information from RAISE by studying attainment and VA data, it is the side-by-side presentation of these data in the FFT Dashboard that makes it such a useful tool for school improvement.

FFT Self Evaluation reports

An extension of the dashboard, these reports give greater detail on progress of pupil groups, both in terms of VA and CVA, with indicators to identify any significant trends over the last 3 years. Future estimates are given for current cohorts, as well as rankings for past performance. Rather than go further into the detail of these reports, I want to share a case study that illustrates how FFT data was used successfully during a recent Ofsted inspection of a primary school.

The school is in a deprived area and has very low ability intakes. Pupils make excellent progress across KS2 - VA placed the school at the 1st percentile in 2013 - and attainment is high. KS1 results however, particularly %L2B+ and %L3+, were below average; and it was KS1 that became the focus of the inspection. One of the limitations of RAISE is its lack of KS1 progress data and prior attainment at EYFS, which means that it is the responsibility of the school to demonstrate pupil progress across KS1. This is particularly where attainment at KS1 is low. The school's tracking data showed pupil progress was good but the low attainment at KS1 continued to be a stumbling block. This is where the school's FFT KS1 self-evaluation report proved invaluable. Like RAISE, it indicated that the school’s KS1 results were significantly below national average, and ranked it below the 90th percentile. VA, on the other hand (i.e. pupil progress compared against that made by pupils with the same EYFS prior attainment nationally), placed the school above the 5th percentile for all indicators, and CVA ranked the school even higher (1st percentile for one measure). These nationally benchmarked progress data and associated rankings, not available in RAISE and not feasible from internal tracking systems, demonstrated that pupils made comparably high progress across KS1 and KS2. The issue of low attainment at key stage one was put into context and the school got the outcome they deserved. 

Estimates & Target Setting

First, let's clarify something: FFT don't set targets; they provide estimates. These estimates can provide the basis of a conversation about target setting and that's what we tend to recommend when working with schools in Gloucestershire. For simplicity's sake, and with view to the future (i.e. FFT Aspire) in mind, I tend to stick to PA (prior attainment) estimates, as these are more in line with the estimates used for VA in RAISE, and focus on 50th (average), 20th (high), and 5th (very high) percentile estimates.  Whilst I understand that target setting should not be about getting a better RAISE report, I do think that schools value having a clear indication of what constitutes 'average' progress and an idea of what pupils would need to achieve in order for the school's VA to be significantly above average (hint: aim for the 20th percentile). Targets based on FFT estimates are certainly more meaningful, realistic and achievable than those based on a blanket approach of setting 4 points per year adopted in many schools. My own analysis of pupil level data in RAISE indicates this is aiming for the 3rd percentile. 

FFT estimates can also help school improvement teams identify schools that are at risk of falling below floor standards. By exporting school level data from FFT Live for current year 6 or 11 cohorts, we can filter on those schools whose future school estimates (based on prior attainment, context and the lasts 3 years results) suggest they may fall below floor standards next year. Whilst these are, of course, only estimates, and will always be considered alongside other sources of information - including the advisor's knowledge of the school - they provide a valuable, early indicator of potential standards, and can form part of the conversation with that school.

The future

This is where things get interesting. There are (at least) three other ways in which LAs can make good use of FFT data, two of which can be done now and I encourage LAs to makes better use of these features. The first is the student explorer. Schools are shocked by this when they see it: the entire pupil census history for their pupils at their fingertips and they didn't know it was there. Not only does it contain pupil characteristics, but attendance and complete school history at the click of a button. I showed it to a secondary school data manager recently and he had the facial expression of someone stepping into the TARDIS. At Gloucestershire LA, we are starting to use it to identify potential NEET pupils by exporting the entire county Y10 and 11 data set, and using certain criteria such as attendance, prior attainment and number of school moves as risk factors. There is therefore potential for this data to be used across teams, departments and even agencies.

Next up, collaborate. With increasing numbers of schools forming federations, partnerships, multi-academy trusts, or working closely in clusters, there is increasing demand to be able to analyse data across a number of sites. Schools are interested in producing benchmarking data for their cluster, or identifying strengths and weaknesses in a particular geographical area. These collaborations in FFT need to be set up by an LA administrator and should be encouraged. By creating these groups, LAs can help foster better partnerships between schools and gain insight into issues in certain areas. Collaborate is already a useful feature but is set to become even more relevant as the education landscape evolves.

And finally, Virtual Schools. Not a feature in FFT Live but it's coming soon to FFT Aspire, giving LAs the power to set up blank schools in FFT, which can populated with pupils by pulling their data into the school via their UPN. This is exactly what Virtual Schools have been crying out for: the ability to analyse the progress made by all their pupils regardless of location. And if there was ever an argument for the appropriateness and relevance of CVA it is surely here, when dealing with children in care. If this feature can be extended to PRUs, even better. 


So that's just about wraps up this blog on how school improvement teams can make use of FFT. How it challenges RAISE and other sources of data, and supplements our own intelligence about schools. It gives us detailed insight into school performance at all key stages, provides benchmarks, guides target setting, helps schools collaborate, and enhances cross-team and multi-agency working. In short, it provides LAs with an indispensable array of intelligent analyses. There is certainly more to FFT than D.


  1. Very interesting, especially the progress measure EYFS to KS1, after being told for years we should not do this. Now OFSTED guidance hints at 'realistic expectations' for those with GLD. I've always used a matrix of my own devising from the EYFS points (much to the concern of advisors of EYFS) but wonder if there is one that has wide-spread support?

  2. Hi Paul. Have you not accessed FFT KS1 report? It's very good. Proper benchmarked VA and CVA. Take a look! Will deal with it during the session next month.

  3. Thanks. It's a question of cost, and relevance to small cohort sizes, hence my DIY approach. It probably is flawed, but better than nothing!

  4. £150 is a bargain. How big are your cohorts?

  5. All under 20. I thought FFT was around £600!