I am currently investigating docAppender as I work towards sitting the certified educator level 2 exam. As I have looked into this, I am intrigued by the possibility of developing an observation tracking form.
We have established a tracking table on docs for students, but this has become clumsy as more is added to it. Data requires multiple entries when multiple students are involved.
Earlier today I was considering forms as a method of tracking because at least you could sort by name etc. DocAppender however, has a possibility to send this information into multiple documents, allowing a central collection as well as an individual tracking sheet. It will be interesting to see how these can actually be used.
Anyway, brain unfrozen. I shall continue my work. Update to come.
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.