Google Forms – passing user details from a VLE

November 27, 2012

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.

Getting started

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:

  1. You want more functionality from your forms
  2. It’s really easy

    Create a form in Google Docs

    This is the current Create button in Google. By the time this post is published I fully expect Google to have changed the design completely

Quick primer

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.

Advertisements

iPad

July 18, 2010

It’s Sunday morning and I’m sitting here with an iPad.  It’s not mine, Cramlington decided we should get one as let’s face it, the buzz surrounding them could mean they become the next big thing in education.Apple's iPadGetting a chance to play with it this weekend has been “interesting”.   I’m not sure where it fits into my ICT use.   If I want to check out my favourite websites, my mobile phone (an HTC Desire – Android smartphone)  can view those sites easily.   The size and weight of the iPad makes it uncomfortable to hold and operate.  And if I want to do more complex tasks, my laptop takes care of those. 

Ultimately for me, the biggest issue with the iPad is the limitations of the browser.   The lack of a Flash player aside, I found plenty of other websites it just didn’t handle particularly well.  I had planned to write this post on the iPad this morning; in much the same way as I used my phone to post on one occasion.  Unfortunately, I wasn’t able to using iPad’s Safari.   The software was so limited it could not interact with the non-standard text box.*

At this point, I suddenly realised what the iPad is.   It’s an App-using tool, not a mini-laptop.  Rather than using the preinstalled programs if I want to accomplish something, “there’s an App for that”.    In fairness, that’s not much different from the PC experience.

Like netbooks before it, it’s very easy to expect a higher capability than the device can deliver.  Is it my fault or Apple’s that I made this assumption?  Given the price tag (£365 + VAT for the cheapest option) I think it’s a little of both.  

My conclusion then?  That will have to wait until I’ve installed some Apps.  Given that other school staff desperate to get their hands on it, my conclusion might be some time.   So for now, I’ll leave you with this thought:   What good is a browser that cannot view Flash?  Especially that 90% of educational resources are made using Flash.


* If I had wanted I could have installed the WordPress App and written the blog that way.  I haven’t, because it’s a shared resource and in order to install Apps, you have to register with Apple.  I’ll do that Monday with the school’s credit card.


Simple English Wikipedia

July 7, 2010

Stepping back from technology for a post, here’s a really good, simple idea.   Wikipedia as a resource is sometimes good, sometimes misleading and generally always useful.  But, it’s explanations can be a little dry.  

Simple English Wikipedia

Simple English Wikipedia offers cut-down, simpler definitions for its subjects.  Here’s an example of the first paragraph of both Wikis for HTML – the code of the internet:

Wikipedia:

  HTML, which stands for HyperText Markup Language, is the predominant markup language for web pages. It provides a means to create structured documents by denoting structural semantics for text such as headings, paragraphs, lists etc as well as for links, quotes, and other items. It allows images and objects to be embedded and can be used to create interactive forms.

Simple English Wikipedia:

  HyperText Markup Language (HTML) makes web pages display properly on the Internet. It is a markup language, which means it has a mix of a normal language that people can read and a special programming language that tells computers what to do.

All the information you need is still there in the second definition, but in an easier to digest form.