Google+Docs+generating+QR+Codes

This is how to create a QRcode with a google Doc

This is from [|www.tammyworcester.com]

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)  1. Go to: [|docs.google.com]
 * 1)  2. Create a new spreadsheet.
 * 1)  3. Label Column A “Text or URL.”

> > > > > > > > > Entering the formula:
 * 1)  4. Label Column B “QR Code.”
 * 1) <span style="color: #5e5e5e; display: block; font-family: ArialMT,Arial,sans-serif; font-size: 15px; text-align: left; text-decoration: none;"> 5. Resize the columns and rows so they look like the screenshot below:
 * 1) <span style="color: #5e5e5e; font-family: ArialMT,Arial,sans-serif; font-size: 15px; text-align: left; text-decoration: none;"> 6. Enter some text or URLs in column A.

> > <span style="color: #5e5e5e; font-family: ArialMT,Arial,sans-serif; font-size: 15px; text-align: left; text-decoration: none;"><span class="style" style="font-family: ArialMT,Arial,sans-serif; font-size: 13px;">=image(" <span style="color: #424242; font-family: ArialMT,Arial,sans-serif; font-size: 13px; text-decoration: none;">[] <span class="style" style="font-family: ArialMT,Arial,sans-serif; font-size: 13px;">" & A2) > > > > > > > > > > > > >
 * 1) <span style="color: #5e5e5e; font-family: ArialMT,Arial,sans-serif; font-size: 15px; text-align: left; text-decoration: none;">In Cell B2, enter this formula (or copy and paste it.)
 * 1) <span style="color: #5e5e5e; font-family: ArialMT,Arial,sans-serif; font-size: 15px; text-align: left; text-decoration: none;">Press the Enter key on your keyboard.
 * 1) <span style="color: #5e5e5e; font-family: ArialMT,Arial,sans-serif; font-size: 15px; text-align: left; text-decoration: none;">A QR code will appear!
 * 1) <span style="color: #5e5e5e; font-family: ArialMT,Arial,sans-serif; font-size: 15px; text-align: left; text-decoration: none;">Click once on cell B2 to select it.
 * 1) <span style="color: #5e5e5e; display: block; font-family: ArialMT,Arial,sans-serif; font-size: 15px; text-align: left; text-decoration: none;">Click the tiny square in the bottom-right corner of the cell and drag down to fill down the formula.
 * 1) <span style="color: #5e5e5e; font-family: ArialMT,Arial,sans-serif; font-size: 15px; text-align: left; text-decoration: none;">Resize the rows and columns to make the QR codes larger or smaller.

<span style="color: #5e5e5e; font-family: Arial-BoldMT,Arial,sans-serif; font-size: 15px; text-align: left; text-decoration: none;">Notes / Ideas:

> >
 * 1) <span style="color: #5e5e5e; font-family: ArialMT,Arial,sans-serif; font-size: 15px; text-align: left; text-decoration: none;"> - 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.
 * 1) <span style="color: #5e5e5e; font-family: ArialMT,Arial,sans-serif; font-size: 15px; text-align: left; text-decoration: none;"> - Create a quick QR scavenger hunt. Just enter the clues in column A, and then print and “hide” the QR codes.

<span style="color: #5e5e5e; font-family: ArialMT,Arial,sans-serif; font-size: 15px; text-align: left; text-decoration: none;">- Print the QR code list as a handout for class or for a presentation!

<span style="color: #5e5e5e; display: block; font-family: ArialMT,Arial,sans-serif; font-size: 15px; text-align: left; text-decoration: none;"> <span style="color: #5e5e5e; font-family: Arial-BoldMT,Arial,sans-serif; font-size: 17px; text-align: left; text-decoration: none;">Option 2

<span style="color: #5e5e5e; font-family: Arial-BoldMT,Arial,sans-serif; font-size: 17px; text-align: left; text-decoration: none;">Use a template

<span style="color: #5e5e5e; font-family: ArialMT,Arial,sans-serif; font-size: 15px; text-align: left; text-decoration: none;">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.

<span style="color: #5e5e5e; font-family: ArialMT,Arial,sans-serif; font-size: 15px; text-align: left; text-decoration: none;">Note - You can also search the template gallery for “QR Code” to find and use my templates.



<span style="color: #584d4d; display: block; font-family: Arial-BoldMT,Arial,sans-serif; font-size: 14px; text-align: left; text-decoration: none;">