UC Stats Admissions for FBHS

Fort Bragg Admissions to UC Stats

By: John Naulty Jr
Date: August 10, 2018
Data from UC Admissions Infocenter

Purpose

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

Analytics

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)

png

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)

png

Admitted Percentage Greater than 80 Percent

Fall Term app_values adm_values perc_adm
0 1994 11.0 9.0 81.818182
2 1996 12.0 12.0 100.000000
3 1997 14.0 12.0 85.714286
5 1999 8.0 8.0 100.000000
6 2000 15.0 15.0 100.000000
7 2001 19.0 17.0 89.473684
8 2002 17.0 15.0 88.235294
10 2004 15.0 13.0 86.666667
11 2005 8.0 7.0 87.500000
12 2006 10.0 9.0 90.000000
13 2007 11.0 9.0 81.818182
14 2008 16.0 15.0 93.750000
15 2009 9.0 9.0 100.000000
16 2010 12.0 11.0 91.666667
17 2011 12.0 10.0 83.333333
22 2016 15.0 14.0 93.333333

Admitted Percentage Less than 70 Percent

Fall Term app_values adm_values perc_adm
18 2012 13.0 9.0 69.230769
20 2014 18.0 10.0 55.555556
21 2015 16.0 11.0 68.750000
23 2017 12.0 6.0 50.000000

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.
            

Steps Forward

Moar Data
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.

Much Pretty
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.

Such Wow
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.

Sharing <3
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.

below :)