The Recording Academy recently released the names of the 217 finalists for the first every Grammy Award for Music Educators. I was curious to see who from the list made it from New Jersey and also wanted to see how many nominees were from each state. The list published online made this difficult to do. So we grabbed the PDF file, copied the information into an excel spread sheet, applied a zip lookup formula to grab the zip codes, classified the schools based on name (elementary, middle, high) and the did a quick visualization.
Now I can find my New Jersey peeps as well as allow others to play with the information.