foulgerinnovations

 

Google Docs, Spreadsheets, Presentations

Page history last edited by Jessica Pranke 1 yr ago

 

 

Technology Mini-Teach PowerPoint Link:

http://docs.google.com/a/asu.edu/Presentation?docid=dfx77np7_4g84kzvcv&hl=en

 

Created By:(10:30 am) Jessica Pranke, Courtney Grable, Laura L.,

(12 pm) Lynette Hill, Emily Delster 

 (9:00 am) Tara Stoicescu, James Dahm, Elda Sandov

 

History:

http://www.google.com/corporate/ takes you a page where some background knowledge of Google may be learned.

 

 

Google Docs is really easy to use! But if you need help here is a short tutorial on how it works:

 

 

 

 

What are the Benefits for Teachers using Google Docs!

 

The possibilities are endless! Google Docs can be used to collaborate with other teachers on lesson plans (creating new ones or making changes on old ones) as well as other topics. They can also be used for teacher/student collaboration on projects. (Think TIPP project!).

 

Additionally, as a student this is a great tool for collaborating on group projects.  Everyone is able to see and edit in real time, and this makes communication much much easier. 

 
Google Spreadsheets:

Under Documents click on the more button, select Spreadsheets.

 

Under the File Tab: 

A spreadsheet may be imported or created at this point. Keep in mind that the formulas from Excel do not transfer, they will need to be recreated under the formulas button. To copy in google docs, use Ctrl C, to cut use Ctrl X, and to paste use Ctrl V.

A new option of notifying the spreadsheet creator when any changes have been made has been added.

 

Under the Revisions Tab:

Access to previous revisions of the spreadsheet is available. 

 

Under the Edit Tab:

Cells may be merged and edited. An option to wrap text is available.

 

Date, time, and currency formats may be utilized by clicking the format button.

Row, columns, and charts may be added or deleted using the insert or delete buttons.

Charts may be created within the spreadsheet. Images which have a URL may be imported into the spreadsheet but may not be larger than 500px in height or width.

NEW: Gadgets may be inserted in a spreadsheet.

 

Under the Sort Tab:

A to Z sorting is available. 

Freezing a row or column for larger spreadsheet viewing may be utilized.

 

Under the Formula Tab:

Cells may be added, subtracted, or averaged by creating a formula. Other formulas such as payments can also be created.

 

At the bottom left corner of the spreadsheet click on the desired sheet to create a template.

Click duplicate. Sheet is automatically duplicated.

Sheets may be renamed by clicking on the new sheet button.

 

Discuss button:

Instant messaging is available if group members are signed in and viewing the spreadsheet.

 

Share button:

Once the spreadsheet has been created and saved, it may be shared with other people to view or collaborate. If you do not want anyone to change the spreadsheet, just click the view window.

 

Publish Button: 

Documents may be published online for anyone to view. Click the radio button, anyone can view this document.

A URL is established. 

http://spreadsheets.google.com/pub?key=p4-mFZjvfYbposwZUJNFtWw

 

New Features: (Be sure to check this out occasionally)

Under new features at the top right of the window, there are various new options to learn with detailed steps.

 

 

SPREADSHEET SURVEYS:

Create a spreadsheet, save the spreadsheet, then click the SHARE tab, and click the radio button "to fill out a form."

 

Start editing your form.

 

Type the question.

 

Under the text button, choose the type of response you wish.

 

Now choose recipients, type in the email addresses.

 

Under preferences, all answers may be viewed by recipients. A custom confirmation message may be checked. 

The survey may be shared with other people to view or to collaborate.

 

Click Invite People.

When you have invited a person to respond to the questionnaire, they need to click on the check for updates to reply, type the reply and then submit.

 

The response will appear in the questionnaire.

 

Spreadsheet may be published. Click anyone can view this document.

http://spreadsheets.google.com/viewform?key=p4-mFZjvfYbpcKvUMnQAIMw&email=true

 

If modifications are allowed an email notification may be set to notify the creator of the spreadsheet.

 

Click the Set Notification Rules link at the top of the spreadsheet.

Go to File > Set Notification Rules.

Go to the Share tab.

 

Collaborators will see the usernames of people who have modified the spreadsheet.

Viewers can set up notifications, but cannot see usernames.

 

 

Under Spreadsheets be sure to check out:

Under new features at the top right of the window, there are various new options to learn with detailed steps.

 

 

Google Presentations:

 

This function is like Power Point but does not have all the fancy bells and whistles in it.

 

 

After opening Google docs, Select “New”, then “Presentation” which will open the window.

 

From here there are many things you can do. Change slide layout, themes and backgrounds are just a few. Don't be afraid to try something.

 

EDITING:
 
There are many editing tools you can use. Change the font style, size, bold italics are just a few. The only draw back is that there are only a couple of font styles to choose from.
 
 
HELPFUL HINTS:
 
Remember:
  • Save frequently
  • Backup work 
 
Pros:
  • Able to access everywhere 
  • Able to work collaboratively in real-time from various locations
  • Able to track Revisions every time saved

 

 

 

http://docs.google.com/Presentation?docid=dcj57bpv_2hkffb7cp&hl=en

 

 

 

Teaching Incorporation:

 

Google Docs for Educators:

 

http://www.google.com/a/help/intl/en/edu/index.html This website offers free applictions for eductors to use for communication, collaboration, to publish tools and email accounts on your schools' domain.

 

http://www.google.com/a/help/intl/en/admins/edu_benefits.html Google provides a web page which describes how eductors may use Google Docs and ways to present using Google Docs to convince others of incorporating it.

 

http://www.google.com/a/help/intl/en/admins/customers.html This link will take you to testimones of ways major companies and ASU has used Google Docs sucessfully and offers ideas to use in classrooms.

 

SlideShare:

 

http://www.slideshare.net/juicygeography/using-google-apps-for-education/ A PowerPoint of ways to use Google Docs for Education. Similar to SlideShare, projects are stored on a server, and multiple students can collaborate on a document simultaneously.

 

Articles:

 

http://www.edutechie.com/2006/11/google-docs-education/ An article from EduTechie.com titled Goole Docs' Academic Potential and Importance. Need I say more...it is great to read to get an idea of the importance and ease of using a simple tool such as Google Docs.

 

http://chronicle.com/wiredcampus/article/2861/google-docs-moves-offline Google Docs announced on April 1, 2008 that they are creating offline capabilites for Google Docs- unlimited potential!

 

Information taken from Google.com under fair use guidelines.

 

Comments (0)

You don't have permission to comment on this page.