Google Sheets
Full list of Google Sheets Training Videos and Practice Activities
Google Sheets Level One Skills
- 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.
- Create a new Google Sheet
- Understanding basic spreadsheet vocabulary
- Formatting cells
- Sorting Numbers, Text, or Dates
- Delete rows or columns of data
- Freeze rows or columns to assist in viewing header information
- Create additional sheets
- Rename sheets
- Duplicate a sheet
- Change the color of a sheet tab
- Insert a new row or column into an existing sheet
- Merge cells
Google Sheets Level Two Skills
- 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
Google Sheets Level Three Skills
- Protecting sheets and ranges
- Apply conditional formatting to efficiently display results
- Sheet add-ons
- Send personalized email with (YAMM)
- Create Personalized Documents (Autocrat)
- Sheet resources available with Flippity
These activities have been created to allow you to put into practice the skills listed under each skill level. The only way to become proficient in the use of Google is to actually put it into regular use.
Google Sheets Level One Practice Activity
Create a new Google Sheet to help you organize your list of parent contacts. In row one enter all of the headings of information you will want to keep for your contacts (i.e. Parent Name, Student Name, Parent Email, Parent Phone, etc). Format the document so it is easy for you to read. Note - you could also achieve this same thing by creating a form with the questions being the list of items for row 1, then use the create sheet button in forms to create the Google Sheet. Forms and sheets work together nicely if you plan accordingly.
Google Sheets Level Two 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
Google Sheets Level Three Practice Activity
Use one of the add-ons described above to create something you can use with your students in the next few weeks.