A Pupil Absence Map can display the names and addresses of all the pupils absent TODAY, within minutes of morning registers closing. They allow your pastoral staff to take a very proactive approach to absence – by literally knocking on doors. Here’s how they work…

Power BI Absence Map for Schools

Why Use an Absence Map?

If you need to keep a close eye on attendance in your school, you will need to understand which pupils are absent and why. In addition you may also want to know where they live. Why might you need to know their location? Because some schools take a very ‘hands-on’ approach to reducing absence by literally knocking on doors (also know as ‘walking buses’), while some schools might suspect that pupils on a certain bus route are more often late than others. Or perhaps that some areas of their catchment area have health (COVID) issues that re preventing pupils from attending school. Whatever the factors for you local area or school catchment, you will want to know all these facts in a timely manner.

What is an Absence Map?

A pupil absence map is an analysis report that brings together all the absence information for a group of pupils, and displays that information on a map to allow staff to visit the pupil’s home address. There’s an example at the top of this page. Because absence maps are often used ‘on the road’, it’s important that the map be useable on the smaller screen of an Apple or Android smartphone.

How do we use an absence map?

In the School Analytics absence map (illustrated above) we’ve included slicers that allow you to display absences for a specific period of time chosen by the end user (today, last week, this term, autumn term). The absences are displayed for each pupil in a simple table. Each dot represents an absent pupil, one line per absence. Authorised absences are represented in green, unauthorised absences are in red, family holidays in yellow. Initially, all types of absence are displayed, but a slicer also allows users to choose certain types of absence, so you can choose to only show traveller absences, or family holidays.

Mobile First

Earlier I mentioned that an Absence Report needs to be as easy to use on mobile devices as on a computer. In School Analytics we’ve made full use of the mobile view to ensure that the Absence report is very easy to use and legible on any device.

Video Demonstration of an Absence Map