You can use dry numbers in your Google Sheet, or even add a chart, but there is an easy way to make dynamic progress bars and charts in Google Sheets using Emojis and the REPT function. What you will be creating We’re going to be taking this sheet: and making it a little more interesting:…
Last week I attened the ITIP Ohio Google Summit. One of the sessions I attended was Getting Google-y in K-2 Reading presented by Jazmine Monroe and Becky McDonald. One of their examples was a Google Sheet that was formatting for Word Mapping, using conditional formatting to reflect correct and incorrect answers. I thought this was…
Here are the directions on how I created a quick and easy student response system with Google Forms and Google Sheets. Why? Sure there are tons of other ways to get input from your students, but I wanted a quick way I could survey students on the fly. The spreadsheet that has the formula for…
Source: SheetHacks: Discover the best tips and tricks for Google Sheets and Excel. Sometimes, you don’t know the problem you are having until you see the solution. Using spreadsheets fall into this category. There are things that you don’t know are possible with a spreadsheet, so you never ask or search for them. That’s where…
Building on my automatic creation of student placards, here’s how you can add QR codes to the student placards. This mean you can link to videos or websites to provide more information about the project.
By using the `image` and `hyperlink` functions, you can create QR codes for a list of URLs.
