Sunday, May 28, 2017

Managing All Those Lists!

Do you ever find yourself drowning in lists? Where did I put the class list? The field trip list? Who returned school photo orders? Who got student of the month so far?

The answer of couse, is a spreadsheet. That may seem like a no-brainer, which is why I haven't blogged about it, but I have a few tips that have worked for me and may work for you.

  1. Use the same spreadsheet for all the lists. Just make a new sheet within the file when you need a new list. That way you always know where to find it.
  2. When you need a new check off list, just duplicate the original sheet. Then you have all the kids names, You never have to type a list again.
  3. Bookmark that spreadsheet right at the top of your screen. It will always be handy.
  4. Add student names when you first set it up with first and last in separate columns so you can sort either whenever necessary. 
  5. Advanced tip - use conditional formatting to help you visualize info.

Here's a sample file with some ideas to get you started. Link Here 

Sunday, May 21, 2017

Creating Bulk QR Codes for Student Work

So Open House is coming up and students have lots of work to share. Maybe you have some cute videos or recordings of student reflections. Here's how you can create a class set of QR codes quickly in a Google Sheet.

Make a copy of this sheet: QR Code Creation Spreadsheet
Add your student names to column A
Paste whatever links or info you need the QR code to share in column B
Copy the formula in column C by selecting C2, hover over the tiny blue square in the lower right corner, and drag it down to fill as many rows as you need.
This is the formula to use:  =image(""&B2)

The QR codes will be displayed as small or large as the row size. To change the size of all the rows at once, select the top left cell, some people call the awesome box. That will highlight the entire sheet. Any changes made to a row or column, will be done to every other row and column.

You can hide the link column if you want. Then just print the spreadsheet.