Skip to main content


Showing posts from June, 2024

Colleges that might close soon

OK, I admit it.  That headline is clickbait.  I have no idea which colleges might close in the near future, but I want to take a look at the problem from 30,000 feet. This is prompted by the recent announcement that Eastern Nazarene College in Massachusetts will close . It comes on the heels of several other announcements like this over the past few years.  And of course, because we've become accustomed to colleges surviving for long periods even during bad times, the surprise makes people wonder who's next. The meta-answer will surprise you: While we of course feel bad for the people who lose jobs, the students who are displaced, and the community that finds itself dealing with the loss of a respected institution, these trends are small blips in the industry.  In fact, the institutions most likely to close (probably) collectively account for a small fraction of enrollment at America's colleges and universities. Follow along.   One of the challenges in talking about this is

Medical College Admission Data, 2023

This is a reboot of a visualization I did in 2018, which I found fascinating, but which didn't get much traffic at the time, and thus, I've not refreshed it.  But I still find it compelling an instructive. Each year, the Association of American Medical Colleges publishes a lot of data about admission to medical colleges in the US. But frankly, it's a mess, and takes a lot of effort to clean up and visualize: Each link is a separate spreadsheet, and each spreadsheet has spacer rows and merged cells and lots of stuff that needs to be scrubbed (carefully) before analyzing and visualizing.  So, if you use this work in a professional capacity, I'd appreciate your support for my time, software and hosting costs at this link . As a reminder, I don't accept contributions from high school counselors, students, or parents who are using the site.  (And if you know anyone at AAMC, tell them raw data would be much appreciated). There are seven views here, some of which combine

How to IPEDS, Part II

This will be the second part of a series of blogposts about how to use IPEDS, The Integrated Postsecondary Education Data System of the federal government. If you're just starting, I highly recommend you go to the  first post  to bring yourself up to speed on the basics.  If you don't, some of this might not make sense. In that post, I covered several of the ways you can extract simple tables of data for a single year or a single institution; or summary data, including fairly basic and interactive charts when you're looking for something simple.  In this one, I'll go over how to extract custom data over multiple years, and then walk you through the frustrating process of making sense of the output.  Warning: I get a bit cranky about this, because the data formats are largely unchanged since I started doing this perhaps 20 years ago, and they create far more work for the end user than they should. The last post covered the options in italics.  This one will cover the opt

How to IPEDS Part I

Most, but not all, of the data visualizations on this site use data from IPEDS , the Integrated Postsecondary Education Data System.  And all of the visualizations (as I recall) use Tableau , a very powerful data visualization tool, especially for people like me who don't know how to write the code necessary in some software packages. In this post, I'll start with a few of the easiest and quickest ways to get data out of IPEDS.  I'll follow it up with one that dives a little deeper for people who like the raw data for analysis. The question I get asked most often is how I get the information out of IPEDS.  And that's not an easy thing to answer, as I use several of the methods available depending on what I'm doing.  Since you federal tax dollars have not yet been used to create an easy guide to IPEDS, I'm going to give you a primer on how to do the most simple things, and hope you'll do like I did, which is to learn it the hard way through trial and error on

Changes in Bachelor's Degrees, 2010 to 2022

There has been a lot written about the death of the English degree in higher education.  Is it true? Sort of.  But there are other interesting trends in patterns across the country in the past dozen years.  I downloaded IPEDS data from 2010 to 2022 (even years) and created the visualization to show those changes and patterns in bachelor's degrees awarded.  There are six views, and some of them are interactive. The first (using the tabs across the top) shows degrees by the institutions where they're awarded. You can see the college or university sector, region, urbanicity, and Carnegie classification (rolled up into larger segments for clarity.)  You'll see little change: Most degrees are still awarded by public institutions, doctoral institutions, in larger cities.  Hover for details. Over the years, degrees (in first majors) increased about 29% and the second view allows you to see the changes by area (using 2020 CIP codes that cluster degrees in broad areas).  You can see