Google Workspace

Course Overview

In today’s dynamic and interconnected world, effective collaboration and seamless communication are essential for success in both personal and professional endeavors. Google Workspace offers a versatile array of cloud-based applications designed to streamline workflow, enhance teamwork, and boost productivity across various domains.

Overall, Google Workspace plays a crucial role in modernizing workplace productivity, fostering collaboration, and empowering organizations to adapt to the evolving digital landscape. Its comprehensive suite of tools, combined with its emphasis on security, scalability, and flexibility, makes it an indispensable platform for businesses seeking to thrive in today’s competitive environment.

Course Outline:

Module One: Getting Started

1. Housekeeping Items
2. The Parking Lot
3. Workshop Objectives
4. Action Plans and Evaluation Forms
5. Evaluation Form

Module Two; Using Google Drive

Managing Files

1. Copying
2. Moving to Trash
3. Downloading to Hard Drive
4. Uploading from Hard Drive

Creating and Managing Folders

1. Copying
2. Renaming
3. Removing (Moving to Trash)
4. Uploading Folders from Hard Drive

Locating Files

1. Search
2. Recent
3. Shared With Me
4. Uploading from Hard Drive 
5. Computers and Device Sync Settings

Changing Display and Setting

1. Grid or List View
2. File or Folder View
3. Offline Accessibility 
4. Notifications (Adding Content and Deleting a File)
5. Folder Activity

Sharing Files and Folders

1. Add to My Drive
2. Assign or Remove Ownership
3. Permission Settings
4. Publish to Web

Module Two: Review Questions

Module Three: Using Gmail

Personalizing Settings

1. Set Vacation Responders
2. Desktop Notifications 
3. Language and Display Preferences

Managing Your Inbox

1. Applying Filters and Blocking Addresses
2. Archiving Messages
3. Mute
4. Multiple Inboxes

Managing and Communicating with Contacts

1. Composing
2. Replying and Reply All
3. Forwarding Emails
4. Carbon Copying (CCing)
5. Blind Carbon Copying (BCCing)
6. Launching a Text Chat
7. Launching a Video Call
8. Sharing a File (Attaching or Linking)
9. Inserting Images

Locating Messages

1. Searching and Sorting Your Inbox
2. Sent Messages
3. Drafts

Using Gmail Offline

Module Three: Review Questions

Module Four: Using Hangouts Meet

Scheduling, Launching, and Screen Sharing

1. Scheduling a Hangout
2. Launching a Hangout
3. Presenting Your Screen in a Hangout

Managing Sound, Video and Bandwidth

1. Muting Microphone
2. Turning Camera Off
3. Reducing Bandwidth

Managing Meetings with Hangouts

1. Dialing In
2. Inviting Users
3. Hangouts Chat
4. Muting Other Users
5. Ejecting Users

Module Four: Review Questions

Module Five: Working in Docs

Setting Up Pages

1. Page Size, Orientation, and Color
2. Adding Footers, Headers, and Page Numbers
3. Table of Contents

Inserting Non-Text Elements

1. Images
2. Tables
3. External Links
4. In-Doc Linking and Bookmarks

Changing Text Attributes

1. Font
2. Font Size
3. Text and Highlight Color
4. Bold, Italic, Underline

Formatting Text Blocks

1. Paragraph Styles
2. Alignment
3. Line and Paragraph Spacing
4. Columns
5. Numbering and Bullets

Using Content Management Tools

1. Spelling
2. Personal Dictionary

Inserting and Editing Tables

1. Creating and Deleting Tables
2. Managing Table Properties

Collaborating and Sharing in Docs

1. Comments
2. Editing
3. Suggestions
4. Revision History

Module Five: Review Questions

Module Six: Working in Sheets

Managing Values, Rows, Cells, or Columns.

1. Adding
2. Deleting
3. Freezing

Formatting Sheets and Cells

1. Formatting Cells
2. Formatting Sheets

Inserting Non-Text Elements

1. Charts
2. Images
3. Links
4. Forms
5. Drawings

Using Functions

1. ‘SUM’ Function
2. ‘AVERAGE’ Function
3. ‘MIN’ Function
4. ‘MAX’ Function
5. ‘COUNT’ Function

Managing and Transforming Data

1. Sorting and Filtering Data
2. Data Validation
3. Conditional Formatting
4. Sorting and Protecting Sheets

Collaborating and Sharing in Sheets

1. Comments
2. Revision History
3. Downloading Sheets

Importing and Converting from Other File Types

1. Importing a CSV File into Google Sheets
2. Importing an XLS File into Google Sheets
3. Converting a CSV or XLS File to Google Sheets Format

Module Six: Review Questions

Module Seven: Working in Slides

Building a Presentation

1. Adding, Copying and Deleting Slides
2. Applying Layouts and Themes
3. Presenter Notes
4. Animating Between Slides
5. Copy and Pasting Slides to Destination Formatting
6. Linking Slides

Working With Text

1. Inserting Text Blocks
2. Changing Font and Size
3. Text and Highlight Color
4. Bold, Italics and Underline

Working With Non-Text Elements

1. Images and Videos
2. Charts, Tables and Diagrams
3. Lines and Shapes
4. Slide Numbers

Arranging Objects

1. Sending to Front or Back
2. Group and Ungroup
3. Alignment
4. Rotation
5. Distribute
6. Snap-to Guiding Lines
7. Resizing

Sharing a Presentation

1. Presenter View
2. Print Settings and Preview
3. Publish to Web

Module Seven: Review Questions

Module Eight: Wrapping Up

1. Words from the Wise
2. Review of Parking Lot
3. Completion of Action Plans and Evaluations