jaxwil24/school_district_analysis

An analysis and correction were completed on the data for highschoolers by removing faulty data.

School District Analysis

Overview

• An analysis and correction was completed on the data for highschoolers. Evidence of academic dishonesty led to a reworking of data for performance of multiple high schools, specifically Thomas High School. Code removed the faulty scores and reworked the data to show a more accurate measurement of the schools success.

Results

• The district summary improves slightly in all grading categories. The total schools, total students, and total budget remain the same.

• The school summary is generally the same except for Thomas High School. As a whole, Thomas High School becomes a good school with high passing rates when before Thomas High School was barely passing math or reading.

• Replacing the ninth graders' math and reading scores puts Thomas High School's performance equal to the performance of other schools.

• Replacing the ninth-grade scores does not affect other grades for math and reading.

• Replacing the ninth-grade scores does not affect school spending.

• Replacing the ninth-grade scores affects school size by decreasing Thomas High School. This decrease is the number of students without the 9th grade, making it 461 less.

• Replacing the ninth-grade scores does not affect school type.

Summary

• A change in the school district after reading and math scores for the ninth grade at Thomas High after being replaced with NaNs is the overall scores of Thomas High School. The overall passing rate went up, and the percentage of passing reading and math drastically changed.

• Another change in the school district would be a more accurate reading of how effective Thomas High School truly is. By taking away the dishonest test scores, we are left with an honest look at the performance.

• Instead of changing the scores or student ID to 0, using NaN for the ninth grade Thomas High School allows for a less convoluted look at the data. Understanding NaN helps to clarify when data is incorrect or incompatible.

• Replacing the reading and math scores for the ninth graders at Thomas High School with NaN puts Thomas High School more in line with the other schools from the district.