Analyse aggregate data on the MAT MIS

This article will go through a few key places where you can view aggregate analysis for attendance, behaviour and assessment. To report more in-depth, you can use the Custom Report Writer.

How do the filters work?

On each main analysis page, you can view the figures across your whole MAT MIS, or for just the schools you are associated with.

To look at specific schools or clusters, add them to the filter, then click Apply filter.



My Homepage

On your homepage, you will see your group average calculation for each headline measure.

You are able to click on any measure and view more detail for each. This includes downloadable tables for each school and each demographic group's performance against the measure. For more information on what is shown, see the sections below.

By default each measure will display with a national average comparison - this can be amended to give a comparison to the Outstanding school average.




You can access a variety of Key Performance Indicators that show data from all parts of your MAT MIS by clicking the Analytics drop-down menu and selecting Group Context, Attendance, Behaviour, Assessment, or Staff/HR.

You can see further details of the Staff HR area here.

In these pages, you will see a reminder if not all of your schools have shared their data with you. It is important to set up your data sharing agreements to ensure the data shown in your infographics is an accurate representation of all your schools. You can see how to set this up here



Hover over an KPI (Key Performance Indicator) to view more information.



You can click on each infographic to view a more detailed breakdown of a variety of groups' data. 



Click 'Monthly trend' or 'Year on Year' to see your progress over time.




Drill down into your behaviour data for fixed-term exclusions, permanent exclusions and positive and negative incidents all the way from MAT-wide averages, through your data split by school or demographic, all the way down to individual pupils.



Identify which students are affecting your averages and view their behaviour, then jump directly to their student profile on the School site (you'll need to have permission to log into a school site).




Drill down into your attendance data all the way from MAT-wide averages, through your data split by school or demographic, all the way down to individual pupils.

Identify which students are affecting your averages and view their attendance, then jump directly to their student profile on the School site (you'll need to have permission to log into a school site) or send emails.

Drilling down into Attendance on the MAT MIS

Go to Analytics > Attendance and click into a measure to drill down.



Display your data by chart, a table of year on year trends or a list of students. Use the drop-down menu to group your data by Cluster, Demographic, Ethnicity or Year Group.



You can see the Arbor National Whole School Attendance average when drilling down into your Whole school attendance, Authorised or Unauthorised Absence KPIs. It'll show you how your schools compare with other schools using Arbor.



Top Tip: On the students tab, click the column headers to sort the students highest > lowest or lowest > highest attendance to identify which students are impacting your averages.

Select a student to jump to their profile on the school's site (if you're able to log into that school).


How do we calculate Attendance on the MAT MIS?

What is included in:

  • Today's figures - The attendance figures take into account all students who are scheduled to be in school that day (due to lessons set up on their timetable).
  • This Year and Last Year figuresThese figures include all students who have a valid attendance mark at any of the schools in the trust for the Academic Year

We include:

We do not include:

  • Dual-registered students marked with a D
  • Students who aren't currently enrolled
  • Students who have never had an attendance mark recorded

The overall attendance calculation is a weighted average across all schools, so it takes into account the number of students in each school, and attendance records for each school. This means schools with a large student enrolment are weighted higher than schools with a smaller student enrolment.


Creating a monthly attendance report in the Custom Report Writer

Go to Analytics > Custom Report Writer and click Create New Report.

Select our Attendance By Year Group (YTD) report then click Create report from template.



In step 2 click Next to report on the whole year.



In step 3 click Skip Setup Wizard, then click Save & View Report.




Want to make changes to report, such as seeing an average for each school? Click the Edit button and remove the existing Year Group grouping.



Add in the new grouping and click Add Grouping. You may also wish to delete this column from your displayed columns (so it doesn't show twice) and edit the name of your report before you click the Save & View Report button again.






You can analyse your summative assessments of the same type across your schools from Analytics > Assessment > Analysis. See more details here: Analysing assessments on the MAT MIS



In Analytics > Assessment > Attainment & Progress > Choose Key Stage you can view breakdowns of your assessment data, and drill down into DfE statutory data for the Phonics Screening Check and End of KS1, End of KS2 or EYFS. See more details here: Viewing your schools' DfE Standardised assessment results on the MAT MIS



Group Context

The KPIs in the Analytics > Group Context area show you some contextual measures about pupils within your trust.

Every KPI takes data from each school as it stands today. For example, Total Number of Pupils on Roll Today matches the total for the whole MAT and will match the number of student on roll today on the School MIS homepage.



For Monthly trends, enrolment figures are taken from the last day of the month - if the month has not ended the figure will be for today.



For Year on Year trends, the figures are from the last day of previous academic years or today for the current year.


Was this article helpful?
0 out of 0 found this helpful
I'm still stuck!



Article is closed for comments.