Skip to main content

A Fresh Look at the New WICHE Data

Note: You should view this on a tablet or desktop.

The Western Interstate Commission for Higher Education (WICHE) has just published the 9th version of "Knocking on the Door," a look at demographic projections of high school graduates in the US.  And several organizations have already published interesting views of the data, like this one on the WICHE site and this one on Hechinger Report.

As I make my case for more self-service BI, these are great examples of what I call the 80/80 rule: Eighty percent of what an analyst will give you is not what you need as a practitioner; and 80% of your questions won't be answered when someone else does the analysis for you.  So I took the data (and allow me to complain a little bit about putting data for 50 states and DC in 51 worksheets in an Excel workbook, WICHE) and spent a lot of time restructuring it for analysis.  Then I started asking my questions, and came up with 6 views, in an attempt to provide practitioners maximum flexibility. On most of these, you can change start dates, end dates, states, regions, and ethnicity. Even after a couple of hours on this, I could have come up with 60 views, but my spare time is, of course, limited.

Overview:

I started with two high level questions.  The first is: What's going on at a macro level?  And thus this. The gray bars show total numbers of public high school graduates between 2000-01 and 2031-32; the lines break out those numbers by ethnicity.   So when your trustees ask about these numbers you can (but I wouldn't) say, "It looks like 2017 will be the low water point for at least eight years.  It's good news going forward."

Because if I were you, and before I talk to your trustees,  I'd want to know why lies underneath the macro trends, and thus my second question: How the changes look related to different ethnic groups: Take a look instead at the colored lines, showing break outs by ethnicity:  As I've written before, ethnicity matters because ethnicity and income and parental attainment all go together. The two groups that attend college at the greatest rates are showing shrinking populations (White students) or modest changes in numbers (Asians, growing at less than 20,000 by 2024.)

But wait.  Suppose you're in New York, or California, or Florida.  In all probability, your enrollment demographics are shaped more by what happens 500 miles from campus than 3,000. And Illinois? We've pretty much seen the best we're going to see until after I retire. So interact, and use those filters to get the view you want.

Tidbit: The population of White graduates peaked almost ten years ago.  And Hispanic populations will peak in 2024 after a long, steady, impressive increase since 2000.

View 1: National Overview

Issues of Control: 

It never fails: When I do the data on public high school graduates, someone asks about private schools. WICHE has included that data this year, and it's, well, sort of boring. The numbers are falling almost everywhere, and as a percent of the whole, are not keeping pace.  As you might expect, private school enrollments are a bigger thing in New England than elsewhere. (These data are not available by ethnicity.)

Tidbit: When a super-selective college brags that 60% of its students are from public schools, you can now understand that what they're really saying is private high school graduates are over-represented in their student body by a factor of five.

View 2: Public and Private



Digging down: The last four views (using the tabs across the top)

Now it gets a little more fun: Four ways to look at change over time.  In my business, knowing what's coming is very important; we have about an 18-year window on our markets, and no one's going to allow you to claim you were surprised.

I've become a fan of Hex Maps, to allow visualization of data on a choropleth map. It's never been easy to color-code on traditional state maps because Rhode Island and Delaware are so small, and Alaska and Hawaii are so far out there.

This map view allows you to see change over time (any two years you choose) by state; to show it for all public high school graduates, or just certain ethnicities, and to show numeric change or percent change.  I'm guessing you'll want to use this one a lot in strategic planning groups; it's my favorite.

Tidbit: Michigan. Notice how it stands out; that's a surprise to me.

Click to the next tab on the top, and you get the view for those who like bar charts.  You can still specify change between any two years, but this data is broken out by ethnicity. You can specify region or single state.

Tidbit: I was expecting bigger drops in New England, but no matter which years I focus on, the drop is smaller than I expected.  You?

The third tab is similar, but line charts over time.  It shows all ethnicities, allows  you to specify the years, and shows both numeric and percentage change from the first year chosen (be careful; these are not numbers, but rather changes).

Tidbit: Although Texas and California have seen dramatic increases in numbers of Hispanic graduates, it's Asian students in both states who will grow at the fastest rate between now and 2031.

Finally, the final view shows regions of the US, and the composition of the high school graduating class by ethnicity.

Tidbit: Pull the slider to show the changes over long periods.  Note how fast some regions (Far West, Southwest) change, and how slowly others don't (Plains, Rockies.)  Those last two regions will still be more White in 2032 than the whole US was in 2001.  And notice the relative stability of African-American high school graduates over time, as a percentage of the total.

Views 3-6: Changes over time

If you use Tableau, and  you want to download this workbook in its entirety, I can share it with you; I'll also be happy to send you the data in a much more accessible database format suitable for your own analysis.

I'd love to hear what you see on these visualizations or on your own analysis.  Leave a comment below.


Comments

Popular posts from this blog

Another 1000 Words and Ten Charts on First-generation, Low-income, and Minority Students

I have always enjoyed writing, and I consider this and my other blog like a hobby.  Usually, I spend no more than 45 minutes on any post, as I don't make my living by writing, and my blogs are not "monetized." But once in a while, an opportunity presents itself to write for a wider audience, and that's when I see what it takes to make a living putting words to paper. That happened this week.

You may have seen my opinion piece in the Chronicle of Higher Education. If not, you can read it first, read it last, or not at all; I think both this and that stand alone, despite their relationship.  In the end, we ended up with about 40% of my first draft, which is what happens when you write for a print publication. And of course, a print publication makes interactive charts, well, difficult.

I think there is more to say on the topic, because the similarities in recruitment challenges for first-generation, low-income, and minority students tend to look a lot alike, and the mo…

2018 Admissions Data

This is always a popular post, it seems, and I've had a couple of people already ask when it was going to be out.  Wait no more.

This is IPEDS 2018 admissions data, visualized for you in two different ways.  You can switch using the tabs across the top.

The first view is the universe of colleges and universities that report data; not every college is required to, and a few leave data out, and test optional colleges are not supposed to report test scores.  But IPEDS is not perfect, so if you find any problems, contact the college.

On the first view, you'll see 1,359 four-year private and public, not-for-profit institutions displayed.  In order to make this as clean as possible, I've taken out some specialty schools (nursing, business, engineering, etc.) as many of those don't have complete data.  But you can put them back in using the filter at top right.

Hover over any bar, and a little chart pops up showing undergraduate enrollment by ethnicity.

You can also choose to…

Changes in Bachelor's Degrees, 2011-2017

This will probably be the final post in Higher Ed Data Stories for a while.  As you may already know, I'm leaving DePaul for the "best coast" to take the position of Vice Provost of Enrollment at Oregon State University, effective July 1.  Thus, I'll be in personal and professional transition for a while, and once I arrive, I'll be busy learning a new institution and working on new challenges that should keep me occupied for a while. (Additionally, I'm not sure what my Tableau situation will be like...)

As you may already know, HEDS got its start when I decided to revise and share work I was already doing in my job at DePaul. Much of it, I presumed, would be of interest to university colleagues and high school and independent counselors.  But I had no idea how many people craved information like this.

So, for now, here is information about bachelor's degrees earned in 2011, 2014, and 2017, the most recent available in the IPEDS data center.  It's pres…