Course Outline

Module 1: Introduction to Google Suite

Lesson 1: What is Google Suite?

• Overview of Google Workspace (formerly G Suite)

• Key tools: Google Docs, Sheets, Slides, Drive, Gmail, Google Calendar, Meet

• Benefits of using Google Suite for collaboration and productivity

Lesson 2: Setting Up and Navigating Google Workspace

• Creating and managing a Google Account

• Introduction to Google Drive: File storage and management

• Exploring the Google Suite interface: Google Drive, Docs, Sheets, Slides, etc.

Module 2: Google Docs

Lesson 3: Creating, Editing, and Formatting Documents

• Creating new documents and using templates

• Formatting text: Fonts, headings, and paragraph styles

• Inserting images, tables, and hyperlinks

• Collaboration: Sharing, commenting, and suggesting mode

Lesson 4: Advanced Google Docs Features

• Using voice typing and autocorrect

• Working with styles and headings

• Inserting footnotes, headers, and footers

• Adding citations and references

Module 3: Google Sheets

Lesson 5: Introduction to Google Sheets

• Creating and editing spreadsheets

• Understanding rows, columns, and cells

• Basic formulas and functions: SUM, AVERAGE, MIN, MAX

• Formatting data: Number formats, text alignment, and cell colors

Lesson 6: Working with Data in Google Sheets

• Sorting and filtering data

• Using conditional formatting

• Creating and using charts and graphs

• Advanced formulas: IF statements, VLOOKUP, and pivot tables

Module 4: Google Slides

Lesson 7: Creating Effective Presentations with Google Slides

• Creating slides from scratch or using templates

• Inserting text, images, shapes, and videos

• Using slide layouts and transitions

• Working with speaker notes and presenting

Lesson 8: Collaboration and Sharing in Google Slides

• Sharing and co-authoring presentations

• Adding comments, suggestions, and resolving them

• Presenting with Google Meet integration

Module 5: Google Drive and File Management

Lesson 9: Storing and Organizing Files in Google Drive

• Uploading and organizing files in folders

• Managing file permissions and sharing settings

• Using Google Drive search and advanced filters

• Version control and file recovery

Lesson 10: Google Drive Integration with Other Tools

• Connecting Google Drive with Google Docs, Sheets, and Slides

• Using Google Drive offline

• Sharing files and collaborating in real time

• Sharing documents securely with external users

Module 6: Google Gmail

Lesson 11: Using Gmail for Effective Communication

• Composing, formatting, and sending emails

• Organizing your inbox with labels, filters, and stars

• Managing contacts and email groups

• Using Gmail for scheduling and reminders

Lesson 12: Advanced Gmail Features

• Setting up email signatures and vacation responders

• Using Google Tasks and Google Keep for task management

• Organizing emails with Gmail search and filters

• Integrating Gmail with Google Meet for video calls

Module 7: Google Calendar and Meet

Lesson 13: Managing Your Schedule with Google Calendar

• Creating events, appointments, and reminders

• Sharing calendars and scheduling meetings

• Using Google Calendar for team collaboration and task management

• Syncing Google Calendar with other devices and apps

Lesson 14: Using Google Meet for Video Conferencing

• Scheduling and joining Google Meet calls

• Sharing screens and collaborating in real time

• Using Google Meet features: Chat, recording, and captions

• Integrating Google Meet with Google Calendar and Gmail

Module 8: Collaboration and Productivity Tools

Lesson 15: Real-Time Collaboration in Google Suite

• Collaborating on Google Docs, Sheets, and Slides simultaneously

• Using comments, suggestions, and live chat for effective teamwork

• Version history: Reverting to previous document versions

• Using Google Keep for notes and task tracking

Lesson 16: Google Workspace Productivity Tips and Tricks

• Keyboard shortcuts for faster navigation

• Automating tasks with Google Apps Script (basic introduction)

• Using Google Forms for surveys and feedback

• Integrating Google Suite with third-party apps and tools

Module 9: Final Project and Review

Lesson 17: Final Project

• Applying learned skills to a project (e.g., creating a collaborative presentation, analyzing data, or managing a team project using Google Suite)

• Presenting and sharing the project with classmates or peers

Lesson 18: Review and Certification

• Recap of core tools and features covered in the course

• Taking the final exam (optional) to test knowledge

• Discussion on how to further develop skills and use Google Suite in the workplace

This course is designed to help beginners gain proficiency in Google Suite tools that will enhance their productivity, collaboration, and organization at work.