The Start of a Swivel Project w/ Google Docs Mixed In
So I worked with a great ITRT and former science teacher, Gaynell Lyman, to look at ways we might use both Swivel and the googlelookup function in google spreadsheets to see what we could do to save time and get to the actual learning.
We wanted students to be able to see how various factors changed as you move across the periodic table and how they interrelate. The goal was also to have them look at the charts and manipulate them to figure out these concepts on their own.
The idea was not to get them to look up data from a chart and re-write it in another chart so we opted to try using google’s lookup function. It performed pretty well but wouldn’t look up some of the values we initially started with and with some of the others it opted for slightly different formats for the same concept (like 185 mu or mu 185). A minor issue but one to look for.
What we did was list the elements in column A, in column B we did a googlelookup of atomic radius with the formula =googlelookup(A2,”atomic radius” and then a similar formula to get the data for electronegativity. We were hoping to get a bit more data but the lookup function, while neat, is still pretty limited.
So, we then fiddled with the data a bit and then exported it as a CSV file (Swivel doesn’t quite deal with other formats too well but there’s some neat options they’re working on).
The import into Dabble was easy.Â Then it takes care of chart generation all by itelf.Â It makes all kinds of charts automatically. Â I liked the extra touches- you can pick a flickr photo to associate with your data and it auto tags your data with a number of keywords which you can then add to or remove.
What I’d like to do in the future is use this for collaborative projects, the kind of project you’d like to do but having everyone do each step would take too long.Â You could set up teams within the class (or by classes, or in different schools).Â Each team would complete related experiments so that all the data would be relevant to each group.Â They’d upload their data to Swivel and then use the accumulated data to complete the project.
Swivel is neat because it allows you to easily layer different graphs in order to compare the information.Â The power in having students do this is multiplied because they have to figure out what data needs to be compared and then how that data should best be presented to get the information they need.
I’m looking into doing some county wide surveys so that students can use the data to explore statistics.
Try Swivel.Â I think you’ll be impressed and I think it’ll get you thinking.