Skip to main content
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 Project
9 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

  1. 1
    Inspecting the data
  2. 2
    Finding missing values
  3. 3
    Schools by building code
  4. 4
    Best schools for math
  5. 5
    Lowest reading score
  6. 6
    Best writing school
  7. 7
    Top 10 schools
  8. 8
    Ranking boroughs
  9. 9
    Brooklyn numbers

Technologies

SQL SQL

Topics

Data ManipulationProgramming
George Boorman Headshot

George Boorman

Core Curriculum Manager, DataCamp

George is a Core Curriculum Manager at DataCamp. He has experience in project management across public health, applied research, and not-for-profit sectors. George is passionate about health technologies and all things data science.
See More

What do other learners have to say?

I've used other sites—Coursera, Udacity, things like that—but DataCamp's been the one that I've stuck with.

Devon Edwards Joseph
Lloyds Banking Group

DataCamp is the top resource I recommend for learning data science.

Louis Maiden
Harvard Business School

DataCamp is by far my favorite website to learn from.

Ronald Bowers
Decision Science Analytics, USAA