NYCPlanning / db-equitable-development-tool

Data Repo for the equitable development tool (EDDT)
MIT License
0 stars 0 forks source link

Educational outcomes: math proficient #87

Open AmandaDoyle opened 2 years ago

AmandaDoyle commented 2 years ago

Description: percent of 3rd-8th grade students that are math proficient by where students live

Logic:

Source(s): DOE; HPD 2017-2018 WWL data - spreadsheet here

Year(s):

Geographies:

Race and ethnicity breakdown: yes Denominator: total students

SME:

Questions:

Roadblocks: Field name convention: edu_math

levysamu commented 2 years ago

Years: 2018 (nothing newer because of COVID) Race/Ethnicity: confirming with DOE Denominator: We will get percent values directly from DOE and won't be reporting total values (confirming as well)

We also need to add ELA scores (this was a late addition to the data dictionary), but it uses the same data source from DOE.

Cwilliams-1 commented 2 years ago

Columns to be divided -- from 5_StudentPerformance tab in NTA_data_prepared_for_ArcMap_wCodebook spreadsheet in linked folder: AR/AL(All Students); AS/AM(Asian); AT/AN(Black); AU/AO(Hispanic); AV/AP(Other); AW/AQ(White)

https://nyco365.sharepoint.com/:f:/r/sites/NYCPLANNING/civic-engagement-studio/Shared%20Documents/03.%20Working%20Materials/03.%20%20Equity%20and%20Displacement%20Vulnerability/HPD-DCP%20EDDT%20Coordination/02.%20Indicators/EDDT%20QOL%20Indicators/DOE%20WWL%20Data/DOE%20Access%20to%20Opportunity%20Files/DOE%20Clean%20Data/Request%204%20and%205%20-%20Location%20of%20Proficient%20Schools%20and%20NTA%20Outcomes?csf=1&web=1&e=rV6lvK