The purpose of this project is to analyze the district-wide standardized test results of students in PyCity, an imaginary city, to help the school board and mayor make strategic decisions regarding future school budgets and projects. The data includes every student’s standardized math and reading scores, as well as various information on the schools they attend. The project explores district, school, subject, and budget-wide trend in order to assist with future decision making.
A quick snapshot of the raw DataFrame:
District Summary:
School Summary:
Highest Performing Schools by % Passing Both Subjects:
Lowest Performing Schools by % Passing Both Subjects:
Math Scores by Grade:
Reading Scores by Grade:
Summary by Budget Category:
Summary by Size Category:
Summary by School Type:
- Top 5 performing schools as measured by % passing both math and reading are all charter schools, with the total number of students and budget below the district average. The statistical significance of the difference is subject to further testing.
- Top 5 performing schools as measured by % passing both math and reading have test scores above the district average. The statistical significance of the difference is subject to further testing.
- Bottom 5 performing schools as measured by % passing both math and reading are all district schools, with the total number of students and budget above the district average. The statistical significance of the difference is subject to further testing.
- Bottom 5 performing schools as measured by % passing both math and reading have test scores below the district average. The statistical significance of the difference is subject to further testing.
- Schools in the lower budget per student category have higher subject scores. The statistical significance is subject to further testing.
- Schools in the higher budget per student category have lower subject scores. The statistical significance is subject to further testing.
- Schools with small student population (less than 2,000) on average have higher test scores. The statistical significance is subject to further testing.
- Charter schools on average have higher test scores. The statistical significance is subject to further testing.
** The general trend is that charter schools that on average have smaller student population have higher math and reading scores compared to district schools. Charter schools also spend on average less budget per student. Further study is required separate the effect of school types from that of the population on students' performance. It is also important to explore if there are any other factors related to charter schools that are affecting students' performance. Before these studies are performed, it is recommended to be cautious before making strategic decisions on budgeting. **
