usds / justice40-tool

A tool to identify disadvantaged communities due to environmental, socioeconomic and health burdens
https://screeningtool.geoplatform.gov/
Creative Commons Zero v1.0 Universal
133 stars 42 forks source link

Update wording & thresholds on side panel and methodology for higher ed and high school degree #1441

Closed BethMattern closed 2 years ago

BethMattern commented 2 years ago

Purpose

Modify copy to corresponding to flipping some indicators.

Higher ed enroll card

From this

Screen Shot 2022-03-24 at 7 02 26 AM

To this

Screen Shot 2022-03-28 at 1 53 37 PM

Copy

Higher education non-enrollment
Percent of people 15 or older who are not currently enrolled in college, university, or graduate school.

Used in: All categories 
Responsible party: Census 

Source: American Community Survey      from 2015 - 2019
Available for: All U.S. states, the District of Columbia, and Puerto Rico

Tasks

High school attainment card

From this

Screen Shot 2022-03-24 at 7 07 21 AM

To this

Screen Shot 2022-03-28 at 1 55 11 PM

Copy

High school degree non-attainment
Percent of people age 25 years or older in a census tract whose education level is less than a high school diploma.

Used in: Training and workforce development methodology
Responsible party: Census

Source: American Community Survey   from 2015-2019
Available for: All U.S. states, the District of Columbia and Puerto Rico

Source: American Community Survey   from 2010 
Available for: American Samoa and the Northern Mariana Islands

Tasks

Training and Workforce card

From this

Screen Shot 2022-03-24 at 7 11 54 AM

To this

Screen Shot 2022-03-28 at 1 56 14 PM

Copy

Training and workforce development
Communites are identified as disadvantaged in this category
IF at or above the 90th percentile for median income as a percent of area median income OR linguistic isolation OR unemployement OR percent individuals in households at or below 100% Federal poverty level
AND 10% or more of adults 25 or older have not attained a high school degree AND 80% or more of adults 15 or older are not enrolled in higher education

Tasks

All cards NOT workforce dev

From this

Screen Shot 2022-03-24 at 7 15 59 AM

To this

Screen Shot 2022-03-24 at 10 54 03 AM

Tasks

Question for Kameron

KameronKerger commented 2 years ago

higher_ed.pdf high_school.pdf training and workforce.pdf for all methodologies except for training and workforce: AND is above the 65th percentile for low income AND at or below 20% for higher ed enrollment rate needs to be updated to AND is above the 65th percentile for low income AND 80% or more of adults 15 or older are not enrolled in higher ed @vim-usds see also the two side panels with a green background on the Indicators for UI and Export sheet.

vim-usds commented 2 years ago

@kameron will update these mocks, TY!

vim-usds commented 2 years ago

@emma-nechamkin (optionally @KameronKerger) - some of these mocks have now flipped the higher ed and high school to be the opposite of what they originally, ie, below 20% => above 80 %. Does this mean that the associated BE signals (CA, HSEF, IAHSEF) need to be flipped and baked into a staging link? Maybe this is already done? Let me know if I'm missing something. TY!

emma-nechamkin commented 2 years ago

This is already done @vim-usds! See https://github.com/usds/justice40-tool/pull/1393

vim-usds commented 2 years ago

@emma-nechamkin - gotcha!

I might be missing something. However here's my understanding. It seems that on the latest staging link is returning the following:

Screen Shot 2022-03-28 at 3 33 03 PM

On step1 of the above screenshot - I have a typo, 1493 should be 1393 (the ticket mentioned in your comment). TY!

emma-nechamkin commented 2 years ago

For 4 -- I think you're pulling the wrong variable, this should actually be 89% (it's 11% college attendance). I think you're looking for NCA (https://github.com/usds/justice40-tool/blob/main/data/data-pipeline/data_pipeline/etl/score/constants.py#L207) For 3a -- it should, for now can you manually coerce? We have a ticket to fix this for another indicator, and so I'll do them simultaneously!

vim-usds commented 2 years ago

@emma-nechamkin

Re 4: Cool updating to NCA, TY!

For 3a - coercion is totally fine!

Also is there a boolean for NCA? Like NCA_GT80 maybe?

emma-nechamkin commented 2 years ago

it should be the same boolean -- the two are logically equivalent (CA_LT20 == NCA_GT80)