Creating Batch/Bulk QR Codes

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.

Read the full story by

Tags:

RELATED READS
iPad Mount Features EdCampLA – Educators Teaching Educators
We are updating our Privacy Policy, so please make sure you take a minute to review it. As of May 25, 2018 your continued use of our services will be subject to this new Privacy Policy.
Review Privacy Policy OK