Secondary Unexcused Absences for Assessment Report

The Secondary Unexcused Absences for Assessment report shows each student's unexcused absence rate for selected secondary course sections. Teachers and administrators can use it to review attendance patterns and apply professional judgment when making assessment decisions, in line with Growing Success. The report only shows the absence rate and does not assign Growing Success levels.

Prerequisite

Navigate to School > School Management > Attendance > Attendance Code Categories and create a new category. Enter a name and description of your choice, and set the Code to UnEx.

Next, navigate to School > School Management > Attendance > Attendance Codes and assign the UnEx category to each attendance code that should count as an unexcused absence for assessment purposes.

Note: If no applicable attendance codes are associated with the UnEx category, the report will display zero unexcused classes missed.

Absence calculation

Unexcused classes missed ÷ scheduled classes × 100

The result is rounded to one decimal place. If no applicable attendance codes are categorized as UNEX, unexcused classes missed is zero. The rate is zero for students with scheduled classes. It is blank when a student has no scheduled classes.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

Students must be enrolled in the selected course sections during the reporting period.
Student must be marked absent and the attendance code categorized as UNEX for absences to be recorded.
Each missed meeting is counted separately.
For sections set to Once For All Meetings, an absence is counted once per date.

Report Input

For help with navigation and running the report, refer to How to Find and Generate a Report.

Field	Description
Course Section(s)	Select one or more course sections for the current school and term.
Students	Choose the current student selection or all students.
Include Inactive Students	When selected, includes students who were enrolled in the selected class for at least one day. This option is selected by default.
Attendance Cutoff Date	The last date through which attendance is counted. Defaults to the last day of the selected term.

Report Output

Each of the fields displayed in the output of the report are described below. Refer to Understanding the Report Output Table for a definition of each column in the table.

Data Element	Description	[Table]FieldName
Attendance Cutoff Date	Date through which attendance is counted. Defaults to the last day of the selected term and can be changed when running the report.
School Number	School number for the selected section.	[Schools]School_Number
School Name	Name of the school.	[Schools]Name
Course - Section	Course number and section number, separated by a hyphen.	[Sections]Course_Number
Teacher	Lead teacher for the section as of the cutoff date. Uses the teacher’s legal name when available; otherwise, the teacher’s first and last name.	[Section]Teacher
Student Name	Student name displayed as last name, first name. Uses legal names when available.	[S_ON_STU_X]Legal_Last_Name /[S_ON_STU_X]Legal_First_Name, if unavailable [Students]Last_Name [Students]First_Name (StudentName).
Student Number	Student’s local number.	[Students]Student_Number
Student OEN	Student’s Ontario Education Number.	[Students]State_StudentNumber
Number of Scheduled Classes	Number of times the section meets during the student’s enrollment window, through the cutoff date. Enrollment windows are bounded by the later of the enrollment date or term start and the earlier of the day before the exit date, term end, or cutoff date. Overlapping or adjacent enrollment windows are merged to avoid double-counting. The timetable helper counts meetings for “Each Meeting Separately” sections and distinct dates for “Once For All Meetings” sections.	Calculated
Unexcused Classes Missed	Count of recorded absences with an attendance code categorized as `UNEX`, matched to a scheduled section meeting within the student’s enrollment window and through the cutoff date. Counts attendance records for “Each Meeting Separately” sections; otherwise counts distinct attendance dates. Returns zero when no qualifying absence is found.	Calculated
Absence Rate Percentage	Unexcused classes missed divided by scheduled classes, multiplied by 100 and rounded to one decimal place. No percent sign is added to the CSV value. The field is blank when scheduled classes is zero.	Calculated