Sunday, May 21, 2017

Creating Bulk QR Codes for Student Work

So Open House is coming up and students have lots of work to share. Maybe you have some cute videos or recordings of student reflections. Here's how you can create a class set of QR codes quickly in a Google Sheet.

Make a copy of this sheet: QR Code Creation Spreadsheet
Add your student names to column A
Paste whatever links or info you need the QR code to share in column B
Copy the formula in column C by selecting C2, hover over the tiny blue square in the lower right corner, and drag it down to fill as many rows as you need.
This is the formula to use:  =image("https://chart.googleapis.com/chart?chs=150x150&cht=qr&chl="&B2)



The QR codes will be displayed as small or large as the row size. To change the size of all the rows at once, select the top left cell, some people call the awesome box. That will highlight the entire sheet. Any changes made to a row or column, will be done to every other row and column.



You can hide the link column if you want. Then just print the spreadsheet. 

No comments:

Post a Comment