Google Sheets L2

NOTE - If you would like a Google Sheet document with some data in it to practice these lessons, use this document. It contains the same data I used in several of my lessons below.

• Using formula and functions including Sum, Average, Unique, CountIf
• Use the copy down feature
• Filter data in a sheet
• Share a Google Sheet
• Analyze the data in a Sheet with Charts and Graphs
• Copy and paste a chart to Docs or Slides
• Publish results from a Google Sheet
• Download Sheet as other types of documents
• Using version history
• Adding comments attached to a cell
• Use data validation to create drop down lists or calendar dates in cells
• Add a link into a sheet
• Add a checkbox in a cell

Practice Activity

I have included several links to sites with ideas on how to use Google Sheets with your class. Look though these resources and find something that will work for you and your content area/age of students that will reinforce some of the skills above.

• Totally Awesome Things to Do with Spreadsheets in the Classroom
• Google Sheets: Project Ideas and Implementation Across Curriculum
• Eric Curts Google Sheets Resources