So, let's have a look at some of the collection I introduced this year...
Regulars here are already familiar with my interest in the Excel Sparklines add-in and building digital gradebooks that communicate a variety of data. You might also be interested in having a look at BeGraphic, which allows you make all sorts of visualizations in both Excel and PowerPoint. There is a free "lite version" available. Lots of opportunities here for design and communication.
We looked at a variety of tools in Google. Google Fusion allows you to take the data you upload into GoogleDocs and create a variety of visualizations. You can see a variety of applications in their Example Gallery, but for my purposes, I wanted to show the same data set in different settings. On this map, each dot represents a school district in Washington which has 10th graders. Not all districts are represented, due to FERPA restrictions. If you click on a location, the popup box will contain a variety of information about the district---all of it pulled from the GoogleDoc.
In addition, we looked at the same data as a motion graph. I am not able to embed it below (I just have a screenshot), but if you follow the link, you can play with it to your heart's content. Again, you have the same data options as in Fusion, the information is just represented differently and we can watch how things change over time.
You might also be interested in Google Refine, for cleaning data sets or even the Public Data Explorer to look at your data from a broader angle. While not a Google tool, the DataMasher also has some nice options for mixing and matching data sets.
I have shared MapAList on this blog. Here is the same data set as above, but using this tool:
There are some reasons why a school or district might prefer this over the maps Fusion can draw. MapAList will allow you to use different pins based on certain types of data (Fusion only allows for heat maps) and is much better at pinpointing location; however, it will not display as many types of data as Google Fusion. However, these are meant to be visualizations. So, if you can't adapt the appearance of the map to reflect data points, I'm not sure how useful a communication you can build.
The big winner of the day? Hands down, it was Microsoft Pivot. I showed only the first half (~3 minutes) of the TED talk below, and I swear I thought half the audience was going to sprint out the door to go try it.
The examples shown in the video are not school-related; but it is not a big leap to picture students (instead of Sports Illustrated covers), data, and the ability to sort and visualize what's happening. We're going to try getting a users group together. I find that very exciting.
Do you have new tools you're using or ideas you're implementing? Share them in the comments!