Tool Search: ADE Reports
This report is also available for State Edition users.
The ADE (Average Daily Enrollment) Summary and Detail Reports contain aggregated pupil enrollment days of students enrolled in the district, school, or charter authority. The district and school summary options are a summary total of all selected calendars. The charter school summary reports all selected calendars separated by Resident District. The detail options will report individual calendars separated by grade level or individual student.
Average Daily Enrollment Reports Editor
Report Logic
- Reports all student enrollments of Service Type = P from selected calendar(s) or school.
- Reports enrollments that have a Start Status = E1, E8, E9, E11, or R2.
- A Pupil Day is defined as an instructional day that occurs on or within the student enrollment range.
- Pupil Day must fall within the Date Range entered on the extract editor. The Pupil Day must also fall within the Term Dates entered on the calendar.
- Reports PK students with a Special Education Exit Date equal to their Enrollment End Date.
PK SPED Students - Preschool students must be actively receiving Special Ed services to be included.
If the PK and SpEd Plan Start date occur after the Quarter Start date, the days from the Plan Start to Quarter End date report.
If the PK and SpEd Plan Exit date occurs before the Quarter End date, the days to the SpEd Plan Exit Date report.
Tips for Validating Data Accuracy in the ADE District Summary and Detail
- After you generate the District Summary report using Summary Type "District," look at the bottom of the report and verify whether all schools were included. If there are missing schools, complete the following tasks:To help validate information in the report, run the District Summary report using a limited list of schools or calendars.
- Verify the school is not marked as type “C.”
- Validate all calendars associate to the school are not marked state exclude.
- Validate that students are enrolled in the school with proper enrollment codes.
- To validate the numbers on the District Summary are accurate, run the School Detail report. It might be easier to run this report in groups of schools; e.g., all elementary schools, instead of district wide. With the report in Excel, sort by grade level and subtotal the Enrolled Days column by each grade level. If the report is accounting for all schools carrying the same grade level, the subtotal should equal the total Enrolled Days of the same grade level on the District Summary.
- After you validate the Enrolled Days match, you can subtotal the Raw ADE by Grade Level on the School Detail report. These subtotals should match the Grade Level ADE total on the District Summary report. If there are discrepancies in School totals, you may want to run the Student Detail report for a specific school. To validate, sort the file in Excel using the Grade Level column. Subtotal Enrolled Days by grade level and validate this is the same subtotal you receive on the School Detail report.
- ADE reports can not manage Schedule structures. If a school has multiple schedules for a year, they must be built as separate calendars and possibly use Schedule Tracks.
- You can use the previous tips on Charter Schools using the Charter School Summary in place of the District Summary.
- If counts seem to be missing from any report, validate that the data is not excluded by any of the following: Student Exclude, No Show, Enrollment Codes, Enrollment Type, State Grade Level, Grade Level Exclude, Calendar Exclude.
- If a report does not supply Days in Session, avoid calculating an ADE from the Enrolled Days counts.
Report Editor
| Extract Option | Description |
|---|---|
| Quarter | Four options are available: 1st Quarter, 2nd Quarter, 3rd Quarter, and 4th Quarter. |
| Quarter Dates | Dates are based on the active year and the selected quarter. Dates can be edited
|
| Report Type |
|
| Format | Options are CSV and HTML. |
| Ad Hoc Filter | This option allows you to narrow report results to students included in the filter you select. |
| Select Calendars | Allows you to select which Calendar(s) should be included in the report. Calendars can be sorted by active year, by school or by year. |
Generate Extract Submit to Batch |
|
Report Layouts
District Summary
| Element | Logic | Location |
|---|---|---|
| Quarter | The name of the quarter being reported. Options are Q1, Q2, Q3, Q4. | NV State Reporting > ADE > Quarter |
| Quarter Dates | The start and end dates of the reporting quarter. Date Field MM/DD/YYYY | NV State Reporting > ADE > Quarter Dates |
| District Number | The district number associated with the chosen calendar. | School & District Settings > District > District Information > Master District Code District.number |
| District Name | The district name associated with the chosen calendar. | School & District Settings > District > District Information > Name District.name |
| Grade Level | The Grade level being reported. | System Administration > Calendar > Grade Levels > State Grade Level Code GradeLevel-dep20101.stateGrade |
| Days Enrolled | Reports the sum all instructional days each student was enrolled between quarter start and end dates for each Track and Grade Level. The sum of each grade level in the district reports. | System Administration > Calendar > Days Student Information > General > Enrollments > Start Date; End Date Day.instruction Enrollment.startDate Enrollment.endDate |
ADE | The average number of pupils enrolled for the term. The average is calculated by dividing the Pupil Days Enrolled by the number of days in the session. The number of days in the session is determined from the calendar schedule. It is the number of instructional days on or between the extract editor Start Date and End Date. The calculation is performed independently on each schedule to determine the Average Pupils Enrolled. If more than one schedule is being calculated, the sum of all scheduled Average Pupils Enrolled report. | N/A |
| School Number | The school number for the school included in the report. | School & District Settings > Schools > School Information > State School Number School.number |
| Schools Reported | The name of the school. | School & District Settings > Schools > School Information > Name School.name |
Charter School Summary
| Element | Logic | Location |
|---|---|---|
| Quarter | The name of the quarter being reported. Options are Q1, Q2, Q3, Q4. | NV State Reporting > ADE > Quarter |
| Quarter Dates | The start and end dates of the reporting quarter. Date Field MM/DD/YYYY | NV State Reporting > ADE > Quarter Dates |
| District Number | The district number associated with the chosen calendar. | School & District Settings > District > District Information > Master District Code District.number |
| District Name | The district name associated with the chosen calendar. | School & District Settings > District > District Information > Name District.name |
| School Number | The school number for the school included in the report. | School & District Settings > Schools > School Information > State School Number School.number |
| School Name | The name of the school. | School & District Settings > Schools > School Information > Name School.name |
| Resident District | The school district in which the student resides or to which the student's residence is assigned. | Student Information > Enrollments > State Reporting > Resident District Enrollment.residentDistrict |
| Grade Level | The Grade level being reported. The report only provides grade levels that have counts associated to them. | System Administration > Calendar > Grade Levels > State Grade Level Code GradeLevel-dep20101.stateGrade |
| Days Enrolled | Reports the sum all instructional days each student was enrolled between quarter start and end dates for each Track and Grade Level. The sum of each grade level in the district reports. | System Administration > Calendar > Days Student Information > General > Enrollments > Start Date; End Date Day.instruction Enrollment.startDate Enrollment.endDate |
| ADE | The average number of pupils enrolled for the term. The average is calculated by dividing the Pupil Days Enrolled by the number of days in the session. The number of days in the session is determined from the calendar schedule. It is the number of instructional days on or between the extract editor Start Date and End Date. The calculation is performed independently on each schedule to determine the Average Pupils Enrolled. If more than one schedule is being calculated, the sum of all scheduled Average Pupils Enrolled report. | N/A |
School Detail
| Element | Logic | Location |
|---|---|---|
| Quarter | The name of the quarter being reported. Options are Q1, Q2, Q3, Q4. Alphanumeric | NV State Reporting > ADE > Quarter |
| Quarter Dates | The start and end dates of the reporting quarter. Date Field MM/DD/YYYY | NV State Reporting > ADE > Quarter Dates |
| District Number | The number assigned by the state to identify the School District. | School & District Settings > District > District Information > Master District Code District.number |
| District Name | The name of the school district. | School & District Settings > District > District Information > Name District.name |
| School Number | The School Number of the reporting school. | School & District Settings > Schools > School Information > State School Number |
| School Name | The name of the school associated with the calendar being reported. | School & District Settings > Schools > School Information > Name School.name |
| Track_CID | A numeric character indicating the track in which the student is enrolled. If a calendar does not have a track assigned, the Calendar ID reports. | System Administration > Calendar > Calendar > Track OR Calendar ID Calendar.track |
| Resident District | The Resident District identified on the Enrollment. If the Resident District field is null, this element reports blank. | Student Information > General > Enrollments > State Reporting > Resident District Enrollment.residentDistrict |
| Grade Level | The Grade level being reported. | System Administration > Calendar > Grade Levels > State Grade Level Code GradeLevel-dep20101.stateGrade |
| Days Enrolled | Reports the sum all instructional days each student was enrolled between quarter start and end dates for each Track and Grade Level. The sum of each grade level in the district reports. | System Administration > Calendar > Days Student Information > General > Enrollments > Start Date; End Date Day.instruction Enrollment.startDate Enrollment.endDate |
| Days in Session | The sum of all calendar days marked as Instructional between term quarter start and end dates for the identified Track and Grade Level. | System Administration > Calendar > Days Day.instruction |
| Raw ADE | The sum of the Days Enrolled and Days in Session by unique track and grade level. The days in session is determined from the calendar schedule. It is the number of instructional days on or between the extract editor Start Date and End Date. For each track and grade level, the Days in Session is divided by the Days Enrolled. | System Administration > Calendar > Days Day.instruction |
Student Detail
| Element | Logic | Campus Location |
|---|---|---|
| Quarter | The name of the quarter being reported. Options are Q1, Q2, Q3, Q4. Alphanumeric | NV State Reporting > ADE > Quarter |
| Quarter Dates | The start and end dates of the reporting quarter. Date Field MM/DD/YYYY | NV State Reporting > ADE > Quarter Dates |
| District Number | The number assigned by the state to identify the School District. | School & District Settings > District > District Information > Master District Code District.number |
| District Name | The name of the school district. | School & District Settings > District > District Information > Name District.name |
| School Number | The School Number of the reporting school. | System Administration > Resources > School > School Detail > State School Number School.number |
| School Name | The name of the school associated with the calendar being reported. | School & District Settings > Schools > School Information > Name School.name |
| Track_CID | A numeric character indicating the track in which the student is enrolled. If a calendar does not have a track assigned, the Calendar ID reports. | System Administration > Calendar > Calendar > Track OR Calendar ID Calendar.track |
| Resident District | The school district in which the student is a resident. | Student Information > General > Enrollments > State Reporting Fields > Resident District Enrollment.residentDistrict |
| Last Name | The student's last name. | Census > People > Demographics > Last Name Identity.lastName |
| First Name | The student's first name. | Census > People > Demographics > First Name Identity.firstName |
SUID | Automatically generated unique state identification number. | Census > People > Demographics > State ID Person.stateID |
| LocalID | The student's Local Student Number. | Census > People > Demographics > Local Student Number Person.studentNumber |
| Grade Level | The Grade level being reported. | System Administration > Calendar > Grade Levels > State Grade Level Code GradeLevel-dep20101.stateGrade |
| Days Enrolled | Reports the sum all instructional days each student was enrolled between quarter start and end dates for each Track and Grade Level. The sum of each grade level in the district reports. | System Administration > Calendar > Days Student Information > General > Enrollments > Start Date; End Date Day.instruction Enrollment.startDate Enrollment.endDate |
