Maria asked me to re-analyze the school districts test scores after the first analysis showed evidence of 9th grade math and reading scores being falsified. The following analysis will report on how removing the falsified scores affected the overall analysis of math and reading test scores for the district, schools, and grade levels.
Removing the Thomas High School ninth grade scores didn't affect the district summary very much. The Thomas High School 9th grader count is 461, which is only 1.2% of entire school district.
School summary before THS 9th grade scores were removed
School summary after THS 9th grade scores were removed
As you can see, Thomas High School remains as the school with the second highest overall percentage passing, however, removing the 9th graders scores decreased the overall passing percentage by 0.32%. With a School that has 1,635 students, that is a decrease in 52 students passing vs not passing. The average reading score increased by 0.047152 points and the average math score decreased by 0.067412 points for Thomas High school.
- How does replacing the ninth graders’ math and reading scores affect Thomas High School’s performance relative to the other schools?
Thomas High School remained as the school with the second highest overall passing percentage when compared to other schools.
Before 9th grade THS scores removed
After 9th grade THS scores removed
9th grade student averages for the school district went from:
- 9th grade reading average: 82.513
- 9th grade math average: 80.352
to
- 9th grade reading average: 82.426
- 9th grade math average: 80.120
By removing the Thomas High School scores, the average math and reading scores for 9th graders in the district both decreased.
Before 9th grade THS scores were removed
After 9th grade THS scores were removed
Spending by school was unaffected by this analysis. Thomas High School's budget per student was not changed by this analysis, only the average test scores and passing percentages.
Thomas High School is a "Medium" sized school. When comparing averages and grouping by school size, removing the 9th grade scores from Thomas High School did not affect the averages when grouped by School Size.
District Summary before removing 9th grade THS scores
District summary after removing 9th grade THS scores
As you can see in the above before and after visualizations of the district summary, there was little change after removing the 9th grade Thomas High School math and reading scores. Thomas High School is a Charter school, so we would be looking for an increase or decrease in the passing percentages, or average scores for the Charter Schools. The overall math_score average decreased by 0.008 and the reading_score average increased by 0.006 after the Thomas High School 9th graders were removed from the analysis. The overall passing percentage for Charter schools decreased by 0.04%.
Summary: Summarize four major changes in the updated school district analysis after reading and math scores for the ninth grade at Thomas High School have been replaced with NaNs.
In summary, removing the reading and math scores of the 9th grade Thomas High School Students from the School District Analysis affected the percentages of students passing reading, math, and overall passing percentage for Thomas High School. It didn't affect Thomas High School's standing when compared to other schools, but it did affect the school's passing percentage by 0.32% which results in a decrease of 52 students passing for a school that size.
Removing the Thomas High School reading and math scores also decreased the average reading and math scores for the 9th grade cohort for the district by 0.09 (reading) and 0.232 (math).