By Mychau Sou
In Gsuite (formerly known as Google Apps for Education), Sheets are spreadsheets that many feel intimidated by, but once you learn the benefits of Sheets, you may not want to go back. I create spreadsheets to help me keep a digital record of what my students turn in. For instances, I would copy and paste my students’ name list from illuminate and insert a checkbox column to check off which students turned in what. At the bottom of Sheet, I add tabs to the same Google Sheet to use it as my track log. The first-day packets, GAFE permission slips, and signed report card envelopes are all examples of what you can quickly check off. I use it to create my small groups and highlight which groups I’ve touched bases with for the week.
A Google Sheet can be converted into tools that help the flow of your classroom. Flippity.net is a site that will provide 10+ templates of ways in which you can convert your spreadsheet into something spectacular. One I frequently use is Flippity Random Name Picker where you insert your class list, publish the Google Sheet and instantly get access to digital equity sticks with your phone or laptop. What I love about this tool is that the Random name picker helps me form groups, pairs, and teams with a push of a button. I know with the constant movement of students it’s hard to keep up with real popsicle sticks. What if I told you can add and delete students on the spreadsheet as you please and still use the same link?
Convert a spreadsheet into …
A flippity random name picker
My students love the quiz shows that I make with Flippity Game Show. I insert the categories of my math units as the topics such as Ratios, Unit Rate, Unit Conversion, etc. and type in my questions and answers using the template provided. The Flippity template allows me to publish and get a link to the game show for a math review. The kids are split into teams where you can have them name their group. Points can be added or deducted to keep track which team is doing well. Once we’re finished playing, I provide the link to my students so they can always study these questions at home the day before the test. This is both easy and effective for teacher and student alike.
Take the spreadsheet and convert it into…A Jeopardy style quiz show board!
Whether or not you will be using Sheets as a system to track your students’ paper permission slips and work, or use free flippity templates, you can learn how to create a sheet with the click of a button! Trust me, it’s fairly simple. Come to my PD next week on Wednesday, February 6, 2019. John Adams Elementary Rm. 28 to learn more about Google Sheets. If you can’t make it, please sign up for the other PDs I’m offering in February.
(This is part 2 in a series. Part one was Getting Savvy with Slides.)
About the Author: