photo credit Rachel PangiThere is a new exciting way to use QR code technology in your K-8 curriculum to quickly communicate information to student devices. I have used them to direct students to an app, a website, a text prompt, and more. Each time they’re used there is no concern that the students may end up at the wrong place since it is a direct connection that works on any device.
Recently, I was writing a project about National Monuments, Memorials, and Landmarks. The teacher had access to a class set of iPads, so we decided that we would have the students visit the landmarks virtually before creating their project. There is an app called Sphere 360 that allows users to upload 360° images of locations around the world. The images are accessible to anyone with the app and gives the experience that you are standing in the center of the sphere, looking around the location. Each Sphere has its own URL and I began the search for important landmarks around the United States.
I could not find Spheres for every location, but the list of Spheres I did find was quickly increasing in length. I created a table of the URLs and was trying to think of how we could quickly get the students to the URLs when I remembered QR Codes! Then I imagined myself creating a QR Code for each URL individually and how much time that was going to take. I decided there had to be a better way! So to Google I went in search of a way to quickly create a large amount of QR Codes and I came across this article http://tammyworcester.com/batch-create-qr-codes-in-google-spreadsheet/. I copied my table into a Google Sheet and followed the instructions in this article to generate 38 QR Codes in a matter of seconds! Here is a link to my Google Sheet with the landmarks that I was able to find on Sphere 360 https://docs.google.com/spreadsheets/d/1WLmXu6UxZsO1X8EHnJwruotwV99VAOpKxX_r2834Imk/edit?usp=sharing. I only had one formula not respond correctly but that was easily corrected. You can see the work-around in cell C32. The formula is pointing to cell B40 which has the same URL that is in B32 but the formula wouldn’t respond to that one for some reason. After I had the QR Codes, I copied the table area to a Microsoft Word document which turned the formula-resulting QR Codes into images that I could manipulate or save (it can also be copied to a Google Doc with the same result). The Word document is what I sent on to the teacher for use in her class project.
This QR Code will allow you to experience the Lincoln Memorial in the Sphere 360 app.
This was definitely a great find! Thanks to Tammy Worcester-Tang for sharing this information, it definitely made this project easier to tackle!!!