Attendance Calculations - Attendance Statistics, Half-Days, Academic Reports

Some attendance reports apply calculations to attendance data to determine information such as half-days (DIVS) and percentages. For example, the Attendance Statistics Reports available on the 'Attendance Administration' page.

Not all attendance reports use the same calculations. For example, the Attendance Statistics Reports use different calculations then the Federal STATS Report. Additionally, some reports pick-up the attendance recorded against calendar classes, time-based attendance, whereas others do not.

Is Attendance only visible in Time-Based View and Attendance Layers Included on Attendance Reports?

Attendance only visible in the Time-based view and attendance layers is included in some attendance reports. For example, the Federal Stats Report, the Statistics Report, and any Reports that include the word 'Time-Based or Linear' in the Report name.

Half Days and DIVS

The information below relates to standard attendance reports. The report 'Absences by Schoolyear' is calculated differently which is outlined in the article Attendance Calculation for the Absences by Schoolyear.

• The system splits the day into two chunks - exactly halfway between the first recorded presence/absence and the last recorded presence/absence.
• It then counts up the number of minutes flagged as present (minutesPresent) and the number of minutes considered absent (minutesAbsent) in each chunk.
• The percentage attendance for a chunk is therefore: minutesPresent / (minutesPresent + minutesAbsent).  Eg. where student is present 87 mins and absent 103 mins: 87/(87+103) = 46% present
• A percentage threshold is then applied based on percentages and number of minutes. On the Attendance stats for reports, if the block is 10%  present (by default) and has at least 20m present, it is considered present. 
• Finally, the blocks for each student are summed up, then grouped and organised as appropriate.

Percentage present threshold

For each half day, the percentage of time that the student has been present is calculated by dividing the number of minutes that the student has been present by the number of minutes of combined absentee and present attendance. In order for the student to be considered present for that half-day, this percentage must equal or exceed a threshold called the percentage present threshold. This threshold is set to 30% by default (hard-coded) but can be overridden on request to the SEQTA Service desk (email authorisation from the School Education Contact required).

Can attendance entered on the weekend or after school hours be excluded when running a report?

Yes, It is possible to exclude attendance applied against weekends when running the Statistics Reports by using the Date repetition filter to specific days of the week (i.e. Monday - Friday). A time-range can also be specified, providing this option has been enabled for the report. The SEQTA Service Desk can enable time field filters for attendance reports, providing the report itself supports the time fields.

How does the Federal STATS Report differ from the Statistics Reports?

The Federal STATSReport is quite distinct from the statistics reports in the SEQTA Suite. The Statistics Reports operate at a half-day level when calculating overall percentages; a half-day is either considered present or considered absent or neither. Whereas the STATS report, by contrast, allows a day to be 5% absent and 95% present, or 17% absent and 83% present; these values are determined across all days, not just one.

Where can I find more information on the Federal STATS report?

Please refer to the article Federal STATS Report Setup Guide for more detailed information.

What attendance counts toward half-days and full days on Academic Reports?

All attendance types, with the exception of those with grey icons, will be included in the calculations for half-days and full-days.

What Attendance Types contribute to 'Lates' on Academic Reports?

By default, the attendance type 'Late' is the only Attendance Type that counts toward the 'Late' on the Semester and Interim Reports.

'Unresolved Late' along with the other 'Absent' Attendance Types are included in the calculations for half days and full days present.

Which Attendance Types are counted as a deduction from their attendance that is displayed on the Attendance Page and the Marks Book?

All 'Absent' Attendance Types (i.e. Late, Unresolved Absent) are counted as a deduction from the students attendance percentage. If there is no attendance, this will not be counted at all.+