Creating Batch/Bulk QR Codes

Design_QR_Code_generator_-_Free_-_Unitag

There are a lot of easy to use QR code generators out there to be used in education. Some of them even create large batches of codes by simply cutting and pasting. There is one small problem with most of these generators if you are creating more than one, more often than not you lose track of which QR code belongs to whom. As a teacher, one way to double up on your productivity and create batch QR codes identified by a student name is to create them in a spreadsheet.

Here is how:
1. Collect student’s digital projects via a Google form (optional)

2. The form that students fill out requests that students submit a link to their project which ends up on a spreadsheet.

3. Once in the spreadsheet, the teacher simply pastes the the following QR Code formula (not sure who created the formula but here is a link to where it is stored online: https://www.evernote.com/shard/s2/sh/bf44024f-837e-4fd3-8f0a-61089874ca8d/155aae1d8d6bb1a777dc79f8755d5ec8) in the last cell of the first row of cells.

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

4. Look at the formula and notice that the last couple characters are A2, which refers to the cell that QR code will be made for. If the links that you want converted into QR codes are on column D2 for example, then change the last piece of code to D2.

5. Click on the cell that contains the formula. The cell will highlight and you will see a small blue box that you can click on, hold and drag down, making QR codes for every single student link just like that!

6. Lastly resize the cells horizontally and vertically to increase the size of the QR code and print.

Screenshot aided directions to create batch QR Code

Mr__Diaz__Assignment_Dropper_-_Google_Forms

 

Mr__Diaz__Assignment_Dropper__Responses__-_Google_SheetsMr__Diaz__Assignment_Dropper__Responses__-_Google_SheetsMr__Diaz__Assignment_Dropper__Responses__-_Google_Sheets

&nbsp

PlayPlay