Spreadsheets/Forms - Integrating Google Tools 4 Teachers

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

Google Spreadsheets and Forms

Source: https://sites.google.com/site/colettecassinelli/spreadsheet

ruben studdard black friday sales 2011 black friday sales 2011 whitney duncan bradley cooper elisabeth hasselbeck roger craig