Expected and Actual Section Attendance
- Eric Jansson
Owned by Eric Jansson
Jun 29, 2022
1 min read
Loading data...
Expected and Actual Section Attendance Use Cases
Report a student's expected total days in attendance for a section.
Expected Days in Attendance for a Section = Section → CourseOffering → Session.TotalInstructionalDays
WHERE Section = { Section for the attendance calculation }
Assumption:
- The student is enrolled for the entire session associated with the section.
Report a student's actual attendance for a section.
Student Section Attendance = { Expected Days in Attendance for the Section (see above) } - COUNT ( StudentSectionAttendanceEvent.AttendanceEvent.EventDate )
WHERE StudentSectionAttendanceEvent.AttendanceEvent.AttendanceEventCategoryDescriptor IN { Absent categories (e.g., Excused Absence, Unexcused Absence) as defined by the implementation }
AND StudentSectionAttendanceEvent.Student= { Student for the attendance calculation }
AND StudentSectionAttendanceEvent.Section = { Section for the attendance calculation }
Assumptions:
- The student is enrolled in the section for the entire session.
- Days are reported as whole numbers. If reported as partial days, StudentSectionAttendanceEvent → SectionAttendanceDuration or StudentSectionAttendanceEvent → AttendanceEvent → EventDuration may be used.