Using Statistics, Lookup and Search Features in Spreadsheets to Analyze Data Incorporate the interactivity of Google Spreadsheets into your classroom adding data analysis and multi discipline lessons to your curriculum. Using spreadsheets and chart creation with Google tools, student teams or multiple classes can author and share spreadsheets for group analysis. This sample lesson demonstrates how World History or Contemporary Issues classes can benefit from this tool. 1. Start with a discussion on World perspectives or the quality of life.

Students respond to “Miniature Earth”: http:/ www.miniature-earth.com/ 2. Explore the power of visual statistics by having students experiment with Gapminder: http:/ tools.google.com/gapminder/ 3. Student teams set up collaborative Spreadsheets using Google Docs & Spreadsheets. http:/ www.google.com/google-d-s/b1.html Teachers can set up one or several spreadsheets and invite teams of students to collaborate on the document by clicking the “share” tab Google Earth.COM Google-Earth.COM Google Spreadsheet Tutorial.

Download Charting with Google Spreadsheets pdf guide