Class Size Average and Progress Calculation
Introduction
The Class Size Average and Progress Calculation generates a PDF that displays monthly enrollment by class for current and previous years, calculates average class size, and calculates a target enrollment to demonstrate progress.
Selection Criteria
Selection criteria determine which database records are used in the report.
Course enrollment begins on or before the last in-session day of the month.
Course enrollment ends after the last in-session day of the month or (if the associated term ends during this month) after the end of the term.
The student is not excluded from state reporting.
There exists a current, previous, or concurrent school enrollment record for the student, at this school, at least partially overlapping the course enrollment, that is not excluded from state reporting.
Courses should have at least one section during the current/previous school year in grades K-3.
The California Department of Education (CDE) has added a new grade level of ‘TK’ that districts must use when reporting Transitional Kindergarten students to CALPADS. This new grade level will be effective starting with the 2023-2024 school year.
To support this functionality, PowerSchool has updated all California state reporting pages and reports to honor the grade level mappings as defined by each district.
The grade level is reported as mapped in all CA-specific reports once you meet the following criteria:
You are on PS Version 23.1 or higher
LTK Pref is enabled
While running the report, the selected school year is 23-24 or higher.
LTK Grade Level Mapping - valid values:
Grade 0 = KN
Grades -1 and below = TK, PS, IN
Grades >12 = AD
Report Input
This report is run at the School level only.
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
Report Parameters | Select the checkboxes next to the filter fields to save the settings as defaults. To select all checkboxes, choose Select All from the Report Parameters pop-up menu. To clear all checkboxes, choose Clear All. |
Months to Include (Blank for All) | Select which months to include for the currently selected school year. "First Day" will include the first in-session day of the academic year, regardless of which other month(s) are selected. If left blank, all months plus the first day will be included in the calculation, and displayed in the table. Note: If a section has no students enrolled at the end of a particular month, that month is not included in the average for that section, nor in the overall average. |
Months to Include - Previous Year (Blank for All) | Select which months to include for the previous school year. "First Day" will include the first in-session day of the academic year, regardless of which other month(s) are selected. If left blank, all months plus the first day will be included in the calculation, and displayed in the table. |
Courses to Include (Blank for All) | Select which courses to include for the currently selected school year. The selection of courses will be limited to those having at least one section during the current year in grades K-3. If left blank, all such courses will be included. |
Courses to Include - Previous Year (Blank for All) | Select which courses to include for the previous school year. The selection of courses will be limited to those having at least one section during the previous year in grades K-3. If left blank, all such courses will be included. |
Sections to Exclude (Course Number : Section Number) | Select specific sections that should be excluded from the calculation for the current year. This list will be limited to those sections defined to be in grades K-3. |
Sections to Exclude - Previous Year (Course Number : Section Number) | Select specific sections that should be excluded from the calculation for the previous year. This list will be limited to those sections defined to be in grades K-3. |
Gap Percentage | Enter a gap percentage. The report will show gap percentage between target enrollment and actual enrollment. Any precision is acceptable and no percent sign is needed. |
Target Class Enrollment | Enter a target class enrollment. The value must be a whole number. If not specified, the default target enrollment is 24. |
Display Previous Year Detail | Choose Yes or No from the pop-up menu.
|
Display Course Details | Select information to display in first column of report output. (Selecting fewer options may help prevent line wrapping, especially if running for numerous months.) |
Use Transitional KG Label | Choose Yes or No 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 Tables for a definition of each column in the table.
Data Element | Description | [Table]FieldName |
Header | ||
Report name | The title of the report | N/A |
School name | The name of the current school. | [Schools]Name |
Current Year | The current school year. | [Calendar]FirstDay [Calendar]LastDay |
Active Enrollment Count | ||
Course/Teacher | The course number, course name, and course teacher. | [Courses]Course_Number [Courses]Course_Name [Users]LastFirst |
Sec. | The course section number. | [Sections]Section_Number |
Gr. | The grade level associated with the section. | [Sections]Grade_Level |
Months Reported | Active enrollment for each month selected at runtime. | N/A |
Total | Total active enrollment by class across all reported months. | Calculated |
Number of Counts (Divisor) | The number of months factoring into the average. These are the months selected at runtime. | N/A |
Average Number of Pupils Enrolled Per Class | The average number of pupils enrolled in each class. | Calculated |
Total (sum of the average number of pupils enrolled per class) | The total average number of pupils enrolled in all classes. | Calculated |
Number of classes (divisor) | The number of classes factored into the average. | Calculated |
Average Class Enrollment | The average enrollment across all classes. | Calculated |
Avg Class Enrollment (rounded to the nearest half integer) | The average enrollment across all classes rounded to the nearest half integer. | Calculated |
Active Enrollment Count (Previous Year) | ||
Course/Teacher | The course number, course name, and course teacher. | [Courses]Course_Number [Courses]Course_Name [Users]LastFirst |
Sec. | The course section number. | [Sections]Section_Number |
Gr. | The grade level associated with the section | [Sections]Grade_Level |
Months Reported | Enrollment by month for each selected month in the previous year. These are the months selected at runtime | N/A |
Total | Total attendance by class across all reported months for the previous year. | Calculated |
Number of Counts (Divisor) | The number of months factoring into the average for the previous year.. | Calculated |
Average Number of Pupils Enrolled Per Class | The average number of pupils enrolled per class in the previous year. | Calculated |
Total(sum of the average number of pupils enrolled per class) | The sum of the average number of pupils enrolled per class in the previous year. | Calculated |
Number of classes (divisor) | The number of classes factoring into the average for the previous year. | Calculated |
Average Class Enrollment | The average enrollment across all classes for the previous year. | Calculated |
Avg Class Enrollment (rounded to the nearest half integer) | The average enrollment across all classes rounded to the nearest half integer for the previous year. | Calculated |
Required Average Class Enrollment for Purposes of Demonstrating Progress | ||
Prior Year Average Class Enrollment at School | The average class enrollment of the previous year. | Calculated |
Minus Target Class Enrollment | The target class enrollment. | Calculated |
Equals | The average class enrollment of the previous year minus the target class enrollment. | Calculated |
Gap Percentage (May Use Department of Finance Estimate) | Gap percentage between target enrollment and actual enrollment. | Calculated |
Prior Year Average Class Enrollment at School | The average class enrollment of the previous year. | Calculated |
Minus Minimum Required Reduction over Prior Year Average | The minimum required reduction divided by the prior year average enrollment. | Calculated |
Maximum Average Class Enrollment (Rounded to Nearest Half Integer) | The maximum average class enrollment rounded to the nearest half integer. | Calculated |