NCES Blog

National Center for Education Statistics

Accessing the Common Core of Data (CCD)

Every year, NCES releases nonfiscal data files from the Common Core of Data (CCD), the Department of Education’s (ED’s) primary longitudinal database on public elementary and secondary education in the United States. CCD data releases include directory data (location, status, and grades offered), student membership data (by grade, gender, and race/ethnicity), data on full-time equivalent staff and teachers, and data on the number of students eligible for the National School Lunch Program (NSLP)

This blog post, one in a series of posts about CCD data, focuses on how to access and use the data. For information on using NSLP data, read the blog post Understanding School Lunch Eligibility in the Common Core of Data

CCD Data Use

CCD data are used both internally by ED and externally by the public. For example, within ED, CCD data serve as the sample frame for the National Assessment of Educational Progress (NAEP) and are the mainstay of many tables in the Digest of Education Statistics and The Condition of Education. Outside of ED, CCD data are used by researchers, the general public (e.g., realtor sites, The Common Application, Great Schools), and teachers who need their school’s NCES school ID to apply for grants.

Data Structure and Availability

CCD data are available at the state, district, and school levels, using a nested structure: all schools are within a parent district and all districts are within a state. CCD does not include any student- or staff-level data.

Most CCD data elements are available for school year (SY) 1986‒87 to the present.    

Unique Identifiers Within CCD

NCES uses a three-part ID system for public schools and districts: state-based Federal Information Processing Standards (FIPS) codes, district codes, and school codes. Using these three parts, several IDs can be generated:

  • District IDs: 7-digit (FIPS + 5-digit District)
  • School IDs:
    • 12-digit (FIPS + District + School)
    • 7-digit (FIPS + School) (unique from SY 2016‒17 on)

NCES IDs are assigned to districts and schools indefinitely, making them useful for analyzing data over time. For example, for a longitudinal school-level analysis, a school’s 7-digit ID should be used, as it remains the same even if the school changes districts. These IDs can also be used to link CCD district and school data to other ED databases.

Accessing CCD Data

There are three ways to access CCD data: the CCD District and School Locators, the Elementary/Secondary Information System (ElSi), and the raw data files. Each approach has different benefits and limitations.

  • CCD District and School locators
    • Quick and easy to use
    • Many ways to search for districts and schools (e.g., district/school name, street address, county, state)
    • Provides the latest year of CCD data available for the selected district(s) or school(s)
    • Tips for optimal use:
      • If you are having difficulty finding a district or school, only enter a key word for the name (e.g., for PS 100 Glen Morris in New York City, only enter “Glen Morris” or “PS 100”)
      • Export search results to Excel (including all CCD locator fields)

  • Elementary/Secondary Information System (ElSi)
    • quickFacts and expressTables: view most-requested CCD data elements at multiple levels
    • tableGenerator: combine data across topic areas and years to create a single file
    • Create “tables” that act like databases and include all of the roughly 100,000 public schools or 20,000 districts
    • Export data to Excel or CSV
    • Tips for optimal use:
      • Save and edit queries using the navigation buttons at the top of the screen
      • popularTables provide links to frequently requested data

 

Interested in learning more about CCD or accessing CCD data at the state, district, or school level? Check out the CCD website and use the District and School locators, ElSi, or the raw data files to find the data you are looking for.

 

By Patrick Keaton, NCES

Listening to Schools: The National Teacher and Principal Survey (NTPS) Shares Educators’ Perspectives on Coronavirus Impacts on Education

As the 2020–21 school year gets underway, many are considering the tremendous impact the coronavirus will have on classrooms—whether in person or virtual—across the United States. What can be done to support policymakers and education sector leaders as they strive to address, amongst other concerns, potentially unequitable learning opportunities and mental health challenges?

The National Teacher and Principal Survey (NTPS) will gather critical information from teachers and principals about the changes implemented and lessons learned by schools and their staff during the 2020–21 school year. The NTPS is a nationwide system of related surveys that collect data on elementary and secondary education in the United States, including teaching and working conditions in schools and characteristics of public and private school teachers and principals at the state level.

Conducted every 2 to 3 years, NTPS provides critical representative data to policymakers and researchers on school organization, staff evaluations, teacher and principal preparation and professional development, classes taught, school characteristics, demographics of the teacher and principal labor force, and other important education topics. These data serve to inform those who set funding and other priorities, including Congress, the U.S. Department of Education, state education agencies, and public school districts. The data also allow important comparative analyses of key education personnel in public and private educational settings.

Unlike many other studies capturing information about the coronavirus and related education issues, NTPS allows for comparisons at the national level, between states for public schools and by affiliation for private schools, and over time. It is important that NTPS questionnaires reach selected teachers, principals, and other staff during these changing times. The information they provide will help decision makers evaluate the effects of school workplace conditions, salaries, and training opportunities on the educational workforce and aid in the U.S Department of Education’s program planning in the areas of teacher recruitment and retention, teaching policies, and teacher education.

But participation is key! If school staff do not participate in NTPS when selected, the data will provide an incomplete and possibly misleading description of the impact of the coronavirus on school communities, potentially affecting funding and other policy decisions.  

 

What do we know about the coronavirus and the 202021 school year?

By May 2020, in just the United States alone, at least 50.8 million public school students were affected by ordered or recommended K–12 school closures. According to Education Week reports, school districts unveiled a variety of reopening plans for the 2020–21 school year that include remote, hybrid or partial in-person, or full in-person learning approaches. As of September 2, 73 percent of the 100 largest school districts had announced they wiould resume with remote learning only. Information from the Census Bureau’s experimental weekly Household Pulse Survey suggests that students in one of every six households do not usually have access to the internet for education purposes.

Regardless of each school district’s decision for the beginning of the school year, local and state education leaders are responsible for numerous decisions on behalf of their schools, students, teachers, and school staff that rely heavily on the availability of reliable data. But most of the existing information on the education sector’s response to the coronavirus is at the district or state level and does not typically include information about experiences of teachers and principals directly from these critical education providers. Also, because of varying reporting resources and practices across the nation’s 130,000 public and private K–12 schools, a consistent national-level understanding of coronavirus-related education problems is not readily available. As a result, key policymakers and other decision makers currently have little information from individual teachers or principals about coronavirus-related problems specifically and education issues more generally. NTPS provides an opportunity for the voices of teachers, principals, and other school staff to be included in the conversation.

 

How can NTPS show what is happening in K–12 schools across the United States?

Last administered in 2017–18, the NTPS is set to resume in the 2020–21 school year and new questions have been added to reflect changes that may have occurred due to the coronavirus. This offers an opportunity for sampled teachers, principals, and schools to provide valuable data that explain their experience as educators during the coronavirus pandemic. In addition to new items, data gleaned from recurring questions will capture changes over time and yield important insights into areas of success and areas in need of further support. Data from prior school years has already been used during the pandemic to highlight differences in the number of health staff, such as school nurses, and mental health staff, such as counselors, psychologists, and social workers. Gathering more responses to these and other questions will allow for trend analyses, giving policymakers and other decision makers a better understanding of changes occurring at the teacher, principal, and school levels.

 

How will the survey be conducted?

The NTPS data collection process is both voluntary and self-administered, meaning all questionnaires can be completed without any in-person contact and without interruption for staff who may be fully working remotely. Teachers, principals, and schools who have been sampled to participate in the survey will be contacted by mail and e-mail and invited to complete the questionnaires online. Sampled participants will also receive paper surveys at their school mailing addresses.

 

Why is this survey important?

Responses from sampled schools ensure that NTPS estimates are reliable and accurately reflect the activities of all U.S. public and private schools. These data are vital as policymakers, researchers, families, and school staff strive to understand and respond to the effects of the current pandemic and build a better, stronger education sector for the future—including improved response options for potential future pandemics. NTPS responses during the 2020–21 school year can be compared to data from future NTPS cycles to understand possible longer-term impacts of the current significant changes to education delivery in the country and across the states. These data provide national and state policymakers with a distinct understanding of the condition of K–12 education in their communities and will remain important as leaders monitor changes in the education sector in future years.

For more information about the National Teacher and Principal Survey (NTPS), please visit https://nces.ed.gov/surveys/ntps/.

 

By Julia Merlin, NCES

New Education Data from the Household Pulse Survey

Recognizing the extraordinary information needs of policymakers during the coronavirus pandemic, NCES joined a partnership with the Census Bureau and four other federal statistical agencies to quickly develop a survey to gather key indicators of our nation’s response to the global pandemic. Thus, the experimental 2020 Household Pulse Survey began development on March 23, 2020, and data collection began on April 23, 2020. This new survey provides weekly national and state estimates, which are released to the public in tabular formats one week after the end of data collection.

The Household Pulse Survey gathers information from adults about employment status, spending patterns, food security, housing, physical and mental health, access to health care, and educational disruption. The education component includes questions about the following:

  • The weekly time spent on educational activities by students in public and private elementary and secondary schools
  • The availability of computer equipment and the Internet for instructional purposes
  • The extent to which computer equipment and the Internet for students were provided or subsidized

Since this survey is designed to represent adults 18 years old and over, the responses to the education questions concern students within the households of adults 18 years old and over, not the percentage of students themselves.

In the Household Pulse Survey during the weeks of April 23 through May 5, adults reported that their average weekly time spent on teaching activities with elementary and secondary students in their household was 13.1 hours. These results differed by educational attainment: adults who had not completed high school reported a weekly average of 9.9 hours in teaching activities with children, whereas adults with a bachelor’s or higher degree reported 13.9 hours (figure 1). In terms of the average weekly time spent on live virtual contact between students in their household and their teachers, adults reported a lower average of 4.1 hours.



Adults’ reports about the school instruction model need to be interpreted carefully because respondents could choose multiple types of approaches. A higher percentage of adults with a bachelor’s or higher degree (84 percent) reported that classes for elementary and secondary students in their household had moved to a format using online resources than did adults who had completed some college or an associate’s degree (74 percent), adults who had completed only high school (64 percent), or adults who had not completed high school (57 percent).

Higher percentages of adults with higher levels of education than of adults with lower levels of education reported that computers and the Internet were always available for educational purposes for elementary and secondary students in their households (figure 2).



The percentage of adults who reported that the school district provided a computer or digital device for children in their households to use at home for educational purposes was higher for adults who had not completed high school (44 percent) than for adults with a bachelor’s or higher degree (33 percent). Also, a higher percentage of adults who had not completed high school than of adults with higher levels of educational attainment reported financial assistance for student Internet access.

It is important to note that the speed of the survey development and the pace of the data collection efforts have led to policies and procedures for the experimental Household Pulse Survey that are not always consistent with traditional federal survey operations. Data should be interpreted with proper caution.  

More information on the Household Pulse Survey, detailed statistical tables, and microdata sets are available at https://www.census.gov/householdpulsedata. The Household Pulse Survey site includes breakouts of the data by other characteristics, such as race/ethnicity. In addition to participating in the development of this new survey, NCES has also generated new analyses based on existing data that respond to new needs for policy information, such as the availability of the Internet for student learning.

 

By Xiaolei Wang, AIR

Bar Chart Races: Changing Demographics in K–12 Public School Enrollment

Bar chart races are a useful tool to visualize long-term trend changes. The visuals below, which use data from an array of sources, depict the changes in U.S. public elementary and secondary school enrollment from 1995 to 2029 by race/ethnicity.


Source: U.S. Department of Education, National Center for Education Statistics, Common Core of Data (CCD), “State Nonfiscal Survey of Public Elementary and Secondary Education,” 1995–96 through 2017–18; and National Elementary and Secondary Enrollment by Race/Ethnicity Projection Model, 1972 through 2029.


Total enrollment in public elementary and secondary schools has grown since 1995, but it has not grown across all racial/ethnic groups. As such, racial/ethnic distributions of public school students across the country have shifted.

One major change in public school enrollment has been in the number of Hispanic students enrolled. Enrollment of Hispanic students has grown from 6.0 million in 1995 to 13.6 million in fall 2017 (the last year of data available). During that time period, Hispanic students went from making up 13.5 percent of public school enrollment to 26.8 percent of public school enrollment. NCES projects that Hispanic enrollment will continue to grow, reaching 14.0 million and 27.5 percent of public school enrollment by fall 2029.

While the number of Hispanic public school students has grown, the number of White public school students schools has steadily declined from 29.0 million in 1995 to 24.1 million in fall 2017. NCES projects that enrollment of White public school students will continue to decline, reaching 22.4 million by 2029. The percentage of public school students who were White was 64.8 percent in 1995, and this percentage dropped below 50 percent in 2014 (to 49.5 percent). NCES projects that in 2029, White students will make up 43.8 percent of public school enrollment.

The percentage of public school students who were Black decreased from 16.8 percent in 1995 to 15.2 percent in 2017 and is projected to remain at 15.2 percent in 2029. The number of Black public school students increased from 7.6 million in 1995 to a peak of 8.4 million in 2005 but is projected to decrease to 7.7 million by 2029. Between fall 2017 and fall 2029, the percentage of public school students who were Asian/Pacific Islander is projected to continue increasing (from 5.6 to 6.9 percent), as is the percentage who were of Two or more races (from 3.9 to 5.8 percent). American Indian/Alaska Native students account for about 1 percent of public elementary and secondary enrollment in all years.

For more information about this topic, see The Condition of Education indicator Racial/Ethnic Enrollment in Public Schools.

 

By Ke Wang and Rachel Dinkes, AIR

Announcing the Condition of Education 2020 Release

NCES is pleased to present The Condition of Education 2020, an annual report mandated by the U.S. Congress that summarizes the latest data on education in the United States. This report uses data from across the center and from other sources and is designed to help policymakers and the public monitor educational progress. This year’s report includes 47 indicators on topics ranging from prekindergarten through postsecondary education, as well as labor force outcomes and international comparisons.

The data show that 50.7 million students were enrolled in public elementary and secondary schools (prekindergarten through grade 12) and approximately 5.7 million students were enrolled in private elementary and secondary schools in fall 2017, the most recent year for which data were available. In school year 2017–18, some 85 percent of public high school students graduated on time with a regular diploma. This rate was similar to the previous year’s rate. About 2.2 million, or 69 percent, of those who completed high school in 2018, enrolled in college that fall. Meanwhile, the status dropout rate, or the percentage of 16- to 24-year-olds who were not enrolled in school and did not have a high school diploma or its equivalent, was 5.3 percent in 2018.

Total undergraduate enrollment in degree-granting postsecondary institutions in 2018 stood at 16.6 million students. The average net price of college for first-time, full-time undergraduates attending 4-year institutions was $13,700 at public institutions, $27,000 at private nonprofit institutions, and $22,100 at private for-profit institutions (in constant 2018–19 dollars). In the same year, institutions awarded 1.0 million associate’s degrees, 2.0 million bachelor’s degrees, 820,000 master’s degrees, and 184,000 doctor’s degrees.

Ninety-two percent of 25- to 34-year-olds in the United States had a high school diploma or its equivalent in 2018. In comparison, the average rate for the Organization for Economic Cooperation and Development (OECD) member countries was 85 percent. Some 49 percent of these individuals in the United States had obtained a postsecondary degree, compared with the OECD average of 44 percent. Similar to previous years, annual median earnings in 2018 were higher for 25- to 34-year-olds with higher levels of education. In 2018, U.S. 25- to 34-year-olds with a bachelor’s or higher degree earned 66 percent more than those with a high school diploma or equivalent.

The Condition of Education includes an Executive Summary, an At a Glance section, a Reader’s Guide, a Glossary, and a Guide to Sources, all of which provide additional background information. Each indicator includes references to the source data tables used to produce the indicator.

As new data are released throughout the year, indicators will be updated and made available on The Condition of Education website

In addition to publishing The Condition of Education, NCES produces a wide range of other reports and datasets designed to help inform policymakers and the public about significant trends and topics in education. More information about the latest activities and releases at NCES may be found on our website or at our social media sites on TwitterFacebook, and LinkedIn.

 

By James L. Woodworth, NCES Commissioner