Skip to main content
California Department of Education Logo

File Structure: ACGR and Outcome Data

File structure for the Adjusted Cohort Graduation Rate (ACGR) and Outcome data from the California Longitudinal Pupil Achievement Data System (CALPADS) reported by race/ethnicity, program subgroup, and gender for 2016–17 through the current year.

Files include state, county, district, and school level data. Please refer to the file structure for details on what data are contained in the file. For more information about the Adjusted Cohort Graduation Rate (ACGR) and Outcome Data, and for information about the Cohort Outcome Data calculated prior to 2016–17, please visit the Information about Adjusted Cohort Graduation Rate web page.

This file contains aggregate data with disaggregated data subsets at multiple different levels and reporting categories to provide enhanced analytical flexibility. For more detailed examples about how to properly use these data, please refer to the Using the ACGR and Outcome Data File examples below.

Note: To protect student privacy, data are suppressed (*) on the data file if the cell size within a selected student population (cohort students) is 10 or less. Additionally, on the Ethnicity reports, “Not Reported” is suppressed, regardless of actual cell size, if the student population for one or more other ethnicity groups is suppressed.

Field Description
Academic Year The academic year corresponding to the expected year of on-time, four-year graduation from high school.
Aggregate Level An indicator of the aggregation level. NOTE: One of these values must be chosen to obtain an unduplicated count at the selected level.
  • T = State
  • C = County
  • D = District
  • S = School
County Code A unique two-digit code corresponding to the county.
District Code A unique five-digit code corresponding to the district.
School Code A unique seven-digit code corresponding to the school.
County Name County name.
District Name District or administrative authority name.
School Name School name.
Charter School (All/Y/N)

An indicator of whether data for all schools, only charter schools, or only non-charter schools are included. NOTE: One of these values must be chosen to obtain an unduplicated count at the selected level.

All = Includes data for all schools regardless of charter status. For Aggregate Level=S, all schools are included. For Aggregate Levels T, C, and D, data for all schools are included in the aggregate.

Y = Includes only data for charter schools. For Aggregate Level=S, only charter schools are included. For Aggregate Levels T, C, and D, only data for charter schools are included in the aggregate.

N = Includes only data for non-charter schools. For Aggregate Level=S, only non-charter schools are included. For Aggregate Levels T, C, and D, only data for non-charter schools are included in the aggregate.
DASS (All/Y/N)

An indicator of whether data for all schools, only schools participating in the Dashboard Alternative School Status Program (DASS), or only non-DASS schools are included. NOTE: One of these values must be chosen to obtain an unduplicated count at the selected level.

All = Includes data for all schools regardless of DASS status. For Aggregate Level=S, all schools are included. For Aggregate Levels T, C, and D, data for all schools are included in the aggregate.

Y  = Includes only data for schools participating in DASS. For Aggregate Level=S, only DASS schools are included. For Aggregate Levels T, C, and D, only data for DASS schools are included in the aggregate.

N  = Includes only data for non-DASS schools. For Aggregate Level=S, only data for non-DASS schools are included. For Aggregate Levels T, C, and D, only data for non-DASS schools are included in the aggregate.
Reporting Category

An indicator of the student group reporting category (race/ethnicity, gender, or program subgroup) disaggregation or subset. NOTE:Select Reporting Category = TA for aggregate totals without consideration of a Reporting Category student group.

  • RB = African American
  • RI = American Indian or Alaska Native
  • RA = Asian
  • RF = Filipino
  • RH = Hispanic or Latino
  • RD = Not Reported
  • RP = Pacific Islander
  • RT = Two or More Races
  • RW = White
  • GM = Male
  • GF = Female
  • SE = English Learners
  • SD = Students with Disabilities
  • SS = Socioeconomically Disadvantaged
  • SM = Migrant
  • SF = Foster
  • SH = Homeless
  • TA = Total
Cohort Students The number of students who enter grade 9 for the first time, plus any students who transfer in later during grade 9 or the next three years, minus any student from the cohort who transfers out, emigrates from the country, transfers to a juvenile facility or prison, or dies during that same period.
Regular HS Diploma Graduates (Count) Total number of cohort students who received the standard high school diploma from a school aligned with State education standards.
Regular HS Diploma Graduates (Rate) The percentage of cohort students who received the standard high school diploma.
Met UC/CSU Grad Req's (Count) Total number of cohort graduates who met all a-g requirements for admission into a UC or CSU school.
Met UC/CSU Grad Req's (Percent) The percentage of cohort graduates who met admission requirements for a UC or CSU school.
Seal of Biliteracy (Count) Total number of cohort graduates who attained a high level of proficiency in one or more languages in addition to English and earned the State Seal of Biliteracy.
Seal of Biliteracy (Rate) The percentage of cohort graduates who earned the State Seal of Biliteracy.
Golden State Seal Merit Diploma (Count) Total number of cohort graduates who earned the Golden State Seal Merit Diploma by earning a high school diploma and demonstrating mastery in at least six subject matter areas, including mathematics, English language arts, science, U.S. history, and other areas.
Golden State Seal Merit Diploma (Rate) The percentage of cohort graduates who earned the Golden State Seal Merit Diploma.
CHSPE Completer (Count) Total number of cohort students who withdrew from regular high school without receiving a regular high school diploma after passing the CHSPE.
CHSPE Completer (Rate) The percentage of cohort students who took and passed the CHSPE.
Adult Ed. HS Diploma (Count) Total number of cohort students who withdrew from regular high school without receiving a regular high school diploma, and later received documentation for completing an adult education program.
Adult Ed. HS Diploma (Rate) The percentage of cohort students who received documentation for completing an adult education program.
SPED Certificate (Count) Total number of cohort students with exceptional needs (having an IEP) who received a certificate or document of education achievement or completion.
SPED Certificate (Rate) The percentage of cohort student with exceptional needs who received a certificate or document of education achievement or completion.
GED Completer (Count) Total number of cohort students who withdrew from regular high school without receiving a regular high school diploma and has received a High School Equivalency Certificate by passing the GED exam, the TASC exam, and/or the HiSET.
GED Completer (Rate) The percentage of cohort students who received a High School Equivalency Certificate.
Other Transfer (Count) Total number of cohort students who withdrew from regular high school without receiving a regular high school diploma and transfer to an adult education program or to community college during the cohort period.
Other Transfer (Rate) The percentage of cohort students who transfer to an adult education program or to community college during the cohort period.
Dropout (Count) Total number of cohort students who do not graduate with a regular high school diploma, do not complete high school, and are not still enrolled as a "fifth year senior".
Dropout (Rate) The percentage of cohort students who do not graduate with a regular high school diploma, do not complete high school, and are not still enrolled as a "fifth year senior".
Still Enrolled (Count) Total number of cohort students who did not graduate high school by the end of their cohort outcome period who: are re-enrolled as a "fifth year senior" at the end of their cohort period, or who completed high school no later than mid-September of the subsequent academic year.
Still Enrolled (Rate) The percentage of cohort students who did not graduate high school at the end of their cohort outcome period who either re-enrolled or completed high school no later than mid-September of the next academic year.

Using the ACGR and Outcome Data File

This file contains different subsets of data based on the values of different variables. If these sub-setting variables are not used properly, it is easy to end up with incorrect or duplicative data. Please refer to the following examples below as a guide for properly using these data:

  1. Get school-level data totals with one record per school with school totals (without student group totals)
    1. Aggregate Level = S (School)
    2. Charter School (Y/N) = All
    3. DASS (Y/N) = All
    4. Reporting Category = TA

  2. Get school-level data totals by student group (Reporting Category) for all non-charter schools
    1. Aggregate Level = S (School)
    2. Charter School (Y/N) = N
    3. DASS (Y/N) = All
    4. Reporting Category Not equal to TA

  3. Get school-level data totals by student group (Reporting Category) for all DASS schools
    1. Aggregate Level = S (School)
    2. Charter School (Y/N) = All
    3.  DASS (Y/N) = Y
    4. Reporting Category Not equal to TA

  4. Get district-level data totals by student group (Reporting Category) for non-charter schools
    1. Aggregate Level = D (District)
    2. Charter School (Y/N) = N
    3.  DASS (Y/N) = All
    4. Reporting Category Not equal to TA

  5. Get statewide-level data totals for charter schools that are DASS schools
    1. Aggregate Level = T (State)
    2. Charter School (Y/N) = Y
    3.  DASS (Y/N) = Y
    4. Reporting Category = TA
Questions: Data Reporting Office | dro@cde.ca.gov | 916-327-0219 
Last Reviewed: Wednesday, September 19, 2018
Recently Posted in Demographics
  • College-Going Rate for HS Completers (12-month) (added 11-Jul-2019)
    College-Going Rate (CGR) for California high school completers 12 months after high school completion reported by race/ethnicity, student group, and academic year.
  • College-Going Rate for HS Completers (16-month) (added 11-Jul-2019)
    College-Going Rate (CGR) for California high school completers 16 months after high school completion reported by race/ethnicity, student group, and academic year.
  • File Structure: CGR Data (12-Month) (added 11-Jul-2019)
    File structure for the College-Going Rate (CGR) 12 months after high school completion reported by race/ethnicity, student group, and academic year.
  • File Structure: CGR Data (16-Month) (added 11-Jul-2019)
    File structure for the College-Going Rate (CGR) 16 months after high school completion reported by race/ethnicity, student group, and academic year.
  • Using the CGR Data File (added 11-Jul-2019)
    This page explains how to effectively use the sub-setting variables included in this CGR data file to obtain the desired counts.

  • Transitional Kindergarten Data (updated 17-May-2019)
    Downloadable data files for school-level transitional kindergarten program participation data racial/ethnic designation and subgroup (i.e., gender, English learner, migrant, and socio-economically disadvantaged status).