Educational outcomes: ELA

[AmandaDoyle]

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

WWL Figure 5.75. Use WWL data for EDDT launch. DOE will supply annual data for future years.Cannot report last two years because of COVID. Waiting on link/folder of that data from DOE

Logic:

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

Year(s):

• [ ] 2017/2018

Geographies:

• [ ] PUMA
• [ ] Borough
• [ ] City

Race and ethnicity breakdown: Yes Denominator: total students

SME: Chad

Questions:

Roadblocks: Field name convention: edu_ela

[Cwilliams-1]

Columns to be divided -- from 5_StudentPerformance tab in NTA_data_prepared_for_ArcMap_wCodebook spreadsheet in linked folder: H/B(All Students); I/C(Asian); J/D(Black); K/E(Hispanic); L/F(Other); M/G(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

[td928]

@Cwilliams-1 Hey Chad is the right understanding that this is reported on NTA level instead of PUMA and we are not doing any translating for geographies?

if I am looking at the correct worksheet which Chad posted above, the data is for 4th grade only based on the column names for the education outcome except the chronically absent which is for grade 3-8. Am I missing something there?

Also @AmandaDoyle if you have any insights on those two questions

[td928]

@AmandaDoyle My bad. I now see that there are columns for just 4th grade and the other ones I assume are for 3rd to 8th grade.

Question for NTA vs PUMA remain

[AmandaDoyle]

@td928 The spreadsheet Census Tract/ NTA/PUMA Equivalencies from here has the crosswalk between NTA and PUMA. This spreadsheet should def be incorporated into a workflow as it will be reused. We are reporting data at the PUMA, Borough, and citywide level.

Values for NTAs that roll up into the same PUMA will need to be summed.

[AmandaDoyle]

@td928 regarding field names, using the wiki as a guide, the field name for this indicator could be education_ela_pct
education_ela_pct_wnh education_ela_pct_bnh
etc. cc @NYCPlanning/data-engineering for input