Google Sheets
If you use Microsoft Excel you will like Google Spreadsheets. Google Sheets allows teachers and students to easily compile,, organize and analyze information quickly and easily on the Drive. There are all the needed tools for crunching data and creating and visualizing information with charts and pivot tables. You can even learn how to use them for class assignments and with Google Forms. (45 minutes)
Learning Targets
• Understand what Google Sheets are
• Develop techniques to use Sheets in the classroom
• Use sheets in a basic way
Step 1 How can you use spreadsheets in class (15 minutes)
You do not have to be a science or math teacher to use spreadsheets in the classroom. In this learning module we will see how spreadsheets can be used through out the curriculum. Please read information below and watch the video on how Google Sheets can be used in class. Then be ready to share how you might use spreadsheets in class. The following are some examples of how teachers can use online spreadsheets:
Learning Targets
• Understand what Google Sheets are
• Develop techniques to use Sheets in the classroom
• Use sheets in a basic way
Step 1 How can you use spreadsheets in class (15 minutes)
You do not have to be a science or math teacher to use spreadsheets in the classroom. In this learning module we will see how spreadsheets can be used through out the curriculum. Please read information below and watch the video on how Google Sheets can be used in class. Then be ready to share how you might use spreadsheets in class. The following are some examples of how teachers can use online spreadsheets:
- Create a classroom seating assignment
- Record grades with an organized grade book
- Conduct a discussion and allow student input
- Store a database of information for students and/or class curriculum
- Chart data
- Use a word cloud gadget to visualize written responses
- Use an Apps Script to automatically email feedback to students
- Collect data from across the web for research
- Use as an organizer for information
- Create graphs to express data
- Inform through use of infographics
- Create interactive flashcards with a spreadsheet gadget
- Format a class schedule
Step 2 Creating a Google Sheet (15 minutes)
In the first video discover how to create a spreadsheet. Next watch either the second video or the third video.You may wish to take some notes on both. Again please choose which video you wish to watch for the second viewing.
Video One: How to create a Google Spreadsheet
Video Two: Formatting and tools in a sheet (Helpful to new spreadsheet users)
Video Three: New Tools in Google Sheets (Great resource for those familiar with spreadsheets)
After watching take some time to practice on your own or with a partner.
In the first video discover how to create a spreadsheet. Next watch either the second video or the third video.You may wish to take some notes on both. Again please choose which video you wish to watch for the second viewing.
Video One: How to create a Google Spreadsheet
Video Two: Formatting and tools in a sheet (Helpful to new spreadsheet users)
Video Three: New Tools in Google Sheets (Great resource for those familiar with spreadsheets)
After watching take some time to practice on your own or with a partner.
Now take some time to practice on your own or with a partner.
Step 3 Differentiation Time...Learning More about Sheets (15 minutes)
Watch one or all of the videos. Make sure you have some time to try some of the features that are explained. Be ready to share what you have learned.
Video 1 - Tips and Tricks using Google Sheets
Video 2 - Making Charts and Graphs with Google Sheets
Video 3 - Using Google Sheets to make Note Cards (Note... Turn on Text Wrap under Format)
Video 4 - Google Sheets to Help Students Self Assess Learning Targets (Link to sheet - http://goo.gl/LLGnMp)
Video 5 - Using Google Sheets to solve equations
Now that you have watched one or all of the videos. Make sure you have some time to try some of the features that are explained. Be ready to share what you have learned.
Step 4 Connection and application time (15 minutes)
- Watch another Differentiation Video
- Work on a class idea
- Practice some more
- Be ready to share ideas
Watch the Presentation
Document Download