School-District-Analysis

Overview:

Our friend Maria who is the Chief Data Scientist at a city school district has asked us to help her with the standardised test data for analysis with the focus of our analysis being towards Student funding and student's standardized test scores. Here we aggregate the data and show trends and performance. This analysis will help the school board and super-intendent in making decisions regarding the school budgets and priorities.

Files Used:

schools_complete.csv

students_complete.csv

Results:

District Summary

Original
Updated
Difference:
As we can see clearly from the images above, our scores have slightly dropped as we have removed the 9th grade Math and Reading scores from our calculations.

Per School Summary

Original
Updated
Difference:
As we can see from the images above, Thomas High School values have seen a significant positive change after replacing the 9th grade scores with NaNs. % Passing Math increased from 66.9% to 93.2%. % Passing Reading increased from 69.7% to 97.0%. % Overall Passing increased from 65.1% to 90.6%.

Top and Bottom School Standings

Original Top 5
Updated Top 5
Original Bottom 5
Updated Bottom 5
Difference:
As we can see from the images above, there are very slight changes to the values within a margin of 0.1 to 0.3% approximately, after replacing the values for 9th grade scores for Thomas High School.

Math and Reading Scores by Grades

Original Math	Original Reading
Original Math	Original Reading

Difference:
As we can see from the images above, we have correctly replaced the 9th grades of Thomas High School with NaNs.

Scores by School Spending

Original
Updated
Difference:
As we can see from the images above, the % Passing Reading has seen slight shifts. <$584 has seen a decrease of 4%. $585-629 has seen a decrease of 6%. $630-644 has seen a decrease of 11%. $645-675 has seen a decrease of 15%.

Scores by School Size

Original
Updated
Difference:
As we can see from the images above, there were no changes with the change in our calculations on the Scores by School Size.

Scores by School Type

Original
Updated
Difference:
As we can see from the images above, there were no changes with the change in our calculations on the Scores by School Type.

Summary

• Count of students reduced 12% (461) from 39,170 to 38,709
• % Passing Math increased from 66.9% to 93.2%
• % Passing Reading increased from 69.7% to 97.0%
• % Overall Passing increased from 65.1% to 90.6%