MIS
Overview
This article explains how to use the attendance code filter in the Attendance Analysis report. The filter finds pupils who have received one or more attendance codes a set number of times over a date range.
The filter helps you answer questions such as:
- "Which pupils have been late 10 or more times this year?"
- "Who has missed at least 2 sessions through unauthorised family holiday this term?"
- "Which pupils have between 5 and 10 illness sessions this half term?"
After you apply the filter, the report shows only the pupils who meet your criteria.
Prerequisites
- You must have a role that can view the Attendance reports in Juniper MIS.
- If you are not sure what each code means, see MIS: What are the different attendance / absence codes?
Open the Attendance Analysis report
Follow these steps to open the report:
- Select Reports.
- Select Attendance.
- Select Analysis.
The Attendance Analysis report opens.
Filter pupils by how many times they have received a code
Follow these steps to find pupils who have received selected codes a set number of times:
- Select Filters.
- Select the Time Period you want to look at, for example This Year, This Term or This Half-term. To use your own dates, select Fixed Range, then select a Start Date and End Date.
- Go to the Attendance code count section. The filter reads as a sentence: Show pupils with a comparison, a number, of the codes you choose.
- Select the comparison from the first list, for example > for greater than. The table below explains each option.
- Enter the number of times the code must have been recorded. If you chose between, enter both the lowest and highest values.
- In of the codes, select one or more attendance codes, for example L for late. Each code you choose appears as a coloured tag. Select the X on a tag to remove it.
The report updates to show only the pupils who meet your criteria. Select a pupil's name to open their record on the Attendance tab.
If you select more than one code, a pupil is included when the count for any one of the selected codes meets your threshold. The counts for different codes are not added together.
Under the codes, select Select all to choose every code at once, or Clear to remove them all. The number of codes you have chosen appears alongside, for example 2 selected.
Comparison options
| Comparison | Shows pupils whose code count is | Example |
|---|---|---|
| < (less than) | lower than the number you enter | < 3 finds pupils with 0, 1 or 2 of the code |
| ≤ (less than or equal to) | the number you enter or lower | ≤ 3 finds pupils with up to 3 of the code |
| = (equal to) | exactly the number you enter | = 3 finds pupils with exactly 3 of the code |
| ≥ (greater than or equal to) | the number you enter or higher | ≥ 10 finds pupils with 10 or more of the code |
| > (greater than) | higher than the number you enter | > 2 finds pupils with 3 or more of the code |
| between | within the two numbers you enter | between 5 and 10 finds pupils with 5 to 10 of the code |
Tips and best practices
- The count is based on sessions, not days. A pupil absent for a full day has two sessions recorded.
- Combine the code filter with Group Type and Groups to focus on a year group or class.
- Check Show Code breakdown under Additional Data to see the number of each code alongside the pupils in your results.
- To review a previous year, select the Academic Year first, then set the code filter.
- To remove the code filter, select Clear under the codes, then select Apply Filters again.
Next steps
After you have found the pupils you need, you can open each pupil's record to review their attendance history and notes. If a pupil has 7 or more unauthorised sessions, see MIS: How do I monitor attendance penalty notices?
Related information
- MIS: How do I view attendance by year group / class over a selected period?
- MIS: How do I see a list of those pupils with absence or late marks?
- MIS: How do I see those pupils who are persistently absent?
- MIS: How do I record a pupil as being late?
- MIS: What are the different attendance / absence codes?
Updated