LILAC 2013 Google Forms and Tables

Hands on: Creating an Evaluation Form

View a sample evaluation form.

Scenario: You’ve been asked to create a simple online form for collecting library instruction evaluation information from students.  The form must (at a minimum) include the following:

Demographics

Evaluation

Create the form using Google forms.  Try to use a variety of the question types available.  Feel free to include other questions you deem appropriate.

*Tip* Using multiple choice or selection type questions will generally make for cleaner data because it controls the values that get input.  

Hands on: Using Google Fusion Tables

Using the following Basic Instruction Stats Fusion Table try to create the following:

To further explore fusion tables, feel free to play with the Evaluation form Fusion Table which contains some data based on the sample evaluation form

Books

Kaufman, R., Platt, W. A., & Guerra, I. (Eds.). (2005). Practical evaluation for educators: Finding what works and what doesn't. Corwin Press.

Popham, W. J. (2008). Transformative assessment. Association for Supervision & Curriculum Development.

Web Pages

Creating a Google form: https://support.google.com/drive/bin/answer.py?hl=en&answer=87809#87809 

Google Support Pages for Google Sheets: https://support.google.com/drive/bin/answer.py?hl=en&answer=140784&topic=20322&rd=1

Google Support Pages for Google Drive: http://support.google.com/drive/?hl=en

Google Support Pages for Google Fusion Tables: http://support.google.com/fusiontables/?hl=en

Videos

A tour of google forms: http://youtu.be/xEY10Ub-k-U 

Getting Started with Google Fusion Tables Video: http://youtu.be/0HdQYl8EBW8

Other useful Google tools

Google Refine: http://code.google.com/p/google-refine/

Contact Info

Shawn McCann: shawn_mccann@wayne.edu

Immersive Learning Librarian

Wayne State University

Detroit, MI  USA

Rebeca Peacock: rebeca.peacock@wayne.edu 

E-Learning Librarian

Wayne State University

Detroit, MI  USA