The Suspensions and Exclusions dashboards on MAT MIS

Permissions

• Group: Permanent Exclusions: View All Students
• Student: Exclusions: View All Students

Viewing the Dashboards

• Go to Analytics > Behaviour > Suspensions Dashboard for the Suspensions dashboard.
  
  
  
   
• Go to Analytics > Behaviour > Exclusions Dashboard for the Exclusions dashboard.
  
  

What the Dashboards show

KPI headline panels

The KPI panels break down suspension/exclusion numbers and rates by key groups for the academic year(s) you set in your Global Filters.

• Count panel: Shows the number of students suspended or excluded, with breakdowns by school phase, gender, and pupil characteristics (EAL, Disadvantaged, SEN Support, EHCP). Tiles turn orange if any suspensions or exclusions are recorded; green if there are none.
   
• Rate panel: Shows the rate per 100 pupils on oll during the reporting period, benchmarked against the national average for the same period. Tiles turn orange if a school is above the national average; green if below.

Bar charts

• By Month: Suspension or exclusion counts across the year, broken down by month.
   
• By Year Group: Counts by year group, split by gender.
   
• By School: Counts for each school in your trust.
   
• By Reason: Counts by reason. Because a single suspension or exclusion can have multiple reasons, this chart uses a separate dataset so each reason is counted independently.

Using the Filters

Both dashboards have two types of filters, global and chart-level

• Global filters: The green filter bar at the top of the page applies to all charts at once and to the KPI panels. The KPI panels do not have their own independent filters. By default, the dashboard shows data for the current academic year.
  
  
   
• Chart-level filters: Each individual chart can also have its own filters applied independently of the global filters. Click the green filter icon in the top-right corner of a chart panel to open the filter
  
  

If you make a change to a Chart-level filter this change only applies to that specific chart. For example, you may have filtered for students with SEN globally but want to include all students in your Suspensions by Month to show all students by removing this condition from the chart-level filter. Or, you might want the chart to show a specific school by adding a School Name filter to a chart.

What happens to chart-level filters when we change the global filter?

If you make changes to a global filter, all chart-level filter conditions that have not been locked will change too.

So, if you add, remove or change a global filter, these settings change for each chart too, unless you lock specific conditions.

Any chart-level filter you do not lock, but that does not match the global filter, is also reset. So, for example, if:

• Your global filter filters by students with SEN
• Your by month chart does not filter by this at all (to show all students, regardless of SEN) because you removed the SEN equals True condition
• And you then change your global filter to look at SEN equals False, your chart will now also filter by Without SEN, even though you removed the SEN condition previously.

How to edit a filter

To edit a filter, click on Edit (for the global filter) or the Filter icon for a chart-level filter. On the pop-up: 

• Use the + Filter button to add more conditions
• Use the Bin icon to remove conditions
• Click Clear all to remove all current conditions
• Click Apply filters to confirm your filter settings

Each filter has three elements:

1. The data you want to Filter on, for example, academic year, student group or school
2. The Condition you want to filter by. Depending on the filter, examples of conditions you can use are:
    
   • Equals/Not equals if you want the condition to be a single, discrete value, like True or False or a specific year.
     
     
      
   • In/Not in if you want the condition to be a set of possible values (is one of/is not one of), for example, to show or exclude specific schools or academic years.
     
     
      
   • Less than/Greater than/Between if you want to set a range of values, for things like dates of birth.
     
     
      
3. The Value(s) you want to filter by. For example, whether something is True or False (filtering by SEN Equals True returns students with SEN) or a specific option from a list, like a specific school or academic year.

How do I lock filters?

Only chart-level filters can be locked. Locking a chart level filer ensures these settings do not change if you alter the global filter. Locking a chart-level filter does not mean that if you leave the page and return at a later time, the locked filter is saved,

To lock a chart-level filter:

• Click the green Filter in the top-right of the chart panel
• On the pop-up, click the Lock icon next to the filter you want to lock so that the lock appears closed rather than open
  
  
   
• Click Apply Filters to save your choice

Viewing the underlying data

FAQs

Who can see these dashboards?

What is the national average based on?

Does the Exclusions dashboard include fixed-term exclusions?

No. The Exclusions dashboard covers permanent exclusions only. Fixed-term exclusions (suspensions) are shown in the Suspensions dashboard.
 

Will the data we see always perfectly match Arbor MIS?

This data is aggregated in our data warehouse and will have a delay compared to when the records are created. Please bear this in mind when comparing the statistics directly to those in a school MIS. All suspensions for the selected academic year are considered, global and chart filters will set additional criteria for inclusion. Arbor National Rates are calculated considering all enrolled students for the period who match the filter criteria.

 

Can I change the layout of the dashboards?

Yes. If you click the Edit layout pencil button in the top-right corner of the page you can rearrange where chart panels appear.

Once you have clicked Edit Layout, go to a chart panel and click and hold the Drag to reorder button to move that chart.


 

Then, once you're happy with the new orientation, click the pencil again to stop editing the layout and lock the panels in pace