CA Report 1.6: Graduates and Dropouts by Subgroup (Retired as of 6/30/2020)

Description: Reports the number of students submitted by each LEA as Graduates by subgroup as well as the number of students submitted as Dropouts. Totals are reported for each LEA and overall for the county selected.

Report Type: Snapshot (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 Report Display Criteria: - LEA Selection

  • Only LEAs who have certified their data are displayed on the C/A reports

  • Reports display data only for expected school types flagged as “Y- Yes” or “P- Permitted”

  • Schools that are expected with a type “Y” will report zeros if the data is certified with no counts

  • Schools that are expected with a “P” and have not submitted data for the report data type, the school will not display on the report if zeros are certified.

  • Permitted type schools will only display if they submit and certify data within the report type.

Basic Select Criteria

  • Graduates and dropouts must have Enrollment Exit Date within the Graduate/Dropout Reporting Cycle
  • 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)
  • NOTE: Enrollment Status Code “40” should ONLY be used for students who had participated in a CAHSEE Intensive Instruction prior to 2015-2016.
  • Exit code equals E230

  • Completer Code equals 100, 250, 330

  • 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**
![CA 1.6 - Graduates and Dropouts by Subgroup](img/ReportCA1.6.png) |Column | Rules | |--------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| | **1** | LEA code is derived from user ID permission and Expected Schools table | | **2** | LEA Name is determined by #1 and the Expected Schools Table. | | **3** | School Code is derived from user ID permission and Expected Schools table | | **4** | School Name is derived from by #3 and the Expected Schools Table. | | **5 & 11** | 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” | | **6 & 12** | 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. | | **7 & 13** | 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. | | **8 & 14** | SPRG 3.13 – Education Program Code equals 144 (Student with Disabilities) and SPRG 3.14 – Education Program Membership equal to 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. | | **9 & 15** | 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 | | **10 & 16** | SINF Field 2.50 – Parent Guardian Highest Grade Level Code equal to 14 - **OR** | | | | | SPRG 3.13 – Education Program Code equals 181 (NSLP Free) or 182 (NSLP Reduced) – **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:** [Accountability Subgroup Data](/Glossary/AccountabilitySubgroupData/AccountabilitySubgroupData/), [English Learner Subgroup](/Glossary/AccountabilitySubgroupData/EnglishLearnerSubgroup/), [Gifted and Talented Education Program (GATE) Subgroup](/Glossary/AccountabilitySubgroupData/GiftedandTalentedEducation(GATE)Subgroup/), [Socio-economically Disadvantaged Subgroup](/Glossary/AccountabilitySubgroupData/Socio-EconomicallyDisadvantagedSubgroup/), [Special Education Subgroup](/Glossary/AccountabilitySubgroupData/SpecialEducationSubgroup/), [Title 1 Part C Migrant Subgroup](/Glossary/AccountabilitySubgroupData/Title1PartCMigrantSubgroup/), [Title III Eligible Immigrant Subgroup](/Glossary/AccountabilitySubgroupData/Title3EligibleImmigrantsSubgroup/) [Dropouts–LEA View Data](/Glossary/AccountabilitySubgroupData/Dropouts–LEAViewData/) [Graduates](/Glossary/SuccessfulHighSchoolCompleterData/Graduates) [English Learner](/Glossary/EnglishLanguageAcquisitionData/EnglishLearner/) ### **User Roles for Access**: - **County Role**