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: in the last cell of the first row of cells.

QR Code Formula

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






EdCampLA – Educators Teaching Educators

On a frigid Saturday morning, droves of educators gathered in West Hollywood, CA at the The Center for Early Education to talk technology and education, all for FREE! Yup, this was an un-conference called EdCampLA, where participants are invited to post 45 minute sessions on something they are passionate about and lead a discussion, how-to or just sit back and enjoy all of the great information being delivered. The following is a second look at wonderful presentations, ideas, resources and thoughts that I was fortunate to be part of!

Evernote was the first session on my agenda and in un-conference fashion, the speaker had posted the session on Evernote but wanted to learn more about it, rather than lead the session, and quickly, educators chimed in about their experiences. Just like that we had a full blown discussion on Evernote. Evernote is an online based product that can store notes, documents, audio and much more. Use it with students, share information anywhere, anytime from multiple devices.

@nerdyteacher for hands-on experiences using Evernote
Laurence School has great resources for teachers regarding Evernote
artsonia art online gallery for displaying kid’s art (can also monetize)

Apps! App Differently
This was the second session of the day for me and as the title states, apps! Jo Ann Fox (@appeducationfox) moderated this discussion and many apps discussed. Below is a small list and some of their attributes. See the image below for a more comprehensive list of apps that were discussed in this session. My favorite by far was MyScript Calculator (see video below)

-madlip app- free version gives you 15 seconds of audio. Have students make a talking book cover using
-imovie app. Use to make trailers with your content
-explain everything
-bugsandbuttons, bugsandnumbers, etc (for lower grades)
-imotionhd for creating stop motion movies
-remind101 – a single directional text for parents and students (can set up groups and for field trips )
-vintagio (for silent films)
-creative book builder
-pickplaypost (create collages) idea: take pictures that relate objective, make collage and explain
-myscriptcalculator (Microsoft version is mathmatica for PC). My favorite of the day (see below) (cost?)

Apps mentioned in a session at EdCampLA

MyScript Calculator Demo

The 1 iPad classroom
John Stevens (@jstevens009) and Eduardo Rivera led this session on how they use a single iPad in the class to teach 8th grade and 9th grade algebra respectively. They utilize both Apple TV and/or the Reflector app to connect their iPads wirelessly to create an interactive and collaborative experience. Here are a few of the apps and resources they recommended:
-educreations and explaineverything (.99)
-appshopper (track apps for pricing)
-class dojo for participation
-Jumbo Stopwatch

After a great lunch I headed off to John Omekubo’s (@jumekubo) session on Subtext. Subtext is an app that allows students and teachers to collaborate on the same book. Students can be invited to a group by their teacher and then both parties can interact by asking questions, tagging and highlighting text , adding resources for the students and much more! Below are a few ideas and resources to support this app. turn web articles into chapters
-make an epub file

The day culminated in a Slam session, where educators stood up and presented their favorite thoughts, apps, websites or whatever they wanted to reflect on, from the day’s events. My favorite is listed below. I actually stood in line to present my slam of the day(MyScript Calculator) but @jstevens009 beat me to the punch, SLAM!
video for playing youtube
– upload any video from google using google docs

Here are some other links that might be useful for finding information on sessions that I did not attend or did not cover in this blog post. You can also peruse the EdCampLA website to search for specific information. Thanks to all of the folks @EdCampLA for a great day!

EdCAmpLA Blog
EdCAmpLA Wiki

CUE Conference 2010 – How To Videos Posted

Hello and thank you to all the people that attended “Igniting the Mathematical Mind” session at CUE on Friday (3/5 ) @ 11:30 AM! Jamie Sweet and myself really enjoyed ourselves and you were a great audience! We would really love to hear from you. We have posted how to create many of the games that we covered in our session. If you see something that is not there and would like to know how to create it, please let us know. Also, if you have time, please visit Session Evaluations (Friday @ 11:30 AM)and evaluate our session, Thanks! Click on the CUE 2010 tab above to access the videos. Subscribe to access the latest videos!

The four minute flip chart for ActivStudio 3

Activstudio 3 is a wonderful piece of software that comes with the purchase of a Promethean Activboard. Some of you may have just received your Promethean board and your not sure where to begin. Sure, you can start writing on the board and even begin to bring in a few shapes or text but you want more, so did I! What I’m about to explain is an easy way to get you and your students started in just minutes.

  1. Open Activstudio 3 Professional
  2. Click on your RESOURCE LIBRARY
  3. Click on the SHARED SHAPES ICON
  4. Expand shared shapes and click on SQUARES AND RECTANGLES
  5. Drag a HORIZONTAL RECTANGLE onto your blank flip chart (do this 3 times)
  6. Expand the rectangles so that they are all of equal size and so that they cover the entire flip chart and are connected
  7. Now, click on the first rectangle, from the color palette click on green and then click on the FILL TOOL icon (the bucket), move it over the first rectangle and click the space bar. The rectangle should have changed to green.
  8. Leave the second rectangle black
  9. Repeat step 7 for the third triangle, but change it to blue
  10. Double click on the first rectangle and click on the icon, OBJECTS TO BACK. Repeat this step for the third rectangle
  11. Double click on the second rectangle and click on the icon, OBJECTS TO FRONT
  12. Let’s add some text! Click on the TEXT TOOL (“T”) and move the cursor over the first rectangle, towards the top portion and click the space bar. An area for you to type and a text palette will open.
  13. On the text palette change the color to blue and type 1.23 + 0.02 = ?
  14. Press the space bar 7 times (or so), change the text color to green and type ? = 1.25
  15. Un-check the BACKGROUND box on the TEXT PALETTE
  16. Close the TEXT PALETTE
  • Note: that when un-checking the background box, at times it converts back. Simply go back and un-check the background box.
  • There you have it! A revealing flip chart template. Move the math question from the left to the right and it will magically disappear and the answer will appear in the blue section. You can use this template to further be creative and add objects, multiple backgrounds and much, much more! Have fun with it. If you have any questions leave a comment or e-mail me. I am glad to help!
  • If you are more of a visual person, click on the tutorials tab for a video enhanced explanation!