Weekly Attendance - Insight Analysis - Summary

Overview

Within the Weekly Attendance section of Insight, the Summary page provides a high level overview of the key headline indicators for Absence and Attendance:

Overall Absence
Overall Attendance
Authorised Absence
Unauthorised Absence
Persistent Absence
Severe Persistent Absence

Each indicator is displayed alongside comparative measures comparing your local cohort to a higher level aggregation such as National, your local cohort in the previous year and the previous week, as well as provide a breakdown by the key pupil groups.

Fullness indicator

Beneath the filters Nexus will show you an indication of the percentage of Local Authorities that have loaded the latest week's file. Clicking this status will also allow you to access the LA Imported Details page which includes indications of which Local Authorities have imported the latest week's files.

Summary Analysis

Weekly Attendance Summary analysis is presented in the familiar Insight style, providing easy to read and absorb highlights. Each card then includes a verbalisation of the descriptions.

The comparison group defaults to NCER national (emerging figure aggregated from LA who have loaded their data), but you can make alternative selections through the comparators listed above including published national figures for the prior year.

As with other areas of Insight you can spin the card where it shows 'View Detail' to see a breakdown of the data presented on the front into key pupil groups such as Disadvantaged, EAL, Minority Ethnicity and SEND cohorts.

Beyond the overall headline values, you can also see 'Gap to <comparator>', 'Yearly Trend' and 'Recent Change':

Gap to <comparator> - This is fairly self-explanatory but there are some nuances:
- NCER National - the current, emerging data for the current year aggregated from all files loaded
- Published National - the last data published by department (published weekly, but two weeks in arrears).
- Region - LA that have loaded data in your region
- Statistical Neighbours - LA that have loaded data in your statistical neighbour group
Yearly trend - compares the LA position this year at whatever week you are at compared to the same week (or as near as possible) from the prior year. In the first year (25/26 AY) - where not every LA will have weekly data from the prior year - the backstop comparison is the end of the 24/25 academic year.
Recent change - changes from week to week in your local imported data

Anywhere on this page where you see a number for your Local Authority and it is underlined, that means that you can click on number to drill down. When viewing scope 'LA' the drill down is to the school level. When viewing scope 'school' and a specific school has been selected, the drill down will take you into the pupil level. (You can also access the pupil level when in scope LA by clicking the 'View by Pupil' button).

Trend Chart

As the name suggests, this provide a trend of each week where data was imported. The chart will provide comparative lines for the selected scope in the previous year* and the selected comparator for both the previous and current years.

*Please note, in the first year where a LA has only imported the end of year file for 2024/25 this will display as a single threshold line. Beyond that, it will show the trend across weeks from the previous year.

Within the trends display, the overall value is the year to date (or last loaded data) figure. However, you can click on the trend line and see the results up to that selected point.

To calculate each week's sessions, we subtract the previously imported file's year to date sessions from the subsequent imported week's year to date values. This approach, rather than simply showing the year to date values each week, was chosen to provide a more dynamic view of the scope's data and to make weeks of high and low attendance more visible

While further investigation takes place, each LA's half term weeks are being hidden from the chart. This will show a gap within the Scope (purple) line.

Weekly Attendance Filters

Weekly Attendance leverages all of the information Nexus already holds on pupils - together with specification of the Weekly Attendance Social Care cohorts - to provide a much richer potential for analysis than is currently available to Local Authorities direct from the Department. This is alongside comparisons to emerging national results (aggregated from LA that have submitted weekly attendance) / published national / regional and statistical neighbour options.

This allows filtering of the attendance data analysis by a much wider variety of options than is possible in the source data.

As is standard in Insight, where a value is underlined then you can click on that to drill through to the next level down.

Note that if you do wish to look at the Census Absence Analysis, you can click the button in the top right to jump straight to it.

Where filters are identical to other parts of Nexus, they are not described in as much detail:

Time period - select one from Latest Week, Last Imported Week, Autumn Term, Spring Term, Summer Term, Autumn & Summer Terms, Full Academic Year
Scope - select one from LA, School, School group, Virtual School, Children in Need (CIN), Child Protection Plan (CPP), Children in Need Only (CINO) and Child Protection Plan Only (CPPO) (the latter 5 options refer only to pupils imported in the Weekly Attendance Social Care Cohort import)

School Type - Multi-selection of school types
School phase - Multi-selection of school phases
Year Group - Multi-selection of NC Years from Reception to Year 11 or ALL.
Pupil premium - select one from All, Disadvantaged True, Disadvantaged False, FSM6 True and FSM False
Ethnicity - Multi-selection from either ALL or the list of DfE sub-category codes
Language: - Multi-selection from either ALL or EAL: True, EAL; False, English, English Believed, Not Obtained, Other, Other Believed or Refused
Sex: - Select one from ALL, male or female
Special educational needs: - Select one from ALL, SEN: EHCP & Support, SEN: None, SEN: EHC Plan or SEN: Support
Primary SEN Type: - Multi-selection from standardised primary need codes including Down Syndrome
Key absence groups: - select one from:
- All
- Persistent absentee (10%+)
- Not persistent absentee (<10%)
- Severely persistent absentee (50%+)
- Not severely persistent absentee (<50%)
- 5%-15% absence
Free school meals: - select one from All, True or False
Comparator: - select one from:
- National - emerging figures from aggregation of data loaded by LA)
- Published national - official DfE figures
- Region - emerging figures based on LA in the region's submissions
- Statistical neighbour - emerging figures based on LA in the statistical neighbour grouping's submissions
- LA - only available when scope is set to School, School Group, CLA / CIN / CPP / CINO / CPPO
- CLA / CIN / CPP / CINO / CPPO National - only available when scope is set to the appropriate option
- CLA / CIN / CPP / CINO / CPPO Region - only available when scope is set to the appropriate option
- CLA / CIN / CPP / CINO / CPPO Statistical Neighbour - only available when scope is set to the appropriate option

Search