Fort Bragg Admissions to UC Stats
By: John Naulty Jr
Date: August 10, 2018
Data from UC Admissions Infocenter
I wanted to look at any longitudinal trend in admission rates for Fort Bragg High School students to University of California universities.
I’ve manually downloaded a csv file from the UC Admissions Infocenter, linked above.
I was curious about hearing stories of the top students in the class of 2018 at FBHS not get accepted to many UC’s. What follows is brief outline of what I’ve found so far
What does the data start to look like (post-filtering)
|Calculation1||Campus||City||County||Fall Term||Measure Names||School||Measure Values|
|11||FORT BRAGG HIGH SCHOOL050955||Universitywide||Fort Bragg||Mendocino||2017||Adm GPA||FORT BRAGG HIGH SCHOOL||4.096667|
|17||FORT BRAGG HIGH SCHOOL050955||Universitywide||Fort Bragg||Mendocino||2017||App GPA||FORT BRAGG HIGH SCHOOL||3.832500|
|24||FORT BRAGG HIGH SCHOOL050955||Universitywide||Fort Bragg||Mendocino||2016||Enrl GPA||FORT BRAGG HIGH SCHOOL||4.232000|
Let’s look at a comparison of Applied and Admitted per year
# all uc applied v admitted uc_app_adm_plot=ultimate_sort(uc_all) uc_app_adm_plot.plot.bar(x=fall_term)
What’s the Admission Percentage by year
# percent admitted per year uc_app_adm_plot['perc_adm'] = (uc_app_adm_plot[adm_values] / uc_app_adm_plot[app_values]) * 100 uc_app_adm_plot[[fall_term, 'perc_adm']].plot.bar(x=fall_term)
Admitted Percentage Greater than 80 Percent
Admitted Percentage Less than 70 Percent
Some Conclusionary Thoughts
Putting things in perspective. Out of 24 years there were 16 years where admissions were greater than 80%, and 4 years where admissions were less than 70% Those low admission years are fairly recent. I wonder what the rates and trends are for other high schools. I wonder how Fort Bragg could improve these percentages, or if it's out of any high school's control.
There is a lot more data out there. There are a lot more csv’s to scrape. Documenting and building an automated tool for collecting this data, or contacting the UC InfoCenter and appealing/requesting easier access to the data might be a worthy venture.
It would be great to overlay this with geographical data. To make a heat map of cities, counties, and statewide admission rates per year. This would be a great visualization on it’s own.
of course, I’m a tad bit rusty when it comes to statistical analysis :oh-no-face:
I’d always be interested in getting advice/mentorship/help in the analysis of these data points. I’m curious what this information might tell us about the state of education in California.
For me, that’s an interesting topic. And I would enjoy meeting other like-minded people.
I’m going to a hack event in the morning. So I should share the work I’ve done. I’ll post the github link below.