A CSV file is downloaded from MISchoolData.org. Make certain the “Student Count” file is downloaded. This file contains Building, Demographic and Grade enrollment and will populate the MySQL s_buildingenrollment. The Grades are in columns and must be normalized.

This data is used in several charts and reports. A consistent problem with the data is that the sum of the parts do not always equal the total. For example, the sum of Grade 1 counts by building may not equal the total given for “Grade 1 All Buildings”. The SQL scripts solve this by first importing the counts by Grade and Building and then go back and import the difference to Building Code “00000” (central office).

Another issue is the data provides number of Economically Disadvanteg students but not the number on Not Econmically Disadvantaged students. The scripts calculate the difference and loads those as well (same for Special Education and English Lamguage Learners)..

Download the CSV file to: Box à Clients à aaMichigan à Schools à [Year] à Student Count.

In Excel:

1.  Truncate and import the Excel worksheet “” file into “aa_mi_se_studentcount”

2.  Run the SQL scripts in: SE MI Import Building Enrollment