Google Sheets is an online spreadsheet app that lets you create and format spreadsheets and work with students and other instructors.
Level 1:
Access stored Drive files offline
Create document templates
See changes to Drive files and folders
Switch to a different version of your file
Share “Make a copy” links to your files
Share links to PDF versions of your files
Work with Microsoft Office files
Use shortcuts to create new files
Add checkboxes to spreadsheets
Get instant insights into your data
Level 2:
Add images to spreadsheets
Add flowcharts and diagrams to files
Summarize your data with charts
Insert and edit charts in presentations
Present during a video meeting
Share content with multiple people
Email collaborators
Filter data in a spreadsheet
Protect content in a spreadsheet
See data changes with conditional formatting
Get notified about spreadsheet changes
Mark a shared file as final
Restrict sharing options on Drive files
Set an expiration date for file access
Transfer ownership of a file
Additional Topics:
Import data from another spreadsheet
Link to data in a spreadsheet
Move Analytics data to a spreadsheet
Use currencies in your spreadsheet
Add financial data to a spreadsheet
Search for data in a sheet with QUERY
Create and edit pivot tables
Automate tasks with macros
Split data into columns
Space table rows and columns evenly
Share a file publicly
Publish files as web pages
Manage large events in Calendar
Create digital sign-in sheets for events
Do more with add-ons and scripts
Activity: Pivot Table Example
Google Sheets Task
Activity:
Sheets Practice Question
Data
Completed Data