The tutorials for how to do this already exist on Google Docs, but whenever I see a survey posted on our VLE, this extra is never included.
I’m assuming if you’re reading this you already know how to set up a Google form. I’m assuming that not because I want to make anyone (including me) an ass, let alone recite a cliché. No I’m assuming, gentle reader, that you know how to make a form in Google for two reasons:
- You want more functionality from your forms
- It’s really easy
Just in case, I’m going too fast:
- log into Google Docs
- click on the Create button
- click Form
Once your Form is opened you can set about adding questions in all sort of styles, from text entry and paragraphs to multi-choice, scales etc… But let’s be honest, you know all this.
Get to the “fun” bit
Alright, I went as fast as I could. So, assuming (there I go again) you’re using a similar set up to Cramlington, where surveys are posted as links inside notices and do not require our students to be logged into Google Docs, you will have no idea who the student is who is completing your survey.Easiest solution is to include a username field. Generally our students are honest and will fill this out, but that’s assuming they spell correctly and include the tutor code part of their username. It would be so much simpler to just pass those details from our VLE.
Fortunately, we use the Frog VLE which exposes the user’s username in a simple Frog tag: [user_username]
This username can be added to the Google Form address in the following manner:
https://docs.google.com/spreadsheet/viewform?formkey=lots of letters&entry_0=[user_username]&
What does that do?
The actual address of the form is:
https://docs.google.com/spreadsheet/viewform?formkey=lots of letters
There’s a link to the form at the bottom of the edit page. The rest comprises of:
& tells your browser that the formkey variable has ended.
entry_0 is a new variable and corresponds to the first field in the form. If you put entry_1 you could set the second variable in the list and so on.
[user_username] is our Frog tag
You can see the example for yourself here:
And that’s it. Simple.
Now all I have to do is make our 100+ teachers read my blog.