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…

Yes, your yield rate is still falling

In 2015, I wrote this post on falling yield rates.  It was pretty obvious to many of us in the profession that this trend was widespread, and largely driven by a dramatic increase in applications against a more modest increase in actual students who could or would enroll.

It apparently wasn't so obvious to everyone.  Response was much stronger than I thought it would be, and I never had seen so many requests from people who wanted to share it with their trustees (btw, this is public; you never have to ask permission to share).

So I redid it, using trend data from 2005 to 2018.  First a couple of definitions:


Admit rate is the percentage of applicants who were offered admission (admits/applicants).Yield rate is the percentage of admitted students who enroll (enrollers/admits).Draw rate is not commonly known, and I wish I remember who first mentioned it to me in the 1980's.  It stuck with me and is a valuable metric, I think, as we attempt to measure market position.  It's Y…