Report 1.6: Graduates and Dropouts by Subgroup (Retired as of 6/30/2020)¶
Description: The graduate and dropout counts are based on students who exited during the prior academic year. Re-enrollment in another LEA is not evaluated for purposes of adjusting dropout counts. To view Dropout data adjusted for re-enrollments in another LEA, please refer to Snapshot reports 1.14 Dropouts Count - State View and 8.1c - Student Profile Dropouts - State View – List
Report Type: Snapshot/Certification (Fall 1)
Data As Of: Fall 1 Census Day (First Wednesday in October)
Reporting Cycle
Graduate/Dropout Reporting Cycle – August 16 of the prior academic year to August 15 of the current academic year
Basic Select Criteria
- Graduates and dropouts must have Enrollment Exit Date within the Graduate/Dropout Reporting Cycle
- Snapshot – Must have a SINF record that wholly or in part overlaps a qualified enrollment
- Student must have a Student Grade Level equal to 07 - 12, or US
- Selection criteria for Program data
- effective on any date during the graduate/dropout reporting cycle, regardless of whether the record is owned by the school being reported
Specific Selection Criteria
- Graduates: Enrollment Status of 10 (Primary) or 40 (Specialized Services Only)
- Exit code equals E230
- Completer Code equals 100, 250, 330
NOTE: Enrollment Status Code “40” should ONLY be used for students who had participated in a CAHSEE Intensive Instruction prior to 2015-2016.
- Dropouts:
- Enrollment Status of 10 (Primary)
- Exit Code equals E140, E300, E400, T270 or T380
- Other Dropout: Exit Code E230 Completer Code equals 104, 360
See Appendix C of the CALPADS DataGuide for detail definitions of all Exit Reasons
Lost Transfers – not included on report
- Unresolved ERD Type C anomalies (Lost Transfers) will be added to the dropout count in the statewide report (a.k.a Dataquest)
Re-Enrolled Dropouts – not considered on report
- Reported dropouts with a subsequent enrollment detected will be deducted from the Statewide report (a.k.a. Dataquest).
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 (Snapshot)
- Status – (Snapshot)
- School
- Gender
- School Type
- Grade
- Ethnicity/Race
Report Logic¶
Column | Rules |
---|---|
1 | School code is derived from user ID permission and Expected Schools table |
2 | School Name is determined by #1 and the Expected Schools Table. School Name column leads to Report: 1.7 Graduates by Subgroup – Student List |
3 | SENR Field 1.27 – Student Exit Reason or SENR Field 1.28 – Completion Status (Exit codes stated above). SINF 2.18 – Student Birth Date equals age 3 to 21 on census day of reporting year and SINF 2.22 – Student Birth Country does not equal US or PR and SINF 2.46 – Enroll in US School less than 3 year indicator equals ‘Y” |
4 | SPRG 3.13 – Education Program Code equals 127 (Gifted and Talented) and SPRG 3.14 – Education Program Membership equals 1 or 3 and SPRG 3.15 – Program Membership Start Date and SPRG 3.16 – Program Membership End date are effective on any date during the Graduate Reporting Cycle regardless of whether the record is owned by the school being reported. |
5 | SPRG 3.13 – Education Program Code equals 135 (Migrant) and SPRG 3.14 – Education Program Membership equals 1 or 3 and SPRG 3.15 – Program Membership Start Date and SPRG 3.16 – Program Membership End date are effective on any date during the Graduate Reporting Cycle regardless of whether the record is owned by the school being reported. |
6 | Count of Graduates for Students with Disabilities. See CALPADS Glossary: Students with Disabilities |
7 | SELA Field 12.15 – Primary Language not equal to 00 (English) or 37 (American Sign Language) and SELA Field 12.13 – English Language Acquisition Status Code equal to EL (English Learner) status effective during the report period (using effective date) regardless of Reporting LEA |
8 | SINF Field 2.50 – Parent Guardian Highest Grade Level Code equal to 14 - OR |
SPRG Field 3.13 - Ed Program Code = 135 (Migrant) or 191 (Homeless) and SPRG 3.15 – Ed Program Membership Start Date equal to or greater than Fall 1 Census Day and SPRG 3.16 – Ed Program Membership End date blank or equal to or greater than Fall 1 Census Day – OR | |
SPRG 3.13 – Education Program Code equals 135 (Migrant) – OR | |
SPRG 3.13 – Education Program Code equals 191 (Homeless) – AND | |
SPRG 3.15 – Education Program Membership Start Date and SPRG 3.16 – Education Program Membership End date – is within the Graduate/Dropout Reporting Cycle - OR | |
Foster Indicator equals Y AND Episode Start date and Episode End date are within the Graduate/Dropout Reporting Cycle - OR | |
Direct Certification Indicator equals Y AND Direct Certification Date is within the Graduate/Dropout Reporting Cycle - OR | |
Student enrolled at a Juvenile Court School within the Graduate/Reporting Cycle or Dropout Reporting Cycle | |
9 | SENR Field 1.27 – Student Exit Reason or SENR Field 1.28 – Completion Status (Exit codes stated above). SINF 2.18 – Student Birth Date equals age 3 to 21 on census day of reporting year and SINF 2.22 – Student Birth Country does not equal US or PR and SINF 2.46 – Enroll in US School less than 3 year indicator equals ‘Y” |
10 | SPRG 3.13 – Education Program Code equals 127 (Gifted and Talented) and SPRG 3.14 – Education Program Membership equals 1 or 3 and SPRG 3.15 – Program Membership Start Date and SPRG 3.16 – Program Membership End date are effective on any date during the Graduate Reporting Cycle regardless of whether the record is owned by the school being reported. |
11 | SPRG 3.13 – Education Program Code equals 135 (Migrant) and SPRG 3.14 – Education Program Membership equals 1 or 3 and SPRG 3.15 – Program Membership Start Date and SPRG 3.16 – Program Membership End date are effective on any date during the Graduate Reporting Cycle regardless of whether the record is owned by the school being reported. |
12 | Count of Graduates for Students with Disabilities. See CALPADS Glossary: Students with Disabilities |
Note: Students with Disabilities will have two different business rules as the reporting cycle for dropouts spans two academic years. | |
13 | SELA Field 12.15 – Primary Language not equal to 00 (English) or 37 (American Sign Language) and SELA Field 12.13 – English Language Acquisition Status Code equal to EL (English Learner) status effective during the report period (using effective date) regardless of Reporting LEA |
14 | SINF Field 2.50 – Parent Guardian Highest Grade Level Code equal to 14 - OR |
SPRG Field 3.13 - Ed Program Code = 135 (Migrant) or 191 (Homeless) and SPRG 3.15 – Ed Program Membership Start Date equal to or greater than Fall 1 Census Day and SPRG 3.16 – Ed Program Membership End date blank or equal to or greater than Fall 1 Census Day – OR | |
SPRG 3.13 – Education Program Code equals 135 (Migrant) – OR | |
SPRG 3.13 – Education Program Code equals 191 (Homeless) – AND | |
SPRG 3.15 – Education Program Membership Start Date and SPRG 3.16 – Education Program Membership End date – is within the Graduate/Dropout Reporting Cycle - OR | |
Foster Indicator equals Y AND Episode Start date and Episode End date are within the Graduate/Dropout Reporting Cycle - OR | |
Direct Certification Indicator equals Y AND Direct Certification Date is within the Graduate/Dropout Reporting Cycle - OR | |
Student enrolled at a Juvenile Court School within the Graduate/Reporting Cycle or Dropout Reporting Cycle |
Glossary References:¶
Gifted and Talented Education Program (GATE) Subgroup,
Socio-economically Disadvantaged Subgroup,
Title 1 Part C Migrant Subgroup,
Title III Eligible Immigrant Subgroup,
User Roles for Access:¶
Fall 1 Reports role