Today I was looking for an alternative to Blackboard’s survey manager when I stumbled upon this great suggestion from Technology Bites. All you do is go to Google Docs (docs.google.com) and create a new Google Docs Spreadsheet (you’ll need a free google account, but if you’re a Gmail user or a Blogger blogger you’ll have these already). One of the sharing options that Google provides is web form for data input and this is quick and easy to use. The rest of this article takes you through the process with a screencast supported demo.
Let’s say I want to make a spreadsheet for gathering student module assessments for one of my courses. In the School of Engineering, we use paper for this, but here’s how I could do it with Google Docs. To make it easier to follow, I am illustrating each step with mini screencasts captured with Jing. [When I created these at the Uni, either the network or screencasts.com was running really, really slowly, so have patience!]
There is also a google gadget that you can use to keep an eye on the form while it is active.
Once the data is in the spreadsheet, you can edit the column fields that the form editor created, and do various other things such as deleting a form field (only the column title goes, any associated data remains). However, deleting a spreadsheet column does not remove the corresponding form field.
When you have made your form available for long enough to collect some data, you can turn off the data capture from the spreadsheet page. As there is no real access control on form submission, you will need to be careful to check the data and eliminate any obvious spam and duplicate submissions.
There are virtually no validation features: for example, a second submission by the same user creates a new row in the spreadsheet. Maybe Google will add these in later revisions. If you want these features, alternatives (free with limitations) exist: e.g. SurveyMonkey.com seems to have a good range of features.
Because it is module specific, anonymous, and doesn’t record an individual’s response, a Blackboard survey may be more appropriate than Google Web Forms for many tasks, including the one described here. If you want to create a more complex survey, then one of the alternatives like SurveyMonkey.com may be more appropriate. However, if you want the response data in a spreadsheet format for quick analysis, don’t mind leaving the Blackboard “walled garden” and are prepared to do a bit of your own quality control, then Google Docs is a very quick and simple way to create a survey and gather your data in just the format you need it.
If you know spreadsheets, it’s childishly simple to use, and it’s worth considering for that reason alone!
Chris Jobling May 21st, 2008
© Swansea University
Hosted by Information Services and Systems, Swansea University