Go Slow Workshop on Google Sheets
Spreadsheets are one of the most useful things we can use as a teacher. We have to manage a lot of data and information and frankly using spreadsheets helps us to do our job better. Spreadsheets are also a valuable life skill for our students. Looking at this list of best jobs for 2017, all of them would use spreadsheets as part of their work.
As part of premium membership I offer online workshops, including workshops on using spreadsheets. Learn more about spreadsheets and become a premium member.
Want More Help with This? Become a Premium Member
Make a Spreadsheet
Step 1: Consider using spreadsheets with your students. You don’t have to do any math or know anything fancy to have your students use a spreadsheet. Instead of “why would I use a spreadsheet” think “why would I NOT use a spreadsheet?” It’s a giant table, you can use it for almost everything.
Have students make a list of their vocabulary words in a spreadsheet. It’s super nice because you can easily leave students feedback in the column next to their responses.
Instead of using a Google Doc to have students answer questions, have students put their answer into a spreadsheet. This way the answer line is already made for you. Way easier than a Google text document.
Finally! A way to grab a spreadsheet cell from individual student spreadsheets. This allows you to easily review all students responses to a question in one place.
Gamification works! Use Google Forms to award students badges using the Forms Add-on Certify’em
How do you copy or move Google Drive files? If you are retiring or moving schools or simply want a backup of your school files here are 5 ways you can move Google Drive files.
You make a copy of a spreadsheet per student, but what if you have a typo or want to add to the spreadsheet? sheetPusher by Alice Keeler and Heather Lyon helps you update student spreadsheets. Here is…