Categories
learning analytics lumenlearning shuttleworth visualizations

Automatically Geocoding Higher Ed Institutions Using the Google Maps API and Google Spreadsheets

I recently needed to quickly create a map of higher education institutions Lumen is working with, and consequently needed LAT and LONG info for dozens of schools. Rather than do that all by hand, I created this little recipe for automatically retrieving coordinates given a school’s name using the Google Maps API and Google Spreadsheets. Here’s a demonstration of the recipe using a list of all the higher education institutions where I’ve taught:

https://docs.google.com/spreadsheet/ccc?key=0Aq0aF_AqiIz9dFRvRVd2Y0JVbHh6WllqcGVCS2VnbWc&usp=sharing

I fully realize I’m no Tony Hirst, but thought this was interesting enough to share.

Categories
learning analytics open content visualizations

Learning Analytics: Time Series Visualization

As part of my work on the NGLC-funded Kaleidoscope Project I’ve been thinking about practical learning analytics. Why “practical”? My goal with practical learning analytics is to provide access to data in ways that an average teacher, with no special training, can leverage in order to help her students succeed. This is, of course, an extremely tall order.

As I began to mull over some common conventions that teachers could interpret without training (e.g., time flows left to right, scores move higher and lower) I realized that there’s already a tool available that provides visualizations like this – the Google Motion Chart Gadget.

This interactive visualization (play with it here) shows “visits” on the x axis and “current score” on the y for about 65 students over the first seven weeks of a course. (You can visualize up to 4 variables simultaneously with the GMCG, but I wanted this demo to be easy to understand.) Watching the data move through time makes it extremely simple to find students whose grades are dropping (as their circle drops), students whose course activity is waning (as their circle slows or stops in its left to right motion), etc. When you see something “interesting,” you just pause the viz and mouse over the circle in question to get the student’s ID so you can then reach out to motivate, offer help, etc.

Now, you might think that it’s quite simple to generate a viz like this since the GMCG provides the framework. However, try asking your LMS how many times a student logged in during week 3. Or what a student’s grade was at the end of week 5. Your LMS doesn’t actually keep this data at all (or anywhere that you can get to it). So if you want day by day or week by week granularity you’re forced to hack your way around by generating reports daily and calculating deltas to get the day’s activity. Even if your LMS provides a “1 day” report, you can only get 1 day – not all of the “1 day”s in the semester. So you’re still left downloading reports every day and combining them by hand (or script) into the form you need. And since you want to provide daily updates to this viz, that’s actually Ok, except that… this is extremely tedious to do since most LMSs provide no interface for pulling out the necessary data programatically (i.e., you’ll be pulling these reports by hand). And if you want to provide this view to teachers in very nearly real-time (which should absolutely be our goal), you’re consigned to pushing this button by hand at the same time every day – like the fellow on Lost who had to push the button every 108 minutes in order to save the world.

Anyway, lots more to unpack here, but I wanted to post this (1) because I think it’s a great approach that demonstrates how a simple visualization can be made to serve learning analytics purposes, (2) to send a shout out to my Kaleidoscope Project friends, and (3) to complain yet again about how difficult LMSs are to work with. Hopefully someone will find this work inspiring and build something even better and more intuitive.