Monday, October 13, 2014

College and University Enrollment in 2021

The National Center for Education Statistics (NCES) provides a lot of snapshot reports of national education data, but it also produces projections of educational statistics out ten years that can prove useful.  Unfortunately, they're always a couple years behind the curve, so this is from the 2012 report (the 2013 report is out, but only available in pdf format.)

It tells an interesting story of college enrollment that can be helpful as we look into the future.  By 2021, overall enrollment will increase with the US population; it will still be mostly Caucasian students, although that majority will have shrunk; and Hispanics will have overtaken African-Americans as the second largest ethnic group.

If your institution isn't thinking about the future, and especially if your administration is still dominated by people who went to college in the 1960's and 1970's, you should show them this.

Is this a case of everything changing?  Or everything staying the same?  Let me know what you think.



Friday, October 10, 2014

Educational Attainment by Race and Gender

This is a great example of how Data Visualization helps tell a story.

First, take a look at this table of data and tell me what you see.  I know, right?  Not much stands out of a table of black numbers on a white canvas.

Now look below.  It's pretty much the same data (I did not display SME), but it shows you a pattern you see instantly.  This is the percent of people by age who are enrolled in any school, from pre-school to graduate programs.  On the first view, you see the pattern by age group; each line is a gender/ethnic group (white females, Hispanic males, etc.)  Right away, the story jumps out at you.  In very early years, white students are enrolled at greater rates.  From ages 6-15, things even out, then they split again. (Causality, coincidence, or co-variance with data you don't see?)

The view starts with 1995, but use the slider in the top right corner to scroll through the years.  When you do, you'll see the consistency over time is another story element.  We've made some, but not enough, progress in getting non-white kids to stay in school in greater numbers.

Another point: African-American and Hispanic women are more likely to be in school in their early 30's than other groups, especially recently.

The second tab shows females and males by age group over time.  This time, use the slider to change the age category.  What's the story here? Positive trends for almost all groups; but--sorry guys--women are always a couple steps ahead of you.  As it is in life, so it is in education.

What else jumps out at you? I'd love to hear your thoughts.



Friday, October 3, 2014

Where do International Students Enroll in the US?

Here's some more interesting information from the IIE Open Doors Project, but this is not about where US students study overseas, but where students from overseas enroll in the US.  This is pretty simple, actually.

Each dot on the map represents a college or university (hover over for details).  The size of the dot represents the International Student population in 2012, and the color represents the percentage of enrollment at that college or university that is international (that is, on a J-1 or F-1 Visa, presumably; permanent residents are not considered international students.)  The bar charts below show every IHE with both the number of international students (right column) and percentage of all enrollment that is international (on the left.)

You can use the filters to narrow down the IHEs displayed, by choosing the number of international students, the percent international, or the percent of all enrollment that is international.  And you can sort the bar charts by hovering over the small icon that appears when you hover over the top of the bar chart.  Clicks cycle through displays.  The circular arrow at the bottom resets it all.

Note: The IIE data does not break out enrollment by graduate/undergraduate, so I cannot calculate the percentage of undergrads or graduate students who are international.  The only thing I can show is the total international population as a percentage of all students enrolled.



Wednesday, October 1, 2014

Students Studying Abroad from American Universities

Lots of US college students study abroad, and the IIE Open Doors Project has great data about where they go; if you're a member, they graciously make even more detailed data about what colleges and universities they attend.

So I took that data and rolled it (from 2012) into my IPEDS data set (from 2013) to see what jumped out at me.  On this visualization, you can sort the top chart several ways to see who comes to the top of the list: Alphabetically, by the number of students studying abroad, by the percent of all enrollment or the percent of undergraduate enrollment.  Just hover over the top of that column until the small icon pops up, and click on it.  It will sort ascending, descending, and alphabetically with subsequent clicks.

Note, I've taken a few institutions out because they are mostly graduate and thus have undergrad/study abroad percentages off the charts.

The bottom chart is more interesting, I think, for the pattern it shows: For public institutions, a higher percentage of freshman with no institutional aid (full pay) translates into a lower percentage of students studying abroad.  For private institutions, it's just the opposite.  Does that suggest anything to you?

Note: An update.  I was asked how this can show an institution sending 15% of its students overseas while that institution claims 50% of its students do so.  The IIE data is for a single year, and it does include graduate students, so it's not perfect.  Thus, it's possible that 15% study overseas in one year, but over time, half the students at an institution do.


Changes in Degrees Awarded Over Time


As we continue the push to enroll and graduate more students from colleges, it's interesting to look back at trends in degrees awarded, at the Bachelor's, Master's, and Doctoral levels over time.  So, I downloaded data from the Digest of Education Statistics and came up with this.

At the very top level, we see that the number of degrees awarded has increased dramatically since 1970, although of course so has the population: It's up about 51% since 1970, while degrees awarded increased 138%, while bachelor's degrees increased just 113%.  You can't say after looking at those statistics, however, whether we've been successful or not; along with the increase in population comes shifts in age distributions, as well as ethnicity and wealth, all of which affect the likelihood of going to college.

Still, the interesting stuff comes as you scroll across the gray boxes on the top, and drill down by academic discipline: Decreases in English and Education, and increases in business and health professions at the undergraduate level; increases in some narrowly focused programs at the graduate level.

Play around. Filter and click.  What do you find interesting?


Wednesday, August 27, 2014

How much cash does a freshman generate?

No one really likes to talk about revenue in higher education, but we need to be honest. A university is not a charity; professors don't work for free, and the utility company likes to get paid, and you need cash or at least good credit to buy computers and build buildings.

One of the things you think about in my job is net revenue per student.  That is, after all is said and done, how much cash does a student generate?  IPEDS allows us to calculate this using data in the set.

To do so, multiply new freshmen times the tuition to get gross tuition.  Then subtract institutional aid to get net tuition, and divide again by the number of freshmen.  So, if you enroll 200 students at $50,000 tuition, you generate a $10,000,000 gross tuition.  Suppose you award $4,000,000 in aid; you're left with $6,000,000 cash. Divided by 200 freshmen, you come up with $30,000 in net revenue.  Your discount rate is $4,000,000/$10,000,000 or 40%.

This always causes some confusion because people confuse it with net price, but the two are very different. It doesn't matter where the $30,000 in net revenue comes from, at least not from an accounting standpoint. It could be out-of-pocket, it could be from loans, or it could be from state or federal grants.  It doesn't matter because a dollar is a dollar, and it only applies to tuition.

Net price, on the other hand, is the out-of-pocket student cost for total cost of attendance, not just tuition. It's total cost minus grant aid.

Now, onto the visualization.  This shows just under 900 private, four-year universities and the net freshman revenue figures from IPEDS data, which is not always perfectly accurate.  I only used private universities because it's easy to figure out gross tuition, unlike at public institutions where you have different students paying different amounts based on residency.

On the top is a scattergram, showing tuition on the x-axis and net tuition on the y-axis.  The dots represent an institution, with the color being the Carnegie Enrollment Profile, and the size of the dot showing the percent of freshmen with Pell grants.

The bottom chart is a bar-and-whisker chart showing net tuition for each institution.  Click here if you don't know how to read one.  If you want to use the bottom chart as a filter on the top, just click on the label name (New England, for instance).

Hover over any dot for details; hover over the blue and white i box in the top right corner for instructions about interacting.

P.S. A big thank you to Steve Wexler and Jeffrey Shaffer for their help on "jittering" the points in the box and whisker chart.



Monday, August 25, 2014

Where students enroll

It's the end of summer, so this is a quick and easy visualization, showing enrollment in 2013 by institution on a map.  The data is provisional IPEDS data, so it's subject to some corrections, but the overall patterns won't change. It's probably obvious: Most colleges and universities are in populated areas, and so most college enrollment is too. But a few clicks can point out some interesting differences between and among the regions in the US. 

Take a look at the first map, showing the US population. Every county in the country is colored from green (low) to red (high) populations. It should come as no surprise that most of the US Population lives on or in the east coast, the midwest, and the west coast.

Now click on the tab at the top to to see where college students enroll, and you'll see a similar pattern: The orange and purple circles represent four-year public and private, not-for-profit institutions; the size of the circle is the relative enrollment.

You can use the control at the top right to show undergraduate, graduate, or total enrollments, and then you can filter the views down.  Start with New England, for instance, and take note of the color and relative sizes of the enrollment.  Then go somewhere else: The west coast, or the south, and see how the patterns change. Then try the same for graduate, and zoom around the country.

This raises an interesting question: How much of this correlation is due to putting colleges where people are, and how much is due to colleges attracting people to the city, state, or region where they live?


Monday, August 4, 2014

Make Room at the Top

Higher education is obsessed with prestige and institutions are always clamoring to find new ways to make it into the exclusive clubs in which they see their peers: Most selective, most applications,highest test scores, or  biggest capital campaigns, for instance.

Has the top gotten bigger? I looked at IPEDS data from 2004 and 2013, and focused just on those whose numbers say are in the upper echelons of higher education, notwithstanding the limitations of IPEDS data.

Use the tabs across the top to see the Tableau Story Points and see for yourself how the world has changed.The good news might be that if you're a student, there are more "elite" colleges these days; the bad news is that some of them are harder than ever to get into.  And that makes them happy.


Friday, August 1, 2014

2013 IPEDS Admissions Data

My now-annual visualization of IPEDS admissions data is now up.

This is always a popular post, for a lot of reasons: Counselors like to use it as a resource: journalists tell me it helps put things in perspective; and alumni rush to see how their school did last year (admit it, I know you do!)

There are several tabs across the top to show test scores, admit rates, applications received, and other interesting data points. To get the most of it, you must interact, so click a filter to see only a region, or limit the view to schools of a certain size. You won't break anything. If you do, just click the little recycle button near the bottom to reset anything.

IPEDS data is often wrong (more often at small schools with limited or no IR Staff) so take some of this with a grain of salt. And this always involves a lot of typing sans spell-check.

If (when) you see something, let me know. Until then, enjoy.


Monday, July 28, 2014

Where Students in the US were enrolled, 2012

A while ago, I wrote about the wide range of institutions in the US post-secondary education system.  The point I was trying to make was that the prestigious, extraordinarily selective institutions you hear about all the time represent just the top of iceberg when it comes to colleges and universities in the US.

That visualization counted institutions, for the most part.

But another way to look at this is to show where students enroll, and I think this can be equally surprising, and, I hope a bit enlightening.  So take a look at this, again using Tableau Story Boards.  Each gray tab across the top shows the data presented in a different way; keep clicking from left to right to see the interesting tidbits this data reveals to us.

Did you know, for instance, that one out of every eleven undergraduate college students in the US (excluding for-profits) enrolls at a California Community College?  Or that there are no private, not-for-profit colleges in Wyoming? Or that the state with the highest percentage of students enrolled in four-year public universities is...well, you'll have to find that for yourself.

Interact:





Tuesday, July 22, 2014

Changes in Faculty Salaries Over Time

Note: The first version of this had a bug; I forgot to add the "Gender" filter to the final view, so everything was showing up at about 3 times the actual value.  It's fixed now, with a thanks to Tableau Zen Master Allan Walker of Utah State University for catching it. While I was at it, I added a second view to show differences by gender.

The last time I wrote about the salaries of educators, I said I'd never do it again: There were too many people who didn't know the difference between nominal and constant dollars ("No one made $75,000 in 1980!") and those who didn't understand averages ("How could the average in that state be $60,000? I only make $53,000!").

But this is interesting, I think in light of discussions about the rapid increase in tuition over time (in case you've been under a rock recently.)  It shows the changes in average (there's that word again) faculty salaries by rank since 1975, in either nominal or constant (inflation adjusted) dollars.

Compare these changes to this and see what you think:



Tuesday, July 15, 2014

A DataViz Reboot: WICHE Projections of High School Graduates

A while ago, I used Tableau Software to visualize trends in High School Graduates provided by WICHE.  I think it was good, but with Tableau's new Story Points feature (in which you create pages of the story you want to tell) I think it's an even better story.  If you scroll through these points, you can get a sense of how America has become more diverse, and how those changes vary pretty dramatically by region.  That last point, especially, is often lost on people who talk about changing national demographics.

Just like all politics is local, almost all enrollment is too.

So, first, if you want, look at the old version, then take a look at the new visualization below.  What do you think?



Saturday, July 12, 2014

Where do International Students Enroll in the US?

In recent years, Colleges and Universities have turned their focus to International Enrollment as a source of new students. But is that a good idea?  It depends on what type of institution you are, apparently.

This data comes from the Institute of International Education's Open Doors project, and while it's valuable, it still points out the problems with pre-aggregated data.  On the site, you'll find good stuff about students by enrollment level (graduate and undergraduate); you'll find good information about enrollment by institution; and you'll find information like this about enrollment by Carnegie Classification.  But you can only ask one question of each data set.  The result is that this information is intriguing, but not granular enough: For instance, what if I presumed that graduate students would naturally flock to doctoral and research institutions and a) I wanted to test that theory or b)I  just wanted to look at undergraduates to see where they went?

Still. have a look, and especially use the year filters to see percent change over long and short periods.



Wednesday, June 25, 2014

US Post-secondary offerings

If you only read the papers, you'd think US Higher Education consisted of a dozen or so high profile institutions.  But fortunately, there are "more things in heaven and in earth than are dream't of in their philosophy," with all appropriate apologies to Shakespeare.

When I started this blog, it was in response to a new Tableau Software feature I had seen pre-viewed last September, called "Story Points."  In fact, the very title of the blog has a lot to do with that: Believing that data can and should be used to tell narratives that provide people with memorable insight.

This is my first attempt to use Story Points to tell a story; one I hope sticks with people as we think about a pretty amazing selection of post-secondary options for students.  To navigate the story points, just use the grey boxes along the top, and a new chart or dashboard should point the way to insight.


Monday, June 23, 2014

Predicting EFC with One Question

Most everyone who knows anything about our Financial Aid system thinks it needs some improvement.  And almost everyone who actually goes through it, it seems, is astonished by the outcome: They expect me to pay how much for college? And that's just for one year?

For those of you who don't know, all federal financial aid begins with the FAFSA, or Free Application for Federal Student Aid.  It's a form that collects information about income, assets, and family size in an attempt to estimate how much a family should be able to contribute to the cost of higher education.  Should being the operative word.  The figure it calculates--EFC, or Expected Family Contribution--is really a misnomer, sort of like the Peacekeeper Missile.  It's really just an index number designed to estimate federal expenditures on financial aid programs.  Many colleges find it so unreliable that they use another form, such as the College Board's Profile, or their own proprietary form to collect more information.

Many people believe the complexity of these forms causes many low-income students, especially those from immigrant families, to opt out of college.  And a new bill has been introduced in Congress to simply the process, by possibly asking only two questions.

Debate is underway, and you can search it to read about it, but I began to wonder: What if we asked just one question: Parental Adjusted Gross Income.  What is the current relationship between AGI and EFC?

I took about 60,000 records from seven years of freshmen applicant to DePaul data, and plotted them (after I made them anonymous and created a fake ID number).  Then I created a polynomial trend line to fit the data, and added confidence intervals to the lines (well, the software did, anyway.)  Note that only about half of the students who apply for admission fill out a FAFSA.

This is messy, of course, so do this:


  • Try choosing a single year.  Or, if you want to show all years, click on a year in the color legend to highlight that year and gray out the others.
  • Use the filter to limit the range of incomes (it's currently set between $0 and $250,000, since negative incomes are associated with business owners, and almost everyone over $250,000 doesn't qualify for any need-based aid), or include only Pell Grant Recipients. 
  • I don't recommend going below zero.


What do you think?  Could we simplify the process?



Wednesday, June 18, 2014

Bachelor's Degrees by Program and Ethnicity, 2010 and 2011

The previous post, about Doctoral Degrees by Program and Ethnicity, generated a followup question from Jennielle Strother at Seminary of the Southwest about similar data for undergraduate enrollment.  While I couldn't find that exact data, I did find this from the Digest of Education Statistics, showing degrees awarded by race and program, so I spent a half hour to pull it into a visualization.

Some data visualization experts don't like tree maps because it's hard to make precise comparisons of area across distance, but I do like it for this purpose: You can pretty easily see the data in one view with minimal effort, and since precise comparisons aren't vital, you can get a good sense of the lay of the land.

It's also very easy to ask your questions of this chart.  For instance, if you want to see how degrees shook out within a program (like engineering, or English)  you can quickly make those selections and see the results by ethnicity.  If you want to exclude non-resident students, for your analysis, you can. If you want to see what Hispanic students majored in, you can look at all programs but select just"Hispanic" on the ethnicity filter.  Just make your selections in any combination and click "apply" on the filters.  And choose which year you want to look at.





Tuesday, June 17, 2014

Doctorates by Discipline and Ethnicity

A recent article in Inside Higher Education touched on a subject I've written a lot about on my other blog (the one with more words than pictures), specifically the role of standardized tests, in this case the GRE in selection of students for graduate programs.  The article cites another article in Nature blaming the dearth of minority and women doctoral graduates in science and engineering, at least in part, on the GRE.

For anyone who is at least knee-deep in the debate about the value of standardized tests, the arguments are familiar ones: Too much emphasis on the tests means that too many candidates with strong potential are being overlooked, especially when you consider the predictive validity of the tests.  The authors are pretty blunt: " The GRE is a better indicator of sex and skin colour than of ability and ultimate success."

So, in light of that, take a look at this data on 2012 Ph.D. recipients, which was downloaded from the NSF Survey of Earned Doctorates.  The patterns are obvious: The two groups who score the highest on the ACT, the SAT, and the GRE--Asians and Caucasians--dominate the newly minted Ph.D. classes.

And if you assume that there is a need to get minority canididates into faculty roles at colleges and universities to effect change in this area, you see even more cause for concern.  For instance, take a look at the production of African-American Ph.D.s in areas like math or computer science.  When you consider that there are about 2500 public and private degree-granting institutions in this country, you see how unlikely the chances are that things will turn around quickly.


Sunday, June 8, 2014

Yes Education Pays. But maybe not how you think.

You have probably seen the headlines: College graduates make $800,000 more in the course of a lifetime than high school graduates do.  It's statistically correct.  And the conclusion it probably leads many people to is completely wrong.

It's true, of course, as you'll see below, that income increases with every increment of education: A high school graduate earns more than someone who didn't graduate from high school; a person with a bachelor's degree earns more than someone with a high school diploma; and someone with a master's degree earns more than someone with just a bachelor's.  (This is not true for every person, of course, just for groups on average; Bill Gates, whom I'm pretty sure earns more than yours truly with a Master's Degree, never finished college.)

But it's wrong to say that graduating from college is the cause of the income difference. It's true that earning a degree opens new doors to you, and new opportunities for income, but some of that can be explained by the fact that the best students in high school--the ones who are probably likely to earn the most later in life--are also the same ones who go to college.  In other words, the same factors that get you into college are the ones that increase your chances for success.

Still, this visualization tells an interesting story, in four views, via the tabs across the top: On the first view, you can choose your own comparison: Use the filters at the top to select the values for the blue bars and the orange dots, to see the gap between any two education levels.  You can choose men or women, and you can pick inflation-adjusted dollars or nominal dollars.

The second view, Income by Attainment, you see the whole world laid our for you.  Pretty simple, and again, you have some choices to make.

The third view is where it gets really interesting, and where you see the disparity between men and women. This (and all the views) show workers over 25, so some older women may be skewing this, but it's still telling.  And shameful.

Finally, the last view shows how much each step up gains you in income over the last one.  A couple points are annotated for demonstration purposes.

As always, don't just look at these: Interact and explore the data.  And let me know what you find.



Tuesday, June 3, 2014

MOOCs: What Harvard and MIT Data Reveal

If you know much about higher education, you know that Massive Open Online Courses (known as MOOCs) are all the rage.  These courses are open to anyone, anywhere, for free, and promise opportunity for students who wish to learn on their own.  They are exciting in concept, and threaten to turn higher education on its head.

So the recent release of HarvardX and MITX data on MOOCs is exciting.  The data is scrubbed to protect the privacy of the students who took the courses, but still yields a wealth of interesting stuff.  But you must interact.

This dashboard starts with the intro, but has five views you can see by clicking across the tabs at the top. Once on a view, you can limit the data shown by (depending on the dashboard), by gender, education levels of students, home country, or institution, and whether the student registered or completed the course for a grade.  Data are shown by course, age, home country, and institution.

Have fun, and let me know what jumps out at you.



Friday, May 30, 2014

The Diversity of American Higher Education

This is not a post about the diversity of American college students, but rather about the diversity of institutions.

Recently, on a list discussion I subscribe to, someone made a point about non-selective or open institutions in the US: That there were many more of them than you might think.  So that got me thinking about our collective fascination with the most selective colleges and universities.  But even that visualization only looked at four-year, degree granting, freshman-enrolling institutions.  And of course, despite what popular culture might suggest, there are "many things in heaven and on earth that are not dreamt of in your philosophy."

So, this: Just about all of the over 7,000 post-secondary educational institutions in the US, shown a couple of ways: Control (Public, Private not-for-profit, and Private, for-profit: Open- and non-open admissions policies; and bachelor's-awarding or not.

Use the filters at right to select a subset, and you'll see how many institutions and how many freshmen we're talking about; the bottom chart shows by state, in case you're interested in that.

Surprised? You're almost certainly not alone.