dfe-analytical-services / dfe-analytical-services/rapify

Create EES API attendance data

Open
#1 1 comment 0 reactions 1 assignee Claimed by @rmbielby View on GitHub
API attendance
Dominant language
R
Stars
0
Forks
0
PR merge metrics
No merged PRs in 30d

Description

We need Attendance data for the dashboard that's compatible with the EES API. Currently the data are in the following files in the dashboard:
- Specifically for the dashboard
- attendance_data_dashboard.csv
- EES upload files that external users like to have access to:
- EES_daily_data.csv
- EES_weekly_data.csv
- EES_ytd_data.csv

The latter are actually just filtered versions of the former.

Thinking about the structure around absence filters, it looks something like the following:
- Attendance
- Present
- Late before registers closed
- Present am
- Present pm
- Approved educational activity
- Approved sporting activity
- Education off-site
- Work experience
- Dual registration
- Educational visit or trip
- Interview
- Overall absence
- Authorised absence
- Illness
- Medical or dental appointments
- Religious observance
- Study leave
- Traveller
- Holiday
- Exclusions
- Other
- Unauthorised absence
- Holiday
- Late after registers closed
- No reason yet
- Other

The third tier in the hierarchy are all effectively "reasons".

Note persistent absence is measured in terms of pupils rather than sessions so is a different "thing"

The Indicators would then be:
- Number of sessions
- Rate

Things that don't fit the above:
- Persistent absence (this is measured by pupil rather than session)
- Enrolments (number of pupils)
- Schools reporting
- Reported on GIAS
- Number of schools
- Schools reporting
- Reported on GIAS

I think all of the above can be organised along the following lines for the purposes of the API:
- Enrolments and persistent absence
- Pupil absence and reasons

The latter could be broken up in a number of ways if it's too bug:
- daily / weekly / year-to-date
- Headlines / reasons

Could maybe demo both options to see which works best

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.