Statistical Summary - Charter Schools
Contents
Introduction
The Statistical Summary provides aggregated data of the student's enrollment, attendance, and transportation. The data is grouped by grade level and Out of Home Placement (OHP). This is the main report and is used as a starting point of the Audit reports. The data submitted via SIF must match this report. The report generates an HTML page.
The header displays the name of the sub-district and the date range of the 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.
- The student is selected based on the schools defined in the Accredited School ID. If the report is run for all schools in the sub-district, accredited and non-accredited are included.
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 |
| Select Sub-District | Select the sub-district. None is selected by default. Only the sub-districts configured in the District Setup displays in this list. |
| School Selection* | Indicate the school for the report. If a sub-district is selected, the schools associated with that sub-district are listed. |
Current Selection Students* | Select the students to include in the report:
If running the report for a single student, or group of students, select the students prior to running the 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.
|
Start Date* | Enter start date of the reporting period (mm/dd/yyyy). |
End Date* | Enter end date of the reporting period (mm/dd/yyyy). |
| Exclude Basis of Admission | 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:
|
Scheduling | Select when to run the report:
|
Report Output
Each of the fields displayed in the output of the report is 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 |
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. STSS - Short Term School Suspension and LTSS - Long Term School Suspension | 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. STSS - Short Term School Suspension and LTSS - Long Term School Suspension | 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 |