Google Workspace 101

Current Status

Not Enrolled

Price

Free

Get Started

Login to Enroll

Starter Projects:
- Lakefront Community Center
- LCC Fundraiser Info Document
Example project: Lakefront Community Center
Appendix

Course Content

Expand All

Google Docs

Google Workspace: Docs – Part 1 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

Introduction to Docs — Part 1

Docs: Set Up Your Document — Choose Page Size, Orientation and Color

Docs: Add Headers, Footers and Page Numbers

Docs: Format Text Blocks — Align Text, Adjust Line and Paragraph Spacing, and Use a Numbered or Bulleted List

Docs: Set Paragraph Styles — Use Headings to Create a Table of Contents

Google Workspace: Docs — Part 1 Wrap-Up

Lesson Plan: Google Workspace: Docs — Part 2 8 Topics

Expand

Lesson Content

0% Complete 0/8 Steps

Introduction to Google Workspace: Docs — Part 2

Docs: Change Fonts and Styles — Choose a Font, Set It’s Size, Color, and Highlight, and Add Bold, Italic or Underline Formats

Docs: Insert Images and Links — Add Images, External links, In-Doc Links and Bookmarks

Docs: Insert and Format Tables — Create and Delete Tables, Rows, and Columns, and Manage Table Properties

Docs: Use Tools to Review and Edit Document Text — Check Spelling and Add Words to a Personal Dictionary

Docs: Share and Collaborate in Your Document — Use Comment, Edit, and Suggesting Modes and View Revision History

Docs: Download Your File in Different Formats

Google Workspace: Docs — Part 2 Wrap-Up

Google Sheets

Google Workspace: Sheets – Part 1 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

Introduction to Google Workspace: Sheets – Part 1

Sheets: Duplicate your sheet and add new data

Sheets: Format and Organize Spreadsheet Data

Sheets: Continue formatting and organizing

Sheets: Add Data Validation to Limit Options

Sheets: Sort Your Data

Google Workspace: Sheets Part 1 wrap-up

Google Workspace: Sheets – Part 2 8 Topics

Expand

Lesson Content

0% Complete 0/8 Steps

Introduction to Google Workspace: Sheets part 2

Create Filters and Use Filter Views

Use filters to count, add, and summarize data in a table

Use the SUM function to analyze data

Display data in a chart

Use COUNTIF to generate numeric data with text values

Share and collaborate

Google Workspace: Sheets part 2 wrap-up

Google Workspace: Sheets – Part 3 8 Topics

Expand

Lesson Content

0% Complete 0/8 Steps

Introduction to Google Workspace: Sheets part 3

Copy sheets into your spreadsheet

Use functions to calculate cost and current sales

Use functions to summarize data and calculate profit

Use the MIN, MAX, and AVERAGE functions to analyze sales data

Add conditional formatting to emphasize data

Insert links, images, and drawings

Google Workspace: Sheets part 3 wrap-up

GOOGLE SLIDES

Introduction to Google Workspace: Slides — Part 1 7 Topics | 1 Quiz

Expand

Lesson Content

0% Complete 0/7 Steps

Introduction to Google Workspace: Slides – Part 1

Slides: Build a Presentation — Add, Copy, Paste, and Delete Slides, Apply Themes and Layouts, Add Page Numbers, Use Presenter Notes, and Link Slides

Slides: Copy, Paste, and Link Slides and Change to Destination Formatting

Slides: Work with Text — Insert Text Blocks, Change Font and Font Color, Size, Style, and Format, Add Highlight Color, and Set Capitalization

Slides: Add Transitions and Animations and Watch in Preview

Google Workspace: Slides – Part 1 Wrap-Up

Google Workspace: Slides – Part 1 Survey