IL Attendance Audit
Contents
Introduction
The IL Attendance Audit report is used to split student attendance data by enrollment type for those students who are promoted to the next grade level or who transfer to different schools within the specified date range. Attendance views and Attendance Conversions are used in the calculation of attendance days.
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.
For the Illinois Attendance Audit report, student enrollment records are selected.
School Selection
The report selects which school records to use based on the following criteria:
- The school must be associated with a student included in the report.
- The school must not be excluded from state reporting.
Student Selection
The report selects which student records to use based on the following criteria:
- The student must not be excluded from state reporting.
- The student must be actively enrolled at some time between report start and report end dates.
- The student’s current enrollment must not be excluded from state reporting.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
Use | If run at the district level, choose one of the following from the pop-up menu:
If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list. |
Students to Include | Indicate which students to include in the report by selecting one of the following options:
Note: If running the report for a single student, or group of students, select the students prior to runningreport. |
Select District | (Optional) If this option appears, select the District for which to run the report. |
Grades | Select which grades to include in the report. Leave all checkboxes cleared to include all grades. |
Start Date | Enter the start date for the reporting period. Students are included if they are/were enrolled at any time between Start and End Date. Format: MM/DD/YYYY |
End Date | Enter the end date for the reporting period. Students are included if they are/were enrolled at any time between Start and End Date. Format: MM/DD/YYYY |
Students to Include | Choose one of the following from the pop-up menu:
|
Run in Validation Mode | Choose one of the following from the pop-up menu:
|
Report Output
Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.
Item # | Data Element | Description | [Table]FieldName | Field Type | Field Length |
1 | Grade Level | Student’s grade level at the time of the enrollment. | [Students]Grade_Level [S_IL_STU_ELL_X]Grade_Level OR [ReEnrollments]Grade_Level | Alpha-Numeric | 2 |
2 | School | Name of the school in which the student is enrolled. | [Student]SchoolID | Alpha-Numeric | |
3 | Total # of Legal Days | Number of in session school days in the reporting date range. | N/A | Numeric | 3 |
4 | Total # of Students | Number of students actively enrolled during the reporting date range. | N/A | Numeric | N/A |
5 | Total Days Enrolled | Number of days of enrollment for the Total # of Students in the reporting date range. | N/A | Numeric | N/A |
6 | Total Days Present | Number of days the Total # of Students were present within the reporting date range. | N/A | Numeric | N/A |
7 | Total Days Absent | Number of days the Total # of Students were absent within the reporting date range. | N/A | Numeric | N/A |
8 | Percent of Attendance | Calculated. (Total Days Present / Total Days Enrolled) * 100. | N/A | Numeric | N/A |
9 | Average Daily Attendance | Calculated. (Total Days Present / Total # of Legal Days). | N/A | Numeric | N/A |
10 | Students Added | List of students added during the reporting date range, sorted by student last name, first name. Fields shown are: name, DOB, Address, School number, grade level, and Entry Date. | N/A | N/A | N/A |
11 | Students Dropped | List of students withdrawn during the reporting date range, sorted by student last name, first name. Fields shown are: name, DOB, Address, School number, grade level, and Entry Date. | N/A | N/A | N/A |