Skip to main content
California Department of Education Logo

File Structure: NCES Graduation Rate

File structure for the National Center for Education Statistics (NCES) graduation rate data.

File Name: ncesrate10.txt

Field Name Field Type Width Description
CDS_CODE Character 14

This 14-digit code is the official, unique identification of a school within California. The first two digits identify the county, the next five digits identify the school district, and the last seven digits identify the school.

COUNTY Character 15 County name.
DISTRICT Character 90 District name.
SCHOOL Character 90 School name.
D9 Numeric 5 Dropouts in grade nine for the year three years prior to the specified year of data.
D10 Numeric 5 Dropouts in grade ten for the year two years prior to the specified year of data.
D11 Numeric 5 Dropouts in grade eleven for the year prior to the specified year of data.
D12 Numeric 5 Dropouts in grade twelve for the specified year of data.
GRADS Numeric 6 High school graduates for the specified year of data.
GRADRATE Decimal (3,1) 5

NCES graduation rate. The usage of this rate is the result of negotiations with the U.S. Department of Education and is required for No Child Left Behind (NCLB) reporting. Since this rate is calculated using comparable data (both school-level dropout and graduate counts are cumulative year-end summary data), the rate will never exceed 100 percent even in schools with increasing or declining enrollments. Therefore this rate may be used at the school-level. This calculation overstates the graduation rate since the difference between ninth grade enrollment and graduates and dropouts is not accounted for.

Formula: Number of graduates from year 4 (GRADS) divided by number of graduates from year 4 (GRADS) + grade nine dropouts from year 1 (D9) + grade ten dropouts from year 2 (D10) + grade eleven dropouts from year 3 (D11) + grade twelve dropouts from year 4 (D12).

YEAR Character 4 Year of data.
Questions: Data Reporting Office | dro@cde.ca.gov | 916-327-0219 
Last Reviewed: Thursday, September 8, 2016
Recently Posted in Demographics
  • Dropouts by Race & Gender (updated 11-Apr-2017)
    Downloadable data files for grade seven through twelve dropouts and enrollment by race/ethnic designation and gender by school.
  • Graduates by Ethnicity and School (updated 11-Apr-2017)
    Downloadable data files for graduates by racial/ethnic group and school.
  • Graduates Meeting UC/CSU Entrance Requirements (updated 11-Apr-2017)
    Downloadable data files for graduates meeting University of California/California State University (UC/CSU) entrance requirements.
  • Graduates by Race & Gender (updated 11-Apr-2017)
    Downloadable data files for graduates and graduates meeting University of California (UC)/California State University (CSU) entrance requirements by race/ethnic designation and gender by school.
  • Cohort Outcome Data (updated 11-Apr-2017)
    California Longitudinal Pupil Achievement Data System (CALPADS) cohort outcome data reported by race/ethnicity, program participation, and gender.

  • Transitional Kindergarten Data (updated 16-Mar-2017)
    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).
  • Classified Staff by Race/Ethnicity & Gender (updated 10-Mar-2017)
    Downloadable data files for classified staff by race/ethnicity, gender, and school for 2008–09 through current year.