In addition to the Student Count data, you must also download the Free and Reduced Lunch count by Building file to populate two tabes:

1.  the demographic counts by building in the s_buildingenrollment table, and

2.  the counts by MunID in the s_freereducedlunch table.

These values are used in the Student Demographic report for Comprehensive Needs Assessment reporting.

In MISchoolData.org select:

1.  Other & Data Files à Data Files à Additional K-12 Data Files à Student Counts à Free & Reduced Lunch Counts.
NOTE: In 2020 it seems the file is now part of the Economically Disadvantaged file.

2.  Download the file

3.  In Excel, create a new worksheet titled “RawData” to the right of Bldg_K-12_Grade.

4.  In Bldg_K-12_Grade, copy A5:I19125 (last cell of data)

5.  Paste into RawData

6.  Truncate MySQL table aa_mi_se_freereduced

7.  Import the Excel file into aa_mi_se_freereduced

8.  Run the SQL scripts in: “SE MI Free Reduce Utilities”

Figure 25: Diagram showing analysis used by Student Count

The Enrollment Code table is a key dataset to understand. This table contains the Code IDs for the various types of enrollment stored in the Student Enrollment table.

Figure 26: data table for Enrollment Codes