kalkidanalemaye/school_district_analysis

The grades of the ninth graders at Thomas High School have been changed. While administrators do not know the full extent of this academic dishonesty, they want to uphold the standards of state testing. In order to analyze the data correctly, the math and reading scores for that high school will be replaced without removing those ninth-grade students from the analysis.

School_District_Analysis

How is the district summary affected?

• Average math score, % passing math, % passing reading and % overall passing values have decreased after the 9th graders in Thomas High School's grades changed to NaN, however the average reading score did not change.

How is the school summary affected?

• The school summary did not have significant change except in the Thomas High School data. The average math score decreased slightly, the average reading score increased slightly, the %passing math decreased significantly, %pass reading decreased significantly and & overall passing also decreased significantly.

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

• Thomas High School's performance decreased compared to the other schools however, it is not one of the lowest performing schools.

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

Math and Reading Scores by Grade

• The scores have not changed by grade.

Scores by School Spending

• In the cohort $630-644, % passing math, %passing reading and %overall passing have decreased after changing the grades to NaN.
• The other values stayed the same.

Scores by School Size

• In the medium school size: the % passing math, % passing reading and the % overall passing decreased.
• The other school sizes and columns have the same values.

Scores by School Type

• For the Charter school types the % passing math, % passing reading and % overall passing have decrease while the other values and the other type of school did not change.

The image below represents the student dataframe after I replaced the reading and math scores for ninth graders at Thomas High School with NaN.