Premium project
Analyzing NYC Public School Test Result Scores
Use summary statistics and filters to analyze test scores across New York City's public schools!
Start Project9 Tasks1,500 XP
Loved by learners at thousands of companies
Project Description
Every year, school test results play a role in deciding the fate of millions of students. In America, the SAT is a major part of the college admissions process.
In this project, you will work with a SQL database containing test performance from NYC's public schools.
You will look at how performance varies by borough, identify how many schools fail to report information, and find the top ten performing schools across the city!
Project Tasks
- 1Inspecting the data
- 2Finding missing values
- 3Schools by building code
- 4Best schools for math
- 5Lowest reading score
- 6Best writing school
- 7Top 10 schools
- 8Ranking boroughs
- 9Brooklyn numbers
Technologies
SQL
George Boorman
Analytics and Data Science Curriculum Manager, DataCamp
George is an Analytics and Data Science Curriculum Manager at DataCamp. He holds a PGDip in Exercise for Health and BSc (Hons) in Sports Science and has experience in project management across public health, applied research, and not-for-profit sectors. George is passionate about sports, tech for good, and all things data science.