Tool Search: NC LCS Collection
As part of the Legislative Class Size Collection, the K-3 and 4-8 Class Size reports ELA class data for Grade Level Grouping of Kindergarten Through Third Grade (K-3) or Fourth through Eighth Grade (4-8) students, excluding Exceptional Children (EC) classes. The ELA Lead Teacher also reports.
This report is available in both District Edition and State Edition.
See the NC Legislative Class Size article for information on required data setup, report logic, tool rights, and more.
Report Logic
See the following for details on the Class Size Report. This report uses Combined Class Logic.
State Course Codes
One record reports per unique State Course Code in the selected School/District. The Course Section must have a State Course Code of one of the following:
- 10502Z0 (Kindergarten courses)
- 10512Z0 (First grade courses)
- 10522Z0 (Second grade courses)
- 10532Z0 (Third grade courses)
- 10542Z0 (Fourth grade courses)
- 10552Z0 (Fifth grade courses)
- 10562Y0 (Sixth grade courses)
- 10572Y0 (Seventh grade courses)
- 10582Y0 (Eighth grade courses)
Combined and pullout classes concatenate to the State Course Code value derived. Section records when the Course of the section contains a valid State Course Code. Sections where the State Course Code is blank or the code value is not in the valid set, do not report.
Teachers
Lead Teachers must have a Staff State ID to report.
All Teachers entered as a PRIMARY on the Section Staff History are Lead Teachers. They must be active on the Snapshot Date (based on the teacher's Start Date/End Dates on the Section Staff History.
Teachers entered as SECONDARY on Section Staff History MUST have a ROLE of Secondary Lead Teacher and must be active on the Snapshot Date to count as a Lead Teachers.
Teachers who exit before the date selected but within the submission window are not counted.
Teachers who start after the date selected but within the submission window are not counted.
The active Lead Teacher on the Snapshot Date reports. In the case of multiple active, the last entered Primary Teacher reports.
Student Count
Students do NOT count when:
- They do not have a State Student ID.
- Their Enrollment record is marked as No Show or State Exclude as of the Snapshot Date.
- They are enrolled in a Calendar marked as Exclude as of the Snapshot Date.
- They are enrolled in a Grade Level marked as Exclude as of the Snapshot Date.
Students who exit prior to the date selected but within the submission window are not counted.
Students who start after the date selected but within the submission window are not counted.
Report Editor
Data Element | Description |
---|---|
Setup | |
Search Calendars | Search field to narrow the list of calendars to select. Use the Expand All/Collapse All. Place a checkbox next to the desired school and calendars. |
Show Active Year Only |
When set to ON, only those calendars for the current school year are available for selection. When set to OFF, all calendars from all school years are available for selection. |
Report Options | |
Report Type | Indicates which LCS report generates. For this instance, select Class Size. |
Grade Level Grouping | Indicates which grade levels are included. For the Class Size report:
|
Only return classes with 0 students | When marked, only those course sections with no students scheduled into them are included in the report.
This option does not display for State Edition. |
Exclude Cross-Site Data | When marked, Cross-Site Enrollment courses are not included in the report.
This option does not display for State Edition. |
Snapshot Date | Indicates the date the report was generated.
|
Output Options | |
Report Processing | To generate the report immediately, select the Generate Now option. To choose when the report generates, use the Submit to Batch option. Submit to Batch is useful when generating the report for several calendars or for reporting more significant amounts of data being reported. See the Batch Queue article for more information.
Due to the amount of data collected in this report, use the Batch Queue option. |
Format Type | Determines in which format the report generates - CSV or HTML. |
Unofficial File Generation
To generate an unofficial K-3 or 4-8 Class Size Report:
- Select the Report Type of Class Size.
- Select the Grade Level Grouping of K-3 to generate the K-3 Class Size report.
- Select the Grade Level Grouping of 4-8 to generate the 4-8 Class Size report.
- Do NOT select an option for the Violation Type.
- Do NOT mark the Only return classes with 0 students checkbox to return class records where at least one student is rostered on the Snapshot Date.
- Mark the Only return classes with 0 students checkbox to return class records where NO students are rostered on the Snapshot Date.
- Select the desired Snapshot Date.
- Select Generate.
Report Layout
Data Element | Description | Location |
---|---|---|
End Year | Reports the end year of the school year selected for report generation.
For the school year 2024-2025, a value of 2025 reports. Numeric, 4 digits |
School Year Setup > School Year Detail > End Year
Calendar.endYear |
PSU Number | Reports the State District Number.
Numeric, 3 digits |
District Information > District Detail > State District Number
District.number |
LEA Name | Reports the Name of the district.
Alphanumeric, 15 characters |
District Information > District Detail > Name
District.name |
School Number | Reports the State School Number.
Numeric, 6 digits |
School Information > School Detail State School Number
School.number |
School Name | Reports the Name of the school.
Alphanumeric, 15 characters |
School Information > School Detail > Name
School.name |
Class Grade Level | Reports the State Grade Level Code reflecting the majority of students scheduled into the class on the Snapshot Date selected on the extract editor. When an equal number of multiple grade level students are scheduled, the lowest state grade level code reports. When Only return classes with 0 students is marked, this field reports blank. |
Grade Level Setup
gradeLevel.stateCode Course Information > State Code Course.statecode |
Department Name | Reports the Department of the course for the reporting section of record. | Course Information > Department Course.department |
Teacher Duties | Returns a concatenated value of the Department Name plus the Class Grade Level. | N/A |
Course State ID |
Reports the assigned State Course Code. This field displays when Generate is selected.
Alphanumeric, 7 characters |
Course Information > State Code
Course.stateCode |
Course Name | Reports the name of the course based on the assigned State Course. This returns the name of the course from the Course Code Mapping tool. | Course Code Setup |
Section Number | Report the Number of the section for the reporting section of record. | Section Information > Number Section.number |
Staff UID | Reports the Staff State ID of the Lead Teacher for the reporting section of record that is active on the Snapshot Date selected on the Extract Editor. All teachers entered as Primary are lead Teachers and only those Teachers entered as Secondary that are marked with a Role of Secondary Lead Teacher are Lead Teachers.
| Demographics > Person Identifiers person.staffStateID |
Lead Teacher | Report the concatenated Last Name (+) space (+) Middle Initial (+) First Name of the teacher reported in field 12: StaffUID. | Demographics > Last Name, Middle Name, First Name Person.lastName Person.middleName Person.firstName |
Teacher Count | Reports the number of Lead Teachers present on the section of record on the Snapshot Date selected on the extract editor.
See the Data Setup information for information on Lead Teachers. |
Calculated value |
Student Count |
Reports the number of (reportable) studentsscheduled in the section of record on the Snapshot Date selected on the extract Editor.
NOTE: Reportable students have a Student State ID and are not marked as No Show or State Exclude. |
Calculated Value. |