IES Blog

With hundreds of tables to explore, the Digest of Education Statistics offers a wide array of education data. For the first time, NCES is visualizing Digest data in a new Digest State Dashboard. The Dashboard provides a centralized location for state-level Digest data, so users can easily find it all in one place. As the first-ever Digest data tool, the Dashboard helps you not only find and use NCES data but also better understand the education landscape of an individual state.

In alignment with NCES’s goal to promote diversity, equity, and inclusion in our products, the Dashboard provides data for all entities that are part of the United States: the 50 states, the District of Columbia, the Bureau of Indian Education, and outlying areas—i.e., American Samoa, Guam, Northern Marianas, Puerto Rico, and U.S. Virgin Islands.

For each of these entities, the Dashboard highlights the most recently published Digest data on topics of interest (see textbox). The selected topics represent key indicators of a state’s education landscape, and data are presented for each entity and topic whenever available.

To help make data interpretation easier, the Dashboard presents data in figures—like bar charts, line graphs, and brief tables—that allow you to interact with the data in ways not possible with the static tables. If you’ve ever explored the Condition of Education—which will be updated next month (May 2024)—the Dashboard’s figures should look very familiar, as they were designed to mirror the appearance and functionality of the Condition’s interactive figures. Similarly, in the Dashboard, you can

1. modify the figure by selecting characteristics and years to include;
2. share the figure on various platforms; and
3. download the figure and the data used in the figure. 

The Dashboard also provides links to other NCES state-level data tools, centralizing these resources and providing a more detailed picture of each state’s educational landscape. You can find state-specific links to NAEP State Profiles, the NTPS State Dashboard, and the PIAAC Skills Map on each state’s page. Plus, you can find links to other NCES data tools, like the EDGE ACS Dashboard and the IPEDS Trend Generator, on the Dashboard’s homepage.

The Dashboard will be continuously updated throughout the year—as data become available in the Digest—making it a great source of up-to-date information for policymakers, researchers, practitioners, and parents/families. In May 2024, several figures will be updated, including two postsecondary figures on enrollment and institutions and student charges. Be sure to check back and follow NCES on X, Facebook, LinkedIn, and YouTube and subscribe to the NCES News Flash to stay informed when these and other updates are made. You can also continue to explore the Digest tables to find even more state-level data.

NCES recently released a finance tables report, Revenues and Expenditures for Public Elementary and Secondary Education: FY 21 (NCES 2023-301), which draws from data in the National Public Education Financial Survey (NPEFS). To accompany the report, NCES has updated the interactive data visualization tool to highlight the per pupil revenues and expenditures (adjusted for inflation) and average daily attendance (ADA) trends from the fiscal year 2021 (FY 21) NPEFS.

This tool allows users to see national or state-specific per pupil amounts and year-to-year percentage changes for both total revenue and current expenditures by using a slider to toggle between the two variables. Total revenues are shown by source, and total current expenditures are shown by function and subfunction. Clicking on a state in the map will display data for the selected state in the bar charts.

The tool also allows users to see the ADA for each state. It is sortable by state, ADA amount, and percentage change. It may also be filtered to easily compare selected states. Hovering over the ADA of a state will display another bar graph with the last 3 years of ADA data.

Overall, the results show that spending¹ on elementary and secondary education increased in school year 2020–21 (FY 21). This is the eighth consecutive year that year-over-year education spending increased (since FY 13), after adjusting for inflation. This increase follows declines in year-over-year spending for the prior 4 years (FY 10 through FY 13).

Revenues

The 50 states and the District of Columbia reported $837.3 billion in revenues collected for public elementary and secondary education in FY 21. State and local governments provided $748.9 billion, or 89.4 percent of all revenues. The federal government contributed $88.4 billion, or 10.6 percent of all revenues. Total revenues increased by 3.0 percent after adjusting for inflation² (from $812.8 to $837.3 billion) from FY 20 to FY 21; local revenues remained relatively unchanged (from $365.1 to $365.1 billion); state revenues decreased by 0.6 percent (from $385.9 to $383.8 billion); and federal revenues increased by 43.2 percent (from $61.8 to $88.4 billion).

Total revenues per pupil averaged $17,015 on a national basis in FY 21. This reflects an increase of 5.9 percent between FY 20 and FY 21 and follows an increase of 1.5 percent from FY 19 to FY 20. The percentage change in revenues per pupil from FY 20 to FY 21 ranged from an increase of 15.3 percent in Maine to a decrease of 4.2 percent in Hawaii.

The Common Core of Data (CCD) contains basic information on public elementary and secondary schools, local education agencies (LEAs), and state education agencies (SEAs) in the United States. The CCD collects fiscal and nonfiscal data about all public schools, public school districts, and state education agencies in the United States. Both IPEDS and CCD provide a sampling frame to many survey collections, including many conducted by NCES and the Department of Education. This blog post, one in a series of posts about CCD nonfiscal data, focuses on CCD’s two major releases and their corresponding components. For information on how to access and use CCD data, read the blog post Accessing the Common Core of Data (CCD).
 

Data Releases

CCD nonfiscal data are published in two releases every school year—as preliminary files and as provisional data files—within the CCD Data File tool. Understanding the differences between the two releases is important to understand how CCD nonfiscal data are released.

• The preliminary files contain basic information about schools and districts, such as name, address, phone number, status, and NCES ID number. Many schools and districts utilize information from the directory file, such as the NCES ID, to apply for grants or other opportunities for their schools. Therefore, it is important that these files are released first, even if the data are still preliminary. 
   
• The provisional data files are the full release of the CCD nonfiscal data. These data files provide school-, district-, and state-level data on topics like enrollment, staffing, and free or reduced-price lunch. These files are much more detailed and include data that are broken down by characteristics such as grade, race/ethnicity, and gender—as well as by combinations of these characteristics. These files are not updated unless there is a significant change to the data.

Each file release includes a version that indicates the type of release. The first preliminary files have “0a” in the file names, and revised preliminary files include “0b,” “0c,” and so on. The first provisional files have “1a,” in the file names, and revised provisional files include “1b,” “1c,” and so on. Note, however, that releasing revised files is rare.
 

Components of a Release

It is important to utilize the various components that accompany each release to find additional information that is specific to the file and can help you better understand the data. In addition, there are other resources available that provide more ways to access and understand the data.
 

Documentation Components

Every data file will have documentation files that provide information about the data. These include the following:

• release notes—basic information about the data release, including details about any changes to the files, such as a change in a variable’s description or a variable that was added to the file; summary tables that include national totals and tables with selected frequencies are also included.
   
• state data notes—information on data anomalies that are discovered during NCES’s collaboration with the states; broken down by state and by file type, these notes describe things like changes to how data were collected by the state.
   
• companion files—included in each data file component, these files include a list of all the variables in the data file—including a brief description—and frequency tables; you should start with the companion files to better understand what variables are in each data file.

Resources and Tools

Along with the release of the CCD nonfiscal data files, additional resources are also updated to improve access to the data.

• Summary Tables: Released with the provisional data files, Summary Tables provide a national-level look at the data. These tables show the operational status of schools and districts by type as well as the number of schools, students, and teachers by state.
   
• Locators and ElSi: There are two primary tools that can be used to access CCD data: the Locators (School Locator and District Locator) and the Elementary/Secondary Information System (ElSi). These tools are updated as the data files are released. The Locators are updated with each release, while ElSi is updated with the release of the provisional data files. Learn more about these tools.
   
• Online Documentation: The online documentation provides some general information about CCD. This information is not year specific, but it provides a detailed explanation about how the data are collected, processed, and reviewed.

• Reference Library: The reference library includes detailed documentation on various components of the CCD files that applies to multiple years, levels, and components of the data collection. The library includes crosswalks, documentation describing changes to the collection, and guidance for utilizing the data files, such as how to aggregate free or reduced-price lunch data.

Be sure to follow NCES on Twitter, Facebook, LinkedIn, and YouTube and subscribe to the NCES News Flash to stay up-to-date on future CCD releases and resources.

By Patrick Keaton, NCES

Today, on Women’s Equality Day, we honor the many women who fuel the education sector with their dedication to our nation’s students! But, let’s also remember the many ways women are still striving to overcome inequalities in the workplace.

Women made up the majority of public school teachers (77 percent) and public school principals (54 percent) in 2017–18. While overrepresented in terms of public school positions, women were paid significantly less than their male counterparts.

Background Demographics

Compared to 30 years ago, women made up higher proportions of public school teachers and principals in 2017–18 than in 1987–88. According to data from the 1987–88 Schools and Staffing Survey (SASS), 71 percent of all public school teachers were women. By 2017–18, data from the National Teacher and Principal Survey (NTPS) showed the rate had increased to 77 percent. The percentage of female public school principals more than doubled during the same period, from 25 percent in 1987–88 to 54 percent in 2017–18. 

Historically, U.S. school buildings weren’t heavily populated by women. Nearly all teachers were men before “Common Schools”—the precursor to today’s public school system—were introduced in the late 1820s. As the education landscape shifted, so did the composition of the teaching workforce. By the 1890s, more than two-thirds (68 percent) of all public school teachers were women.¹ 

New Depression-era laws in the 1930s—which limited the number of adults in a family who were allowed to work in certain occupations—made it more difficult for married women to stay in the workforce, since a husband often earned more than his wife, even in the same position. Since female public school teachers were the most immediately recognizable example of this law at the local level, married women in education were direct targets of employment discrimination.² Consequently, the percentage of female teachers dropped from 81 percent in 1930 to 76 percent in 1940.³ Throughout history, this percentage continued to fluctuate as laws readjusted more equitably and more diverse jobs became available to women, although women have always represented more than 50 percent of the teacher workforce. 

The Gender Wage Gap: Teachers and Principals (2017–18 NTPS)

According to Bureau of Labor Statistics data, women are paid less than men in nearly all occupations. While the gap for public elementary and secondary teachers is smaller than the average, it still exists.  

History tells us that the gender wage gap in elementary and secondary education wasn’t accidental. In fact, it was specifically created to expand the reach of the public education system by Common School reformers who argued that the United States could afford to staff the proposed new schools by adding more female teachers, since schools could pay them less than male teachers.⁴

Patterns in teacher compensation from the 2017–18 school year show that the average base teaching salary of female public school teachers is less than that of their male counterparts ($55,490 vs. $57,453).⁵ Comparably, female public school principals also had a lower average salary in 2017–18 than did male principals ($96,300 vs. $100,600).

How does average annual salary vary based on teacher, principal, or school characteristics? (2017–18 NTPS)

Public school teacher and principal salaries are known to vary by several individual- or school-related characteristics (see figures 1 and 2).

For instance, there are fluctuations in teachers’ and principals’ average annual salary by age, years of experience, and highest degree earned. Salary increases often follow a predictable pattern: older, more experienced, or more highly educated teachers and principals generally earn higher salaries than their younger, less experienced, or less educated counterparts.

Educators are also paid differently based on where they work. Certain school characteristics, such as community type, school level, and school size, can influence teachers’ and principals’ average salaries. In 2017–18, the educators with the highest average annual salary worked in either suburban schools, high schools, or large schools with more than 1,000 enrolled students.

How do we achieve the best education results for the best price? This is a central question among researchers and policymakers alike. In this blog post, we share outcomes from school year 2017–18 concerning public charter school spending at the elementary, middle, and high school levels to help inform the discussion on charter school costs and benefits to the broader education system.

The first modern charter law in the United States was passed in Minnesota in 1991. Since that time, the number of charter schools has grown tremendously as an option in public elementary and secondary education. In 2017–18, the United States had 7,086 public charter schools in 44 states and the District of Columbia. In a decade, from 2007–08 to 2017–18, the number of public charter schools in the United States increased more than 70 percent, representing a little more than 7 percent of all public schools at the end of this time period (figure 1).

Figure 1. Number of public charter schools in the United States: School years 2007–08 through 2017–18

NOTE: These data include counts of operational public elementary/secondary charter schools for the 50 states and the District of Columbia.
SOURCE: U.S. Department of Education, National Center for Education Statistics, Common Core of Data (CCD), 2007–08 through 2017–18.

Nearly half (47 percent) of all public charter schools in the United States are classified as elementary schools, 11 percent are classified as middle schools, and 28 percent are classified as high schools (figure 2). The remainder (14 percent) have other grade-level configurations and do not fall into any of these categories.

Figure 2. Percentage of public charter schools in the United States, by school level: School year 2017–18

NOTE: These data reflect operational public elementary/secondary charter schools for the 50 states and the District of Columbia from the Common Core of Data (CCD) for 2017. School-level categories are taken from the Documentation to NCES’ Common Core of Data for school year 2017–18, whereby “Elementary” includes schools with students enrolled in grades K–4 that offer more elementary grades than middle grades; “Middle” includes schools with students enrolled in grades 5–8 that offer more middle grades than elementary or secondary grades; “High” includes schools with students enrolled in grade 12 and other secondary grades that offer more high grades than middle grades; and “Other” includes schools with both elementary and high grades or grades at all three levels (elementary, middle, and high). Excludes 2,360 schools categorized in the CCD as adult education, not applicable, not reported, prekindergarten-only, secondary, and ungraded.
SOURCE: U.S. Department of Education, National Center for Education Statistics, Civil Rights Data Collection (CRDC), 2017–18.

According to expenditure data captured in the Civil Rights Data Collection (CRDC), public schools in the United States spent $330.94 billion in 2017–18, or more than $6,600 per pupil. Reports of national school expenditures based on data from the CRDC are significantly lower than those estimated using the National Public Education Financial Survey (NPEFS) from the Common Core of Data (CCD). This could be attributed to data on spending for school nutrition, operations and maintenance, and transportation being captured in the NPEFS but not collected in the CRDC. However, the CRDC data allow for comparisons of public charter and noncharter schools at the school level. In 2017–18, spending among public noncharter schools fell just under the national average of $6,500 per pupil. Like other schools in the U.S. public school system, charter schools do not charge tuition and instead receive district and state funding based on their enrollment. Public charter schools spent more than $26.83 billion in 2017–18, or just more than $8,900 per pupil, thus exceeding the national average.

The per pupil school expenditures of public charter schools across school levels¹ are different from those of public noncharter schools. This analysis compares spending between public elementary, middle, and high schools in 2017–18. (Mixed-level and other schools are excluded because they have variable grade levels and other characteristics that can make expenditures incomparable across school types.) Across school levels, per pupil expenditures among public charter schools exceeded the national average, while per pupil expenditures among public noncharter schools were closer to the national average. Specifically, for public charter schools, per pupil expenditures were highest for elementary schools ($8,400), followed by high schools ($8,200) and middle schools ($8,100) (figure 3). However, for public noncharter schools, per pupil expenditures were highest for high schools ($6,600), followed by elementary schools ($6,400) and middle schools ($6,100).