Skip to main content
California Department of Education Logo

Using the CGR Data File

This page explains how to effectively use the sub-setting variables included in this CGR data file to obtain the desired counts.

How to use the College-Going Rate (CGR) Data File

The College-Going Rate (CGR) data 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:

  • Get school-level data totals with one record per school with school totals (without student group totals)
    • Aggregate Level = S (School)
    • Charter School (Y/N) = All
    • Alternative School Accountability Status (ASAS) (Y/N) = All
    • Reporting Category = TA
  • Get school-level data totals by student group (Reporting Category) for all non-charter schools
    • Aggregate Level = S (School)
    • Charter School (Y/N) = N
    • ASAS (Y/N) = All
    • Reporting Category Not equal to TA
  • Get school-level data totals by student group (Reporting Category) for all ASAS schools
    • Aggregate Level = S (School)
    • Charter School (Y/N) = All
    • ASAS (Y/N) = Y
    • Reporting Category Not equal to TA
  • Get district-level data totals by student group (Reporting Category) for non-charter schools
    • Aggregate Level = D (District)
    • Charter School (Y/N) = N
    • ASAS (Y/N) = All
    • Reporting Category Not equal to TA
  • Get statewide-level data totals for charter schools that are ASAS schools
    • Aggregate Level = T (State)
    • Charter School (Y/N) = Y
    • ASAS (Y/N) = Y
    • Reporting Category = TA
Questions: Data Reporting Office | dro@cde.ca.gov | 916-327-0219 
Last Reviewed: Thursday, July 11, 2019
Recently Posted in Demographics
  • File Structure: Classified Staff 2018 (added 02-Aug-2019)
    File structure for classified staff data by race/ethnicity, gender, and school for 2018–19.
  • File Structure: CBEDS Data About Schools/Districts (added 02-Aug-2019)
    File structure for California Basic Educational Data System (CBEDS) data about schools and districts for 2018–19.
  • 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.