Skip to main content
Skip table of contents

Class Size Average and Progress Calculation

Contents

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.

  • If Yes is selected, report will produce a by-month, by-section table for the previous school year.
  • If No is selected, the report will only produce the overall average will be displayed for the previous year.

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.

  •  If Yes is selected, any section containing at least one enrolled student with a 185 program overlapping the dates of section enrollment will be reported as grade level "TK."
  • If No is selected, all grade levels will be reported as defined in the section records.

Back to top

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/TeacherThe 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 ReportedEnrollment by month for each selected month in the previous year. These are the months selected at runtime
N/A
TotalTotal 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 ClassThe 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 EnrollmentThe 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

Back to top

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.