I'm so excited about a spur of the moment project I started today in my sixth grade computer science class. We just finished group reports in our millennial/computer terms wiki, and our next topic to cover is graphing. For the past two quarters, I've done a rather dry assignment involving temperatures of cities around the world in Google Docs and Spreadsheets. I decided I wanted to explore an Ogle Earth blog posting forwarded by Chris Walsh to the GCT community, and I began by trying out the Google LookUp formula within Google Spreadsheets. Essentially, you enter certain search terms into this formula, data is found by Google, and entered into the specified cell. See this blog posting in the official Google blog for more information and check out the hunt itself. I need to add more complete directions and polish it a bit, but I may post about this over at the Infinite Thinking Machine when the project is finished. So far, my students' reactions have been really positive... they had no idea about the calculator features in Google Search and many said that this alone would help them with their homework. Another thing to note is a suggestion from my colleague, Marty. She thought it would be great to use autofill with this Lookup formula, to say, find statistics for a set of pro baseball players. Unfortunately, autofill doesn't seem to be a feature with Google Spreadsheets yet!
Recent Comments