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:

=image(“https://chart.googleapis.com/chart?chs=150×150&cht=qr&chl=”&A2)

 

Let me know in the comments how you could use it in your classes. 

 

What you will need is:

 

Watch the video below: