NCES Blog

National Center for Education Statistics

Using IPEDS Data: Available Tools and Considerations for Use

The Integrated Postsecondary Education Data System (IPEDS) contains comprehensive data on postsecondary institutions. IPEDS gathers information from every college, university, and technical and vocational institution that participates in federal student financial aid programs. The Higher Education Act of 1965, as amended, requires institutions that participate in federal student aid programs to report data on enrollments, program completions, graduation rates, faculty and staff, finances, institutional prices, and student financial aid.

These data are made available to the public in a variety of ways via the IPEDS Use the Data webpage. This blog post provides a description of available IPEDS data tools as well as considerations for determining the appropriate tool to use.


Available Data Tools

College Navigator

College Navigator is a free consumer information tool designed to help students, parents, high school counselors, and others access information about postsecondary institutions.

Note that this tool can be found on the Find Your College webpage (under "Search for College"), along with various other resources to help users plan for college.

IPEDS provides data tools for a variety of users that are organized into three general categories: (1) Search Existing Data, (2) Create Custom Data Analyses, and (3) Download IPEDS Data.

Search Existing Data

Users can search for aggregate tables, charts, publications, or other products related to postsecondary education using the Data Explorer or access IPEDS data via NCES publications like the Digest of Education Statistics or the Condition of Education.

Create Custom Data Analyses

Several data tools allow users to create their own custom analyses with frequently used and derived variables (Data Trends) or all available data collected within IPEDS (Statistical Tables). Users can also customize tables for select subgroups of institutions (Summary Tables). Each of these options allows users to generate analyses within the limitations of the tool itself.

For example, there are three report types available under the Data Feedback Report (DFR) tool. User can

  1. select data from the most recent collection year across frequently used and derived variables to create a Custom DFR;
     
  2. create a Statistical Analysis Report using the variables available for the Custom DFR; and
     
  3. access the NCES developed DFR for any institution.

Download IPEDS Data

Other data tools provide access to raw data through a direct download (Complete Data Files) or through user selections in the IPEDS Custom Data Files tool. In addition, IPEDS data can be downloaded for an entire collection year for all survey components via the Access Database.

IPEDS Data Tools Help

The IPEDS Data Tools User Manual is designed to help guide users through the various functions, processes, and abundant capabilities of IPEDS data tools. The manual contains a wealth of information, hints, tips, and insights for using the tools.

 

Data Tool Considerations

Users may consider several factors—related to both data selection and data extraction—when determining the right tool for a particular question or query.

Data Selection​

  1. Quick access – Accessing data in a few steps may be helpful for users who want to find data quickly. Several data tools provide data quickly but may be limited in their selection options or customizable output.

  2. Data release – IPEDS data are released to the public in two phases: Provisional and Final. Provisional data have undergone quality control procedures and imputation for missing data but have not been updated based on changes within the Prior Year Revision System. Final data reflect changes made within the Prior Year Revision System and additional quality control procedures and will not change. Some tools allow users to access only final data. Table 1 summarizes how provisional and final data are used by various data tools. The IPEDS resource page “Timing of IPEDS Data Collection, Coverage, and Release Cycle” provides more information on data releases.


    Table 1. How provisional and final data are used in various data tools

  1. Select institutions – Users may want to select specific institutions for their analyses. Several tools allow users to limit the output for a selected list of institutions while others include all institutions in the output.
     
  2. Multiple years – While some tools provide a single year of data, many tools provide access to multiple years of data in a single output.
     
  3. Raw data – Some data tools provide access to the raw data as submitted to IPEDS. For example, Look Up an Institution allows users access to survey forms submitted by an institution.
     
  4. Institution-level data – Many data tools provide data at the institution level, since this is the unit of analysis within the IPEDS system.
     
  5. All data available – Many data tools provide access to frequently used and derived variables, but others provide access to the entirety of variables collected within the IPEDS system.

Data Extraction

  1. Save/upload institutions – Several data tools allow a user to create and download a list of institutions, which can be uploaded in a future session.

  2. Save/upload variables – Two data tools allow a user to save the variables selected and upload in a future session.
     
  3. Export data – Many data tools allow a user to download data into a spreadsheet, while others provide information within a PDF. Note that several tools have limitations on the number of variables that can be downloaded in a session (e.g., Compare Institutions has a limit of 250 variables).
     
  4. Produce visuals – Several data tools produce charts, graphs, or other visualizations. For example, Data Trends provides users with the opportunity to generate a bar or line chart and text table.


Below is a graphic that summarizes these considerations for each IPEDS data tool (click the image to enlarge it). 

 

To find training opportunities—including video tutorials, workshops, and keyholder courses—check out the IPEDS Training Center. Plus, access the IPEDS Distance Learning Dataset Training modules for more guidance on how to use IPEDS data. For additional questions, call the IPEDS Data Use Help Desk at (866) 558-0658 or e-mail ipedstools@rti.org.

 

By Tara B. Lawley, NCES, and Eric S. Atchison, Arkansas State University System and Association for Institutional Research IPEDS Educator

Measuring Student Safety: New Data on Bullying Rates at School

NCES is committed to providing reliable and up-to-date national-level estimates of bullying. As such, a new set of web tables focusing on bullying victimization at school was just released.  

These tables use data from the School Crime Supplement to the National Crime Victimization Survey, which collects data on bullying by asking a nationally representative sample of students ages 12–18 who were enrolled in grades 6–12 in public and private schools if they had been bullied at school. This blog post highlights data from these newly released web tables.

Some 19 percent of students reported being bullied during the 2021–22 school year. More specifically, bullying was reported by 17 percent of males and 22 percent of females and by 26 percent of middle school students and 16 percent of high school students. Moreover, among students who reported being bullied, 14 percent of males and 28 percent of females reported being bullied online or by text.

Students were also asked about the recurrence and perpetrators of bullying and about the effects bullying has on them. During the 2021–22 school year, 12 percent of students reported that they were bullied repeatedly or expected the bullying to be repeated and that the bullying was perpetrated by someone who was physically or socially more powerful than them and who was not a sibling or dating partner. When these students were asked about the effects this bullying had on them,

  • 38 percent reported negative feelings about themselves;
  • 27 percent reported negative effects on their schoolwork;
  • 24 percent reported negative effects on their relationships with family and friends; and
  • 19 percent reported negative effects on their physical health.

Explore the web tables for more data on how bullying victimization varies by student characteristics (e.g., sex, race/ethnicity, grade, household income) and school characteristics (e.g., region, locale, enrollment size, poverty level) and how rates of bullying victimization vary by crime-related variables such as the presence of gangs, guns, drugs, alcohol, and hate-related graffiti at school; selected school security measures; student criminal victimization; personal fear of attack or harm; avoidance behaviors; fighting; and the carrying of weapons.

Find additional information on this topic in the Condition of Education indicator Bullying at School and Electronic Bullying. Plus, explore more School Crime and Safety data and browse the Report on Indicators of School Crime and Safety: 2022.

How Often Do High School Students Meet With Counselors About College? Differences by Parental Education and Counselor Caseload

There are many factors that can affect students’ decisions to apply to college, such as income, school engagement, and coursework.1 Similarly, previous research has reported that students whose parents did not hold a college degree (i.e., first-generation college students) enrolled in college at a lower rate than did peers whose parents held a college degree.2 However, high school counselors may help students choose colleges and apply to them, meaning that students who meet with a counselor about college could be more likely to attend college.3 Counselors may help potential first-generation college students plan for college by providing information that continuing-generation students already have access to via their parents who had attained college degrees themselves. Despite the potential benefits of meeting with a counselor, a school's counselor caseloads may affect its students' counseling opportunities.4

What percentage of high school students met with a counselor about college? How did this percentage vary by parental education and counselor caseload?

Around 47 percent of 2009 ninth-graders were potential first-generation college students whose parents did not hold a college degree (table U1). These students met with a counselor at a lower rate than did students whose parents held a college degree. Figure 1 shows that 72 percent of students whose parents did not hold a college degree met with a counselor, compared with 76 and 82 percent of students whose parents held an associate’s degree and a bachelor’s degree or higher, respectively.


Figure 1. Percentage of students who met with a counselor about college in 2012–13, by average counselor caseload level at the school and parents' highest education level

NOTE: Caseload is a continuous variable based on counselor reports of the average number of students per counselor at the school. Each caseload category accounts for roughly one-third of the sample in the unweighted data. Low caseload refers to counselors responsible for 40 to 299 students, medium caseload refers to counselors responsible for 300 to 399 students, and high caseload refers to counselors responsible for 400 or more students. The category high school degree or less incudes high school diploma or GED and those who started college but did not complete a degree. Respondents who did not know whether they met with a counselor are excluded from the analyses. These represent approximately 8 percent of weighted cases. 
SOURCE: U.S. Department of Education, National Center for Education Statistics, High School Longitudinal Study of 2009 (HSLS:09) Base year, First Follow-up, and 2013 update.


During the senior year of most of the cohort of 2009 ninth-graders, the average counselor caseload at schools attended by these students5 was 375 students per counselor. The average caseload at public schools was 388, and the average caseload at private schools was 202.

Students attending schools with low counselor caseloads met with a counselor about college at a higher rate than did students at schools with high counselor caseloads, when comparing students whose parents had similar attainment levels. For example, at schools with low caseloads, 79 percent of students whose parents held a high school degree or less met with a counselor about college, compared with 70 percent of these students at schools with high caseloads. This pattern is also true for students at schools with low caseloads compared with medium caseloads (i.e., 86 vs. 76 percent of students whose parents held an associate’s degree and 89 vs. 81 percent of students whose parents held a bachelor’s degree), except among students whose parents held a high school degree or less (79 percent was not statistically different from 74 percent). Finally, students whose parents held a high school degree or less met with a counselor at a lower rate than did students whose parents held a bachelor’s degree or higher in each caseload category (i.e., 79 vs. 89 percent for low caseload schools, 74 vs. 81 percent for medium caseload schools, and 70 vs. 77 percent for high caseload schools).

For more information about counselor meetings and college enrollment, check out this Data Point: High School Counselor Meetings About College, College Attendance, and Parental Education.

This blog post uses data from the High School Longitudinal Study of 2009 (HSLS:09), a national study of more than 23,000 ninth-graders and their school counselors in fall 2009. Student sample members answered surveys between 2009 and 2016. Sample members or their parents reported on whether the student met with a counselor about college during the 2012–13 school year (most students’ 12th-grade year).

While data presented here are the most recent data available on the topic, NCES will have new data on high schoolers’ experiences in the 2020s coming soon. In particular, data from the High School and Beyond Longitudinal Study of 2022 (HS&B:22), which also includes information about students’ visits to school counselors, is forthcoming.

Until those data are released, we recommend you access HSLS:09 student and counselor data to conduct your own analyses via NCES’s DataLab.

 

By Catharine Warner-Griffin, AnLar, and Elise Christopher, NCES


[1] See, for example, Fraysier, K., Reschly, A., and Appleton, J. (2020). Predicting Postsecondary Enrollment With Secondary Student Engagement Data. Journal of Psychoeducational Assessment, 38(7), 882–899.

[2] Cataldi, E. F., Bennett, C. T., and Chen, X. (2018). First-Generation Students: College Access, Persistence, and Postbachelor’s Outcomes (2018-421). U.S. Department of Education. Washington, DC: National Center for Education Statistics.

[3] Tang, A. K., and Ng, K. M. (2019). High School Counselor Contacts as Predictors of College Enrollment. Professional Counselor, 9(4), 347–357.

[4] Woods, C. S., and Domina, T. (2014). The School Counselor Caseload and the High School-to-College Pipeline. Teachers College Record, 116(10), 1–30.

[5] These schools are only those sampled in the base year (i.e., students’ 2009 schools).

NCES Presentation at National HBCU Week Conference

In NCES’s recently released Strategic Plan, Goal 3 identifies our commitment to foster and leverage beneficial partnerships. To fulfill that goal, NCES participates in multiple conferences and meetings throughout the year. Recently, NCES participated in the National Historically Black Colleges and Universities (HBCU) Week Conference. NCES’s presentation at this conference helps us to establish a dialogue with HBCUs and develop partnerships to address critical issues in education.

NCES Commissioner Peggy G. Carr kicked off the presentation with an overview of HBCU data—such as student characteristics, enrollment, and financial aid. Then, NCES experts explored how data from various NCES surveys can help researchers, educators, and policymakers better understand the condition and progress of HBCUs. Read on to learn about these surveys.

 

Integrated Postsecondary Education Data System (IPEDS)

The Integrated Postsecondary Education Data System (IPEDS) is an annual administrative data collection that gathers information from more than 6,000 postsecondary institutions, including 99 degree-granting, Title IV–eligible HBCUs (in the 2021–22 academic year).

The data collected in IPEDS includes information on institutional characteristics and resources; admissions and completions; student enrollment; student financial aid; and human resources (i.e., staff characteristics). These data are disaggregated, offering insights into student and employee demographics by race/ethnicity and gender, students’ age categories, first-time/non-first-time enrollment statuses, and full-time/part-time attendance intensity.

Data from IPEDS can be explored using various data tools—such as Data Explorer, Trend Generator, and College Navigator—that cater to users with varying levels of data knowledge and varying data needs.

 

National Postsecondary Student Aid Study (NPSAS)

The National Postsecondary Student Aid Study (NPSAS) is a nationally representative study that examines the characteristics of students in postsecondary institutions—including HBCUs—with a special focus on how they finance their education. NPSAS collects data on the percentage of HBCU students receiving financial aid and the average amounts received from various sources (i.e., federal, state, and institution) by gender and race/ethnicity.

Conducted every 3 or 4 years, this study combines data from student surveys, student-level school records, and other administrative sources and is designed to describe the federal government’s investment in financing students’ postsecondary education.

Data from NPSAS can be explored using DataLab and PowerStats.

 

National Teacher and Principal Survey (NTPS)

The National Teacher and Principal Survey (NTPS) is the U.S. Department of Education’s primary source of information on K–12 public and private schools from the perspectives of teachers and administrators. NTPS consists of coordinated surveys of schools, principals, and teachers and includes follow-up surveys to study principal and teacher attrition.

Among many other topics, NTPS collects data on the race/ethnicity of teachers and principals. These data—which show that Black teachers and principals make up a relatively small portion of the K–12 workforce—can be used to explore the demographics and experiences of teachers and principals. NTPS provides postsecondary institutions, like HBCUs, a snapshot of the preK–12 experiences of students and staff.

Data from NTPS can be explored using DataLab and PowerStats.

 

National Assessment of Educational Progress (NAEP)

The National Assessment of Educational Progress (NAEP)—also known as the Nation’s Report Card—is the the largest nationally representative and continuing assessment of what students in public and private schools in the United States know and are able to do in various subjects.

Main NAEP assesses students in grades 4, 8, and 12 in subjects like reading, mathematics, science, and civics, while NAEP Long-Term Trend assesses 9-, 13-, and 17-year-olds in reading and mathematics.

Among many other topics, NAEP collects data on students by race/ethnicity. These data can help to shed light on students’ experiences, academic performance, and level of preparedness before they enroll in HBCUs.

Data from NAEP can be explored using the NAEP Data Explorer.

 

To explore more HBCU data from these and other NCES surveys—including enrollment trends from 1976 to 2021—check out this annually updated Fast Fact. Be sure to follow NCES on X, Facebook, LinkedIn, and YouTube and subscribe to the NCES News Flash to stay up to date on the latest from NCES.

 

By Megan Barnett, AIR

Education at a Glance 2023: Putting U.S. Data in a Global Context

International comparisons provide reference points for researchers and policy analysts to understand trends and patterns in national education data and are very important as U.S. students compete in an increasingly global economy.

Education at a Glance (EAG), an annual publication produced by the Organization for Economic Cooperation and Development (OECD), provides data on the structure, finances, and progress of education systems in 38 OECD countries—including the United States—as well as a number of OECD accession and partner countries. Data presented in EAG on topics of high policy interest in the United States are also featured in NCES reports, including the Condition of Education and Digest of Education Statistics.  

The recently released 2023 edition of EAG shows that the United States is above the international average on some measures, such as funding of postsecondary education, but lags behind in others, such as participation in early childhood education and care (ECEC). The 2023 report also features a Spotlight on Vocational Education and Training as well as interactive data dashboards on ECEC systems, upper secondary education systems, and educational support for Ukrainian refugees.


Spotlight on Vocational Education and Training (VET)

Each EAG edition centers on a particular theme of high policy relevance in OECD countries. The focus of this year’s report is VET programs, which look very different in the United States compared with many other OECD countries. Unlike in many OECD countries, most high schools in the United States do not offer a separate, distinct vocational track at the upper secondary (high school) level. Instead, vocational education is available as optional career and technical education (CTE) courses throughout high school. Regardless of whether they choose to take CTE courses, all U.S. students who complete high school have the same potential to access postsecondary programs. In other OECD countries, selecting a vocational track at this level may lead to different postsecondary opportunities. Check out the 2023 EAG Spotlight for an overview of VET programs across OECD countries.


Highlights From EAG 2023

Below is a selection of topics from the EAG report highlighting how key education benchmarks in the United States compare with other OECD countries.


Postsecondary Educational Attainment

The percentage of U.S. 25- to 34-year-olds with a postsecondary degree increased by 13 percentage points between 2000 and 2022, reaching 51 percent (the OECD average in 2022 was 47 percent) (Table A1.3).1 In this age group in the United States, higher percentages of women than men attained a postsecondary degree (56 vs. 46 percent) (Table A1.2). Across OECD countries, the average postsecondary educational attainment gap between 25- to 34-year-old men and women in 2022 (13 percentage points) was wider than the gap in the United States (10 percentage points). In the United States, the postsecondary attainment rate for 25- to 34-year-old men was 5 percentage points higher than the OECD average, and the attainment rate for women was 3 percentage points higher than the OECD average.


Figure 1. Percentage of 25- to 34-year-olds with a postsecondary degree, by OECD country: 2022

[click to enlarge image]

Data include a small percentage of adults with lower levels of attainment.
Year of reference differs from 2022. Refer to the source table for more details.
SOURCE: OECD (2023), Table A1.3. See Source section for more information and Annex 3 for notes.


International Student Enrollment

The United States is the top OECD destination country for international students enrolling in postsecondary education. In 2021, some 833,204 foreign students were enrolled in postsecondary programs in the United States, representing 13 percent of the international education market share (Table B6.1).2 In comparison, the United Kingdom had the second highest number of international students enrolled in postsecondary education in 2021, representing 9 percent of the international education market share. Interestingly, when examining enrollment trends over the past 3 years (2019 to 2021), foreign student enrollment decreased by 143,649 students (15 percent) in the United States but increased by 111,570 students (23 percent) in the United Kingdom. International student enrollment during these years was likely affected by the coronavirus pandemic, which had large impacts on global travel in 2020 and 2021.


Education Spending

U.S. spending on education is relatively high across all levels of education compared with the OECD average. The largest difference is in postsecondary spending, where the United States spent $36,172 per full-time postsecondary student in 2020, the second highest amount after Luxembourg ($53,421) and nearly double the OECD average ($18,105) (Table C1.1).3 This spending on postsecondary education amounts to 2.5 percent of the U.S. GDP, higher than the OECD average (1.5 percent) (Table C2.1). These total expenditures include amounts received from governments, students, and all other sources.


Figure 2. Expenditures per full-time equivalent student, by education level and OECD country: 2020

[click to enlarge image]

1 Year of reference differs from 2020. Refer to the source table for more details.
SOURCE: OECD (2023), Table C1.1. See Source section for more information and Annex 3 for notes.


High School Completion Rate

The United States has a higher upper secondary (high school) completion rate than most other OECD countries. In 2021, some 87 percent of U.S. students completed their high school program in the expected timeframe, compared with the OECD average of 72 percent (Table B3.1).


Early Childhood Education

The level of participation in early childhood education programs in the United States is below the OECD average. In 2021, average enrollment rates across OECD countries were 72 percent for 3-year-olds, 87 percent for 4-year-olds, and 84 percent for 5-year-olds (Table B2.1). In contrast, enrollment rates for students of these ages in the United States were 30 percent for 3-year-olds, 50 percent for 4-years-olds, and 81 percent for 5-year-olds.  

 

Browse the full EAG 2023 report to see how the United States compares with other countries on these and other important education-related topics.

 

By RaeAnne Friesenhahn, AIR, and Cris De Brey, NCES


[1] EAG data for the year 2000 can be accessed via the online OECD Stat database.

[2] Unrounded data in Excel format can be accessed via the StatLink located below each table.

[3] Expenditure in national currencies was converted into equivalent USD by dividing the national currency figure by the purchasing power parity (PPP) index for GDP. For more details on methodology see Annex 2 and Annex 3.