Statistical Summary

Contents

Introduction

The Statistical Summary report provides a summary of student transportation, attendance, and membership information sorted by grade level. The aggregate values are for all students enrolled during the reporting period. The report generates an HTML page.

The header section of the report lists the district location and the report date range information used to produce the report. The details of the report are summarized in the Report Output section below. The report at the district level is now grouped by number of days taught to produce accurate student totals and calculations for ADA and ADM. The end of the report has a grand total for all grades.

The Statistical Summary report values in the Total Days section and the Total Students For Entire Period match the summary section of the Attendance Register report.

The Statistical Summary report values in the Transportation section, Total Days section, and Total Students For Entire Period match the summary section of the Transportation Register report.

All PK4 IDEA students are denoted as (FD) Full Day irrespective of whether they are am or pm.

Underage students in Grades Pre-K, Kindergarten and Grade 1 are moved to the converted grade, denoted with (UA) Underage in the report. The following rules apply:

If a three-year-old student is reported to be in PK, then the student’s ConvertedGrade is PK3.
If a student is reported to be in KG and turns 4 before or on September 1st of that current school year, then that student’s ConvertedGrade is PK4.
If a student is reported to be in the 1st grade and turns 5 before or on September 1st of that current school year, then the student’s ConvertedGrade is KG.

Students moved to the Converted grade and underage students in Grades Pre-K, Kindergarten and Grade 1 moved to the Converted grade are listed in a separate section at the bottom of the report.

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.

Student Selection

The report selects records from the [Students] and [ReEnrollments] tables based on the following criteria:

The student must not be excluded from state reporting.
The student must be enrolled in a school included in the report.
The student’s school enrollment Exit Date must occur after the report start date.
The student’s school enrollment Entry Date must occur on or before the report end date.
The school enrollment Exit Date must occur after the Entry Date.

Note: Entry Codes and Exit Codes are required to correctly calculate the Total Students – On Count Date.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field	Description
Current Selection Students*	Select the students to include in the report: The Selected [number] Students Only. All Students Note: If running the report for a single student, or group of students, select the students prior to running report.
Grade (Leave blank to include ALL Grades)	Choose the grade level(s) to be included in the report. To choose multiple grade levels, use Ctrl+click. To include all grade levels, as well as OHP, leave blank. Notes: If no grade levels are selected, all grade levels are reported, including OHP. If grade levels are selected, OHP is excluded. If OHP and grade levels are selected, the report outputs OHP for all grades and non-OHP students for the grades selected.
Start Date*	Enter start date of the reporting period (in mm/dd/yyyy format).
End Date*	Enter end date of the reporting period (in mm/dd/yyyy format).
Basis of Admission to Exclude	To exclude a Basis of Admission code, select it from the pop-up menu. To exclude multiple codes, use CTRL+Shift on your keyboard and select the codes to exclude. The following codes can be excluded: ACEPT BORDER CHSP COOP COOPVOFF COOPVON IEPSA IEPSAVOFF IEPSAVON LTSS NR NRISP OTH PK3 Pre-ISP RISP STSS
Scheduling	Select when to run the report: Run Now (Recommended) Schedule – Run the report on the specified date, time and schedule.

Back to Top

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.

Header Section

Item #	Data Element	Description	[Table]FieldName
1	District	Name of the School District	[Prefs]Value where [Prefs]name = districtname
2	County	Name of the County of the School District	[Schools]CountyName
3	Site Number	School Site Number	[Schools]School_Number
4	School Name	School Name	[Schools]_Name
5	Period	Reporting Period or Cycle for which the report is run.	Report parameter
6	Date Range	Period start and end dates for which the report is run.	Report parameter
7	Days Taught	Number of days in session in the report date range.	At District, uses Report parameter. At School, calculated from the calendar where Day Type is In Session.
8	Not Taught	Number of days not in session in the report date range.	At District, uses Report parameter. At School, calculated from the calendar where Day Type is not In Session.
9	Total Days	Sum of days taught and not taught in the report date range.	Sum of days taught and not taught in the report as calculated above.
10	Date	Date when the report was run.	System date
11	Time	Time when the report was run.	System time
12	Grade	The grade reported.	[Students]Grade_Level

Back to Top

Detail Section

Item #	Data Element	Description	[Table]FieldName
1	Grade	School grade levels K (0) through 12.	[Students]Grade_Level
2	Transportation – Transferred Transported	Total # of days multiplied by the number of students per grade level for transportation as transfers.	[S_OK_STU_X]TransportStatus = 3
3	Transportation – Resident >= 1.5 Miles	Total # of days multiplied by the number of students per grade level for transportation from a distance of 1.5 miles or greater.	[S_OK_STU_X]TransportStatus = 1
4	Transportation – Resident < 1.5 Miles	Total # of days multiplied by the number of students per grade level for transportation from a distance of less than 1.5 miles.	[S_OK_STU_X]TransportStatus = 2
5	Transportation – Legally Transported	Total # of days multiplied by the number of students per grade level that reside in the district at least 1.5 miles from the school.	[S_OK_STU_X]TransportStatus = 5
6	Transportation – Other Transported	Total # of days multiplied by the number of students per grade level that reside less than 1.5 miles from the school.	[S_OK_STU_X]TransportStatus = 4
7	Transportation – State Aid Paid	Sum of values of Transferred Transported and Resident >=1.5 Miles per grade level.	Calculated
8	Total Days – Present	Total # of present attendance days times the number of students per grade level.	Calculated
9	Total Days – Absent	Total # of absent attendance days times the number of students per grade level.	Calculated
10	Total Days – Membership	Total # of membership days times the number of students per grade level. Note: STSS - Short Term School Suspension and LTSS - Long Term School Suspension Enrollments that have LTSS or STSS as the basis of admission will be dropped from ADA and Membership and will not be counted in the reports. Upon returning to school, these students will be re-entered with the entry code, 1837, and the appropriate Basis of Admission code, then these enrollments will resume getting calculated in the reports.	Calculated
11	Attendance - % Attd	The attendance percentage times the number of students per grade level.	Calculated
12	Attendance – A.D.A.	Total # of Average Daily Attendance days times the number of students per grade level. Note: STSS - Short Term School Suspension and LTSS - Long Term School Suspension Enrollments that have LTSS or STSS as the basis of admission will be dropped from ADA and Membership and will not be counted in the reports. Upon returning to school, these students will be re-entered with the entry code, 1837, and the appropriate Basis of Admission code, then these enrollments will resume getting calculated in the reports.	Calculated
13	Attendance – A.D.M.	Total # of Average Daily Membership days times the number of students per grade level.	Calculated
14	Total Students – For Entire Period	Total # of students per grade level enrolled in the school for the entire reporting period.	Calculated
15	Total Students – On Count Date	Total # of students per grade level enrolled in the school on the report end date.	Calculated
16	Students Educated at District	Total # of distinct students educated for this reporting period at this school district. The Students Educated at District calculation includes all students who attended this site during the reporting period; this is the total number of students who have an entry, not the total number of entries. Students who have exited are not included. The number here matches the sum total for the "Entire Period" column only if no students changed grade levels during this reporting period. If any students did change grade levels, this number is lower than the sum for the "Entire Period" column.	Calculated

Back to Top