Overview:
Enter some text or a URL in a spreadsheet and a QR code will be automatically created - all with the help of a little formula that you’ll learn about in this tip of the week.
This is a great way to create lots of QR codes very quickly and easily!
You will have two options: 1. Create your own; or 2. Use the provided templates.
Note:
For more information about what QR codes are and how to use them in the classroom, see Tip 95 and Tip 96.
Option 1
Create your own spreadsheet
Let’s do one together for practice, and then you can adapt the instructions to create more of your own:
Getting Ready:
-
1.Go to: docs.google.com
-
2.Create a new spreadsheet.
-
3.Label Column A “Text or URL.”
-
4.Label Column B “QR Code.”
-
5.Resize the columns and rows so they look like the screenshot below:
-
6.Enter some text or URLs in column A.
Entering the formula:
-
1.In Cell B2, enter this formula (or copy and paste it.)
=image("https://chart.googleapis.com/chart?chs=150x150&cht=qr&chl=" & A2) -
2.Press the Enter key on your keyboard.
-
3.A QR code will appear!
-
4. Click once on cell B2 to select it.
-
5. Click the tiny square in the bottom-right corner of the cell and drag down to fill down the formula.
-
6. Resize the rows and columns to make the QR codes larger or smaller.
Notes / Ideas:
-
-Use a form to populate a spreadsheet with URLs from students or other teachers; then add the formula to quickly create a QR code for each URL.
-
-Create a quick QR scavenger hunt. Just enter the clues in column A, and then print and “hide” the QR codes.
- Print the QR code list as a handout for class or for a presentation!
Option 2
Use a template
I have created two templates that already contain the formulas and are ready to use. Just click “Use this template” below and then follow the on-screen prompts.
Note - You can also search the template gallery for “QR Code” to find and use my templates.
