About This Course
Google Workspace (formerly G Suite) has become a staple for collaboration and productivity in countless organizations and educational institutions. This course provides a practical guide to effectively utilizing its core components. Learn to create, format, and collaboratively edit documents in Google Docs, leveraging features like commenting and version history.
Master data management and analysis basics in Google Sheets, including formulas, functions, and charts. Efficiently manage your time and schedule meetings using Google Calendar. Conduct effective virtual meetings with Google Meet, and organize, share, and collaborate on files securely using Google Drive. The course culminates in a collaborative project applying these integrated tools.
Learning Outcomes
- Create, format, share, and collaboratively edit documents using Google Docs.
- Manage and analyze data using formulas, functions, and charts in Google Sheets.
- Efficiently schedule and manage appointments, events, and meetings using Google Calendar.
- Host and participate effectively in virtual meetings using Google Meet features.
- Organize, store, share, and manage permissions for files and folders in Google Drive.
- Utilize Google Forms for creating surveys and quizzes (Introduction).
- Leverage collaborative features across the Workspace suite to optimize teamwork.
- Complete a collaborative project demonstrating proficiency in Google Workspace tools.
Prerequisites
This course is suitable for anyone looking to improve their efficiency and collaboration skills using Google's productivity suite.
- Basic computer literacy and internet navigation skills.
- A Google Account (a free Gmail account is sufficient).
- Comfortable using a web browser.
Curriculum Breakdown
Week 1: Introduction to Google Workspace & Drive
Topics Covered:
- Overview of Google Workspace Apps and Benefits
- Navigating the Google Workspace Interface
- Google Drive: Interface, Uploading/Creating Files & Folders
- Organizing Files (Moving, Starring, Folders)
- Sharing Files and Folders: Permissions Explained (Viewer, Commenter, Editor)
- Searching effectively in Drive
E-Tivities:
- Setting up Drive folder structures
- Practicing sharing files with different permissions
- Using search operators in Drive
Week 2: Document Management with Google Docs
Topics Covered:
- Creating and Formatting Text (Styles, Fonts, Alignment)
- Working with Lists, Tables, and Images
- Headers, Footers, Page Numbers, Table of Contents
- Collaboration: Sharing, Commenting, Suggesting Edits
- Version History: Tracking Changes and Restoring Previous Versions
- Using Templates & Add-ons (Introduction)
E-Tivities:
- Formatting a sample document using various tools
- Collaborating on a shared document using comments and suggestions
- Exploring and restoring previous versions
Week 3: Data Management with Google Sheets
Topics Covered:
- Sheets Interface: Cells, Rows, Columns, Sheets
- Entering and Formatting Data (Numbers, Text, Dates)
- Basic Formulas and Functions (SUM, AVERAGE, COUNT, IF)
- Sorting and Filtering Data
- Creating Basic Charts (Bar, Line, Pie)
- Sharing and Collaboration in Sheets
E-Tivities:
- Creating a simple budget spreadsheet using formulas
- Sorting and filtering a dataset
- Generating charts from sample data
Week 4: Scheduling with Google Calendar & Intro to Forms
Topics Covered:
- Calendar Interface: Views (Day, Week, Month)
- Creating and Managing Events (Details, Reminders, Guests)
- Scheduling Meetings: Finding Times, Adding Rooms/Resources
- Creating and Sharing Calendars
- Setting Up Appointment Slots (Brief Intro)
- Google Forms: Creating Simple Forms/Surveys
- Collecting and Viewing Form Responses (in Forms & Sheets)
E-Tivities:
- Scheduling individual and group events
- Sharing a calendar with specific permissions
- Creating a simple feedback form using Google Forms
Week 5: Virtual Collaboration with Google Meet & Slides
Topics Covered:
- Starting and Joining Google Meet calls (via Calendar, Gmail, Meet)
- Meet Interface: Muting, Video On/Off, Chat, Presenting Screen
- Using Features like Backgrounds, Layouts, Polls, Q&A (where available)
- Meeting Etiquette and Best Practices
- Google Slides: Creating Basic Presentations
- Applying Themes and Layouts
- Adding Text, Images, and Basic Transitions
- Presenting and Collaborating on Slides
E-Tivities:
- Participating in a practice Google Meet session, using various features
- Creating a short presentation using Google Slides
- Collaboratively editing a shared Slides presentation
Week 6: Final Collaboration Project & Review
Topics Covered:
- Integrating Workspace Tools: Using Drive, Docs, Sheets, Slides, Calendar, Meet together
- Tips for Staying Organized in Google Workspace
- Review of Key Features and Best Practices
- Collaborative Project Work Time
- Project Showcase/Walkthrough
E-Tivities:
- Work in small groups on a collaborative project requiring use of multiple Workspace apps (e.g., plan an event using Calendar, create agenda in Docs, track budget in Sheets, create presentation in Slides, coordinate via Meet/Chat).
- Present the outcome of the collaborative project.
- Final Q&A and Course Wrap-up.
Certificate Information
Upon successful completion, you'll receive an IgniteSkillz Certificate in Google Workspace Productivity. This demonstrates your ability to effectively use Google's core productivity and collaboration tools (Docs, Sheets, Calendar, Meet, Drive).
Certificate Benefits:
- Industry-recognized credential
- Verification links for employers
- LinkedIn integration