Related Topics   

Attendance Truancy Report

Contents

1 Overview

1A Unexcused Absence Definition

1B Calendar Method

1C Schedule Method

2 School Building Summ Rpt (1)

3 School Building Summ Rpt (2)

4 School Building Summary (3)

5 District Summary Rpt (1)

6 District Summary Rpt (2)

7 Selected Schools Summ Rpt (1)

8 Selected Schools Summ Rpt (2)

9 Selected Schools Summ Rpt (3)

10 Selected Schools Dist Summ (1)

11 Selected Schools Dist Summ (2)

12 Detail Rpt

13 Report Parameters

14 How-to

15 Summary Rpt Fields

16 Detail Rpt Fields

1C Schedule Method

This includes the definitions and calculations used to determine if a student’s unexcused absence counts as a full day.

 

The Calendar Method is defined in the Calendar Master table. The Schedule Method or "S" value uses data values defined in the Entity’s Default Calendar to compute the percentage of a day that counts as a Full Day’s Absence. This Full Day’s Absence Ratio appears on the Parameter Page of the Attendance Truancy Report.

 

The following definitions and calculations are used to compute the Full Day Absence Ratio:

  1. Calculate Periods in a Day:

The Schedule Method uses values defined in the Entity’s Default Calendar to compute a Full Day Absence Ratio. The Default Calendar for an Entity is defined in the Calendar Description code record.    

The calculation uses the maximum number of periods defined in the Entity Default Calendar’s, Calendar Master (CALENDAR-MASTER.CAL-DEF-PRDS-PER-DAY-MAX).

  1. Number of Periods Absent for a Full Day's Absence:

The report uses the value defined in the Full Days Period Absent on the Calendar Detail Maintenance Table. Skyward uses the Half Days high range value to compute the Full Days lower range value by adding one period to the Half Day High field value. (CALENDAR-DETAIL.CAL-PRDS-IN-HALF-DAY-HI + 1).

For example, if the value in the Half Day high range is three periods, the system computes a value of four periods as the minimum number of periods a student would have to miss to be counted as a Full Day's Absence.

The Maximum Periods from the Calendar Master supplies the Calendar Detail Full Day’s absence upper range value.  

  1. Calculate the Full Day's Absence Ratio:

The "Full Days Absence" ratio is the Minimum Number of Periods that count as a Full Day's Absence divided by the Maximum Number of Periods in a day as defined in the Entity Default Calendar Master.  

For example, if being absent four periods is defined as a Full Day’s Absence and the Maximum Periods per Day is six then the Full Day's Absence ratio is 4/6 or .667.

  1. Check Daily Period Detail:

Loop through each day in the calendar that falls within the report date range. Determine the number of periods for the specific calendar day being checked, as defined in Calendar Day Maintenance. This screen allows the school to define a "short" day, or a day in which attendance is taken for less than the normal number of periods. Within the table Calendar-day, a value of "Y" in each CAL-DAY-PRDS-MEET[ ] field denotes that the period is included in the attendance calculation.

  1. Count the Student’s Unexcused Absences:

If a student has attendance detail for one or more periods on a given day (STUDENT-ATND-DETAIL.ATND-DATE), the report looks at the Absence Category assigned to each Absence Type code to determine if the attendance detail counts as an unexcused truancy absence.

Each Absence Type code with an Absence Category code of "U" is counted. The report loops through each student attendance record for each calendar day in the range and calculates the number of periods that are identified as an unexcused absence (ATND-ABSENCE-TYPE.AAT-EXC-UNEXC-TAR-OTH = "U").

  1. Each Absence Type code with an Absence Category code of "U" is counted:

ATND-ABSENCE-TYPE.AAT-EXC-UNEXC-TAR-OTH = "U". The report loops through each student attendance record for each calendar day in the range and calculates the number of periods that are identified as an unexcused absence.

  1. Calculate the Student’s Unexcused Ratio:

The Schedule Method looks at the Student’s actual schedule for each day there is an unexcused absence.  The Attendance Truancy Report creates the Student’s Unexcused Ratio based on the number of periods scheduled and the number of periods the student was unexcused on that same day. For example, if the Student was scheduled for six periods and missed five of the six, that Student’s Unexcused Ratio would be 5/6 or .833.

  1. Compare the Full Days Absence Ratio to the Student’s Unexcused Ratio:

If the Student’s Unexcused Ratio is equal to or greater than the Full Day's Absence Ratio, the day counts as a full day's absence on the Attendance Truancy Report. For example, if the Student’s Unexcused Ratio for a day is .833 and the Full Day's Absence Ratio is .667, the day will be counted as a full day’s unexcused absence.

Page Updated 11/07

Top