Google TOOLS Collaboration

Using Google Tools to Collaborate: Documents, Spreadsheets, Email, Presentations, Photo Editing

You don’t have to purchase any software or apps for this course – Google makes all these products free. You can use a computer, tablet or phone! Demand for online collaboration tools is skyrocketing – and for good reason – you can get a lot done in a short amount of time. Learn how to use Google Documents to read Word, PDF, Excel and PowerPoint files without having Microsoft software. Learn how to SHARE these documents with other people, a class or group, and how to have multiple people from anywhere in the world update the documents...even at the same time. Extra help will be available until 8:30. If you need help setting up a gMail account before class starts or if you have questions, call JilMac at 802-254-8628. Class limited to 12 students.

.....................................................................................................................JilMac notes .... combine this with https://sites.google.com/site/jilmacgsites

Watch this video as I walk you through creating your FIRST Google Tools - Document

Course Documentation: http://JilMac.com > Workshops & Classes > WRCC > Collaboration > Google TOOLS Collaboration Click Handout: Link to Document

Google Documents Training (15 videos + extras & quiz) https://www.gcflearnfree.org/googledocuments

Mailing Group: GoogleCollaboration2016@googlegroups.com

Please send an eMail to: JilMac.MacRand@gmail.com

Session 1

Introduction & Discussion: What does it mean to Collaborate on-Line?

• • Wikipedia lists them alphabetically http://en.wikipedia.org/wiki/List_of_collaborative_software

  • Google Apps http://en.wikipedia.org/wiki/Google_Apps_for_Work - gMail, Calendar, Hangout, Picture, can be shared as view only

  • Google Drive http://en.wikipedia.org/wiki/Google_Drive - individual files & folders can be shared for update

Handout(s): "Google Documents & Spreadsheets", "Google Document - Sharing Documents"

• • Overview of Google Documents Handout: Word Document Google Doc

  • How do I share a Google Folder or File? Handout: Word Document Google Doc

  • Revision History Handout: Word Document Google Doc

  • "Google Documents Revision History" and "Reading Microsoft Files and Writing Microsoft Files" File > Download > Word or PDF format

Workshop:

• • Login to each students individual Google Account (gMail login)

  • Create a Google Document

  • Create a Shared Folder

  • Move the document into the Shared folder

  • Share the Document with JilMac and at least one other student

  • Change permissions from Can Edit to Can Read - note the changes

Session 2

Discussion:

• • Review of Google Documents

  • Answer Student Questions

  • Let's add a Graph to the Above Spreadsheet "Spreadsheets can ADD"

  • Everyone Update Google Sheets

    • Login into Google gMail

    • Click Rubrics Cube > select DRIVE > click SHARED WITH ME >

    • Open the Folder ___WRCC-Collaboration-Can-Edit

    • Add your Name and Eye Color - watch and see as everyone add's their data

    • Everyone Create a Google Sheet of their own > NEW > Google Sheet > Rename Sheet-MyName

    • Everyone SHARE their Google Sheet with group Google

Handout(s):

• • Google Documents can read and write Microsoft: Word, PDF, Excel and PowerPoint files

  • Microsoft Word 2007, 2010, 2013 & 2016 have the Ribbon and are very similar

  • Word 2003 is similar to Google Documents, Excel 2003 is similar to Google Spreadsheets

  • What are the differences between PowerPoint & Presentation

• • Understanding Permissions

Google Spreadsheet Videos (16 videos + extras + quiz) https://www.gcflearnfree.org/googlespreadsheets

Workshop:

GOOGLE GROUPS: What is a GROUP email?? How does Google do Groups?? Do any of you already participate in Groups??

PLEASE JOIN Our Google Group - this is how we send group emails & how we share documents - Please use your gMail account.

• • Presentations - imbedding Videos https://drive.google.com/?authuser=0#folders/0B_nsZH_N7X9mWVMxU2xudFd2TE0

  • Answer Student Questions

  • Synchronize - Question from you!

    • Some people have their Google settings set up to AUTOMATICALLY SYNC - this may cause you to upload files that are in the WRCC1's login DOWNLOAD folder. You may want to change this setting in your Google > Settings or use your own computer while in class.

    • At the High School/WRCC you are prompted to log into CHROME to Login into Google go to http://Google.com

    • To see what is Synchronized - if you have logged into Chrome:

      • From the MENU button in Chrome > SETTINGS > ADVANCED SYNC settings button,

      • It will display exactly what's synched.

    • On YOUR computer - choose what is Sync'ed https://support.google.com/drive/answer/2375083?hl=en

  • Images

    • Go to your Google Drive

    • Create > Drawing (note: if you are in a Shared Folder, it will ask if you want to share this Drawing) > Click the Button Create & Share

  • Using Mobile Technology with Google Docs - most things are the same ... remember - working with Tablets & Phones takes some time to transition from using a Computer

Handout(s):

• Google Calendars: Creating & Using BASICS.doc Word Google Docs

Workshop:

• Lets use Tablets & Phones to collaborate

• What other tools are available

  • Click the Nine-Squares

  • Two Categories - Those that you can have "Others ADD To", Those that others can view

    • We have learned how to share documents for others to Own, Update and View in this "Using Google Tools to Collaborate "

    • Let's look at a few products that you can share in View Only

      • Calendar <-- Only the owner of a Calendar can edit it, but you can Combine Calendars to see overlapping open spots.

      • Pictures

      • Google Search for Web, News, Videos, Images, Documents .... Don't forget Advanced Search Use "-" to remove, Time and Location

      • Maps

      • YouTube <-- we shared the ability to INCLUDE a video into a Presentation, but only the author or the video can edit or upload it.

      • Google Books

      • Blogs

      • Translate

      • Groups

      • Hangouts

      • Forms

Wrap-Up:

• How do we keep learning? Where do we get support? How to Google for Answers

• Questionnaire (This is a Google Form)

  • You could also email people this link https://docs.google.com/spreadsheet/viewform?hl=en&key=0AvnsZH_N7X9mdEM5MG9UT1hwM2VjcExXWVVYakpyWHc

  • Or include it in a Google Doc or Microsoft Word document Click here to fill out the WRCC Class Evaluation

• • • You can copy and paste the statistics and put them into a Document

    • This will keep a snapshot of the data at a particular time

    • You can also make a copy of the FORM as a snapshot in time.

• Learn more about forms on JilMac's page: https://sites.google.com/site/jilmacgsites/form

• Google+ Share everyone's pictures from an event http://www.google.com/+/learnmore/events

• Google Forms will be updated sometime this year! with more great features https://support.google.com/docs/answer/3541269?p=pre_form_migrate&rd=1

VIDEOS by JilMac for Learning Google Tools

JilMac Demonstrates GoogleTools GoogleDocs

JilMac Demonstrates Google Calendar embed G Site+HTML

JilMac Demonstrates Imbedding PowerPoint Google Slide into your Google Web Site

JilMac Demonstrates Embedding Google Maps Gsites & HTML

Google SITES - a way or ORGANIZING your files, folders, images, links, maps and more

• • • Google Calendar & Inserting into a Google Site

JilMac Creating a Google Site Editing

JilMac Creating a Google Site AddingLinks

JilMac demonstrates creating a FaceBook Professional Page + Clickable Facebook Like

JilMac demonstrates Google Sites Open Link in New TAB

JilMac demonstrates Google Sites Open Link in New TAB

JilMac Demonstrates GoogleCalendar

JilMac Creating a Google Site AddingPages

JilMac Demonstrates Making Google Site MOBILE

JilMac Creates Favicon GoogleSites

JilMac Demonstrates Paint+Pixler Sizing an image

JilMac Explains Clickable Links

JilMac Creates a FAVICON

JilMac Demonstrates Uploading an mp4 video to YouTube https://www.youtube.com/watch?v=C4V3uyV52Qc