I have meant to play around more with the Google Chart API for a while and I wasn’t happy with what I made earlier to visualize the network storage differences among the schools and users. I thought a treemap would be a more powerful way to show just how much space a few teachers used vs the masses. Knowing your options and picking the right one to help illustrate your point is an important element of data visualization. After all, we aren’t ignorant savages who believe –Isn’t this about visualizations, basically a form designed for those who won’t (or can’t) read? Kinda like remedial explanation for the 99%.” You can see the Google example for this kind of graphic here. This is my first time messing with it so I started by copying their example into my text editor. Their example was pretty close to what I wanted in terms of the structure of the information. They had Location, Parent, Volume, Color as the main variables. I wanted something pretty similar. Instead of ‘Global,’ ‘HCPS’ was my top category with the schools taking the place of the countries. Pretty simple but I sure didn’t want to write all that data by hand. I already had the basic data in Excel, I just had to come up with the right formula. […]
We have 668 high school teachers using at least .1 MB on a shared network volumes we’ve collectively dubbed “Virtual Share.” Those 668 high school teachers use 2019.7 GB or 2.02 terabytes of storage. What’s particularly interesting to me is the disproportionate usage between teachers. The top user, a single person, uses 180 GB or roughly 17% of the total.1 The top 10 users use 733.2 GB of storage. The top 20 users use 993.6 GB of storage or almost 50% of the storage is used by roughly 3% of the users.2 These are just embeds of the data from Google Spreadsheets. Nothing fancy, not much control but I think it does paint a decent picture of the extreme differences in resource usage. I do continue to have trouble with the interactive chart embeds outside of the spreadsheet. I do like the unintentional psychedelic effect on the pie chart. 1 No judgements on quality of use, just amazement that they are so far out there. 2 Makes me reconsider the whole 1% thing as even more screwed up.
I spent quite a lot of time with my wife and oldest son looking at the dialectic survey map1 and trying to figure out which one of us said a particular phrase or pronounced a word a certain way. About half the time I answered “all of the above” while my wife was tried and true Massachusetts for just about every one.2 I figure my wandering ways are to blame so I figured I’d take a shot at visualizing that. I did recall that Google Spreadsheets would let you visualize spreadsheet data on map with no trouble at all. It’s an option under “insert chart.” All I needed was a location in the first column and the numerical value for the circle in the second column (years in this case). Said and done.3 Too easy. Mine is immediately below and is followed by my wife’s map. Turns out it has a rough time with two different data sources from one document- even if they’re on different sheets. I could have made an additional spreadsheet but I don’t like this enough. Easy-ish but not much control. I’m going to look for some other options. Image Version Turns out I’m starting to hate these as there are more issues than they’re worth. I don’t know how to allow access to the interactive […]
Word Games/English in the Wild I made a blog focused on the idea of English in the wild. The goal is to look at language and how it works outside of school, to capture the things people find interesting, odd, or broken about English as they interact with it. Essentially, I keep finding things that are interesting (at least to me)- strange phrases, interesting sentences, games comedians play with words1, even a little Scottish poetry recently.2 I thought it might be useful to aggregate content like this. Naturally, it’s just me at this point but I’ll invite/beg some people to join me at some point and hopefully it’ll map out to students as well. This content can then become fodder for all kinds of reuse. I see aspects of it falling short of the weight of Defective Yeti’s book review posts but containing elements of them. His structure would make a grate template for larger scale project and I like his “Words I Looked Up” at the bottom of the post and his neologisms (and I had to look neologism up). So between neologisms and paraprosdokian you have some unfortunate names but interesting items. This idea may be something that was submitted Henrico 21 at one point. Gaynell remembers it but hasn’t provided me with proof yet. I went through […]
This collection of dashboards1 was brought on by a tweet2 from Dan Meyer but precipitated by the fact that I am struggling to figure out what matters in terms of a future LMS and how the data we present (or don’t present) to students and teachers impacts education as a whole.3 While we4 often say we5 want a balance between multiple choice assessment and other types of assessment, if the only data that teachers see and talk about is related to multiple choice we probably shouldn’t bother talking about other types of assessment. There’s also the idea that assessment data may just be the tip of the iceberg. I’m not sure what exactly would make a difference but there are lots of other things that ought to be looked at. In the end I see the data displayed to students and teachers as being pretty important but it means nothing if it’s not set within the right context and used in the right way by both parties. All that aside, let’s see what’s going on right now. Delaware Insight Dashboards Fairly traditional, I’m not sure these dashboards are even meant for student view but many of the systems I’ve seen lately just give students access to their own data with the same views they give teachers and call it a […]
I blame D’Arcy for this. I kept thinking that it’d be interesting to take the results of IOGraphica and make it into stop motion animation. I looked for ways to download the image every X minutes but failed to find any way to do that in the program. I then thought, I could just remember to do this every hour or so. Then I realized I’d never do that even with a calendar reminder and besides, computers are supposed to do this stuff for me. My next attempt was to search for AppleScripts that might have been written to do this for me. I wandered around quite a bit and found nothing. I then looked to see if IOGraphica had anything in the AppleScript Dictionary (While running Script Editor>File>Open Dictionary> choose the App you want). Nothing there. Now I was stuck. I had invested nearly an hour last night searching for the answer. I saw a few other people interested in a solution. So, I dusted off a few of my old AppleScripting bookmarks in delicious1. The hassle with Applescripting applications without dictionaries is that you are pretty much shooting blind . . . unless you use the amazingly useful UI Browser. If AppleScripting were a class the teacher would ban the UI Browser. It not only helps you find […]
Survival guides have some interesting potential for a variety of historical and literary analysis needs. This idea was jump started by the Brighid Survival Manual which was found via Super Punch. Here’s a quick example for the Witch in The Wizard of Oz. I’ll see if time allows me to make one for a Jamestown colonist. The problem is that these take a good bit of time and effort if they’re going to be good. That’s great in a project but it does make it harder on me. Anyway, lots of English and history applications. It’d be fun to write survival guides for self-destructive historical or literary figures- maybe Edgar Allen Poe or Custard.
I don’t know what it is about posters lately but this is simply awesome. It’s from the movie Mega Shark vs Giant Octopus1. Pitching this WCYDWT style would be awesome. Any crazy physics teachers out there willing to give this a shot? I was utterly bored by physics both times2 I took it but I’d have spent a happy week trying to figure stuff like this out. Found via the always awesome Super Punch 1 It’s now on my list to watch. I don’t know why Jim Groom hasn’t dedicated an entire blog to this yet. 2 I took it once in HS and once in college. I didn’t fail people. I only failed classes when I had personality conflicts with teachers.
OK, the new1 Exhibit API is crazy fast. It still takes a second or so to load but once it’s up and running the selection speed is dramatically improved. DRAMATICALLY2. I’ve been pitching the Simile project3, especially Exhibit, for quite a while for all sorts of educational uses. It really is fairly simple and allows you to create the kind of powerful data-driven interactive websites that would simply be impossible if you aren’t able to write code. You need to create these kind of interactive database sites because they are interactive and allow students to manipulate data and see it in a variety of contexts. That enables, and encourages, all sorts of processing and helps students see connections. David Huynh and the rest of the people who are working on this BSD licensed project have really made some incredible speed improvements. To change to the new API, just replace the original API reference in the header of your page (http://static.simile.mit.edu/exhibit/api-2.0/exhibit-api.js) with http://api.simile-widgets.org/exhibit/2.2.0/exhibit-api.js = instant speed jump4. As a way to force myself to do it, I’m going to take this pretty new API and attach it to this interesting data set on X Box games5. Why? Well, because I can and it’s awesome. 1 How new, I’m not sure. Allison C. from UR mentioned it in relation to the Confinder […]
It has been interesting to see the excitement surrounding WolframAlpha . The new “Computational Knowledge Engine” called Wolfram|Alpha has gone through a full media cycle before it has even been unleashed on the world. It has been hyped as a “Google Killer” and denounced as snake oil, and we’re still at least a few days from release. The simple goal behind the engine is to connect searchers with precise information. Wolfram|Alpha’s search magic comes through a combination of natural language processing and a giant pool of curated data. That quote is from Radio Berkman (which is a very interesting podcast out of Harvard Law) and they’ve got an interview with the creator as well. Watch the abbreviated 10 minute version below. I’m not sure how well the idea of a curated semantic web will work (although I can understand that urge). This does really show a different way to think about searching for information. It really takes it beyond search, making it closer to exploration maybe. It’s similar in some ways to one of David Huynh’s Parallax project (of Simile Exhibit fame) which has been out for quite a while now. Video of that is below. Freebase Parallax: A new way to browse and explore data from David Huynh on Vimeo. While the media may be portraying Google as being […]