New learning = blogging explosion

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.

“Getting Ready:
  1. Go to: drive.google.com.
  2. Create a new spreadsheet.
  3. Label Column A “Text or URL.”
  4. Label Column B “QR Code.”
  5. Resize the columns and rows so they look like the screenshot below.
  6. 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. 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s