Spreadsheets/Forms

Uses for Google forms...

6 Ways to collect data using a Google Form
  1. Have students conduct experiment in classroom and one member goes to teacher's computer to enter data for that group
  2. Have students create surveys using Google forms and display on own computer; students travel from machine to machine to fill out the survey
  3. Email the form to participants to collect data (can embed the form in the email); must know all members email addresses
  4. Email the form by using a distribution list from your contacts  (very easy if using Google Apps since all domain names are the same)
  5. Share the URL of the published form; consider using a URL shortener for easy access like:  http://goo.gl/, http://bit.ly/ or http://tinyurl.com/ 
  6. Embed the form in a Google Site, wiki, blog or Moodle.

Administrative:
Classroom:
More ideas ...  Google form ideas collected by Karl Fisch http://sites.google.com/site/ahsgform/


Examples of embedded forms:

Administrative:
Classroom:



Reference links from Google Help:



View a Screencast for making a self-grading quiz using Google Forms (thanks to Jesse Spevack) http://www.screencast-o-matic.com/watch/cjXeqwnDe


Google Spreadsheets Background Info

from http://sites.google.com/site/techtipstuesday/

Google offers a spreadsheet as part of its office tool suite. A spreadsheet helps you organize data in columns and rows and can generate graphs using the data. Google Spreadsheet has the added features of being stored online to allow access from any online computer.  Collecting data from multiples users has always been quite the challenge.  But now thanks to Google's shared spreadsheets and forms - it's a snap! Just like Google Docs, spreadsheets can be shared with anyone.  

Here are some examples of how you can use Google spreadsheets:
 
    * Collect names, addresses, and emails of group members or class parents
    * Create a survey for opinions. votes, or preferences
    * Collaborate with others for data collection (ie, fast food nutritional information, State facts, Historical data)
    * Financial Planning or Budgeting
    * Plan a project
    * Collect and store student information

Here's how:

Before you start, decide how you want users to enter the data on a spreadsheet.
          * If you'd like users to access the Google spreadsheet and add the data directly on the spreadsheet, you can share the spreadsheet with them, just like you can with documents. Note: If you do this, all data will be visible to the user.
          * You can email a form, and users can submit the data right from their email program.
          * A user can link to the published form from a URL.
          * You can embed a form into a webpage and users can submit the data from the embedded form.
   
You can create a new spreadsheet at http://docs.google.com by going to New > Spreadsheet. This will open a blank spreadsheet which you should name and save.  Enter your titles, data, or formulas and then click on the SHARE button to enter the email addresses of those you want to collaborate.  They will receive an email with a link to be able to access the spreadsheet. This also allows for easy collaboration through a chat window when two or more of the collaborators are online at the same time!

Another option is to upload an existing Excel spreadsheet.  Now you can access this data from any computer.

 If you would rather have the users enter the data into a FORM - go to New > Form and you will see the beginnings of a web form.  Add your questions and choose the type of answer:  text, paragraph, check boxes, multiple choice, choose from a list or Scale (1-n).  When done, save and then choose to "publish" the form (it provides a long URL), "Email this form", or from "More Actions", get the embed code to embed the form into a webpage, wiki, or blog.

 When users enter the data into the form and press submit, all of the data will be dropped into ONE spreadsheet.  This is an excellent way to gather data from multiple users.

Example of peer evaluation form from HS science class

Sample Google Form


Comments