Skip to main content

Staffing in Public Schools in the US, 2011

A while ago, I found some interesting NCES data on teacher salaries over time Teacher Salaries; it quickly became the most popular (currently 34,000 views) and the most contentious piece I'd ever posted, and months later, it's still getting hundreds of hits a week.  I simply found the data interesting, and wasn't making any sort of political statement.  I vowed at that time to never post about teachers again, so of course I'm breaking that rule today.

This is from the 2011 Common Core of data, showing all personnel in each state who work in public primary and secondary education.  Click here to see the data table and read all the footnotes, especially if you want to argue.

There are many things that can explain this data: States that have mostly urban areas (like California and New York) are likely to have bigger schools and classrooms, and thus fewer teachers per student.  Different states with similar populations may have more district administrators if they manage schools locally, or fewer if they do it in bigger geographies (by county, for instance.)

I added a couple data pieces to the table: First, the 2010 census data of the population under 18, which is not a perfect proxy for public school enrollment, but it's probably close enough.  I used Data Ferret to extract the data, and used those figures to compute the ratios (students per teacher, for instance.)  Again, a state with a younger population (more in elementary schools) might have fewer students per teacher than one with an older population (more in secondary schools).

Second, I downloaded 2012 election results, to see if data might sort out by Republican and Democrat states.  I'm pleased to say they generally don't, as I suspect that might avoid more colorful "discussion" on the topic.  The colors are applied to all but the top tab; Republicans in red and Democrats in blue.

There are four views, with the tabs across the top.  If you want to sort any of this data by any column, just hover over the x-axis labels at the bottom and click on the little bars icon to the right of the text.


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…