Millennial Zombies Page 3
A while back I posted about using GoogleLookup to get data quickly and easily to make and put into Google Earth via Google Spreadsheets. The example file is at http://spreadsheets.google.com/pub?key=pGAYO0Q5WpT8_Rsss6Uw2LQ&output=txt&gid=2&range=a1. It’s a network link. In Google Earth- click Add– Network Link and paste the URL into the Link box. Here’s some information on how to do this if you’re interested. Put Info into Google Earth from a Google Spreadsheet Things ended up being far easier than I anticipated. The last time I did a networked KML link from a spreadsheet (sounds way fancier than it is) I had to make it myself and go through a different service. Now Google has a nice template all set up to make things work well and it makes things pretty as well. Adding GoogleLookup to the Template So the next thing I did was play around a little with the lookup function. I didn’t do too much. I was just playing around to make sure it would work. This wouldn’t save you much time as it’s only five cities but it you wanted to plot all this information for 50 cities things would start to get a lot more interesting. I just added a few columns at the end of the spreadsheet and then set up the following formulas. I put the lookup […]
I used BombayTV last year to get students to illustrate the major and minor conflicts in Richard III. It could be applied to any story you are working with–whether literature or history. Actually, I imagine you could use this for math and science with a little creativity. The student’s loved it.