I was looking for ways to create QR codes using Google sheets and came across this article by Tammy Worchester. I started to have a play around with the spreadsheet and came up with a workflow that you could use for taking attendance for class or voting on a piece of work, there is a host of uses this workflow could be used for.
The magic formula to create QR codes in your Google Sheet is:
Let me know in the comments how you could use it in your classes.
What you will need is:
- A Google Apps ID
- Copy of this worksheet
- And a Google Form – For a Copy of the one in the video click here
- To view the attendance sheet click here
Watch the video below: