My earlier posts have included some of my ideas for using QR Codes in the Classroom. Since many of my activities require a bunch of QR Codes, I needed a way to 'batch' create the codes instead of creating them one-by-one.
So...what better way to create these Codes in mass quantities then by using my Google Apps account! Here are easy step-by-steps for getting the job done:
1) In Google Apps, create a 'Sheets'
2) Adjust column and row height and width to make a large square (approximately 3"x3").
3) Title Column 'A': Text/URL/Contact Information or whatever you want your QR to contain.
4) Title Column 'B': QR Code
5) In Column 'A', on each row, type in what you want your QR Code to be about (text, contact, URL, etc.)
6) In Column 'B', type in this formula:
=image("https://chart.googleapis.com/chart?chs=150x150&cht=qr&chl="&A2)
Note that the last 2 characters of this formula represent the cell from Column 'A'. If you copy & paste this formula down Column 'B', make certain that last number is for the correct/adjacent Column 'A' cell.
7) Tip: If the QR Code doesn't show in the cell in Column 'B', try looking at it from 'Print View'. Many times, my cells were blank, but in 'Print View', I saw the code and it scanned perfectly.
8) Before going live with these Codes, I always 'test drive' them for accuracy and to make sure there are no errors.
Voilà!....you've made QR Codes!
Elana Moore
