A Google Map of Michigan’s 2014 School Score Cards

The Michigan Department of Education (MDE) has released their annual school score cards.  The web interface for viewing the data isn’t particularly good, so I’ve created a custom Google map that displays each school, the score card status, free lunch information, 11th grade test scores, 5th grade test scores,  and demographic information.  The MDE has an official guide for understanding the score card information.

The map adopts the MDE Score Card’s practice of using colors to denote success levels.

green-dotGreen – attain 85% or greater of possible points


lime-dotLime – attain at least 70% but less than 85% of possible points


yellow-dotYellow – attain at least 60% but less than 70% of possible points


orange-dotOrange – attain at least 50% but less than 60% of possible points



Under Performing SchoolsRed – attain less than 50% of possible points


purple-dotPurple — meet all applicable Participation and Compliance Factor requirements;  have no full academic year students

black-dotBlack –Schools that participate in the free lunch program but do not have MDE Score Cards.

Here is the 2014 map of Michigan schools with integrated performance information.  Be sure to click on the icon to display the data!




Evaluating Michigan Schools MME Results with Regression Analysis

In my last post, I looked at factors impacting Michigan primary school test performance.   In this post I look at high school performance using the Michigan Merit Examination (MME)  11th grade  results to determine what is the  role of race, location, poverty, and school type (public, not for profit, and for profit charter).   In all of the exam subjects (Math, Reading, Science, Social Studies, and Writing) for profit charters out perform not for profit charters and public schools at a 95%, or higher, confidence level.  Not for profit charter schools typically outperform public schools at lower confidence level than their for profit comparisons because their are so few in the data (only 16 as opposed to 79).  The higher the ratio of Asian and female students, the better the school performs on the exams.

One of the advantages of a regression analysis is that it can be used to forecast what the result should be based on the factors involved.   Some schools will vary more (above and below) the forecast.  I hope to illuminate that distinction using an online map in a future post.

Continue reading