Tag Archives: spreadsheet

Make a Google Form in 5 Minutes

I was once sitting in an meeting of the Gaming Special Interest Group at a CALICO Conference (I mention these details because this is a great group within a great organization — check them out) when we got to the point in the agenda where we needed to collect the names and email addresses of everyone in the group.

Rather than passing around a pen and a pad of paper, I whipped up a Google Form on my iPad and passed that around instead. Not only was it so quick and easy that I had the form created and the information collected before the end of the 30-minute meeting, but I didn’t have to try to decipher anyone’s handwriting in order to get their email address.

The simplest Google Forms look like online surveys.  As the form is completed, the answers are uploaded to a Google Spreadsheet. And, like all of the different types of Google documents in Google Drive, the form and the spreadsheet can be made public, private, or unlisted and multiple collaborators can be given various levels of access from owning to editing to viewing.  Of course, private information entered into the form is still archived by Google.  If your institution, like mine, has protocols involving what information can and can’t be stored in the cloud, you may want to investigate those before using these tools.

If you’ve never created a Google Form, take a look at the above video for a 5-minute walkthough.  Then open Google Drive, sign up for a free Google account (or sign in if you already have one) and create your form.  It’s easier than you think.

Leave a comment

Filed under Resources

Crowdsourcing Meta-Resources

A Google Spreadsheet of TED Talks.

A Google Spreadsheet of TED Talks.

I came across a blog post on The History Teacher’s Attic which organized TED Talks by educational discipline and haven’t been able to stop thinking about it.  The interesting part is that the post is based on a Google Docs Spreadsheet containing information on every TED Talk through July 29, 2009.  The thing I like most about this post is the potential in this spreadsheet.

Johnny Lee's TED Talk introduces his $50 interactive whiteboard.

Johnny Lee's TED Talk.

First, most TED Talks are fascinating (Johnny Lee’s talk introduced the world to the Wii-based $50 interactive whiteboard) and authentic audio resources for advanced ESL students.  Having one central resource with overviews of all talks, is very useful for an ESL teacher.

Second, Google Docs can be very useful tools for collaboration.  Because they are cloud-based, anyone can access and edit documents via a web browser.  By opening up the document for anyone to edit, the work of compiling all of the information can be distributed to many people.  For example, this list of educators on Twitter spreadsheet was crowdsourced, meaning many people did a little bit of work to build what is a pretty extensive list.

The US Presidents mashup.

A mashup of US Presidents.

And once the spreadsheet has enough information, it can be mashed up in useful new ways.  For example, this mashup, created using MIT’s Exhibit, makes the information in the TED Talks Google Docs spreadsheet sortable and searchable.  Other examples include Flags of the World, which combines flag images from Wikipedia and a Google Map, and US presidents, which includes a timeline, map, images, and facts about each president such as religion and political party.

So, at this point, I’m ready to begin the new project of collecting and compiling some of my favorite resources into larger, crowdsourced, mashable meta-resources.  I’m going to start with a wide-open Google Docs spreadsheet, and then try my hand at different mashups.  But, before I begin, here are some questions I’m trying to answer.  (Feel free to supply your answers by commenting on this post.)

This American Life has great audio.

This American Life has great audio.

First, what resource(s) should be compiled?  TED Talks seem to be relatively well covered, but how about a similar resource for This American Life episodes, stories from The Moth live storytelling events, YouTube videos (EDU or otherwise), or other resources?  Should the meta-resource be targeted to ESL / EFL teachers or all educators?  And finally, what information should be included?  A link to the resource, the title, duration and a synopsis are obvious details, but what else?  Maybe keywords or tags as a way to organize them, the goegraphic location of where the story takes place, a warning system for language or content not appropriate for the classroom, and links to related resources in case students want to explore particular topics further.

So, consider this a call to action.  I’m going to solicit lots of feedback and then begin.  Once underway, I’m going to solicit more help.  With a little crowdsourcing, we can grow some really interesting and useful resources.


Filed under Resources