Class Period Absence Rate
Background
Student Dashboard Metrics
Because attendance is a leading indicator of student performance, virtually every performance management dashboard should include a measure of student attendance. This need was echoed in focus groups conducted with over 2,600 Texas educators, in which attendance was consistently named as one of three top student data needs. Further, the Class Period Absence Rate metric, as presented in screen shots of the student dashboard, was considered useful by 96% of those surveyed.
Primary Metric
- Class Period Absence Rate: the percent of class periods a student is in attendance during the last four weeks, last eight weeks and the entire year to date, with comparison to campus goal for each time frame.
User Interface
Dashboard Example
Figure 1 shows the Class Period Absence Rate metric as seen on the student dashboard.
Figure 1 TSDS Class Period Absence Rate Metric
Status Definition
The Status indicator is determined by campus-specific thresholds (campus goals) which are set at the district level. The default threshold set in the dashboards for each time frame is 10%.
Metric Indicator | Trend Comparisons | |||
Metric Name | Sub-metric Name | Metric Indicator | Compares: | To: |
Class Period Absence Rate | Last Four Weeks | Red (Percentage) = if class period absence rate is greater than campus goal Green (Percentage) = if class period absence rate is less than or equal to the campus goal | Last four weeks Begins 40 days into school year with no overlapping days | Prior four weeks |
Last Eight Weeks | Red (Percentage) = if class period absence rate is greater than campus goal Green (Percentage) = if class period absence rate is less than or equal to the campus goal | Last eight weeks Begins 80 days into school year with no overlapping days | Prior eight weeks | |
Year to Date | Red (Percentage) = if class period absence rate is greater than the campus goal Green (Percentage) = if class period absence rate is less than or equal to campus goal | Current Year | Prior Year |
(a) The value column displays the number of class period absences.
Delta Definition
Delta Indicators: Objective is to indicate Class Period Absence Rate | |||
Metric Name | Sub-Metric Name | Campus Goal | Delta |
Class Period Absence Rate | Last Four Weeks | Set Student Goal | Red (Percentage) = if the calculated delta is less than the campus goal Black (Percentage) = if the calculated delta is equal to or greater than the campus goal |
Last Eight Weeks | Set Student Goal | Red (Percentage) = if the calculated delta is less than the campus goal Black (Percentage) = if the calculated delta is equal to or greater than the campus goal | |
Year to Date | Set Student Goal | Red (Percentage) = if the calculated delta is less than the campus goal Black (Percentage) = if the calculated delta is equal to or greater than the campus goal |
Periodicity
Best practice is to upload the data for this metric daily.
Recommended Load Characteristics | |
Calendar | Throughout the school year |
Frequency of data load | Daily, Weekly, Monthly |
Latency | 4 weeks |
Interchange schema | Interchange-StudentAttendance.xsd |
Tooltips
The standard tool tips for the metric definition, column headers, and help functions display for this metric.
The following are tooltips specific to the Class Period Absence Rate metric:
- Green metric status: OK
- Red metric status: LOW
- 'More' indicates drill down views for this metric
is ‘No change from the prior period'
is ‘Getting worse from the prior period’
is 'Getting better from the prior period'
Business Rules
The Class Period Absence Rate metric displays the percentage of class periods a student has missed out of the total number of eligible class periods for that student over the following time frames:
- Last Four Weeks
- Last Eight Weeks
- Year to Date
- Prior Year
When calculating this metric, do not count tardy or early release occurrences.
Data Assumptions
- Campus must record student absences at the classroom level for each specified time frame.
- Class period absence rate is meaningful only for those grades where students have more than one class period.
- Student absences are categorized (e.g. excused, unexcused).
- Student excused absence reasons are recorded.
- District sets the value that drives the campus and student status thresholds.
- For the detailed views of this metric, the dashboard does not account for students who missed roll call.
- Data is based on the last 20 and 40 instructional days.
Computed Values
Table 4 defines how values are calculated for each time frame. The result of the calculation displays in the Status column on the student dashboard.
Metric Values | ||
Class Period Absence Rate | Last Four Weeks | (Student excused class period absences + student unexcused class period absences) / (Total number of class periods for a student in last four weeks) |
Last Eight Weeks | (Student excused class period absences + student unexcused class period absences) / (Total number of class periods for a student in last eight weeks) | |
Year to Date | (Student excused class period absences + student unexcused class period absences) / (Total number of class periods for student for school year to date) |
Calculation Notes
- This metric is calculated only for students who are currently enrolled.
- Days a student is not enrolled are subtracted from the “Total Number of Instructional Days” in the denominator.
- In addition to the percentage of total class periods missed, developers may also display the total number of days missed.
- If there is a day when no students are absent, count the date as "no school."
Data Anomalies
Data Anomalies
- Metrics are sensitive to when and how often the data is loaded.
- Late enrollees are likely to be missing attendance and discipline data. The calculation for the metric value is not dynamic. However, detail views on class period absences will display more information.
- If the school calendar changes, then adjust the denominator to reflect eligible days.
- Create an icon (not implement) that shows if data was last data loaded was more than a month ago.
Best practice is to use footnotes to address these anomalies.
Footnotes
Footnotes are used to provide additional information concerning the metric. Footnotes are sequential for the entire page. Therefore, a metric's footnote may not begin with the number 1.
The following footnotes appear below the metric:
- Students transferring in that have not been present for a full grading period should be noted by a designated icon.
- If the school calendar changes, then adjust the denominator to reflect eligible days.
Date of Refresh
Best practice is for the date of last data refresh to appear next the metric in the following format:
- (Through April 22, 2010)
Implementation Considerations
Late Enrollments
For late enrollment students, adjust the number of instructional days in a time frame to reflect eligible days. Specifically, subtract the number of instructional days in a time frame (i.e., last 4 weeks, last 8 weeks, or year-to-date) the student was not enrolled.
Classification of Days as Non-Instructional Days
For the computation of the number of instructional days, use either the total count of instructional days in a period or the school calendar to identify specific instructional days for the time frame as the denominator for the percentage. The latter is a more accurate approach to calculating the metric with the caveat that this requires frequent uploading of data throughout the school year.
Types of Absences
It is important to determine what your Student Information System (SIS) captures for the absence types and absence reasons. The type of absences, also known as Attendance Event Descriptor, captured in the SIS consists of tardy, excused, or unexcused absences.
For example, TSDS default for this metric uses excused and unexcused absences. The reason is displayed for excused absences (see Drill Down section). Tardy occurrences are measured as a separate metric.
Students with No Absences
When taking roll at the classroom level, campuses typically record student absences, but do not record if a student is present in a class. The query to compute student absences needs to account for students with perfect attendance, which results in null absences.
Number of Instructional Classes
The Number of Instructional Classes data element varies by student and may vary by semester. The most accurate method is to count the actual number of classes a student is enrolled in each time frame.
Class Subject Information
The displayed subjects for the classes are dependent upon local categorization in the district information sources. Alternatively, developers can display the class title with or instead of the subject.
Frequency of Uploading Data
The metric computation implementation may vary depending on the periodicity of loading the data. For example, a daily load requires that you load data for only a single day (i.e., the last instructional day). Less frequent uploads require that you load data for each day since the date of the last load.
Length of Time Frames
The choice of four and eight weeks and year to date in TSDS is based on educator input, but the length of each time frame is configurable at the district level.
Trend
The metric assumes that only the current year’s daily attendance data is loaded. In this case, if the current time frame is the
- first time frame, there is no trend for current time frame and no trend for previous time frame.
- second time frame, there is no trend for the previous time frame.
If the previous year’s daily attendance is loaded, you have the option to compare current year to the previous year.
Best practice is for the district to establish a precision policy of what defines no change (e.g., ±5 percentage points).
Thresholds
Best practice is to set the thresholds for each campus at the district level. A secure mechanism is required to allow the district to set and maintain those thresholds.
Drill Downs
Description
The Class Period Absence metric contains drill downs to provide more insight on class period absences broken down by days and weeks and by subject area.
Drill Down Views
The dashboards include the option to drill down and see more detail that is associated with a metric. Table 5 shows drill down views that are recommended for this metric.
Calendar | Absences and Tardies Calendar | |
Historical Chart | Graph of metric values by day, week, grading period, semester, and year |
User Interface Notes
Dashboard Example
Figure 2 shows the Class Period Absence Date drill down as seen on the student dashboard.
Figure 2 TSDS Absences and Tardies Calendar
Figure 3 shows the historical class period absence rate.
Figure 3 TSDS Class Period Absence Rate Historical Chart
Drill Down Tooltips
Absences and Tardies Calendar:
- The date is shown as you hover over a specific period when a student is present.
- The date and the reason for an excused absence is shown as you hover over a specific day's excused absence on the calendar.
- 'Unexcused absence on (date)' is shown as you hover over an unexcused absence.
- 'Tardy on (date)' is shown as you hover over a tardy.
- The calendar does not account for missing roll
- Not all courses meet every day.
Historical Chart:
- The start and end dates and the percent value of the metric for that time period are shown as you hover over a bar of the graph.
- The slider bar adjusts the number of time periods viewed in the graph.
- The green bar indicates student did meet the student goal
- The red bar indicates student did not meet the student goal
Business Rules
The default view of classroom absences by subject is recommended because:
- viewing period absences by a particular subject enables you to directly tie data to performance issues in that subject.
- not every class meets daily, making it difficult to display period absences by time of day.
The visualization shows a set of by-week matrices for a time frame. Each column is labeled with a day of the week. Each row is labeled with a subject. Because the intent is to examine class absences by subject, the visualization may or may not order the classes by time of day.
Individual class period absences are displayed in red. Those that are unexcused display with a 'U'. If a reason was captured for an excused absence, it is shown in a tooltip as you hover over the excused absence.
Individual class period tardies are displayed in yellow with a 'T'.
Non-instructional days per subject are blacked out in the following circumstances:
- If a class period does not meet on a specific day
- If the day is a non-instructional day (e.g., holiday)
- For days the student is not enrolled
- For class periods missed because of delayed start or early release
The Historical Graph allows the user to see historical data across multiple timeframes. As time passes, there are many bars to be displayed; therefore, the slider on the bottom allows the user to adjust the number of bars displayed as well as the time period shown. The timeframes for this metric were chosen based on educator feedback.