mfairbro1 / school_district_analysis

Evaluating school performance based on standardized test results

School_District_Analysis

Overview

The purpose of this analysis is to investigate the performance of a number of schools, based on standardized test results, in order for the school board to make decisions about budget allotments.

At one school in particular, Thomas High School, there is evidence of academic dishonesty. The reading and mathematics scores for 9th graders from the school have seemingly been altered. The altered scores must be replaced by NaNs before conducting analysis. We must then compare the results of this new analysis with the results of the original analysis before evidence of academic dishonesty was discovered.

Results

• In the district summary, the overall results do not change a great deal. We can see that the "Average Reading Score" remains unaffected and the other metrics drop by only a few tenths of a percentage point in the new analysis.

Original

New

• In the school summary, the averages and percentages decrease slightly in the new analysis for Thomas High School. The averages decrease by a few hundredths and the percentages decrease by a few tenths of a percentage point.

Original

New

• Despite the replacement of the 9th grader scores, the school overall retains its standing relative to other schools.

• Replacing the 9th grade scores simply changes the 9th grade scores in the "scores by grade" with NaN. The scores by school spending decrease slightly after the replacement, however the "Average Reading Score" slightly increases (this is in the $631-645 range):

Original

New

• Looking at "scores by size", we can see that every metric decreases in the medium sized school category, which Thomas High School falls under:

• If we look at "scores by type", we can see that again we have an overall decrease across all metrics for charter schools in the updated analysis. However, we do see a slight increase in "Average Reading Score":

Original

New

Summary

In the district summary, we see a slight decrease in all metrics except for the "Average Reading Score", which remains the same. In the school summary, we see another slight decrease across all metrics for Thomas High School. The 9th grade score in "scores by grade" is replaced with NaN for Thomas High School. In "scores by type" we see an overall decrease in the metrics, and a slight increase in "Average Reading Score" for charter schools.