Covid-19 Coronavirus Primary Pupil Absence Tracking Software

An automated COVID-19 Absence tracker for Primary Schools
This automated spreadsheet allows you to monitor the impact of coronavirus upon your pupils and staff. Information can be recorded for each year group cohort, recording days absent due to confirmed positive absences, school enforced contact absences & self-isolating absences.
All inputs are automated to speed up the entry and display of key data. Including a colour coded calendar displaying the reasons for absences. The calendar can be re-ranked upon numerous criteria with the click of a single button. Individual pupil summaries can be displayed as can the impact of the absences for a set date. This last option aids the calculations necessary for the daily DfE Education Setting Status questions which have to be submitted at 2pm on each term time day.
Term dates can again be adjusted with the click of a button for all calendars to suit your establishment.
The free evaluation version caters for 13 pupils in a single year group cohort. The full paid for version allows for 250 pupils per year group and for year groups 1 - 6 & Staff.
The spreadsheet requires the use of macros (computer code) to enable the automations. When you first open the spreadsheet, you must enable Macros within Excel. Due to the use of macros this version CAN ONLY be run on Windows Versions of Microsoft Excel.
A free evaluation version is available from:
https://www.tes.com/teaching-resource/covid-19-coronavirus-absence-tracking-software-12425518

A paid for version for Secondary Schools is available from:
https://www.tes.com/teaching-resource/covid-19-absence-tracking-software-12425525