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!




Identifying the Over and Under Achieving Michigan Schools

The Michigan Department of Education (MDE) ranks schools past on test scores and than reports the percentile a schools is in.  This tells us the absolute performance, but leaves out information.  For example, the percentage of students getting free lunches greatly impacts performance.  A school that has a lot of free lunch students that beats expectations, could be adding more value than a school with high absolute performance.  I’ve created a map that shows under and over performing schools based on location, demographics, and socio-economic status.    The model captures the top 10% and the bottom 10%.

OverperformingIndicates a school that over performed on one or more of math, reading, science


Under Performing SchoolsIndicates a school that under performed on one or more of math, reading, science.


Be sure to click on the icon to get the details about the school.

The icky math details are below.

Continue reading