Corey A. DeAngelis Sends Me Into a Deep Dive on Education

The tweet above links to Mr. DeAngelis’s tweet on twitter. (I’ll discuss the reasons for calling it twitter way down at the end.) Thanks to him for thoroughly documenting his sources. Here’s the graphic linked in Mr. DeAngelis tweet:

School employment Corey A. DeAngelis Sends Me Into a Deep Dive on Education

School employment (from Corey A. DeAngelis, linked above. Click for larger image)

For better or worse, Will Swaim, president of the California Policy Center,  asked me to verify the numbers.  That was the easy part. Here are my calculations.

A screenshot of a table AI-generated content may be incorrect.As you would expect, here’s the link to my Excel workbook.

So here’s how Corey A. DeAngelis sent me into a deep dive on education. This is mainly turning the data into graphs.  First, let’s look at the total numbers of students, teachers, principals, and administrators.  Unsurprisingly, there are far more students.  But note the drop in 2020.  The education system still has not recovered from the COVID insanity.

Students. teachers, principals, administrators

Students. teachers, principals, administrators

So let’s remove students.  It may be mildly surprising to learn there are many, many more teachers than principals, administrators, or the sum of the two.

Teachers, Principals, Administrators

Teachers, Principals, Administrators

Here are the two remaining categories.  More principals than administrators, but the gap is narrowing.

Principals, Administrators

Principals, Administrators

But the real issue is the number of students per teacher.  Until 2020, the ratio remained close to 16 to 1.  But, starting in 2020, that ratio fell to 15.4.  COVID caused the initial hit, but the ratio remains low.

Students/Teachers

Students/Teachers

The students – principals and students – administrators ratios are, naturally, considerably higher.  The student-principal ratio has stayed pretty steady, declining slightly.  This is probably caused by technological improvements.  And, encouragingly, the students-administrator ratio has declined steadily.

Students/Non-Students

Students/Non-Students

Fun stuff.  If you enjoyed this, my Excel workbook has the full tables 203.10 and 213.10.

Now, about twitter.  Elon Musk is obsessed with the letter X.  I do not share his obsession.  And I like posting tweets on twitter.  As a small compromise, I use a lower-case t in the name.

Share if you feel like it

About Tony Lima

Retired after teaching economics at California State Univ., East Bay (Hayward, CA). Ph.D., economics, Stanford. Also taught MBA finance at the California University of Management and Technology. Occasionally take on a consulting project if it's interesting. Other interests include wine and technology.