Following on from my previous post about using Google Forms to help compile profiles for new bloggers, I have a few updates to share.
I wasn't satisfied with using an add on that only had a limited trial period, and thanks to my mate Vicki, I have another tool called Autocrat that does the job for free. Yay! To get Autocrat, you need to use the add ons menu in Google Sheets. Helpful tip if you're going to use this add on is to make sure your spreadsheet settings are accurate: File > Spreadsheet Settings > General.
Fiona also suggested that it might be helpful to record a demonstration of the merging process, so I have done that too. Please let me know how you get on with this, if you use it. I would also be interested to know of any other classroom uses you can think of for this kind of 'form + template + merge = save admin time' idea.
Kia ora Cam, I bookmarked this as I knew it would be a 'go to' for me some time in the future... the time was right this term.
ReplyDeleteI have set up a page on the Cybersmart site under Smart Footprint with links to your your blog posts and have included how I repurposed slightly for a year 3-4 class rolling out blogs for the first time this term. Thanks for creating and sharing this... a real game changer.
ngā mihi
Fiona