Yet more just in time learning! I wanted to create some QR code stickers for our school Ready to Read texts so I don’t have to keep fluffing searching for the audio file during the lesson, or going and putting a bookmark on each device to the text. I was going to use bit.do for short links & creating QR codes. A quick Google search & some experimenting = success!
How to create QR codes on mass – use this. It does work. I was really suprised – but excited.
- Go to: drive.google.com.
- Create a new spreadsheet.
- Label Column A “Text or URL.”
- Label Column B “QR Code.”
- Resize the columns and rows so they look like the screenshot below.
- Enter some text or URLs in column A.” Quoted from Google Search”
I then wanted to resize the cells so that QR codes were larger. I figured out how to do one – a bit painful, but achievable – on mass though? No. There is a shorter way.
Resize cells in Google Sheets – “Locate and click the Select All button just below the formula bar to select every cell in the spreadsheet. Hover the mouse over the line between two rows. The cursor will turn into a double arrow . Click, hold, and drag the row border to modify the height.” Quoted from Google Search.