As my students did their Genius Hour projects this year, I've been working on my own. It's something I've wanted to do for a while and was inspired by a post on doing a QR Inventory in the Band Director Group on Facebook. I didn't follow what was shared there exactly, but it was a great spring board for how to make this work in the way I imagined using Google Drive and QRs. It's been tedious, but so worth it. I checked out an instrument to a student with nothing but my phone today!
Here are the nuts and bolts:
- First is one master inventory folder.
- Within those instrument group folders are sub folders for each individual instrument. The QR links back to these individual folders. The green folders are instruments that are checked out to students right now. To change the color, either right click the folder or, if you're on a mobile device, click the three dots on the folder, then select Change Color. Each folder is named with the brand and serial number.
- Each individual instrument folder has yet more sub folders for pictures (to track instrument condition), repair slips, and a Google Sheet with the instrument check out information such as Student name, case number, date the instrument agreement was handed in, any accessories in the case, etc. Pictures taken can be added to Drive through the app on a mobile device.
- Once all of the folders and sub folders are created, this magic extension will populate a Google Sheet with the links to each of the sub folders! I use the URL option. Use the link to the Instrument Group folder and it will give you a sheet with the sub folders for that instrument.
- It makes a folder of folders into this!
- From there, this QR Generator will create a page of QR codes from the column of links.
- The QR codes can then be printed and attached to the instrument cases. Through the sharing settings on the folder, I am the only one who can access the information when the QR is scanned to protect student information. After downloading the Google Sheets app, the spreadsheet can be edited from my phone.
![]() |
Voila! A QR inventory system! |
Hopefully this made sense, but I'm happy to elaborate and clarify if needed! It's always a little different when describing the process for someone else than it was going through it at the time. Thoughts? Questions? Additions?