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