This data will contain all the various staff demographic details by district and building. This chart is for the CNA Staff Demographics chart at the Building Level. The data is stored in MySQL as: “s_staffcount”. Download the data from MISchooldata.org at K-12th Grade à Staffing Information à Staffing Count.
All the demographic categories will be included in the same Excel download for the CNA reporting.
In Excel:
Create a new Worksheet titled, RawData
Copy the “Building” worksheet A5:AC:####.
Paste into A1 of the RawData worksheet
In MySQL;
Truncate table: “aa_mi_se_staffcount”
Import the downloaded CSV file into this table
Run the SQL scripts in: “SE MI Import Staffing Count”
Once loaded, the s_ftebuilding table will need to be updated for Tableau charts using the SQL scripts: “SE MI FTE Building Utilities”.