Exploring College Readiness in NYC High Schools

Data Resourses

For the Final Project, there was a total of four resources used in the project: “2019 - 2020 School Point Locations”1., “2014-15 to 2017-19 NYC Regents Exam Results”2, “2013-2019 Attendance Results - School”3, and New York City Borough GeoJson Data4. The first three data sets are from Open NYC Data and the GeoJson Data is from Code from Germany, all for public use The parameters of linking the three Open NYC data were by the school’s DBN number, which was universal across all sets and the school year.

Data Handling

For the Regents data, the college readiness percentage was available as the marker of overall performance rather than a combination of regents scores across multiple subjects. The formula for college readiness takes the college readiness count divide by the total testing count. The time range set for this collection is between 2015-2019. In order to match the testing scores and attendance, any school year took its second half year. The overall attendance was calculate by its days presents over its total days. For the visualization, the data sets combined by the school’s borough, the overall attendance average by borough, and the testing year.

Data Exploration

The choropleth map displays the college readiness rate for the five boroughs by the year of the score and its attendance range. The density of the borough is calculated by the combination of year, attendance range, and its borough. In the analysis, the overall attendance and schools with an attendance of 90% or higher saw differences in college readiness rates above 20%. For example, schools in Manhattan with high attendance rates were 38% higher compared to the overall average (0.53 vs 0.77). This stark difference in the readiness score may signify a correlation between high attendance and the student’s ability to succeed in college. The visual can help educators create a plan for encouragement toward students’ attendance at their borough’s schools. The improvement plan can look like an overall attendance goal of 85% and above for a school year and analyze the college readiness score after the results return.

## Preparing to deploy application...DONE
## Uploading bundle for application: 9091705...DONE
## Deploying bundle: 7207461 for application: 9091705 ...
## Waiting for task: 1299646024
##   building: Parsing manifest
##   building: Building image: 8566913
##   building: Installing system dependencies
##   building: Fetching packages
##   building: Installing packages
##   building: Installing files
##   building: Pushing image: 8566913
##   deploying: Starting instances
##   terminating: Stopping old instances
## Application successfully deployed to https://vyluvsshiny.shinyapps.io/d608_final/

  1. https://data.cityofnewyork.us/Education/2019-2020-School-Point-Locations/a3nt-yts4↩︎

  2. https://data.cityofnewyork.us/Education/2014-15-to-2017-19-NYC-Regents-Exam-Results-Public/bnea-fu3k↩︎

  3. https://data.cityofnewyork.us/Education/2013-2019-Attendance-Results-School/vww9-qguh↩︎

  4. https://github.com/codeforgermany/click_that_hood/blob/main/public/data/new-york-city-boroughs.geojson↩︎