This lesson will help you view average daily attendance within Illuminate Student Information. Average Daily Attendance (ADA) is the average number of students present per day over a given period of time. School funding is determined by these numbers.
ADA is calculated as:
(num_present_day1 + num_present_day2 + num_present_day3 + num_present_dayX ...) / number_of_days
What's new in this report?
To make month to month balancing easier and avoid the need to flip between reporting months, we have added two new columns - "Carry In" and "Carry Out." Carry In displays the Carry Out number of the previous month. Carry Out calculates the End number minus the Last Day Exits. Additionally, we now highlight same grade level across attendance programs when you hover over the report. This feature is useful for sites that offer a lot of attendance programs.
Where to Start
1. Click Attendance.
2. Under ADA 3.0 Reports, click Daily ADA.
Options
1. Adjust any selections (or leave the defaults in place if you don't wish to change anything) based on your needs.
2. Select school(s). Note that changing Show Column Descriptions to Yes will provide you with definitions (at the bottom of your report) of all terms used in the report.
3. Click View in Browser or Download to PDF/Excel.
View Report
Here is an explanation of terms you might encounter upon viewing your report:
- ADA - The average number of students in attendance per day. Calculated using the following formula: ([# of students present on day 1] + [# of students present on day 2] + ...) / [number of days]
- % ADA - The percentage of time that students were present during the date range when enrolled. Calculated using the following formula: [Apport] / ([Poss] - [N/E])
- Days - The number of in-session school days in the date range
- First Day Entry - The number of students who began enrollment on the first day of the date range.
- Begin - The number of students enrolled at the beginning of the date range
- Gain - The number of students who began enrollment during the date range
- Max - The total number of students who had any enrollment during the date range
- Male - The total number of male students who had any enrollment during the date range
- Female - The total number of female students who had any enrollment during the date range
- Loss - The number of students who ended enrollment during the date range
- End - The number of students enrolled at the end of the date range
- Last Day Exit - The number of students who ended enrollment on the last day of the date range.
- N/E - For students who either began or ended enrollment during the date range, the sum of the number of days each student was not enrolled during the date range
- Abs. - The sum of all absent (excused and unexcused) records across the date range
- Exc. - The sum of all excused records across the date range
- Unex. - The sum of all unexcused records across the date range
- Apport. - The sum of all present records across the date range
- Poss. - The highest potential apportionment for the date range, with days N/E included (the number of students multiplied by the number of days)
- Sched. - The highest potential apportionment for the date range, with days N/E excluded (the sum of the number of students enrolled on each day in the date range)
Next Steps
You may want to use the other ADA Reports to access Average Daily Attendance by grade or district. See other lessons within the "Attendance" manual for guidance in related tasks.