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 | | 916-327-0219 
Last Reviewed: Thursday, September 8, 2016
Recently Posted in Demographics
  • DataQuest Listserv (added 13-Jun-2017)
    The DataQuest listserv provides one-way communication from the California Department of Education (CDE) to interested recipients.
  • File Structure: Staff Demographics Record (added 22-May-2017)
    File structure for the staff demographics record, which includes demographic and full-time equivalent (FTE) data for K-12 public education certificated teachers, administrators, and pupil services personnel reported as employed on Information Day.