This populates the Census Poverty Tableau chart in the CNA app.

Navigate to the State’s Field Services page: https://www.michigan.gov/mde/0,4615,7-140-81376_51051-127227--,00.html

Download [School Year] Estimated Title I, Part A - Improving Basic Programs

Save as an Excel file

Open the Excel file and create a worksheet titled: RawData

On the source data, select Copy A6: [last data]

. copy and paste into RawData B1

Label A1: “ImpSadYear”

Populate column A with the school Year: like 2020

Truncate and import into the MySQL staging table: “aa_co_census_poverty”

Run scripts in: “CO SE CNA: CO SE CNA Census Poverty”