This repository contains python code in a Jupyter notebook for performing analysis on school performance by various data elements available in the CSV files provided.
The following is the resulting analysis:
PyCity Schools Analysis
Schools in PyCity have wide range of achievement in reading and math. An analysis of the schools found variances in school type, school size, budget per student.
-
The data showed that higher spending per student was not correlated with higher achievement. The schools with the least spending per student had a 90% overall passing rates, whereas schools with the highest spending per student had the lowest overall passing rates, averaging only 53%.
-
Larger schools fared worse than smaller schools. Schools with fewer than 2000 students had an overall passing rate of 90%, whereas larger schools averaged a 58% passing rate.
-
Charter schools had higher passing rates than district schools, as well – with 90% of the charter students passing vs. 54% of the district schools passing.
One might look at this data and conclude that smaller charter schools with less spending have better outcomes. However, further analysis is required, because none of the schools showed appreciable changes in reading or math test scores for students as they progressed from 9th through 12th grades. If one category of school was appreciably more or less effective, one would expect to see student achievement either improve or degrade over the 4-year period.
Please note the following table showing the average reading scores by grade, as an example:
9th 10th 11th 12th
Pena High School 83.63 83.37 84.33 84.12
Shelton High School 83.42 82.92 83.38 83.78
Wright High School 83.26 84.01 83.84 83.64
Thomas High School 83.59 83.09 83.50 83.50
Griffin High School 82.04 84.23 83.84 83.36
Cabrera High School 83.09 83.15 82.77 83.28
Wilson High School 83.09 83.72 83.20 83.04
Holden High School 83.79 83.43 85.00 82.86
Rodriguez High School 76.86 76.61 76.40 77.69
Huang High School 77.03 75.91 76.45 77.23
Hernandez High School 77.44 77.34 77.14 77.19
Figueroa High School 76.40 76.54 76.88 77.15
Johnson High School 77.19 76.69 77.49 76.86
Bailey High School 77.08 77.00 77.52 76.49
Ford High School 77.36 77.67 76.92 76.18