Management Information System (MIS) for schools
Expert ideas for a better working life at your school or trust
Data and Insight | School Improvement
Category : Blog
The start of this academic year presents a lot of immediate challenges for students and staff – from new routines, to catching up on lost learning and recovering emotionally from lockdown. Looking beyond September towards setting school improvement objectives for the whole year, School Leaders are also faced with a challenge. With a six month
The start of this academic year presents a lot of immediate challenges for students and staff – from new routines, to catching up on lost learning and recovering emotionally from lockdown.
Looking beyond September towards setting school improvement objectives for the whole year, School Leaders are also faced with a challenge. With a six month gap in reliable attainment data, there’s less evidence to help identify areas for improvement.
So how can you use the data you do have to inform your school improvement plan this term?
Like any other year, the first (and arguably most important) step in creating an effective school improvement plan is to really understand your school’s performance in depth, including the attainment gaps between different student groups and the factors that cause them.
This year, without performance tables, ASP data from the DfE or consistent assessment data from last term, a good idea is to look back at your prior attainment data (averages over three years are ideal) as a starting point.
For a full picture of your school’s attainment from the last three years, we’re releasing a bundle of our popular Arbor Insight reports exclusively for free. Find out more below or go straight to download your reports here.
In combination with your past performance data, you can look at data from other sources, such as:
A big focus of most school improvement plans this year will be how to get students back on track after lockdown. Your Governors will need to understand the impact of partial school closures on students’ learning and wellbeing to help them review your plans for recovery.
To understand the impact of Covid-19 on your students’ attainment, most schools will be performing a new set of baseline tests with students in the first few weeks of term, then comparing these results with where students were at before lockdown. This is where a full and broad evidence of students’ prior performance will help you reliably understand what has changed and set the most effective goals for how to get students back on track.
Gathering full and reliable prior attainment data could mean lengthy searching through DfE performance tables, and pulling together internal spreadsheets and student records.
To save you time this term and help you kickstart your school improvement planning, we’re releasing a bundle of our most popular Arbor Insight reports (usually worth £300-400) – exclusively for free.
Created especially for your school, your reports will show you the full picture of your students’ progress and attainment over the last three years, giving you the context you need to see where to focus your efforts this year.
You can download your reports from your free benchmarking portal – Arbor Insight – used by over 10,000 schools in the UK to dig deeper into their results and benchmark their performance.
Here’s what the reports will help you to achieve:
Your reports are waiting for you in your free Arbor Insight benchmarking portal – sign up here and download them today!
Here’s some more detail about each of your reports:
We hope your Arbor Insight reports are helpful in giving you the context you need to get started on your school improvement plan.
Make sure you look critically at your data in the reports, and ask questions like “Why did these trends happen?” and “Are they typical of our school?” This will help to make sure your decisions are not based on any bias or previous assumptions. Check out our earlier blog for two approaches you can use to challenge your assumptions – 1) the Socratic Approach and 2) Asking “why?” 5 times.
As you move onto drafting your in-year priorities and objectives, question where you are in your current 3-5 year rolling plan: What have you achieved? What’s changed?
Take a look at some guidance we’ve gathered below on writing an effective plan:
Interested in finding out how Arbor’s cloud-based MIS can help you work more easily and collaboratively this term? Book a demo today, or join one of our webinars.
email@example.com | 0208 050 1028
Data and Insight
As you begin strategic planning for Autumn Term, you may want to dig into your data from the last three years in order to shape your new improvement plan. Arbor’s out-of-the-box dashboards make this easy, helping you quickly access meaningful data so you can make the best decisions. You can drill down into key attendance,
As you begin strategic planning for Autumn Term, you may want to dig into your data from the last three years in order to shape your new improvement plan. Arbor’s out-of-the-box dashboards make this easy, helping you quickly access meaningful data so you can make the best decisions. You can drill down into key attendance, behaviour and attainment metrics and easily spot useful patterns, all without the need for any special training (and no need for a complex setup process!).
We’ve been working with schools and MATs recently who want to customise how they analyse and visualise their data even further using BI (Business Intelligence) tools, such as Microsoft Power BI, Google Data Studio or Excel. We make it easy to export your Arbor data securely into BI tools if you want to, so you can dig even deeper into your student measures.
Using BI tools are great for:
So what does using BI look like in practice as a MAT? Andrew Mackereth, Arbor Senior Partnership Manager, caught up with Empower Trust in Shropshire about how they created a custom dashboard in Google Sheets using their Arbor data. Find out why they wanted to create it and how they built it in five easy steps below.
1. Share information with the Board
As the Board of Trustees is accountable for the performance of the Multi-Academy Trust and its Academies, a key issue for Ian Nurser, Empower’s CEO, was to provide them with a breadth of accurate, timely information across a range of key performance indicators (KPIs). This would allow the Board to understand the trust’s strengths and development issues, assess progress and review future risks and priorities.
Pulling everything into a single live dashboard would give the Board a single source of truth. At each meeting, the data would automatically refresh, updating the current picture, or monthly/termly trends at the same time.
2. Make sure everyone has the same information
It was important to Empower that the CEO, the Trust School Improvement Officers and local governing bodies (LGBs) had access to the same Academy-level information to allow them to question, support and appropriately challenge Academy leaders to build on their strengths and continually improve.
3. Bring together a range of live data sources
Empower wanted to bring together real-time information across a broad range of KPIs including attainment and progress for all year groups, pupil attendance, exclusions, SEND, safeguarding and staff absence (as an indicator of staff wellbeing). Using Google Sheets would enable the reports to automatically update as each Academy entered data.
As well as providing real-time information, they wanted to increase efficiency and save leadership time by compiling the content for their termly CEO and Headteacher reports to Trustees and LGBs automatically. They also wanted this information to be available to other groups of Trust and Academy staff such as SENCos and EWOs, so they could better monitor SEND, attendance, staff wellbeing, etc.
Empower took the following steps to plan and build their Google Sheets dashboard:
1. Agree the data they want it to show
2. Find the sources of the data
3. Plan the structure of the dashboard
4. Export the data they want from Arbor
5. The dashboard is ready and will refresh automatically!
The main process involved in creating a dashboard in Google Sheets is exporting data sets from Arbor using “Live Feeds”. Empower pulled the majority of their data from the data tables in Arbor and the other information (such as the number of days of absence caused by holiday) using Arbor’s unique Custom Report Writer.
For each data set (table) they wanted to export from Arbor, they created a “Live Feed” for it, then inserted it into their custom dashboard using the Google Sheets add-on. Then they selected the graph type they wanted to use to illustrate the data (like the bar chart below).
It’s important to be confident that your data is safe when you export it out of your MIS. That’s why in Arbor you can add authentication to your “Live Feeds”. This means that anyone accessing your new custom dashboard (whichever BI tool you create it in) must enter a password. You can also track when each Feed was last accessed. Read more about how Arbor keeps your data secure here.
To find out more about how to explore BI tools with your Arbor data, join our free webinar next Tuesday (7th July) at 11am. In this 45-minute session, we’ll show you how to get the most insight from your school data, both within Arbor MIS and using Power BI. Former Middle Leader at a secondary school and now Arbor’s Lead Product Manager Stephen Higgins will be joined by two data experts – Ed Cadwallader, School Improvement Consultant, and Mark Hodges, Education Systems Manager at Cantium Business Solutions.
There’ll be plenty of time for questions of our three panellists.
Click here to sign up for your free place – hope to see you there!
Data and Insight | MAT Operations
Where do you look for data analysis across your trust? How do you pull this data together? What tools will you have to make informed decisions next year without 2019/20 performance data? Although 2019/20 Analyse School Performance (ASP) data won’t be coming out for any schools in Autumn Term, the government is advising schools and
Where do you look for data analysis across your trust? How do you pull this data together? What tools will you have to make informed decisions next year without 2019/20 performance data?
Although 2019/20 Analyse School Performance (ASP) data won’t be coming out for any schools in Autumn Term, the government is advising schools and trusts to use the last three years of performance data to build improvement plans.
In our webinar last week, with guest speaker Loic Menzies, Chief Executive of The Centre for Education and Youth (CfEY), we showed you how you can use the benchmarking and performance analysis in your free Arbor Insight portal to help you inform your strategy for next year. You can catch up on the webinar on YouTube:
Arbor Insight gives you out-of-the-box, MAT-level dashboards which aggregate your academies’ latest performance data and benchmark your MAT against national and Top Quintile averages. The dashboards show multi-year trends, which are really important for forming next Academic Year improvement strategies.
You can also drill down to see how individual schools, demographic groups or particular clusters of schools are affecting results. You can also remove schools from your analysis to see how that changes your overall performance.
Also available in your Arbor Insight portal is your trust’s personalised Understanding Your MAT Report, which gives you a unique picture of the contextual factors affecting your trust’s performance, like local area demographics and pupil characteristics.
Access your free Arbor Insight portal here
We have some very exciting webinars for MAT leaders coming up in the next few weeks. Click the links below to sign up for your free space:
Friday 3rd July, 3.30pm
MAT Centralisation vs School Autonomy during Covid-19
Kate Davies, CEO of the 13 school White Woods Primary Academy Trust, will discuss how she is bringing together a group of autonomous schools.
Friday 10th July, 11am
How to look after your most vulnerable students during and after Covid-19
Angela Ransbury, CEO of The Raedwald Trust will discuss how the parameters of education have changed, and the ways in which we fulfilled our teaching and caring commitments before Covid-19 are no longer fit for purpose. She’ll explain what mainstream schools can learn from AP, and how changing and adapting now will help Teachers, pupils and guardians in September.
To find out more about how Arbor’s cloud-based MIS can help you future-proof your school during Covid-19 and beyond, book an online demo. You can also call 0208 050 1028 or email firstname.lastname@example.org.
Arbor Updates | Data and Insight
See your trust in a new light with our new free report Often serving a broad range of pupils from different backgrounds, and sometimes varying geographical areas, a big priority for Multi-Academy Trusts (MATs) is ensuring their spread of provision gives every pupil an equal chance of success. There are lots of factors that play
Often serving a broad range of pupils from different backgrounds, and sometimes varying geographical areas, a big priority for Multi-Academy Trusts (MATs) is ensuring their spread of provision gives every pupil an equal chance of success.
There are lots of factors that play a part in how pupils perform, such as where they live, whether they’re eligible for free school meals (FSM), or have special educational needs (SEN). As a DfE official warns that the attainment gap for pupils from disadvantaged backgrounds could widen by 75% as a result of Covid-19, it’s more important than ever for trusts to look at their school performance in context. The problem is, it’s not always easy to gather all this data in one place without trawling online data tables or waiting on spreadsheets.
That’s why we’ve launched a brand new free report for MAT leaders – the “Understanding Your MAT Report”. Created for every MAT in the country, the report helps you understand your unique make-up in a national context, so you can shape smart strategy going forwards.
Designed in partnership with the Centre for Education and Youth, the Understanding Your MAT Report brings together your schools’ key performance measures, alongside your MAT’s size and local demographics, to help you understand your unique set of strengths and challenges. What’s more, the report shows you how your MAT compares to other trusts nationally for the first time.
Your Understanding Your MAT Report is live now for you to download from your free Arbor Group Insight portal (our benchmarking tool for MATs)! If you don’t have an account yet, sign up here for free.
What can you do with the new Understanding Your MAT Report?
Let’s break that down…
We use your schools’ latest validated 2019 Analyse School Performance (ASP) data to show you your spread of performance in key measures at KS4, 2 and 1, such as Progress 8, Achieving Expected Standard: Reading, Writing and Maths, and Working at the Expected Standard: Year 1 Phonics.
Then we compare your results against three key benchmarks: Trust average (the weighted average of all your schools’ results), National average (weighted average of all state schools in England) and National MAT average (weighted average of all academies in England) to help you see what makes your MAT distinctive.
Plus, you can use your report as a companion to your free Arbor Group Insight portal, where you can dig further into any data set to see pupil level figures.
Image 1 – KS4 Progress 8 score, Understanding Your MAT Report 2020
You might be wondering “Is my MAT growing at the same pace as other trusts?” Or “Is our proportion of students eligible for Free School Meals higher or lower than other trusts?” The Understanding Your MAT Report will help you answer all these questions and more, showing you how your unique make-up compares to other trusts in the country.
You’ll get an overview of your MAT’s size, growth, blend of phases, pupil characteristics (% of FSM, SEN and EAL pupils), as well as the “Area Type” your schools are in, according to Office for National Statistics (ONS) area classifications. The report also shows you the demographic factors associated with the areas your schools are in (such as the level of education and the unemployment rate) which helps you understand your pupils’ socio-economic background.
Image 2 – Area Type Blend, Understanding Your MAT Report 2020
By bringing together your demographics, pupil context and school attainment, your Understanding Your MAT Report will help you understand all the factors impacting achievement at your MAT. As you’ll see from the report’s leading article “Breaking the link: Attainment, poverty and rural schools” (preview here), the relationship between disadvantage and attainment varies considerably between different parts of England, so it’s important for trusts to understand how this plays out across their mix of schools.
Use this analysis to drive decision making at your next strategy meeting, and find new ways to improve results for staff and pupils.
Your Understanding Your MAT Report is live now for you to download from your Arbor Group Insight portal – we’ve also sent the link to you by email. If you’re not registered, don’t worry, you can sign up for free here.
If you have any questions about your report, or if you’d like one of our team to show you around Group Insight, get in touch at email@example.com or call 0208 050 1028.
Preview of the new Understanding Your MAT Report – special article In partnership with the Centre for Education and Youth (CfEY), we’ve created a new free report for MATs across the country – the Understanding Your MAT Report – to help you see your trust in a new light. Built especially for your trust, your
In partnership with the Centre for Education and Youth (CfEY), we’ve created a new free report for MATs across the country – the Understanding Your MAT Report – to help you see your trust in a new light.
Built especially for your trust, your report brings together key measures like your schools’ ASP performance statistics, alongside your MAT’s size and local demographics, to help you understand the unique makeup of your trust compared to others in England.
The report is out soon but you can sign up to our waiting list to get early access to your report now!
As a preview, we wanted to share with you the leading article from the report, written by Loic Menzies, CEO of The CfEY. The article introduces you to the contextual analysis the report gives you and the kinds of conversations your report might bring up in your next strategy meeting.
To find out about what’s included in the Understanding Your MAT Report, check out our blog.
by Loic Menzies
The relationship between disadvantage and attainment varies considerably between different parts of England. Combining datasets shows that poverty has a particularly pernicious effect on educational attainment in some area-types, particularly the rural areas shown in green, below.
Free School Meals aren’t the only ingredient
In recent years there has been increasing recognition that the relationship between deprivation and educational achievement is not as simple as we once thought. Researchers like Simon Burgess have shown that the interaction between disadvantage and ethnicity / migration status, for example, is often underestimated.
At LKMco we’ve had a longstanding interest in ONS area classifIcations (see “The Two Kingstons – what FSM does and doesn’t tell us” and “Maybe it’s because I’m a Londoner”). These classifications combine a range of characteristics of different areas, including industrial and employment data; demographics and qualification levels.
Combining these classifications with school data reveals striking differences between patterns of school performance in different area types.
Affluent England and London in the lead (surprise, surprise)
At the most basic level, we see that area types differ considerably in their attainment and deprivation levels.
Areas described as “Affluent England” achieve most highly, but “London Cosmopolitan” and “Ethnically Diverse Cosmopolitan” areas are not far behind – despite having two or three-times the same level of deprivation.
However, once we plot FSM levels against attainment, the results get considerably more interesting – and the worrying situation in rural schools is revealed.
A variable picture
Firstly, notice how, apart from a small cluster of very-low-deprivation, very-high-attainment schools on the far left, pink dots dominate the top of the distribution. These represent “ethnically diverse cosmopolitan” areas (most of which are in Greater London). This shows that regardless of their deprivation levels, pupils tend to do best in these areas. Meanwhile, red dots are concentrated in the top right-hand corner. These represent high-achieving, high-deprivation central-London schools.
How strong is the link between deprivation and attainment…? It depends on the area
Switching our attention to the trend lines and R-squared values (representing the strength of the relationship between poverty and attainment), we see that the angle of the lines differs considerably – as does the strength of the correlation, even though all eight correlations are significant.
Notably, in rural areas the relationship between poverty and educational outcomes is particularly strong. So although pupils in rural schools with low deprivation attain highly, schools in deprived areas are really struggling.
It seems that rural schools have particular difficulty breaking the link between poverty and low pupil attainment.
What about pupil progress?
Switching the measure to pupil progress paints an even starker picture of pupil outcomes in disadvantaged rural schools.
In general, the relationship between FSM and Progress is much weaker than when looking at attainment (r squared values of <0.2 in most area types).
This is unsurprising, since how well pupils achieve at KS2 (which is taken into account in Progress 8), already depends a lot on their deprivation level.
However, in rural schools, we find that a moderate relationship returns. It therefore seems that low attainment in rural, high-deprivation secondary schools is not just about pupils having low starting points. Instead, there is an important link between school deprivation level and progress rates.
Why is pupil progress in disadvantaged secondary schools worse in rural schools than in other parts of the country?
When considering how to break the link between poverty and education outcomes, it is crucial to take a nuanced view of poverty. Geography, demographics and community/economic context play a critical role in moderating the relationship between poverty and educational outcomes.
Studies of the factors affecting schools in different area types are therefore urgently needed, since these would help schools understand how best to respond to their circumstances.
Key factors to explore could include:
Find out more about this analysis in Schools Week.
Loic Menzies is Director of The Centre for Education and Youth (CfEY). He specialises in education policy and research, youth development and social enterprise. He was previously a tutor for Canterbury Christ Church’s Faculty of Education, an Associate Senior Manager and Head of History and Social Sciences at St. George’s R.C. School in North West London and a youth worker. He has authored numerous high profile reports and works with policy makers to communicate the implications of research, for example presenting to the Education Select Committee on White Working Class Underachievement or presenting to civil servants on teacher recruitment, retention and development. He is currently editing CfEY’s first book with Routledge entitled ‘Young People on the Margins’.
For descriptions of all the area types in England, as defined by the Office for National Statistics (ONS), take a look at the ONS website.
At Arbor, we take data security very seriously – it’s at the heart of what we do. We’re proud to go above and beyond the MIS industry standard when it comes to protecting school and MAT data. We’ve put together this short blog to explain what we do in a little more detail. 1)
At Arbor, we take data security very seriously – it’s at the heart of what we do. We’re proud to go above and beyond the MIS industry standard when it comes to protecting school and MAT data. We’ve put together this short blog to explain what we do in a little more detail.
The security of every Arbor office is maintained by formal security inspections and risk assessments. Access to our offices is restricted with secure keys, CCTV, 24/7 security personnel and secure perimeter doors.
When protecting data at your school, it’s important that you follow data security best practice to make sure data does not fall into the wrong hands. Here are some key things you can keep in mind:
If you’d like to find out more about how our simple, smart cloud-based MIS could help you transform the way your secondary school works, contact us.
You might have heard of Microsoft Power BI, Google Data Studio or Tableau. But what is Business Intelligence (BI) and what does it mean for schools and MATs? We’ve put together this handy guide to help you navigate all things BI. What is BI? BI stands for “Business Intelligence”. In simple terms, this means the
You might have heard of Microsoft Power BI, Google Data Studio or Tableau. But what is Business Intelligence (BI) and what does it mean for schools and MATs? We’ve put together this handy guide to help you navigate all things BI.
What is BI?
BI stands for “Business Intelligence”. In simple terms, this means the technology used by companies (or schools and trusts!) to analyse their data. BI tools are used to do these things:
How is BI used in schools and MATs?
Schools are swimming in data. But data is only helpful when you can learn from it. Without a way to understand their data so they can turn it into actions, schools can find themselves “drowning in data” (Education Technology). This is where Business Intelligence tools come in – they help SLT monitor the health and progress of their schools (e.g. Which of my schools is performing most highly?), inform strategic decisions (e.g. Which subject should we invest in more next year?) and report to governors, parents and trustees.
Why are schools using external BI tools?
Schools and MATs are turning to external BI tools more and more in order to analyse their data. This is usually because their management information system (MIS) doesn’t give them an easy way of visualising their data in the way they need. BI tools free schools from having to manually build reports in spreadsheets which is time-consuming and doesn’t present an overall picture. For multi-academy trusts especially, BI dashboards allow them to see a “single source of truth” in order to monitor and assess the performance of all their schools, rather than having to piece together and compare the data themselves.
The size of your trust will affect the type of data analytics and BI tooling that’s right for you. Larger MATs may have the resources to employ data and software professionals to create a bespoke BI solution. We’ve put together a diagram below showing how the size, degree of centralisation, existing systems and data strategy of a MAT might affect what they need from BI.
The problem schools are facing with external BI products is they’re expensive, complex and require setup by trained staff. Many tools don’t work with schools’ existing management information systems, which means it takes a long time for staff to take actions on the data. Plus, as most tools are not suited to groups of schools, MATs have to rely on products such as Microsoft Power BI to bring all their data together.
Arbor’s BI solution
At Arbor, we have built “out of the box” Business Intelligence solutions into the fabric of our MIS through clear, detailed and relevant dashboards. This means there’s no need for configuration or setup – everyone working at your school can see and manipulate the data they need in a few clicks. Plus, you can go deep into the detail of your data and take actions without needing to be a data expert or to hire one!
What makes Arbor different?
Whilst Arbor provides detailed, powerful, “out of the box” analysis for schools, we also know that you sometimes need to analyse data outside of your MIS. That’s why Arbor MIS supports all major BI providers, giving you the freedom and flexibility to choose and define your own BI approach for your group. It’s easy – using Arbor “Live Feeds”, you can export live data from Arbor MIS into your external BI tool.
We’ve built powerful yet simple Business Intelligence into Arbor MIS, Group MIS and Arbor Insight. You can book a demo today or come and chat to us at BETT – we’re at stand NM30. We’re also hosting lunch (on us!) at Tapa Tapa restaurant (on the DLR walkway outside the ExCel centre) – sign up for your free spot here.
Category : Blog , Uncategorized
Download your FREE 2018/19 KS2 and KS4 Performance Summary Report to compare how you’re performing against schools in your LA and schools “Like You” We know school budgets are getting tighter each year, so we’ve built completely free KS2 and KS4 Performance Summary Reports for every primary and secondary school in the country. We believe
Download your FREE 2018/19 KS2 and KS4 Performance Summary Report to compare how you’re performing against schools in your LA and schools “Like You”
We know school budgets are getting tighter each year, so we’ve built completely free KS2 and KS4 Performance Summary Reports for every primary and secondary school in the country. We believe fast and effective data analysis should be available to all schools, at a price that won’t break the bank, so you can get on and focus your time where it matters most – supporting your students.
Your reports present your data in a clear, visual graphs and charts, making it easy for you to find the data you need to celebrate successes, prioritise interventions, inform your School Improvement Plan and quickly spot areas to highlight in meetings with governors. Log in or sign up for your free Arbor Insight portal today, and download your school’s unique Performance Summary Report to see your school’s performance over the last 3 years.
Who is this report for?
Headteachers, SLT, data managers and governors will all find this report useful. You can add as many users as you like to your free Arbor Insight Portal, so everyone can see how your students are getting on.
What features does this report have?
(i) School context
See how the proportion of FSM, EAL and SEN has changed over the last three years
Fig. 1: The Pupil Context page of your Free Performance Summary Report
(ii) Compare your performance against schools “Like You
We know it’s harder to get students to the expected level if they come from more disadvantaged backgrounds, so your report shows you how schools in the same phase and proportion of Prior Attainment, FSM and EAL are performing in Headline measures
(iii) Compare your performance against schools in your LA
See how all other schools are performing in the same Headline measures in your LA
(iv) Compare your performance against National average
See what the difference is between your school’s average performance in each measure compared with the National Average
Fig. 2: Your report compares your pupils’ performance to the national average in a variety of measures
(v) 3 year Rolling Average
Find out if this year’s performance is an anomaly or consistent with the last three years
(vi) Focus on “Closing the Gap”
This section of the report helps you focus on closing the gaps in your school for School Improvement Planning, understanding the key areas to prioritise and for working out where to focus interventions. This section of the report looks at the attainment gaps in your school
Fig. 3: Your report shows you where you need to focus in order to close the gaps in your school
How can I get this report?
To download your free 2018/19 Performance Summary Report:
1. Already an Arbor Insight user? Log in here: https://login.arbor.sc
2. If you haven’t logged in before, sign up here for free in 30 seconds: https://login.arbor.sc/auth/register
3. Click on the Free tab in the Performance Reports section of your portal
4. Click the green Download button
5. Find your PDF Performance Summary in your downloads folder
What else can I find in my Arbor Insight portal that’s free?
On the left-hand side of your Insight portal, you can find completely free dashboards which show you:
All of these dashboards are updated with the latest ASP data as soon as we receive it from the DfE.
If you’re an academy that’s been open since 1st September 2017, we’ve also built a free Academies Financial Benchmarking report for you! To learn more about this report, just click here.
What else do you do?
Arbor Insight is a free tool we offer alongside our cloud-based MIS that schools and MATs love to use. If you’re interested in learning more about how our MIS can take the stress out of daily school admin and make your data more powerful, book a free demo here.
I still have a few questions. Can I contact you for help?
Absolutely. You can reach the Arbor team at firstname.lastname@example.org or by calling us on 020 7043 1830.
We’re really pleased to announce that your latest KS4 data is now available on Arbor Insight! We’ve been hard at work crunching all of your 2018/19 ASP data, so you can spend more time focusing on how findings from your performance data will inform your school improvement planning. We’ve produced 7 premium PDF reports, which
We’re really pleased to announce that your latest KS4 data is now available on Arbor Insight!
We’ve been hard at work crunching all of your 2018/19 ASP data, so you can spend more time focusing on how findings from your performance data will inform your school improvement planning.
We’ve produced 7 premium PDF reports, which benchmark your school against similar schools and top performing schools, as well as the national average. You can quickly and easily share these reports with your team, governors and even parents. We’ve also created free performance dashboards for every school in the country, where you can look at all of your headline measures and drill down into your data to see your strengths and weaknesses and where your biggest gaps are in attainment and progress. Adjust filters to change the year, demographic group and benchmarks; this makes your analysis quick, simple and highly effective.
(Fig. 1 Key Findings page from an example Understanding Your School Report)
The percentage of pupils entered into the EBacc increased this year by 1.6% from 2018; this is the highest entry rate since the introduction of the Ebacc in 2010. Both Humanities and Foreign Languages subjects had increased entry rates this year compared with last, which contributes to this increased entry rate. However, this increase is not across the board, The Department for Education has stated that this year 58.4% of pupils with high prior attainment entered the EBacc, compared with 30% of pupils who have middle attainment and just 9.4% who have low attainment.
There is also a lot of variation in terms of what subjects students choose across these 3 attainment groups. We’ve created a curriculum summary in the “Understanding Your School Report”, so you can see what subjects your low, middle and high attainment pupils have taken this year and a separate summary for the subjects your FSM pupils have entered. Our Understanding Your School report also shows you the subjects your disadvantaged students have entered into in comparison with their peers, so you can see whether there are issues with access to different areas of learning between different pupil groups.
(Fig2. Curriculum Summary focus on disadvantaged from an example Understanding Your School Report)
Another feature of the “Understanding Your School Report” is our “Schools Like You” benchmark, which is hugely effective in demonstrating how the specific demographic context of your school affects pupil attainment. This is something that the Progress 8 measure cannot show by itself and it’s useful to know how similar schools are performing, so you can use this as a realistic benchmark. Our “Schools Like You” benchmark shows an average figure of all schools that have a similar demographic intake to yours. We’ve used the methodology of the Education Endowment Foundation for the weighting of demographics in this benchmark, which is: average prior attainment (40%), variance prior attainment (5%), FSM 6 (25%), EAL (20%) and IDACI – Income Deprivation Affecting Children (10%).
(Fig. 3 Maths attainment page showing an example of the “Schools Like You” benchmark from the Understanding Your School Report)
Researchers at the Centre for Multilevel Modelling, Bristol University, compared the current Progress 8 measure with an “adjusted” measure that also accounted for pupil criteria such as gender, age, ethnicity, residential deprivation, Free School Meals, English as an Additional Language and Special Educational Needs. Adjusting the Progress 8 measure to include background factors like these meant that, in national rankings based on accountability measures, 20% of schools would change by over 500 places.
Exam results can also be disproportionately affected by social and geographical context. You can see how the area your school is in has impacted your pupils’ outcomes in our “Understanding Your School Report”, which features our new Area Type Comparison graph. This graph brings ONS area classification data together with your ASP attainment data – something entirely unique to Arbor Insight. The ONS has classified every LA in the country into 8 “supergroups”, which share characteristics, based on socio-economic and demographic data from the national census. Our graph explains which supergroup (or area type) your school is in, and shows how your performance compares to schools in areas with similar socio-economic characteristics, helping you to examine patterns between your student intake and attainment.
(fig. 4 Area Type Graph of a school in “Affluent England” taken from an example Understanding Your School Report)
Arbor Insight is our industry-leading benchmarking tool for every school and MAT in the country. It’s free for everyone! If you haven’t already, sign up today in just 1 minute: https://login.arbor.sc/auth/register
If you already have an account, log in to see your updated performance dashboards: https://login.arbor.sc/auth/login
Over 80 secondary schools have Arbor MIS and if you want to know why they love using Arbor, then take a look at the product here: https://arbor-education.com/products/school-mis/. Get in touch by phone on 020 8050 1028 or email email@example.com -we’d love to hear from you!
We are all aware of the widespread funding shortfalls in the education sector, and it’s definitely a challenging time to be a budget holder in schools and Multi Academy Trusts. Having full visibility of all income and expenditure is hugely important in order to understand your school’s financial allocations, like where you may be lacking
We are all aware of the widespread funding shortfalls in the education sector, and it’s definitely a challenging time to be a budget holder in schools and Multi Academy Trusts. Having full visibility of all income and expenditure is hugely important in order to understand your school’s financial allocations, like where you may be lacking in funding and areas you might be overspending in.
We have created a Schools Financial Benchmarking report (SFB) for every state school in England, which displays all of your income and expenditure in a clear, easy-to-read PDF report. Over 1,000 schools have used their Arbor Insight Financial Benchmarking report since we launched it in 2015; sharing it with governors, using it as evidence in internal and external meetings and using it to inform their budget planning.
(Image 1: A screenshot of Grant Funding as presented in Arbor’s Financial Benchmarking Report)
Your school budget should reflect your School Improvement Plan – covering a five-year basis, showing two years in retrospect, the current year, and the next two years’ forecast.
Before setting up any new budget, you’ll want to have handy:
Being aware of where you expect to see larger expenditure and accounting up front for your budget planning and communication is really important. For example, staffing costs in schools typically account for between 75 to 85% of the overall school expenditure and premises costs 10 to 12%. It’s therefore important to forecast likely costs in these areas early on. In your SFB report, you will see all expenditure and income sections shown as a percentage of total spend so you can visualise all of your finances better. We also break down every value as an amount that has been spent or received per pupil in your school.
(Image 2: A screenshot of total spend as presented in Arbor’s Financial Benchmarking Report)
Arbor’s Schools Financial Benchmarking report is a useful resource for school budgeters, as you can see how much schools in your local authority spend on resources, such as classroom assistants, catering, building maintenance and so on. We also benchmark you school against other schools that have a similar demographic cohort of pupils to you, weighted by percentage of prior attainment, FSM and EAL pupils. If you have a high proportion of disadvantaged pupils, or perhaps pupils with low prior attainment, it’s important to see whether similar schools have comparable spending patterns – or if being benchmarked against these schools highlights some areas of funding/spending that might be good to look into.
In terms of planning your budget and making sure it aligns with your school improvement planning, you can see how your finances have shaped up over the last 3 years with our line graphs that include trend figures. We also show the last 3 years of finances for each resource compared with that of the national average, schools in your LA and schools like you. Our 3-year rolling average for each expenditure and income resource can help you predict and plan your future 3 year expenditure planning.
(Image 3: A screenshot of Premises as presented in Arbor’s Financial Benchmarking Report)
How to present this data to other key stakeholders:
Now you’ve got to break down the school budget for the governors. Come with easy-to-understand, clear budget reporting sheets, such as your Schools Financial Benchmarking report and feel prepared to explain any holes with recommendations for avoiding them in the future. For example, if you overspent on building maintenance this year, you could suggest implementing more regular building checks to spot problem areas, or negotiating better terms with your insurers and maintenance providers.
If you’re looking to keep your cost low and give next year’s budget a little wiggle room, look at how Arbor’s simple, smart MIS can help you not only centralise your systems and data, but also your costs, so that you can focus on what matters most, your pupils.
Haven’t yet signed up to your Arbor Insight portal? No problem! Sign up here in seconds: https://login.arbor.sc/auth/register
Already signed up? Just log in here: https://login.arbor.sc/auth/login
If you have any questions or would like any help, you can reach the Arbor Insight team at firstname.lastname@example.org or by calling us on 0207 043 1830.
Arbor Insight is a free tool we offer alongside our hassle-free MIS that schools and MATs love to use. If you’re interested in learning more about how our MIS can make daily school admin easier and your data more useful, book a free demo here or call our MIS Demo Team on 0208 050 1028.
Your academy’s free Financial Benchmarking report for 2017-2018 is now available on your Arbor Insight portal. The report was prepared by Arbor Education Partners using your most recent Schools Financial Benchmarking data from the Department for Education. The aim of these reports is to help you with benchmarking your income and expenditure, as well as
Your academy’s free Financial Benchmarking report for 2017-2018 is now available on your Arbor Insight portal. The report was prepared by Arbor Education Partners using your most recent Schools Financial Benchmarking data from the Department for Education. The aim of these reports is to help you with benchmarking your income and expenditure, as well as helping you to plan your budget effectively.
What is Arbor Insight?
Arbor Insight is our industry-leading benchmarking tool for every school and MAT in the country. It’s free for everyone! See your school’s performance on all your key measures from the DfE – including comparisons with similar, national, local and top quintile schools – in easy to read reports you can share with your whole team. We also give you personalised recommendations for your school, so you can understand exactly where to focus.
Why create a report?
Our reports have been created just for your to help you see the power information can have when intelligently analysed, and intuitively presented. It also acts as a small introduction to what Arbor can do! While this data may be from last year, it is also totally free as part of our mission to help schools stress a little less and focus on what matters most – use our data to help drive your school improvement for the coming year.
Fig 1: Screenshot showing how total spend is broken down in your Financial Benchmarking report
How did you get the data?
This report has been created using Academies’ Financial Benchmarking Data from 2017/2018 as released for the first time in October 2019. We combined this with data sourced from the Department for Education which our clever data scientists then imported into Arbor’s Adaptive Management System for analysis and output. The result is an individual academies’ financial budget report unique to each academy.
Your Financial Benchmarking report will contain an overview of funding and spending across your academy from the years 2017-2018. We have also compared your data with schools like you, schools in your local Authority and the national average. Quickly spot trends and anomalies in your finance data with our easy-to-read graphs, and see how your income and spending has changed over time with our 3-year rolling averages.
See how much funding your school received last academic year broken down into percentages and compared to schools like your, Local Authority schools and the national average.
Find out what percentage of grant funding you were given, across: direct grants, community grants and targeted grants.
Fig 2: Screenshot showing a Grant Funding breakdown in Arbor’s Financial Benchmarking report
See what percentage of self-generated funding you had, taking into account: community-focused school facilities, income from facilities and services, income from catering, receipts from insurance claims, donations and more!
Fig 3: Screenshot showing Self-generated Funding in our Financial Benchmarking report
See how much your schools spent in the years 2017-2018 broken down into percentages and compared to schools like your, Local Authority schools and the national average.
Find out what percentage of staff spend there was, across: teaching staff, supply staff, education support staff and administrative staff.
Fig 4: Screenshot showing a Staff Spending breakdown in Arbor’s Financial Benchmarking report
See what percentage of income was spent on the school premises, including: premises staff, cleaning and maintenance.
Fig 5: Screenshot showing a premises spending breakdown in our Financial Benchmarking report
Have a look at your spending on different occupations, including: energy, water and sewage and catering expenditure.
Fig 6: Screenshot showing occupations spending in our Financial Benchmarking report
See what your academy spends on supplies and services, taking into account: administrative supplies, educational supplies and bought-in professional services.
Fig 7: Screenshot showing supplies and services spending in our Financial Benchmarking report
How do I get my hands on a free report?
It’s super easy for you to download your academy’s free, personalised financial benchmarking report. Just log in to your Arbor Insight portal here: https://login.arbor.sc/
I haven’t used Arbor Insight before – how do I sign up?
Click here to sign up to your academy’s free Arbor Insight portal: https://login.arbor.sc/auth/register
You haven’t answered my questions! Can I contact you for help?
Absolutely. You can reach the Arbor team at email@example.com or by calling us on 020 8050 1028.
We’re excited to let you know that all your KS1, KS2 and Phonics Analyse School Performance (ASP) data has been added to your Group Insight portal. We’ve crunched your schools’ 2019 data ahead of the DfE and used it to build free, interactive dashboards which you can use to explore aggregated statistics for all your
We’re excited to let you know that all your KS1, KS2 and Phonics Analyse School Performance (ASP) data has been added to your Group Insight portal. We’ve crunched your schools’ 2019 data ahead of the DfE and used it to build free, interactive dashboards which you can use to explore aggregated statistics for all your schools. Keep reading to find out more about Group Insight and how you can use it to plan your MAT’s improvement approach for next year.
What is Group Insight?
Group Insight is a free performance analysis tool for MATs to help you analyse your schools’ latest Analyse School Performance (ASP) data. We automatically analyse your MAT’s latest school performance data and present it back to you in easy-to-understand PDF reports and personalised dashboards, so you don’t have to spend hours aggregating and analysing the raw data yourself.
Fig 1.: A screenshot of a Group Insight dashboard displaying KS2 data across a MAT
How do you present my schools’ KS1 & KS2 data?
Your dashboards are great for helping you spot trends over the past three years, identifying which schools are driving over (or under) performance, and benchmarking your academies against national and top quintile averages. You can also use them to view each of your schools’ outcomes side by side, drill down into individual school outcomes and show impact over time when reporting to trustees.
Fig 2.: A screenshot of a Group Insight comparing a MATs school results by cluster
We’ve also updated our popular pre-paid PDF reports analysing your schools’ attainment and progress, highlighting areas to close the gap, and exploring patterns between your trust’s outcomes and the context of your unique demographic intake in our new Understanding Your School Report, which you can download via your portal.
Click here to log in & access your 2019 reports and dashboards: https://login.arbor.sc
Fig 3.: A screenshot of a Group Insight comparing a MATs results by demographic
“Clear, saves us time, available sooner than DfE MAT data, and is extremely well presented, making reporting to Trustees very straight forward”
– Paul James, Chief Executive Officer at River Learning Trust
How do I sign up?
Click here to sign up to your MAT’s free Arbor Insight portal: https://login.arbor.sc/auth/group-register
When will you add KS4 data to my portal?
We expect to receive your 2018/2019 KS4 data from the DfE very soon – so watch this space! If you’re already signed up, we’ll email you automatically to let you know when this happens.
Do you offer training on how my schools can use their Arbor Insight portal?
Yes! We run a free Arbor Insight Roadshow each Autumn Term offering free, in-person training to help your schools’ central teams to get the most out of Arbor Insight. Click here to sign up
Where can I hear more about Group Insight?
You can hear our CRO, Phillippa De’Ath, talk about how you can use your ASP data to drive school improvement across your MAT at the Schools & Academies Show in Birmingham. She’ll be speaking in the Business & Finance Theatre from 10:10-10:30 on 14th November 2019.
Can I use Group Insight alongside the DfE’s ASP service?
Yes! Arbor is an accredited supplier of ASP data, which means we receive secure, early access to all your school performance data from the DfE as soon as it’s released. So far over 10,000 schools have signed up to use us. Lots of schools and MATs use us instead of the DfE’s ASP service, but you can also use our reports and dashboards as a companion to the DfE’s analysis.
This November, we’re also holding another of our popular MAT Conferences in Manchester. Over 80 MAT leaders from over 50 MATs have already signed up! Click here to book your free place before they sell out
We’re very pleased to announce that we have now updated your Arbor Insight reports and dashboards with your 2019 KS1 & Phonics data! As an accredited supplier of ASP data, you can get early access to your school’s performance data in your free Arbor Insight portal, where we have done the work for you in
We’re very pleased to announce that we have now updated your Arbor Insight reports and dashboards with your 2019 KS1 & Phonics data!
As an accredited supplier of ASP data, you can get early access to your school’s performance data in your free Arbor Insight portal, where we have done the work for you in analysing your performance data! Now you can view your Phonics, KS1 and KS2 (including disadvantaged) data in your Arbor Insight portal.
We’ve used your data to build free interactive dashboards and 7 premium performance reports, which show your attainment & progress over time, identify gaps between different student groups and explain your performance in the context of your school’s unique demographic intake. Over 10,000 schools are now using Arbor Insight to benchmark their performance, so if you’re thinking of signing up, you’ll be in good company!
Just sign up here to your free portal: https://login.arbor.sc/auth/register
Or if you already have an account, log in here: https://login.arbor.sc/auth/login
You will find your latest KS1 data in our popular premium reports:
Fig 1.: Screenshots of Arbor’s popular premium reports
NEW Understanding Your School report
Our new report is designed to help you analyse your outcomes in the context of your school’s unique demographic intake. It benchmarks you against similar schools, the top quintile & the national average, and helps you explore patterns between the socio-economic makeup of your local area, deprivation and attainment. Use this report to help inform your school improvement strategy.
Closing the Gap Reports x5
The Gap reports are a set of 5 reports showing attainment & attendance gaps between different student groups at your school. The government wants schools to focus, not only on overall attainment, but on narrowing these achievement gaps between disadvantaged and non-disadvantaged pupils. There does not appear to be a direct relationship between increased school funding and increased pupil attainment – what matters most is how schools can effectively and efficiently use the resources they have (both financial and human) for maximum impact. You first need to see where these gaps appear in your school in order to focus your attention and resources – and these reports do the job for you!
Attainment & Progress Report
The Attainment & Progress reports analyse the attainment and progress of different demographic groups at your school. Use them to help identify where you could be making more progress. We benchmark each subject against the performance of all other subjects combined and against the national average of each subject and all other subjects combined.
You will also find your KS1 & Phonics data in your FREE performance dashboards -find them on the left hand side of your portal and start analysing your performance data now!
Don’t forget, you’re invited to free Insight Training sessions this Autumn! Learn how you can use your Arbor Insight reports and dashboards to dig deeper into the trends behind your benchmarking data, understand how to determine whether your results are typical, quickly identify your school’s strengths & weaknesses and take part in workshops about how you can write specific, measurable objectives for your School Improvement Plan.
Spaces are limited, so click here to reserve your free spot at a training session near you!
Get in touch if you have any questions or would like help signing up, using your dashboards, purchasing reports or anything else! We’re always here to help. Just email firstname.lastname@example.org or call us on 0207 043 1830.
Arbor Insight is a free tool we offer alongside our simple, smart, cloud-based MIS. If you’re interested in learning more about how our MIS could help to transform the way you work, book a free demo here or call our MIS Demo Team on 0208 050 1028.
We’re thrilled to announce that we’ve just added 2019 KS2 data to Arbor Insight. We’ve crunched your data ahead of the DfE to give you a head start analysing your latest SATs results, making Arbor one of the first places you can see your latest data! We’ve been busy updating your dashboards, readying your reports
We’re thrilled to announce that we’ve just added 2019 KS2 data to Arbor Insight. We’ve crunched your data ahead of the DfE to give you a head start analysing your latest SATs results, making Arbor one of the first places you can see your latest data!
We’ve been busy updating your dashboards, readying your reports (and even adding a whole new report!) to analyse your performance data for you so you can get on with using it to plan your school improvement approach. Keep reading to find out more about Arbor Insight, what’s changed and how our reports can help.
What is Arbor Insight?
Arbor Insight is a free performance analysis tool for schools & MATs to help you analyse your latest Analyse School Performance (ASP) and finance data. We automatically analyse your latest school performance data and present it back to you in easy-to-understand PDF reports and interactive dashboards, so you don’t have to spend hours analysing the raw data yourself. It’s free to sign up for your school’s interactive dashboards and portal, and we charge a small amount for our premium, in-depth reports (as they take a bit more work to build).
Can I use Arbor Insight alongside the DfE’s ASP service?
Yes! Arbor is an accredited supplier of ASP data, which means we receive secure, early access to all your school performance data from the DfE as soon as it’s released. So far over 10,000 schools have signed up to use us. Lots of schools use us instead of the DfE’s ASP service, but you can also use our reports and dashboards as a companion to the DfE’s analysis.
How do you present my KS2 data?
Your school’s Arbor Insight portal contains free interactive dashboards benchmarking your performance against the national average, as well as against schools “Like You” and “Top Quintile” schools. Click on any measure to drill down and see which demographic groups are driving over or underperformance.
Image 1: A screenshot of one of Arbor’s free interactive dashboards
You can also dig deeper into your KS2 data with our popular paid-for PDF reports:
What’s the new report you mentioned?
This year we’ve released our brand new Understanding Your School Report, which helps you understand your performance in the context of your school’s unique demographic intake. See your performance benchmarked against similar, top 20% & national averages, and explore patterns between the socio-economic makeup of your local area, deprivation and attainment.
Image 2: A screenshot of Arbor’s new Understanding Your School Report
Click here to sign up to your school’s free Arbor Insight portal: https://login.arbor.sc/auth/register
When will you add KS1 & KS4 data to my portal?
We expect to receive your 2018/2019 KS1 data in October and your KS4 data in November – so watch this space! If you’re already signed up, we’ll email you automatically to let you know when this happens.
Do you offer training on using my school’s Arbor Insight portal?
Yes! We run a free Arbor Insight Roadshow each Autumn Term to help you get the most out of your school’s dashboards and reports. Click here to sign up for your slot
Absolutely. You can reach our Arbor Insight Team on email@example.com or by calling 0207 043 1830.
Data and Insight | School Operations
Data entry is a daunting prospect for most teachers. With the amount of data they are expected to record, it can often take up a large portion of their daily workload, and workload is listed as one of the most common reasons for leaving the profession. The good news is it doesn’t have to be
Data entry is a daunting prospect for most teachers. With the amount of data they are expected to record, it can often take up a large portion of their daily workload, and workload is listed as one of the most common reasons for leaving the profession. The good news is it doesn’t have to be this way – keep reading to see how you can transform the way your school deals with data entry.
Making data work
In November 2018, the Teacher Workload Advisory Group released a report called “Making Data Work”. The report reveals that teachers consider unnecessary tasks around recording, monitoring and analysing data to be notably time-consuming, with data entry highlighted as the biggest problem. The Teacher Workload Advisory Group set out a number of suggestions for the DfE to consider. These included:
So what’s the best way to reduce data entry at your school? Try following these simple steps:
Part 1: Streamline your systems
Before you do anything else, you need to ask yourself if all the third-party systems you’re currently using still work for your school. Are they up to date? Do you need all of them? Do staff engage with them regularly?
Find out by running a systems audit. It’s easy to do – just follow the instructions in our blog on how to audit your school or MAT’s IT systems. By running a systems audit, you can reduce the number of places you have to enter data. Goodbye, multiple logins! Your staff will have fewer systems and apps to keep track of, which will considerably reduce their administrative workload.
Image 1: How we encourage schools to approach an IT systems audit
Part 2: Make sure any extra systems you’re using are integrated with your MIS
Over the years, your school has probably invested in lots of different systems that were useful at the time, but which don’t integrate with your current MIS. This can make everyday tasks like following up with detentions and creating meal plans much more complicated and time-consuming than they need to be, as you have to visit external apps in order to properly record all of the data. Using systems that integrate with your MIS can make admin a lot simpler. For example, Arbor’s integrations with apps like CPOMS and Inventry means that you only have to enter student data once and it will update automatically in these apps.
The “Making Data Work” report also advises that schools should “minimise or eliminate the number of pieces of information teachers are expected to compile.” Ensuring your systems integrate with your MIS will mean that you can access all your data in one place, which means you won’t have to spend time transferring it from one system to another.
Image 2: How parents can view all payments and invoices from Arbor’s Parent Portal
Part 3: Set up a system to suit your school
It’s important to think about how your MIS can best serve your school. For example, the report advises that schools should have simple systems that allow behaviour incidents to be logged during lesson time, rather than at break or lunch. In Arbor, you can set up incident workflows that track negative and positive behaviour (e.g. a Level 2 incident could automatically create a lunchtime detention). Automating workflows in this way means that teachers don’t have to add this information manually, which will save them a significant amount of time.
Your MIS can also help to reduce data with quick group selection. For example, in Arbor you can select absentees from your register and instantly send emails to their primary guardians with the help of our mail merge tool. You can even use a pre-made message template so you won’t have to type a single word!
Image 3: How you can follow up on students registered absent in Arbor
Not only will reducing data entry help to improve workloads, it will make your staff happier too. So – streamline your systems, make sure they integrate with your MIS, and set it all up to suit your school. If you’d like to hear more about how Arbor could help you reduce data entry at your school, why not drop us a message here?
The educational landscape is constantly changing, not least the way in which student and school performance is measured. While working in my previous role as a secondary school data manager we still had Levels, GCSEs graded A* to G and RAISEonline. Now we have Progress 8 and Attainment 8 as the headline measures used to
The educational landscape is constantly changing, not least the way in which student and school performance is measured.
While working in my previous role as a secondary school data manager we still had Levels, GCSEs graded A* to G and RAISEonline. Now we have Progress 8 and Attainment 8 as the headline measures used to measure school performance, along with the English Baccalaureate (EBacc) average point score, and the proportion of pupils attaining English and Maths at a grade 5 or above.
Fig 1.: Your free Arbor Insight dashboards analyse trends over the past three years and benchmark you against local, national and “Schools like you” measures
Arbor Insight is all you need to analyse past performance and view trends, but how can you estimate your accountability measures for your current Year 11 cohort?
First, some quick definitions:
Attainment 8 for each student is simply the sum of values of the highest GCSEs within four “buckets”: Maths, English, EBAcc and Open (other subjects). Maths is double-weighted. The highest of English Language and English Literature is placed in the English bucket and is also double-weighted, provided that the student takes both. Some non-GCSE qualifications can count towards the ‘Open’ slots.
Progress 8 for each student is one tenth of the difference between the student’s predicted Attainment 8, and the expected Attainment 8 score, based on their KS2 Prior Attainment. Both measures are calculated after the Key Stage 4 results are released each year, because they’re based on the actual average results achieved by students.
The first and easiest way to analyse your Key Stage 4 performance is to check the features available in your MIS or assessments system. Your MIS may provide estimates for Progress 8 and Attainment 8. Arbor does this within the Progress 8 Analysis dashboard. This automatically uses the complex DfE methodology and will give you a useful overview of your estimated measures. The estimates for each student can be downloaded or sent to a live feed:
Fig. 2.: Arbor uses DfE methodology to calculate estimates for Progress 8 & Attainment 8
What can you do if your MIS doesn’t provide this analysis?
You can calculate your Progress 8 measures within a spreadsheet. You’ll need to start by calculating the KS2 prior attainment for each student. For details of how the DfE calculate the KS2 Prior Attainment you should refer to the Secondary accountability measures document published by the Department for Education. It’s currently the rounded average of the fine scores for Reading and Maths. Below is an example of how the fine scores can be calculated within a spreadsheet – feel free to copy my work!
You can use lookups on the test marks to find the fine score for each student. Then average the two marks and round to one decimal place:
You then need to download the grades for English, Maths, Ebacc and Open from your MIS. To calculate the Attainment 8 convert these grades to values and sum, doubling the value for Maths and English (providing students are taking both English Literature and English Language).
The Secondary accountability measures document provides Attainment 8 and “bucket” averages from the previous year. These can be copied into your spreadsheet.
Use this data to calculate the expected Attainment 8 score and marks for each student. The KS2 Prior Attainment for the student is used to lookup the average marks for Attainment 8 and for the English, Maths, EBacc and Open subjects. The average marks for Maths and English need to be divided by 2 to give the expected marks for these subjects; the EBacc and Open marks need to be divided by 3.
The Progress 8 for each student can be found by subtracting the expected Attainment 8 score from the predicted Attainment 8 score for each student and dividing by 10:
To calculate the overall school Progress 8, find the average of all the students’ Progress 8:
Finally, you can refer to columns from the different sheets and use conditional formatting to analyse your data further:
I hope these tips have been useful for new data managers, as well as those who still aren’t quite comfortable with the new system. If you’d like to find out how you can perform your Progress 8 or Attainment 8 analysis in Arbor instead, do get in touch here!
We’ve just updated our KS1 and KS2 free dashboards and premium Insight reports with the latest ASP disadvantaged data! This means that our Ofsted Readiness, Attainment & Progress and Closing the Gap reports all now include validated & disadvantaged KS2 data and disadvantaged data & phonics KS1 results. With the release of this new disadvantaged
We’ve just updated our KS1 and KS2 free dashboards and premium Insight reports with the latest ASP disadvantaged data!
This means that our Ofsted Readiness, Attainment & Progress and Closing the Gap reports all now include validated & disadvantaged KS2 data and disadvantaged data & phonics KS1 results.
With the release of this new disadvantaged data, the Department for Education has published new analysis about the disadvantage gap in UK schools. Looking at provisional phonics data from 2018, 70% of pupils eligible for free school meals (FSM) met the expected standard in phonics in year 1, compared to 84% of all other pupils. The gap between pupils eligible for FSM and all other pupils is 14 percentage points, and remains the same compared to 2017.
The gap between disadvantaged and non-disadvantaged KS2 pupils (measured using the disadvantage gap index) has decreased in each of the last seven years, narrowing by 3% in the latest year and 13.2% since 2011.
If you’d like to know how your disadvantaged pupils have performed relative to national averages and other pupils within your school, you can find all the information you need in your Insight reports, which are available to view in your Arbor Insight portal. If you’ve already got an account, you can click here to log in, or click here to create an account for your school or MAT.
A closer look at what’s new in our Insight reports:
Since we imported this new data, we’ve made a few changes to your Arbor Insight reports. We’ve outlined the most important changes below.
1. Ofsted Readiness report
In the KS1 section of this report, we’ve added disadvantage cohort benchmarks to the Working at Expected Standard measures for Reading, Writing and Maths. For KS2, this added benchmark can be found in Averaged Scaled Score and Overall Progress Score for Reading, Writing and Maths.
Fig. 1: The bar graphs above show your school’s average as a benchmark against each demographic group, helping you to quickly see which cohorts are under-performing or exceeding the school average
Fig. 2: A screenshot of our Ofsted Readiness report
You may have also noticed changes in the condensed Closing the Gap section in our Ofsted Readiness report for both KS1 and KS2 data (see above image). For KS1, Working at the Expected Standard for Reading, Writing and Maths now has added disadvantaged measures. For KS2, this measure has been added under Averaged Scale Score in Reading and Maths. The text callout for these measures contain useful calculations which explain your data in plain english & calculate the percentage by which the gap for each measure has widened or narrowed in your school.
2. Attainment & Progress report:
The KS1 & KS2 Attainment and Progress reports also now contain disadvantaged benchmarks and cohort data for 2017/18, allowing you to benchmark this cohort against all other demographic groupings in your school. For KS1, this chart can be found in measures, Achieving Expected Standard: Y1 Phonics, Achieving Expected Standard and Working at Greater Depth within the Expected Standard for Reading, Writing and Maths. For KS2, this graph appears in Overall Progress Score for Reading, Writing and Maths.
Fig. 3: A screenshot of our Attainment & Progress report
3. Closing the Gap report: Focus on Disadvantage
This particular report is part of a series of 5 reports which help to identify the gaps between student groups, showing which groups are under or over performing relative to the school, group and national averages.
At the beginning of this report there is a star chart which shows the gaps between disadvantaged and EAL pupils compared to the rest of the school. For KS1, the measures shown in this graph are attendance and attainment, and for KS2 they are attendance, attainment and progress measures. This star chart is colour coded to help you identify any areas that need your attention (or indeed any areas that should be shouted about because there is no gap!); for example, a green star indicates there is no gap between the group and the school average, whilst an orange star indicates the group has performed below the school and national averages. A yellow star indicates the group has performed between them.
Fig. 4: A screenshot of the star chart at the beginning of the Closing the Gap report
Your reports clearly display the cohort size for each measure, so you know how much statistical significance each outcome has. This can help you know which areas you should be prioritising.
Finally, KS4 validated and disadvantaged data will be released in the next few weeks. Once it’s released, Arbor Insight portals & reports will be automatically updated.
As one of only a few accredited suppliers, we receive all of our data for Arbor Insight reports and dashboards directly from the DfE. Over 10,000 schools are now using Arbor Insight to benchmark their performance, so if you’re thinking of signing up, you’ll be in good company!
We’ve just released our 2017/18 Schools Financial Benchmarking report for all schools in England! Like all Arbor Insight reports, Arbor’s Financial Benchmarking report uses colour coding, call-outs written in plain English, and specific benchmarks to give you a clear picture of your spend & income, even for those not used to working with data. Thousands
We’ve just released our 2017/18 Schools Financial Benchmarking report for all schools in England!
Like all Arbor Insight reports, Arbor’s Financial Benchmarking report uses colour coding, call-outs written in plain English, and specific benchmarks to give you a clear picture of your spend & income, even for those not used to working with data. Thousands of schools up and down the country use our Financial Benchmarking report to help plan next year’s budget, and explain their spending to SLT & governors.
The report is broken down into clear sections, with a diagram per measure on spend and income. Trends show how income and spend has changed over time, helping you to plan next year’s budget informed by your school’s data.
As well as showing spend and income as an exact figure, as a percentage of total funds allocated and per pupil, we’ve built specific benchmarks for this report to give your financial data additional context. Along with benchmarking you against the national average, the Financial Benchmarking report also benchmarks each measure against schools in your LA and schools that are ‘like you’.
How we derived LA and National averages:
Arbor benchmarks your school against a variety of measures, helping you to analyse your budget in a wider context. We’ve only compared your school to the averages for other primary, secondary, or special schools (depending on your school type), to make the comparisons in the report more meaningful. After all, a primary school’s spend is different to that of a secondary school, which will also be different to that of a special school. An average that included all three wouldn’t be accurate!
How we created the ‘schools like you’ benchmark:
We created the ‘schools like you’ measure to give you the most meaningful comparison for your school. First, we filtered by schools of your type (primary, secondary, or special) for the reasons mentioned above. Then, we filtered by schools who were inside/outside London, as this changes your cost structure. Next we filtered by size, ensuring that your school is compared to schools with a similar number of pupils. Finally we took your FSM, SEN and EAL data, weighted them based on the size of the attainment gaps at KS2, and combined them into a baseline score to find schools with similar demographic intakes to your school.
For example, if you’re a large rural secondary school with a lot of FSM students, your spending in each area will be benchmarked against other large rural secondary schools with a lot of FSM students. The schools ‘like you’ measure helps you account for your specific circumstances and understand why your spending might be above or below average.
Image 1: Example page, graphing overall spend
On this page the simple, digestible call outs explain how the school compares to schools like them and the national average on each section of spend at the school.
Image 2: Example Spend page, focusing in on maintenance and improvement
Bar graphs show the spend of each section as a percentage of total spend, while the line graph depicts not only the exact spend figure but how it has changed over 3 years compared with schools like you, schools in your LA and the national average. The grey arrows show the overall calculation of how much this figure has changed.
Image 3: Example Funding page – Grant Funding: Targeted Grants
Funding pages have the same layout as spend pages. Again, colour coding for trends and bar graphs makes your data easy to understand. You can quickly see if your level of funding is in line with what it should be, and if there are any areas of concern that need to be addressed when planning next year’s budget.
If you’re a current user, you can log in to view your updated dashboards and purchase your reports immediately here: https://login.arbor.sc/auth/login
If you don’t already use Arbor Insight, click here to sign up & view your performance dashboards and purchase your Financial & ASP reports: https://login.arbor.sc/auth/register
We’ve just released our free annual KS2 Performance Summary! This report gives schools and academies an overview of their latest ASP data. Trends in your performance are clearly plotted over the last three years, and benchmarked against the national average, schools in the local authority and schools similar to you. We use Analyse School Performance
We’ve just released our free annual KS2 Performance Summary! This report gives schools and academies an overview of their latest ASP data. Trends in your performance are clearly plotted over the last three years, and benchmarked against the national average, schools in the local authority and schools similar to you.
We use Analyse School Performance data from the Department for Education to build this report. ASP data is not suppressed, so the cohort sizes are more accurate and representative, giving a more in-depth overview of your school’s performance.
Your Performance Summary Report covers school context, overall attainment, attainment, averaged scaled score and progress by subject, with a brief Closing the Gap section which focuses on prior attainment and gender. For a deeper dive into any of the measures present in this report, take a look at our premium reports that can be purchased from all school Insight portals.
Image 1: Attainment by subject: working at a higher standard
You can easily see trends from the last couple of years by looking at the arrows below this year’s outcome. These arrows are colour-coded so you can check if improvements in this measure are consistent with an established trend, or whether they’re a more recent development. Seeing your data presented in this easy-to-understand format can help expedite the questioning of your data. You can ask why 5 times and use socratic questioning to understand why and how your school reached the outcomes it did this year (we’ve written a blog about this – click here to read it!).
Image 2: Closing the gap: focus on gender page
For a more in-depth report focusing on each demographic in your school, you should use our Closing the Gap report bundle that contains 5 reports, each with an individual focus: disadvantaged pupils, SEN pupils, gender, ethnicity and prior attainment. These reports can help you narrow important attainment gaps within your school, as they show you in detail exactly where interventions need to be made.
How did you derive my LA and National averages?
We’ve benchmarked your school on a variety of measures to allow you to analyse your performance in a wider context. We only compared your School to the averages for other primary, secondary, or special schools (depending on your school type), to make the comparisons in the report more meaningful.
What is a school ‘like me’?
We created the schools ‘like you’ measure to give you the most meaningful comparison for your School. First, we filtered by schools of your type (primary, secondary, or special) for the reasons mentioned above. Next we filtered by size, ensuring that your school is compared to schools with a similar number of students. Finally we took your FSM, SEN and EAL data, weighted them based on the size of the attainment gaps at KS2, and combined them into a baseline score to find schools with similar demographic intakes to your School.
For example, if you’re a large rural secondary school with a lot of FSM students, your performance in each area will be benchmarked against other large rural secondary schools with a lot of FSM students. The schools ‘like you’ measure helps you account for your specific circumstances and understand why your performance might be above or below average.
If you’re a current user, you can log in to view your updated dashboards and reports immediately here: https://login.arbor.sc/auth/login
If you don’t already use Arbor Insight, click here to sign up for your free portal & view your performance dashboards & KS2 reports: https://login.arbor.sc/auth/register
We’ve just released our Arbor Insight 2016/17 Academies Financial Benchmarking report. All schools that academised before September 2016 will now be able to log in to their free Insight portal and download their newest Financial Benchmarking report! You can use your Financial Benchmarking report in governors meetings, financial planning meetings and to improve next year’s
We’ve just released our Arbor Insight 2016/17 Academies Financial Benchmarking report. All schools that academised before September 2016 will now be able to log in to their free Insight portal and download their newest Financial Benchmarking report!
You can use your Financial Benchmarking report in governors meetings, financial planning meetings and to improve next year’s school budget. We calculate specific benchmarks in your Financial Benchmarking report to give your data context and enable your budget plans to be effective and realistic. Your report benchmarks your school against schools ‘like you’, ‘Schools in your LA’ and the ‘national average’.
(Image 1: AFB report page on the breakdown spend of an example school)
We’ve benchmarked your school on a variety of measures to allow you to analyse your budget in a wider context. We only compared your School to the averages for other primary, secondary, or special schools (depending on your school type), to make the comparisons in the report more meaningful. After all, a primary academy’s spend is different from a secondary academy’s, which is different from a special academy. An average that included all three would be misleading.
We created the schools ‘like you’ measure to give you the most meaningful comparison for your School. First, we filtered by schools of your type (primary, secondary, or special) for the reasons mentioned above. Then, we filtered by schools who were inside/outside London as this changes your cost structure. Next we filtered by size, ensuring that your school is compared to schools with a similar number of students. Finally we took your FSM, SEN and EAL data, weighted them based on the size of the attainment gaps at KS2, and combined them into a baseline score to find schools with similar demographic intakes to your School.
For example, if you’re a large rural secondary school with a lot of FSM students, your spending in each area will be benchmarked against other large rural secondary schools with a lot of FSM students. The schools ‘like you’ measure helps you account for your specific circumstances and understand why your spending might be above or below average.
(Image 2: AFB report page showing staff expenditure)
For each spend and income measure, your Arbor Insight Academies Financial Benchmarking report will show how much you spent as a whole, as a percent of your total spend and per pupil. We add detailed analysis to all of your graphs so you can quickly see the headlines for each measure.
(Image 3: AFB report page showing three year trends and easy-to-understand text callouts)
Our 2017/18 Schools Financial Benchmarking report will be released early next term. If you have pre-ordered this report you will receive an email from us as soon it is released, and you can then download it from your portal.
If you don’t already use Arbor Insight, click here to sign up for your free portal & view your performance dashboards & KS4 reports: https://login.arbor.sc/auth/register
— I recently spoke at our Manchester MAT Conference on how culture beats strategy when MATs start thinking about centralising data, operations and people. At Arbor we talk about 4 (broad) types of MAT cultures, and how the degree of MAT alignment vs school autonomy dictates how you approach scaling systems, processes and people. What
I recently spoke at our Manchester MAT Conference on how culture beats strategy when MATs start thinking about centralising data, operations and people.
At Arbor we talk about 4 (broad) types of MAT cultures, and how the degree of MAT alignment vs school autonomy dictates how you approach scaling systems, processes and people. What we see more and more from the 57 MATs who we provide MIS systems to, and the 100s more we are speaking to is that centralisation of school back office functions such as data, HR, finance and operations is the general direction of travel for all MATs. The debate is centred around the degree, style and pace at which this happens.
We’ve gathered feedback about the 4 different ways MATs go about scaling decision making, curriculum & assessment, systems & processes and their central team in the presentation below. See what you think and whether you fit into 1 or more of the categories I describe.
A couple of weeks ago we added 2018 KS4 Analyse School Performance (ASP) data to our award-winning Insight dashboards and reports. Arbor Insight is a free benchmarking portal that we’ve created for every school and MAT in the country, and our premium performance reports provide in-depth analysis of your data to help you spot trends
A couple of weeks ago we added 2018 KS4 Analyse School Performance (ASP) data to our award-winning Insight dashboards and reports. Arbor Insight is a free benchmarking portal that we’ve created for every school and MAT in the country, and our premium performance reports provide in-depth analysis of your data to help you spot trends you might have otherwise missed, understand strengths & weaknesses, and make interventions.
This is the first year that all 5 core English Baccalaureate subjects (English, Maths, Science, Language and Humanities) have been graded 9-1 under the new grading scale, so we’ve updated your KS4 Insight reports in light of the reform, to make sure you’re still getting accurate insight into your school’s performance data.
How have my reports changed?
Schools and MATs will notice a few changes in their KS4 ASP performance reports and dashboards since last year:
Ofsted Readiness report
As well as highlighting your strengths and weaknesses in performance measures, our Ofsted Readiness report has 6 graphs for each core subject. These include how many pupils in your school or MAT achieved a Strong or Standard Pass, benchmarked against schools graded Good and Outstanding at their last Ofsted inspection.
Image: an example from an Ofsted Readiness report: Maths Attainment page
Image: an example from an Ofsted Readiness report: Achieving a Strong Pass in English & Maths – showing three year trend data and your school benchmarked against outstanding schools in the country
Attainment & Progress report
In this report, we show you the percentage of pupils achieving a Strong Pass, so you can understand where you need to improve to help all pupils achieve this goal. You can see how your pupils performed in the core subjects (English, Maths and Sciences) how the core average compares, and compare these to national averages.
Closing the Gap reports (x5)
Each report, in this set of five, focuses on a different attainment gap that is prevalent in England. You can see how wide or narrow this gap is in your school, and compare it with the national average. For example, you can see what percentage of boys in your school are achieving a Standard Pass (4+) in EBacc Maths Pillar, and compare that rate against your girls. You can find this information in the Closing the Gap report: Focus on Gender.
Our take on Analyse School Performance (ASP) The DfE launched its new, slimmed down service called Analyse School Performance (ASP) to replace RAISEonline in April last year. ASP is intended to be a sister service to Compare School Performance (which helps you benchmark your school’s performance), and was designed to be a simpler and more straightforward service than RAISEonline.
Our take on Analyse School Performance (ASP)
The DfE launched its new, slimmed down service called Analyse School Performance (ASP) to replace RAISEonline in April last year. ASP is intended to be a sister service to Compare School Performance (which helps you benchmark your school’s performance), and was designed to be a simpler and more straightforward service than RAISEonline. In theory, this sounds great – but what’s it actually like using ASP for meaningful performance analysis?
At first glance, ASP does seem easier to use and more useful than RAISEonline. It’s not flashy – but to get a quick overview of your data, ASP works well. The charts are clearer to read than in the old RAISEonline, and some less frequently used data (like confidence intervals) have been dropped, which makes it easier to digest your data at a high level.
But what about if you want to dig deeper into your performance? Below we show you how ASP can help your Senior Leadership team get an overview to ask the right questions – but how you’ll need to use other performance analysis tools like Arbor Insight to go one level deeper and help you answer them.
Using Arbor alongside ASP
As in the old RAISEonline, ASP shows users an overview of headline and key measures for your school. The problem is, seeing your performance at such a high level doesn’t help you truly understand why your school performed as it did.
Analysing Progress 8 in ASP
For example, after seeing this chart on Attainment 8 in ASP, schools might wonder:
Analysing Progress 8 in Arbor
Services like Arbor can help you answer these questions. Our reports (like the example shown above) use trend data to help you see how your performance has changed over time, and we benchmark your school not just nationally and locally, but against similar schools and Outstanding schools too.
The DfE has also introduced scatter graphs in ASP. These graphs are helpful in that they allow schools to see individual students’ attainment on a key metric, and identify whether there are any trends with other measures. For example, the scatter graph below shows the correlation between KS2 prior attainment and KS4 Progress 8 score.
An example scatter graph in ASP
Again, whilst this graph is good at giving an overview, schools might need to look elsewhere to answer key questions this graph raises such as:
Benchmarking different groups in Arbor
In Arbor we help schools answer these questions by using plain text call outs to explain how significant a trend is. We also benchmark different groups within your school against each other, and against national and local averages to help you see your performance in a more holistic context.
Use Arbor to give you the edge in discussions with Ofsted, and to provide context to your governors
Using Arbor Insight reports, like the ones shown above, can give you an extra advantage when an inspector calls. Our reports can help you show things like:
Arbor Insight reports help you present the real story behind your data – sometimes this isn’t clear just from looking at your average headline measures for the current year. Once you understand the real picture you can have much more constructive conversations with stakeholders like Ofsted and your Governors to help you focus on your priority areas for the year ahead.
Want to find out more? Read our blog about how Arbor Insight can help your governors get to grips with data here
This blog has been written for Arbor by Oliver Kean, Service Development Manager at Governors for Schools. One of the first things governors realise when they start is that the role involves data. A lot of data. Data on attainment, about progress, on different groups, data on pupils’ attendance, punctuality, behaviour incidents. And it’s not
This blog has been written for Arbor by Oliver Kean, Service Development Manager at Governors for Schools.
One of the first things governors realise when they start is that the role involves data. A lot of data. Data on attainment, about progress, on different groups, data on pupils’ attendance, punctuality, behaviour incidents.
And it’s not just data focused for their own school. Governors are presented with data on national, local and similar schools so they can benchmark their performance to identify areas where they might be able to do better.
They then need to understand what the data is suggesting sufficiently well to construct challenging, relevant questions that hold experienced headteachers and other members of the senior team to account, and identify where it puts the school at risk of not achieving particular performance thresholds that could lead to intervention.
It’s a challenge for all governors, but especially those who are less confident with numbers and statistics (who may nevertheless have valuable expertise elsewhere). Nowadays, everyone involved in school governance is expected to be able to use data to help deliver effective governance. However, it’s clear that not all school governors can. A recent report from Ofsted said:
The ability to understand and query performance data was a common area of weakness … Weak governing bodies rarely provided enough challenge to the headteacher’s interpretation of published and internal assessment information, absence rates and exclusion data. There are also schools at which governors are not given access to assessment information. This limits their ability to challenge leaders.
Data’s rise within the accountability system hasn’t gone unchallenged, however. In response to the accountability system’s seemingly insatiable hunger for ever more complex, in-depth, up-to-date data some teachers have begun to complain that it now represents an unmanageable aspect of their work, and one that distracts them from the core nature of teaching. The oft-repeated complaint that education is about more than just numbers and learning is about more than just stats is nevertheless worth repeating, because it’s fundamentally true. You’d be hard-pressed to find a teacher that went into the role first and foremost to deliver incremental improvements in narrow performance measures derived from assessment results.
Ofsted has begun to show signs of understanding this as it works on a new inspection framework; chief inspector Amanda Spielman recently said that schools that place too narrow an emphasis on their data systems are more likely to suffer falls in performance. But good governors have always known this. They know that understanding the health of a school is equally about the unmeasurable, the emotional and the invisible. That’s why the best governors understand and apply data to their role, but also make sure that they visit school, speak to parents, pupils and staff, look at books, displays, go for lunch, spend time in the staff room, and see the playground. Of course, this places demands on governors’ already limited time and energy – anything that frees them up to see a school, its complexities, nuances and atmosphere ‘in the round’ is to be welcomed.
Attending training on data is one way to get smarter, thus providing more time for governance other crucial activities. Training can help governors to quickly understand what data might be telling us, provide quick ways to assess its robustness and reliability, as well as show us the limits to its usefulness (and where investigation elsewhere might be more appropriate). A quick and convenient way to learn more is to use the Governors for Schools eLearning for an introduction to some of the key concepts and ways to use data.
Moreover, adopting more intuitive data reporting systems, such as that provided by Arbor Insight, goes a long way to providing governors with the information they need in a clear and digestible way, giving them clear leads as they hold leaders to account. Based on Department for Education data, they convert often confusing formats and measurements into something that is far easier to interpret and analyse. As such, it saves headteachers a huge amount of time in preparation and commentary.
While it’s clear that we aren’t about to see a wholesale abandonment of data anytime soon, data literacy for governors is increasingly going to involve thinking hard about proportionality, ease of use and accessibility. Anything that can help schools manage their data and performance analysis, such as Arbor Insight, should be welcomed enthusiastically.
Governors for Schools exists to improve educational standards so that children and young people have the chance to realise their full potential. You can visit their website here.
Reducing time spent on data and assessment is the key to reducing additional teacher workload Much has been written recently by the government and in the press about reducing teachers’ workloads, with polls suggesting that 1 in 5 teachers intend to leave their job because they feel overworked. One of Arbor’s impact goals (which we analyse each year
Reducing time spent on data and assessment is the key to reducing additional teacher workload
Much has been written recently by the government and in the press about reducing teachers’ workloads, with polls suggesting that 1 in 5 teachers intend to leave their job because they feel overworked.
One of Arbor’s impact goals (which we analyse each year for all the schools we work with) is to reduce the time teachers spend on inputting & analysing data so that they can focus on improving student outcomes! So we decided to take a look at the data to see where teachers were spending their time.
By looking at teacher diary surveys, we found that in just three years the workload of teachers has increased by an average of 12%. Put another way, this is a huge 5 days extra work per year for a primary teacher and 4 days extra work for a secondary teacher!
Digging down into the data further, we found that three-quarters of this increase in workload can be explained by an increase in the amount of time teachers are spending on planning, preparation and assessment. Given that it’s doubtful that teachers have been ramping up the time spent on planning or preparation, as this has always been a core requirement, the change most likely comes from an increase in assessment-related work driven by government, Ofsted and school policies on data and reporting.
Following this analysis, if your school can reduce the amount of time teachers spend on assessment and data, you’ll go a long way towards solving the workload problem! To do so requires reviewing how and why you collect, analyse and report on data.
6 steps to reduce teachers’ data workload
Arbor has built a simple 6 step checklist to help senior leaders reduce workload in your school:
Implementing a data workload checklist
We’ve broken down the 6 steps above into a helpful checklist for senior leaders to help implement within your school, complementing the advice given by the Teacher Workload Review Group with an actionable list of key tasks. If it seems too much to take on all at once, just start with one item at a time, and remember that every step you take could help to reduce the workload burden on staff.
Click here to download this checklist as a handy PDF.
Good news, we’ve added the latest KS2 Analyse School Performance (ASP) data to Arbor Insight, our free benchmarking portal for schools & MATs! We’ve created a free portal for every school and MAT in the country to help analyse your latest ASP & finance data, giving you a simple, visual overview of how well your
Good news, we’ve added the latest KS2 Analyse School Performance (ASP) data to Arbor Insight, our free benchmarking portal for schools & MATs! We’ve created a free portal for every school and MAT in the country to help analyse your latest ASP & finance data, giving you a simple, visual overview of how well your school or MAT is really doing. Read on to find out how your Arbor portal can help:
Inform your School Improvement Plan
Prepare for Ofsted inspections
Provide context to your governors
Inform your School Improvement Plan
Your free, interactive dashboards benchmark your school not just nationally and locally, but also against similar schools and Outstanding schools, helping you see your school’s performance in a more holistic context. From there, you can drill down to uncover which student groups are driving over or underperformance, and use this information to help set specific, measurable objectives for your school improvement strategy.
“I have found it incredibly useful for our MAT self-evaluation – it so clearly illustrates the impact of the MAT’s work at a simple touch of a button. The ability to compare our MAT and each academy to the outstanding schools average is also a brilliant feature, allowing us to evidence the impact of our aspirational target setting and provision.”
Jo Ashcroft, Director of Education at Aspire Educational Trust
Image 1: Our free interactive dashboards benchmark your performance against national, Outstanding, subject & demographic averages
Our Ofsted Readiness report has been designed to help you get ahead before your next Ofsted inspection. It predicts your next Ofsted grade and benchmarks your performance against “Good” and “Outstanding” schools, and clearly highlights which areas you’ll need to look into before the inspector calls. Once you understand the real story that your data is telling, you can have much more constructive conversations not only with Ofsted, but with stakeholders like your Governors to help you focus on your priority areas for the year ahead.
“The Ofsted Readiness report is outstanding. It’s very easy to read and understand. It’s well presented and the data crunching behind it gives us something we can’t get from other sources. That and the customer care makes this a product I promote to colleagues widely”
James Ayton, Headteacher at Walgrave Primary School
Image 2: Use our Ofsted Readiness Report as a school improvement tool ahead of your next inspection
Provide context to senior leaders and governors
The DfE’s ASP service creates scatter graphs and bar charts that are helpful for giving you a general overview of your data, but you may need to look elsewhere to answer the key questions these graphs raise. In Arbor we help schools find these answers using plain text callouts to explain how significant a trend is, as well as displaying your data over a three year period to help contextualise your performance. Your Arbor portal also benchmarks different groups within your school against each other, and against national and local averages. Our PDF reports can be quickly and easily printed out to share with governors during meetings, giving them a clear, visual picture of how your school is doing.
“Arbor Insight reports are simple, clear and easy to understand, with an obvious colour system that explains pages of data in a digestible snapshot”
Richard Gasser, Headteacher at Park Junior School
Image 3: Our plain text call-outs explain the real story behind your data, making it easy to present to senior leaders and governors
We’ve been working hard to crunch your latest KS2 performance data into 7 personalised PDF reports that analyse your attainment & progress over the past 3 years, highlight gaps across your school and even predict your next Ofsted grade. These reports are now all available in your Arbor portal, and will automatically update with disadvantaged, FSM and KS1 data when it’s released by the DfE.
Click here to log in & access your 2018 reports and dashboards!
Don’t forget that you’re also invited to the free Insight training sessions that we’re holding across the country this term to help you get the most out of your reports & dashboards. You can click here to see the full agenda and book your place.
If you have any questions about how Arbor Insight can help your school better understand your data, give us a call on +44 (0) 207 043 1830 anytime, send us an email at firstname.lastname@example.org!
By Loic Menzies, LKMco The school accountability system is changing fast. League table measures have been reformed dramatically and Ofsted has been grappling with how it can become a more proportionate and reliable force for good. This has led to a brand new strategy for the inspectorate and recent speeches and publications have started to set
By Loic Menzies, LKMco
The school accountability system is changing fast. League table measures have been reformed dramatically and Ofsted has been grappling with how it can become a more proportionate and reliable force for good. This has led to a brand new strategy for the inspectorate and recent speeches and publications have started to set out a new landscape which will have important implications for how schools use data to reflect, improve and prepare for inspection.
This blog talks about how you can use Arbor Insight Reports to analyse your schools’ performance and set out your plans for improvement. As Amanda Spielman, the Chief Inspector of Schools, put it this Summer: “Rather than just intensifying the focus on data, Ofsted inspections must explore what is behind the data, asking how results have been achieved”. This report should therefore act as a starting point for important conversations and reflection.
At secondary school, the shift to Progress 8 has heralded a new era in which a much wider range of subjects falls under the lens of school accountability and where the emphasis has shifted away from pupils on the C-D borderline. Meanwhile, life-after-levels and the new system of ‘scaled scores’ are now a reality in primary schools across the country. As further shifts come into place over the next few years, the pace shows no sign of slowing.
All this rapid change, and a shift in emphasis towards progress – sometimes from unreliable base lines – is leading to some unexpected and unpredictable results. It is therefore particularly important that you scrutinise data particularly carefully to be clear what it is and is not saying. Ofsted has also made it clear that attempts to predict progress scores are not worth the effort since they are impossible to know in advance. Instead, your school should be prepared to respond to queries from inspectors who will have looked at a range of information in advance including:
Details from the school website – much of which will be data-driven like:
Inspectors will also have looked at key data summaries such as: the Inspection Data Summary Report (IDSR), ‘Analyse School Performance’ (ASP), (which Arbor’s Ofsted Readiness report helps you analyse), and the Level 3 Value Added (L3VA) report. This will help determine any pupil groups that inspectors want to focus on during the inspection. Careful advance scrutiny of your data can therefore ensure you are not taken by surprise. (School Inspection Handbook, p. 15 & 23)
As Ofsted’s National Director of Education explains in relation to the new ‘short inspections’, what the inspectorate wants to understand is:
The two key questions to ask yourself are therefore:
1. What do we do well/less well?
2. What is our plan going forward?
On the other hand, Ofsted has also been keen to insist that:
“Ofsted does not require self-evaluation to be graded or provided in a specific format. Any assessment that is provided should be part of the school’s business processes and not generated solely for inspection purposes.”
Arbor Insight Reports – in particular the Ofsted Readiness Report – are intended to support you in understanding the two key questions above. It should prompt you to consider your strengths and weaknesses and help you dig beyond the headlines to question what might really be going on. This is crucial since the strength of leadership and management is largely driven by “the rigour and accuracy of self-evaluation and how well it leads to planning that secures continual improvement.” (School Inspection Handbook, p. 41)
Key in this is looking across different sources of information to triangulate and reach better evidenced conclusions. As the current Inspection Handbook points out, “No single measure or indicator should determine judgements”, and as Ofsted’s recently published strategy points out:
“While data will always be an important starting point, our inspections should look beyond published data, explore how results have been achieved and in some cases act as a counterbalance to any unintended incentives in the broader accountability system.”
The inspectorate will consider:
According to the DfE Guidance, last updated in August 2017, headline measures for primary schools are:
Key measures for secondary schools are:
Given that Progress 8 is now the headline secondary measure it is important to take into account the following key definitions:
You can find out more about the full range of measures and how they are constructed in Schools Week’s special supplement by LKMco.
Progress 8 at secondary school and relative progress at primary school have shifted the emphasis of school accountability to how pupils with similar starting points are doing in different schools as well as how each pupil is performing – whether they are starting from a high or low baseline. The national and ‘‘schools like you’ measures in this Arbor Insight Reports will help you to scrutinise this and identify your schools’ particular strengths and areas for development. Consider for example:
Throughout your analysis, be wary of making overly concrete conclusions based on small groups, for example, if you only have five black male pupils, do not use statistics based on this to make major claims about their relative performance. Look carefully at the patterns you spot and be prepared to use three-year rolling averages for example to spot longer term trends amongst larger cohorts of pupils. Where this report helps you identify an underperforming group, be careful about jumping to quick fit solutions, Ofsted itself has recently stated that:
“The existence of a gap does not always indicate that an intervention at sub-group level is the right approach. Very often, identifying and correcting institutional shortcomings (for example in curriculum, teaching or behaviour management) will improve outcomes, with disproportionate benefits for lower attaining and disadvantaged students”
It is therefore perfectly acceptable to identify an underperforming group and consider how whole school improvements might address this issue, rather than specifically targeting a new intervention at the group. You can investigate gaps further using Arbor’s set of Gap reports which analyse the performance of pupils in different groups (based on gender, SEN, prior attainment, ethnicity and disadvantage).
If your pupils appear to be doing particularly well, note this, and combine it with different sources of information, including your professional judgement to understand why, and how you can build on this. Ofsted too will look at a range of evidence so be prepared to share how you have brought a range of different sources of information together to plan for improvement. Consider for example how patterns vary across subjects and how you might spread good practice from one area to another.
Explaining and presenting this information however, need not mean putting together extensive and labour intensive pre-prepared packs. As Ofsted has explained:
There will almost invariably be areas in which your pupils are doing well, or groups that are doing particularly well so share your reflection and plans with inspectors. As Simon Eardley, Head Teacher at Orton Wistow Primary School, explains, the morning of his school’s short inspection was all about “dialogue and discussion” and an:
“Opportunity to go through our school self-evaluation evidence and tell the story about our school and to pick out the things we think we thought we were doing well but also the things we’d recognised we needed to get better on… that initial conversation steered the rest of the day.”
By providing this type of information in an easily digestible form, Arbor’s Ofsted Readiness Report helps you prepare for these discussions. Used well, it will be an invaluable part of the tapestry of evidence that you use to support your pupils, raise standards and evidence your achievements to inspectors.
Interested in finding out more about how Arbor Insight Reports can help your school ahead of your next inspection? Drop us a line at hello@arbor-education, give us a call on +44 (0) 207 043 0470 or get in touch via the contact form on our website.
LKMco are an education and youth-development ‘think-and-action tank.’ They support schools, teachers and education and youth organisations by planning, evaluating and improving the way they work. LKMco work to ensure all children and young people receive the support they need to make a fulfilling transition to adulthood by carrying out research and campaigning for action.
Data and Insight | MAT Operations | School Operations
Why bother centralising your data? Schools, Trusts and LAs increasingly ask us how they can centralise their data, but they sometimes don’t know where to start and what their broad options are. Most share the common need of wanting to bring their data together to gain deeper, faster insight into their staff and students, save
Schools, Trusts and LAs increasingly ask us how they can centralise their data, but they sometimes don’t know where to start and what their broad options are. Most share the common need of wanting to bring their data together to gain deeper, faster insight into their staff and students, save teachers time endlessly copying and pasting data from multiple systems (and reduce mistakes whilst doing so), whilst saving money by reducing the number of systems they have in the school.
From our work with schools, MATs, LAs and governments we’ve seen a lot of different ways of centralising data, but they generally fall into 3 categories.
When small, it’s best to keep things simple. Whilst not ideal, excel is the quickest, cheapest and easiest tool to get to do your heavy lifting. Most schools will organise data drops at set times in the year, using permissioned worksheets and data validation to minimise errors, and producing graphs and reports that can act as simple dashboards. New versions of excel can even link live to your systems (we do this in Arbor) so that can be pulled automatically from your MIS, meaning no more data drops and data errors! That said, excel comes with hidden costs, it can involve staff double entering data, takes time to fill in, is prone to errors, and doesn’t scale as your school or MAT grows (in fact it gets harder to administer as you grow).
Once a Trust grows to about 5 schools (depending on the complexity of the Trust) the person in charge of collecting and analysing all of the data can often become overwhelmed by the manual process, and as we’ve written about before, this is the time most Trusts look at standardising some core systems to start to automate the process of data collection. It’s worth noting that this step is typically beneficial for all school types; the key is not to leave it too late, as you then end up unpicking all of the manual process within each school.
Once the core systems have been standardised and rationalised into as few systems as practical (e.g. finance, assessment, MIS), then the school, Trust or LA can integrate these systems, ensuring data is only entered once, and use the tools’ internal ability to aggregate their core data and reports. The disadvantage of this approach is the upfront setup time and cost, however if chosen sensibly, these system should be able to payback this in time/money savings within a year or two, lowering overhead, improving reporting capability, allowing the Trust to centralise workflows and communication and ultimately enabling the group to scale.
Without a degree of standardisation in your core systems and data, as described above, achieving an analytics layer can take a lot of time and patience. Custom field names, non-standardisation across schools of assessment, and people simply choosing to record things in different ways at different times lead to increasing complexity. Many systems (like Arbor) integrate with analytics layers such as Microsoft’s PowerBI (which many Trusts are using) out of the box, so once you’ve standardised your MIS, you can spin up an analytics layer in little to no time. This allows you to create custom graphs and charts with the reassurance that the underlying data is accurate – else bad data can lead to bad decisions!
1. Integrate live with Excel/Google: Every table and report in Arbor can be live linked to Excel or Google sheets [slide 18], meaning no more data drops. Schools and Trusts can collect data instantly from several schools, and generate their own simple dashboards, combining MIS, national, HR and external data to create a holistic view of performance
2. Standardising systems: we’ve talked about what systems to standardise and when before. Once standardised, Arbor’s Group dashboards and reports instantly aggregate student and staff data across schools, allowing MATs and LAs the ability to centralise data and take action by logging into systems remotely and performing workflows (e.g. attendance follow-ups)
3. Analytics layer: Arbor integrates with PowerBI out of the box via the excel integration, allowing groups to build their own simple Analytics layers. Our free and open API can also be used for deeper integration with Business Intelligence tools.
+44 (0) 207 043 0470
First Floor - Unit 16
White City Place
195 Wood Lane
Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.
If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.