School District Analysis

Table of Contents

1. Overview of the School District Analysis

• Purpose

2. Results

• How is the district summary affected?
• How is the school summary affected?
• How does replacing the ninth graders' math and reading scores affect Thomas High School's Performance relative to the other schools?
• How does replacing the ninth-grade scores affect the following:
  • Math and reading scores by grade
  • Scores by school spending
  • Scores by school size
  • Scores by school type

3. Summary

• Four changes in the updated school district

1. Overview of the School District Analysis

Purpose

The school board notified Maria and her supervisor that there is evidence of academic dishonesty amongst the ninth graders in Thomas High School in regards to their reading and math grades being altered. Our goal is to replace their grades with NaNs while keeping the rest of the data intact and to run this modified data again to see how these changes affected the overall analysis.

2. Results

How is the district summary affected?

We see through our code that there is a total of 39,170 students amongst the district and there were 461 students from the ninth grade who attend Thomas High School that we will omit from the analysis, which leaves us with 38,709 students. Even with the omitted students, the amount of students in the district is still quite large so there was little change to average in their math and reading grade analysis.

How is the school summary affected?

As opposed to the district summary, there is a stark difference in the school summary due to there being a smaller sample size. There is originally 1,635 students who attend Thomas High School and now we are taking away 461 of them out of the analysis. This caused a much bigger discrepancy as we can see by the % passing math, % passing reading, and % overall passing. (Grade 9 to 12 shown above) (Grade 10 to 12 shown above)

How does replacing the ninth graders' math and reading scores affect Thomas High School's Performance relative to the other schools?

As we replace the Thomas High School ninth graders' math and reading scores with NaNs we can see that the % passing math, % passing reading, and % overall passing are much higher. Thomas High School in comparison to the other schools was hovering over the bottom in terms of performance but now they have the second highest overall passing percentage.

How does replacing the ninth-grade scores affect the following:

• Math and reading scores by grade
  • Only the ninth grade math and rearding scores were affected. The average scores for ninth graders in Thomas High School were 83.728850 for reading and 83.590022 for math. The average of all the ninth grade scores went down since we are omitting the scores from the Thomas High School ninth graders.
  • First image is the Math Scores. Second image is the Reading Scores.

• Scores by spending range
  • As we can see from the pictures below there is a slight change in the scores in the $630-644 range. This change was not visible when we rounded the numbers because of it's slight change.
  • First image includes the ninth graders in Thomas High School. The second image does not.

• Scores by school size
  • As we can see from the pictures below there is a slight change in the scores in the Medium school size range. This change was not visible when we rounded the numbers because of it's slight change.
  • First image includes the ninth graders in Thomas High School. The second image does not.

• Scores by school type
  • As we can see from the pictures below there is a slight change in the scores under the charter category. This change was not visible when we rounded the numbers because of it's slight change.
  • First image includes the ninth graders in Thomas High School. The second image does not.

3. Summary

Four changes in the updated school district

• When we took out the ninth graders scores in Thomas High School we noticed a couple of changes. Within Thomas High School, the percentage of students that passed math, reading, and overall were all incresed significantly. This brought Thomas High School to the second highest overall passing percentage in the whole district.
• Thomas High School also affected the average in scores to ninth graders across the district. Their score average in math and reading were on the higher end across the ninth graders in the district so when omitting their scores the average scores of the ninth graders in the district has dropped.
• Thomas High School was in the category of student spending range of $630-644 and a medium school size. In the updated school district analysis we see the percentage of students passing math, reading, and overall has dropped by a small percentage. We initially formatted the data to a more rounded number but this made it harder to see the difference in the analysis so we went back to see the changes.
• If we were comparing the types of schools then district schools' average was not affected. However, Thomas High School is a charter type school so it did have an affect on those. The passing percentage of students who attended charter schools has decreased slightly.