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: Friday, February 16, 2024
Trending in Accessing Educational Data
Recently Posted in Accessing Educational Data