Description: This is an abstract for the Michigan SGP Multi-Year Rating report, which takes an average of ELA and/or Math SGP values for M-STEP and/or MI ACCESS for a district, site, or teacher.
Purpose: This report averages ELA and/or Math SGP values for M-STEP and/or MI ACCESS for a maximum of three years. Overal SGP Rating is calculated using those averages.
Navigation: Reports > View Reports > Prebuilt Reports
Data is required in the below columns in order for the reports to run:
For MIPSAT Tests:
- mipsat89_2020_evidenceBasedReadingWritingGrowthScore
- mipsat89_2020_mathGrowthScore
For MISAT Test:
- misat_2020_evidenceBasedReadingWritingSGP
- misat_2020_mathSGP
Who is the intended audience?
Teachers and administrators
What data is reported?
Student count for each available academic year, average ELA SGP for each academic year, average Math SGP for each academic year, average SGP for each academic year (based on ELA, Math, or both), multi-year weighted average SGP, and overall SGP rating score
For three years, the formula is (Year1_AvgSGP * .5) + (Year2_AvgSGP * .3) + (Year3_AvgSGP * .2)
For two consecutive years, the formula is (Year1_AvgSGP * .65) + (Year2_AvgSGP * .35)
For one year or if year two is unavailable/no data, only the most recent year averages are used.
How is the data reported?
Calculations are presented on a single page for a district, per site, or per teacher.