School_District_Analysis

🏫Learning to use Python Libraries with school district data.

Resources

• Python version 3.8.8
• Anaconda version 4.9.2
• Files used: student_complete.csv and school_complete.csv

Analysis Overview

The purpose of the analysis was to provide a high - level snapshot of the school district's key metrics, math and reading scores. As well as editing scores affected by academic dishonesty from Thomas High School's 9th grade. The information was requested in a table format.

Initial School District Summary

• Top 5 and bottom 5 performing schools, based on the overall passing rate
  • 
  • 
• The average math score received by students in each grade level at each school
• 
• The average reading score received by students in each grade level at each school
• 
• School performance based on the budget per student
• School performance based on the school size
• School performance based on the type of school

Corrected School District Summary

• Top 5 and bottom 5 performing schools, based on the overall passing rate
  • 
  • 
• The average math score received by students in each grade level at each school
• 
• The average reading score received by students in each grade level at each school
• 
• School performance based on the budget per student
• School performance based on the school size
• School performance based on the type of school

Results

All the summaries use only the 10th - 12th-grade math and reading scores for Thomas High School. The "nan" scores of the 9th grade were dropped. Had the "nan" scores of the 9th grade been included, all of Thomas High School's passing percentages would be around 30% lower than those presented here.

• How is the district summary affected?
  • The % Passing Math, % Passing Reading, and the % Overall Passing decreased in the district summary after the ninth grade math and reading scores from Thomas High School were corrected to nan. Image District Summary Comparison shows the values from the initial District summary are in blue, and the values that changed after the correction are in red.
• How is the school summary affected?
  • The corrected school summary shows a decrease in Thomas High School's Average Math Score (down 0.067412), % Passing Math (down 0.2903%), % Passing Reading (down 0.29013%), and % Overall Passing (down 0.317688%). The Average Reading Score showed a slight increase. The image School Summary Comparison indicates the initial scores in blue, the scores that decreased after the correction in red, and the score that increased in green.
• How does replacing the ninth graders’ math and reading scores affect Thomas High School’s performance relative to the other schools?
  • Thomas High School performance was not significantly affected by removing the 9th-grade math and reading scores and only using the 10th - 12th-grade math and reading scores. The school retained its second-place rank in the top 5 schools. The percentage of students passing math was reduced by 0.086481%, and the percentage of students passing reading was reduced by 0.29013%. The overall passing percentage decreased by 0.317688%.
• How does replacing the ninth-grade scores affect the following:
  • Math and reading scores by grade
    • The only change is that the math and reading scores for the ninth grade from Thomas High School show "nan.”
  • Scores by school spending
    • The scores by school spending were not affected.
  • Scores by school size
    • The scores by school size were not affected.
  • Scores by school type
    • The scores by school size were not affected.

Summary

The four major changes in the school district analysis are four decreases in the District Summary and Thomas High School's Average Math Score, % Passing Math, % Passing Reading, and % Overall Passing. Larger changes were not seen in the school district analysis because the only Thomas High School's 9th-grade’s "nan" scores were dropped from the analysis and the analysis still included Thomas High School's math and reading scores from the 10th grades - 12th-grades.