For many users, Spreadsheets is the most intimidating of the Google Suite, and for good reason. The formulas and the functions and the cell formatting…oh my!
My goal with this tutorial, will be to demystify the not-so-scary world of Google Spreadsheets! Here it goes!
So, why should you use Google Spreadsheets? How can it help in your classroom?
- Create lists with Google Spreadsheets
- Collect Google Form Responses with Google Spreadsheets
- Enter information from your students scores on tests…broken down by learning objective
- Create charts and graphs
- And so much more!
If you’re looking for basic directions for creating a Google Spreadsheet, please click here.
Now that you’re able to create a Google Spreadsheet, how can it help you most in your classroom?
Click here for an example of how I would use Google Spreadsheet to chart student scores.
Click here for an example of how I would chart and display responses from a Google Form.
Google Spreadsheets and Forms can be used together to create self-grading quizzes…so if you’d rather use this format than a Learning Management System like Edmodo, then you can!
Below are some more resources for using Google Spreadsheets! Enjoy!
Thanks for reading 🙂
Hi Bethany,
How did you insert a table in your “Teaching with Technology Google Form” spreadsheet? The table appear to be placed “above” the spreadsheet.
Hi Allison! Thanks for reading!
When I created the table for the responses, I chose the chart icon and then selected the type of chart I wanted to insert. The chart inserts below the form responses. You can also choose to insert the chart on a new sheet within your Google Spreadsheet. If you choose to insert the chart on a new sheet, it is a little easier to manipulate the size and location of the chart. I hope that helps!
Thanks again,
Bethany