Skip to content

Use Jupyter Notebook to analyze test scores in a school district and provide useful insight.

Notifications You must be signed in to change notification settings

delacruzfranklyn93/District_Test_Analysis

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 
 
 
 
 

Repository files navigation

Does where you go to school matter?

Summary:

The purpose of this project is to analyze district-wide standardized test results, aggregate data, and showcase obvious trends in school performance. The data is in the form of 2 separate CSVs that can be found in my resource’s directory. I used Jupyter Notebook and Pandas to read in the CSVs and merge them so that I had a complete dataset in the form of a data frame that I will use for the analysis.

Observations:

After analyzing the school district I have concluded that where you go to school truly does matter when it comes to standardize test results. Charter schools outperformed district schools with 90% of students passing while only 53% passed in district schools, so you are more likely to pass if you went to a charter school. Not only does the type of school you go to matter, but also the size of the school that you attend. Schools that had less than 2,000 students had 90% of its students pass. What I found most surprising is that schools with a higher per student budget, did not necessarily perform better. The schools that performed better had the lowest per student budget. So, in conclusion, if you wanted a higher chance of performing well on the standardized tests then I would attend a charter school that had less than 2,000 students.

District Summary: Overall the district did not do too well with only 65% of the students passing the math and reading test.

image

Top 5 Performing Schools: (By % Overall Passing): Below you can see the top 5 performing schools and it is interesting to note that all the schools are charter schools. We can also note that the number of total students is quite low compared to the district schools which makes sense as charter school typically have less students.

image

Bottom 5 Performing Schools (By % Overall Passing): Below you can see the bottom 5 performing schools and it is also interesting to note that all the schools are district schools. We can also note the number of total students is rather high.

image

Scores by School Spending and Size: Below you can find scores grouped by the spending and the size of the schools. What we find is that having more money to spend per student does not necessarily lead to higher test scores. The schools with less than $585 per student performed the highest amongst those that had a higher per student budget. When it comes to the school size, it seems that anything above 2000 students can drastically reduce your test scores.

image

image

Scores by School Type: Below you can find the scores by school type. There is a major difference in overall % passing of charter schools and district schools.

image

About

Use Jupyter Notebook to analyze test scores in a school district and provide useful insight.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published