Skip to main content

College Board AP Data

The College Board recently released data on its AP Exams.  I've downloaded several workbooks already, and of the one I've dug into, I've only been able to get through two worksheets.  The data presentation is clunky (please, agencies, provide un-pivoted data without merged cells and totals and all that stuff, if not by itself, then as a companion), but it reveals some interesting patterns.

Well, I think so.

I've visualized it in five views: The source of the data is here, in case you want to download it yourself.

View 1, Totals (using the tabs across the top) is just totals: Use the controls to show males or females, or certain scores, or certain exams.  I think it's very compelling, especially if you look at the high scores the College Board claim about AP opening access to selective institutions.

View 2, Scores by Ethnicity and Exam, shows score distributions of the four largest ethnic groups.  Filter by a single exam if you'd like.

View 3, 100% Stacked Bars, shows the same data, presented by ethnicity.  Again, filter to a test if you'd like.

View 4, Mean Scores by Ethnicity and Exam, arrays all tests, and breaks out mean scores (yes, I know you shouldn't take averages of string variables.  So sue me).  Use the highlighter if you'd like to make any of the groups stand out visually, and filter by gender if you'd like.

View 5, Mean Scores by Gender and Exam, shows the differences between males and females. Filter to a single ethnicity if you'd like.

Tell me what you see.  Does this change your perspective on the College Board claims, or does it strengthen them?  Does it help you make up your mind?

I'd love to hear.


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…