Report 1.12: Dropouts – Count Disaggregated
(Updated as of 11/1/2023)
Description: Reports the number of students the LEA submitted as dropouts (Other Dropouts and No Show Same School Dropouts) by Ethnicity/Race within Grade and Gender.
Report Type: Certification (Fall 1)
Security Roles: Fall 1 Reports Role
Data As Of:
- Fall 1 Census Day (First Wednesday in October)
Basic selection criteria:
-
SENR – - Enrollment Exit Date within the Graduate/Dropout Reporting Cycle: August 16th of the prior academic year to August 15th of the current academic year - Exit Codes = E140, E300, E400 or T380 OR Completer Code = 360 - Grade Level = 7 – 12
- Enrollment Status = Primary (10) -
SINF – record that wholly or in part overlaps a qualified enrollment.
-
SPRG – based on dropout date range regardless of whether the record is owned by the school being reported
Report Filters: Filters can be selected resulting in only totals for the selected filter being displayed – legend on bottom of last page of report states which filter/s were selected
- Academic Year
- LEA
- Status
- School Type
- School
- Grade
- Gender
- Ethnicity/Race
- English Language Acquisition Status
- Title III Eligible Immigrant
- Title I Part C Migrant
- Socio-economically Disadvantaged - NOTE: Free Meal program and Reduced Price Meal program criteria for SED includes Program Membership Start Dates from 7/1 – 10/31 of current academic year
- Students with Disabilities
- Gifted and Talented Education
- Dropout Type
- Exit Reason
- Group By
Report Logic
| Column | Rules |
|---|---|
| 1 | School code is derived from user ID permission and Expected Schools table. This field can be expanded to show by Enrollment Status and Grade categories. |
| 2 | School Name is determined by #1 and the Expected Schools Table. School Name column leads to Report: 8.1 Student Profile List |
| 3 | Grade Level Code – this field can be expanded to show by Grade within Ethnicity and Race categories |
| 4 | Student Gender Code – this field can be expanded to show by Gender within Ethnicity and Race categories |
| 5 | Total Number calculation – Count of Dropouts (No Show Same School and Others) |
| 6, 8, 10, 12, 14 ,16, 18 | Number (#) – Count of Dropouts in each race category |
| 7, 9, 11, 13 ,15, 17 | Percentage (%) – Percentage of Dropouts in each race category |
| 19 | Number (#): Sum of Completers with more than one race category |
| 20 | Number (#) – Count of Dropouts with multiple race categories |
| 21 | Percentage (%) – Percentage of Dropouts with multiple race categories |
| 22 | Number (#) – Count of Dropouts with race code missing indicator selected |
| 23 | Percentage (%) – Percentage of Dropouts with race code missing indicator selected |
Additional Resources:
CALPADS File SpecificationsForm
Look for Student Enrollment (SENR), Student Information (SINF), Student English Language Acquisition (SELA), Student Program (SPRG) tabs for the fields indicated in the report logic.