Skip to main content
HomeSQL

Project

Analyzing NYC Public School Test Result Scores

Beginner
Updated 12/2023
Use summary statistics and filters to analyze test scores across New York City's public schools!
Start Project for Free

Included withPremium or Teams

SQLData ManipulationProgramming45 minutes9 Tasks1,500 XP8,116

Create Your Free Account

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.
Group

Training 2 or more people?

Try DataCamp for Business

Loved by learners at thousands of companies

Project Description

Analyzing NYC Public School Test Result Scores

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!

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 for Free
  • 1

    Inspecting the data

  • 2

    Finding missing values

  • 3

    Schools by building code

  • 4

    Best schools for math

  • 5

    Lowest reading score

  • 6

    Best writing school

  • 7

    Top 10 schools

  • 8

    Ranking boroughs

  • 9

    Brooklyn numbers

FAQs

    Join over 16 million learners and start Analyzing NYC Public School Test Result Scores today!

    Create Your Free Account

    or

    By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.