School District Analysis

Project Overview

School Board members have asked for assistance to make budgeting decisions based on different performance outcomes. Thomas High School's 9th grade class showed evidence of academic dishonesty, therefore these test score data will be removed for this analysis. The following dataframes were used for this analysis.

1. District Summary for all 15 schools.
2. School Summary.
3. Top 5 and bottom 5 schools, based on overall passing percentage.
4. Average math and reading scores by grade for each school.
5. The average scores by:

• Spending per student
• School size
• School type.

Resources

• Data Sources:
  • schools_complete.csv
  • students_complete.csv
• Software: Python 3.7.10, Anaconda 4.10.1

Challenge Results

District Summary:

School Summary:

Top Performing Schools

Bottom Performing Schools

Math Scores by Grade

Reading Scores by Grade

Scores by School Spending

Scores by School Size

Scores by School Type

Summary

1. Thomas high School was among the top 5 high schools in the district:

• 94% of students passed math.
• 97% of students passed reading.
• 91% of students passing overall.

2. The changes done by removing 9th grade scores does not affect the school district summary:

• 75% of students passed math.
• 86% of students passed reading.
• 65% of students pass overall.

3. Schools of similar size and type performed well:

• 94% of medium-sized school(1000-2000 students) students passed math, 97% passed reading, with 90% passing overall.
• 94% of charter students passed math and 97% passed reading, with 90% passing overall.

4. Schools that spent between $630 and $644 per student did not perform as well as Thomas High School:

• 73% of students passed math, while 84% passed reading. 63% of students passed overall.