Management Information System (MIS) for schools
Data and Insight
Category : Blog
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!
You must be logged in to post a comment.
This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.
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.