M-STEP data is stored and reported at several levels of granularity:
1. Public Aggregate Data (3-8 and High School)
2. Private Aggregate Data
3. Protected Student Level Data
For public data, there is a production table titled “s_mstep” as well as a temp table titled “aa_mi_se_mstep_source” for storing the imported raw data from the state. SQL scripts are run to move the data from the temp table to the production table.
Figure 27: Michigan portal for M-STEP data