Using the CGR Data File

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