I got a lot of feedback on my last post where I calculated the admittance rate for every school in Los Angeles Unified’s boundaries. The most common feedback I got was this: Could you calculate other schools outside the LAUSD boundaries?
Sure, why not.
Thanks to a few tips from readers, I was able to crosswalk all the data, and bring you (almost) every school in California’s UC Admittance Data. As a reminder, this number is the total number of students who were admitted to a UC school (as reported by the UC Office of the President) divided by the 12th grade enrollment (as reported by the California Department of Educatiuon)
But I took it a step further.
For the first time, I am going to try to present this data using Tableau, which you will see below. Tableau is a powerful data visualization tool that allows me to display all of the data visually and allows you to compare schools.
DIRECTIONS: To find your school, hover your mouse of the box that says “CDE name” and you’ll see a little magnifying glass. Using that, you can then search for your school. Make sure to uncheck “all” and then check the school you want to see.
You can also select counties so that you can compare within a county. To do this, uncheck “all” in counties and select the county you want to look at. The result will be only your county’s data.
The data is below. For those of you who are email subscribers (and I hope you choose to subscribe!), I am not sure it will work – so you can click here for a full window view.
I was unable to calculate the data for the following schools because of data irregularities:
- The Miguel Contreras Learning Academies (all of them)
- Creative and Performing Arts High School
- San Diego High
- Carson Creek High
- Hamilton Union High
- Washington Union High