Wednesday, November 2, 2011

Oh the things you can do with Google Spreadheets and Forms by Tammy Worcester

Getting Started

Google Accounts for the Teacher
    A. Go to www.google.com to create a generic google account.
        or
    B. Go to www.google.com/mail to create a Gmail account.

To Create Google Spreadsheets/Forms, go to:
    - http://docs.google.com

Helpful websites:
    - Getting Started with Google Spreadsheets
    - Google Spreadsheets Help Articles

Spreadsheet Lesson Plans:
-Google Spreadsheet Lesson Plans Part 1
-Google Spreadsheet Lesson Plans Part 2
-Google Spreadsheet Lesson Plans Part 3


Spreadsheet Collaboration:
2 options for collaboration:

Option 1 - Invite Collaborators (Requires Google Accounts)

1.Click the “Share” button in the upper-right corner.
2.Enter the email address of the desired collaborators.
3.Click “Share.”

Option 2 - Share via a link (No Google Accounts necessary!)

1.Click the “Share” button in the upper-right corner.
2.Click the “Change” link at the top.
3.Choose to allow “Anyone with the link to View.”
4.Also choose to “Allow anyone to edit.”
5.Click “Save.”
6.Give the provided URL to the desired collaborators.
Note - You may want to use http://tinyurl.com or another similar tool to shorten the URL first.


Google Forms

Quiz Bowl
Create 2 fields (name and answer) to use over and over again.


Digital Dropbox
Create fields for:
-Class
-Last name
-First name
-Assignment name
-URL   
-Student Notes/Description

Use to collect and organize digital student assignments.

Art for this activity was created at:
http://artpad.art.com/artpad/painter/

Self-checking quiz
Click here

http://www.tammyworcester.com/TipOfWeek/TammyWTechTipOfWeek/Entries/2010/2/15_Tip_81_-_Google_Docs_Self_Check_Quizzes.html