Spreadsheets/Forms

Uses for Google forms...

Administrative:
  • Principal's use forms for classroom observation with entry from an iPod Touch.
  • technology inventory
  • feedback on mentoring and lead teacher programs
  • staff development surveys
  • Forms for morning lunch count, students enter selections and teacher sees totals.
  • Business Manager is working on one for her OSHA building walk-throughs.
  • Typical weekly questions and school surveys as well.
  • To do list: enter jobs for my assistant as I identify what needs to be done... all of the assignments are in one place.
  • Collect data before a workshop: http://spreadsheets.google.com/viewform?formkey=cE1XUVBUU3JzS1h4TkE3Qkl6R0loTFE6MA  
  • For admin & teachers, here is an example of data used in mail merge to create end-of-term student evaluations (1 page typed per student):
    http://spreadsheets.google.com/ccc?key=pu5NGQr-ucZwix8Odd1RPaw
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