A short while ago I was given a little problem to solve – to find a way for department members to create an editable ‘task list’ for our Curriculum Area Supervisors – and make it available on our VLE.
After a fair amount of playing around I turned to Google Forms, which is incredibly useful for surveys, formative assessments, feedback and lots of other things. Here I could create a form for staff to complete and make the results visible to all, whilst only allowing a select few to edit the resultant spreadsheet. This was exactly what I was after.
Google Forms has lots of great functions that make it ideal for this task. Both the form and the resultant spreadsheet can easily be embedded in a webpage, whilst you can also control who has access to the editable spreadsheet (Frog IF statements helped here too). The linked versions are copies containing only test data, so you can try it for yourself.
In addition, Google Spreadsheet allows the results to be filtered and sorted – allowing for a quick and easy process of identifying the tasks that need to be completed, including the use of low, medium and high priority options to filter tasks by.
So we now have a new system for building task lists and it’s unbelievably simple to create. I look forward to seeing exactly how successful it is…
Below are some of the failures I endured before settling on Google Forms as the chosen problem solver.
I tried using our Frog VLE Calendar to make the task list. It worked fairly nicely, but only showed up the ‘required completion date’ on the calendars of individuals. Frustrating, as I expected.
Naturally, I asked my Twitter PLN for advice and almost all (kind) suggestions pointed to Google Docs. So I built a straightforward document that could have the information entered on it. Not only did it look rubbish, it didn’t allow the data to be sorted either – one of the few absolute necessities.
Google Calendar was the final avenue I unsuccessfully travelled down, which is strange since I am a huge fan. For some reason Google don’t allow you to share ‘tasks’ with others in the same way you can easily share calendars. They have clearly known about this for a while too.
Any advice on how I could make this whole process even more efficient very welcome.