Student Counts (Census Day) Report by Grade and Race/Ethnicity
Student Counts (Census Day) Report by Grade and Subgroup
Print Student Counts By Reporting Language and Grade (Census Day)
Print Student Counts By Graduates and Dropouts (Census Day)
Print Student Counts By NSLP/EL (Census Day)
Overview
Navigate to Reports > Student Counts (Census Day) Report.
The Student Counts (Census Day) Report can be used to validate student data in Aeries that is submitted to CALPADS. Since an effective date is used with this report, it can also be used to verify student counts, grade level counts and program counts on any school day. The report can be printed from a school or the district level.
Report Options ↑
From the school, there are four report options available when printing the Student Counts (Census Day) Report. In District, an additional option is available for NSLP/EL.
- Grade and Ethnicity/Race
- Grade and subgroup
- Reporting Language and Grade
- Graduates and Dropouts
- NSLP/EL (District-Level Only)
Student Counts (Census Day) Report by Grade and Race/Ethnicity ↑
To run the Student Counts (Census Day) Report by Grade and Ethnicity/Race, select from the following options:
- Select the Grade and Ethnicity/Race radio button.
- Enter the Enrollment Date for the report.
- If the effective date entered in the Enrollment Date field is a Census Day (CALPADS Information Day), the Update STU.CIC (Counted in Census Day) option will become available. If selected, the STU.CIC field will be populated with a "Y" for every student who was enrolled on Census Day.
- If the STU.CIC is populated, additional information on students, enrolled on Census Day, can be obtained using the following KEEP Query: KEEP STU IF CIC = Y
- The Group by Grade option will group totals by grade level for each school selected. If the option is not selected, the report will provide school totals.
- The Honor Reporting Home School option will populate student grade and race/ethnicity counts in the Reporting Home School for students with the Reporting Home School (STU.HS) field populated.
- The Sort Schools by Name option, if selected, will list the schools alphabetically instead of numerically.
- Select the Schools to be included in the report. The Select All, Clear All and Show Selected options are available to assist with the selection process.
When all options have been selected, click the Run Report button.
The report will display the Race/Ethnicity Totals by Grade Levels for each School, a School Total for each Race/Ethnicity and an overall District Total for each Race/Ethnicity on the last page.
| Race/Ethnicity | Qualifying Value |
| Total Enrolled | Total count of students active on the reporting date. |
| Hispanic | Total count of students if the Ethnicity (STU.ETH) field is populated as "Yes, Hispanic or Latino". If students STU.ETH = Y, students will only be counted in the Hispanic column, even if the students have values in the Race (STU.RC1 - STU.RC5) fields. |
| American Indian/Alaskan Native | Total count of students if Race field (STU.RC1) = 100. |
| Asian | Total count of students if Race field (STU.RC1) = 201 through 299 |
| Filipino | Total count of students if Race field (STU.RC1) = 400 |
| Black/African American | Total count of students if Race field (STU.RC1) = 600. |
| Hawaiian/Pacific Islander | Total count of students if Race field (STU.RC1) = 301 through 399. |
| White | Total count of students if Race field (STU.RC1) = 700. |
| Multiple | Total count of students if values exist in Multiple Race fields (STU.RC1 - STU.RC5). |
| Missing | Total count of students not listed/missing race and ethnicity. |
Displayed below is an example of the Student Counts (Census Day) Report by Grade and Race/Ethnicity.
Student Counts (Census Day) Report by Grade and Subgroup ↑
To run the Student Counts (Census Day) Report by Grade and Subgroup, select from the following options:
- Select the Grade and Subgroup radio button.
- Enter the Enrollment Date for the report.
- If the effective date entered in the Enrollment Date field is a Census Day (CALPADS Information Day), the Update STU.CIC (Counted in Census Day) option will become available. If selected, the STU.CIC field will be populated with a "Y" for every student who was enrolled on Census Day.
- If the STU.CIC is populated, additional information on students, enrolled on Census Day, can be obtained using the following KEEP Query: KEEP STU IF CIC = Y
- The Group by Grade option will group totals by grade level for each school selected. If the option is not selected, the report will provide school totals and will include a column for Transitional Kindergarten (PGM.CD = 185).
- The Honor Reporting Home School option will populate student grade and race/ethnicity counts in the Reporting Home School for students with the Reporting Home School (STU.HS) field populated.
- The Count English Learners as of Report Date option when selected will count the English Learners whose EL Start Date (LAC.SD) is before or on the Enrollment Date entered on the report options.
- The Sort Schools by Name option, if selected, will list the schools alphabetically instead of numerically.
- Select the Schools to be included in the report. The Select All, Clear All and Show Selected options are available to assist with the selection process.
When all options have been selected, click the Run Report button.
The report will display the Subgroup Totals by Grade Levels for each School, a School Total for each Subgroup and an overall District Total for each Subgroup on the last page.
| Subgroup | Qualifying Value |
| Total Enrolled | Total count of students active on the reporting date. |
| English Learners | Total count of students with a Language Fluency (STU.LF) = English Learners (EL) and Redesignated(RFEP) Students if a Language Redesignation Date (LAC.RD1) is after the Enrollment Date entered on the report. |
| Title III Eligible Immigrants | Total count of students with the following conditions:
|
| Gift and Talented Education (GATE) | Total count of students with either of the following conditions:
|
| Title I Part C Migrant | Total count of students with Program Code (PGM.CD) = 135 and date in Program Eligibility Start Date (PGM.ESD) or Program Participation Start Date (PGM.PSD) fields effective the Enrollment Date entered on the report. |
| Special Education | Total count of students with a Special Education Entry Date (CSE.ED) and Special Education Exit Date (CSE.XD) = NULL effective the Enrollment Date entered on the report. |
| LEP (EL + Selected RFEP) | Total count of students with the following conditions:
|
| Socio-Economically Disadvantaged | Total count of students with any of the following conditions:
|
Displayed below is an example of the Student Counts (Census Day) Report by Grade and Subgroup.
Print Student Counts By Reporting Language and Grade (Census Day) ↑
On the report option page select the Reporting Language and Grade option. Enter the Enrollment Date for the report and select the schools to be included in the report. If the Enrollment date entered is the date of Census Day, an additional option to Update STU.CIC (Counted in Census Day) will display. If selected, this will update the STU.CIC field for the applicable students listed on the report.
Selecting the Honor Reporting Home School option will look at the reporting home school designated for the student if that information is available. Select codes to include for EL and FEP, RFEP and IFEP.
Displayed below is an example of the Student Counts (Census Day) Report by Reporting Language and Grade.
Print Student Counts By Graduates and Dropouts (Census Day) ↑
On the report option page select the Graduates and Dropouts option. Enter the Enrollment Date for the report and select the schools to be included in the report. If the Enrollment date entered is the date of Census Day, an additional option to Update STU.CIC (Counted in Census Day) will display. If selected, this will update the STU.CIC field for the applicable students listed on the report. Selecting the Group by Grade option will display the totals by grade level. Selecting the Honor Reporting Home School option will look at the reporting home school designated for the student if that information is available.
Displayed below is an example of the Student Counts (Census Day) Report by Graduates and Dropouts.
Print Student Counts By NSLP/EL (Census Day) ↑
This report is only available at the District Level. To run the Student Counts (Census Day) Report by NSLP/EL, select from the following options:
- Select the NSLP/EL radio button.
- Enter the Enrollment Date for the report.
- If the effective date entered in the Enrollment Date field is a Census Day (CALPADS Information Day), the Update STU.CIC (Counted in Census Day) option will become available. If selected, the STU.CIC field will be populated with a "Y" for every student who was enrolled on Census Day.
- If the STU.CIC is populated, additional information on students, enrolled on Census Day, can be obtained using the following KEEP Query: KEEP STU IF CIC = Y
- The Group by Grade option will group totals by grade level for each school selected. The Group by Grade Range option will group totals by grade ranges for each school selected. If the option is not selected, the report will provide school totals.
- The Honor Reporting Home School option will populate student grade and race/ethnicity counts in the Reporting Home School for students with the Reporting Home School (STU.HS) field populated.
- The Sort Schools by Name option, if selected, will list the schools alphabetically instead of numerically.
- Select the Schools to be included in the report. The Select All, Clear All and Show Selected options are available to assist with the selection process.
When all options have been selected, click the Run Report button.
Displayed below is an example of the Student Counts (Census Day) NSLP/EL.
