Research Task - SB125 Allocation Package Data Cleaning
Closed this issue · 4 comments
Research Task
Use this template to create issues that represent small chunks of work (.5 - 2 days) that stand alone, or represent incremental work as part of an Epic Issue Template.
-
Relevant PR (if applicable):
-
Question or Goal: RTPAs/Orgs submitted allocation packages for SB125 funding, do these packages meet all the requirements per the SB125 final guidelines?
-
Data Required:
- Currently have: submitted SB125 allocation packages, allocation packages submitted via Google Survey, SB125 final guideline,
- Need:
-
Research Required: Read SB125 final guideline to understand context of what is submitted.
-
Metrics: a yes/no value for the presence of each requirement
-
Expected Outputs / Findings: A table where each row is a RTPA/Org, columns of each requirements for allocation packages and yes/no values to indicate if the RTPA met the specific requirement.
Initial work plan
- Start an excel file in SB125 folder in Teams, layout rows/columns per above. May need to use the same layout as the google survey
- Enter the RTPA/org name of each submitted allocation package into the sheet
- For each package, mark whether each requirements is met
Future work plan
- add pdf allocation package data to google survey to fill in gaps,
- explore what analyses and metrics can be done with all this data
meeting w/ Anthony Serna and maybe Chad soon for next steps from CalSTA
closing since initial scope complete, may create future issue if needed