theidari/schools_performance

Pandas Challenge - UofT Data Analytics BootCamp

^{Pandas Challenge - UofT Data Analytics BootCamp}

| ◰ Overview of Project | ◱ Code | ◲ Results | ◳ Documents & References |

Please let me know your feedback Tnx!

◰ Overview of Project

          This project used python programming language and jupyter notebook to analyze school budgets and priorities and report school performance to the school board and mayor for making strategic decisions based on math and reading scores.

Objective:

⓵ District Summary Create a dataframe to hold: - total number of schools - the total number of students - total budget - average math score - average reading score - passing math score percentage (70 or greater) - passing reading score percentage (70 or greater) - passing math and reading percentage (% Overall Passing) ⓶ School Summary Create a dataframe to hold: - School Name - School Type - Total Students - Total School Budget - Per Student Budget - Average Math Score - Average Reading Score - % Passing Math - % Passing Reading - % Overall Passing

⓷ School Performance - top five (% overall passing) - top five (% overall passing) - table that lists the average Math Score for students grade (9th, 10th, 11th, 12th) at each school - table that lists the average reading Score for students grade (9th, 10th, 11th, 12th) at each school - Score by Spending Ranges (Per Student) / School Size / School Type, include:           * Average Math Score           * Average Reading Score           * % Passing Math           * % Passing Reading           * Overall Passing Rate

Methods and Software:

• The analyses were performed using the Resources dataset.
  
• Following Software and programming language were used in this project:
  • jupyter notebook v.6.4.12
  • Visual Studio v.1.73.1
  • pandas v.1.4.4
  • python v.3.9.13

◱ Code

Code

^{⬆ BACK TO TOP ⬆}

◲ Result

District Summary

The results of 15 schools show that: The total amount of budget is 24,649,428,00 $. and the percentage of overall passing is 65.17, Also passing reading course is easier than math by 85.81%.

_{District Summary}

School Summary

Below table compares 15 schools e.g. type, total students, budget and etc.

_{School Summary}

After Sorting by % overall passing, it shows charter type schools outperform others with more than 90%. probably due to less number of students even though the budget per students are less than district type schools. also in charter schools both math and reading course average are the same and they are uper than 80, but in district school they are not equal and student in this type schools have a weakness in math course with average of 77 and passing rate of 66 %.

_{School Summary Top Performing}

_{School Summary Bottom Performing}

^{⬆ BACK TO TOP ⬆}

Math / Reading Score by Grade

According to the following tables, Math scores are averagely less than the reading scores across schools. Moreover, the math score decreases as the grade increases. However, this pattern is not observable for reading scores.

Math Score by Grade

Reading Score by Grade

Score by School Spending

Results indicate that by increasing Spending the money per student, the Overall average and overall percent decreases across all schools.

_{Score by School Spending}

Score by School Size

Results indicate that increasing the number of students up to 2000 does not affect the students results,but the schools with more than 2000 students significantly affect the performance.

_{Score by School Size}

Score by School Type

Charter schools with an overall passing of >90% significantly outperform District schools with an average of 53%.

_{Score by School Type}

Conclusions

1. Charter schools overall are significantly better than District schools.
   
2. Spending more money does not increase students’ performance in courses.
   
3. It is highly recommended that keep capacity of schools be lower than 2000 students.
   

^{⬆ BACK TO TOP ⬆}

◳ Documents & References

Documents:

Resources Schools Data Students Data

Results Images

References:

^[1] Data generated by Mockaroo, LLC, (2022). Realistic Data Generator.
^[2] Trilogy Education Services, a 2U, Inc. brand.

^{⬆ BACK TO TOP ⬆}