School District Analysis using Python, Anaconda and Jupyter Notebook.
The purpose of this analysis is to summarize math and reading scores at a school and school district level to measure performance. Factors that weighed into the results were type of school, school spending and size of student population. Concerns were brought forward about Thomas High Schools 9th grade class and therefore those data points were removed in this analysis.
o District summary
The school district summary is a high-level snapshot of the district's key metrics. Omitting the Thomas High Schools 9th grade class scores had very little affect on any of the key district metrics. The overall % went from 65.2 to 64.9.
o School Summary
The breakout by school performance removing Thomas High Schools 9th grade class can be seen below.
o Replacing the ninth graders’ math and reading scores affect Thomas High School’s performance relative to the other schools see the specific detail below.
o How does replacing the ninth-grade scores affect the following:
-Ajusted Math and reading scores by grade are shown below
-Adjusted Scores by school spending are shown below
-Adjusted Scores by school size are shown below
-Adjusted Scores by school type are shown below
-Average scores for math were higher in the Charter schools at 83.5% vs District schools at 77%.
-Similarly, average scores for reading were also higher in the Charter schools with Charter schools at 83.9% and District 81%.
-The % of passing Math was much higher at 94% for the Charter schools vs 67% at the District schools.
-Passing % of Reading was also higher for Charter schools at 97% vs 81% at District schools.
-Overall passing % was 90% for Charter and 54% for District Schools indicating that Charter schools performed better on Math and Reading tests overall.