Google Workspace

Google Calendar

Google Calendar is a time-management and scheduling calendar service developed by Google. It became available in beta release April 13, 2006, and in general release in July 2009, on the web and as mobile apps for the Android and iOS platforms. Google Calendar allows users to create and edit events.

Gmail

Gmail is a free email service provided by Google. As of 2019, it had 1.5 billion active users worldwide. A user typically accesses Gmail in a web browser or the official mobile app. Google also supports the use of email clients via the POP and IMAP protocols

Advance Activity 6: Company challenge: Formulating forecasts

Advance Activity 5: Create a pivot table on existing data

Advance Activity 4: Create a chart using Google Sheets

Advance Activity 3: Create a data validation & name a range

Advance Activity 2: Use the IFS function

Advance Activity 1: Apply conditional formatting

Activity 9: Company challenge: Details in the data

Activity 8: Comment, edit, and assign an action item

Activity 7: Explore sharing options

Activity 6: Create a chart

Activity 5: Use named ranges to perform calculations

Activity 4: Use formulas to perform calculations

Activity 3: Apply formatting to a Google Sheet

Activity 2: Manage data in Google Sheets

Activity 1: Import an Excel spreadsheet to Google Sheets

Activity 12: Company challenge: Leverage lessons learned

Activity 11: Present your Google Slides

Activity 10: Use comments and action items

Activity 9: Explore publication and download options

Activity 8: Share a presentation and check version history

Activity 7: Import and reorder slides

Activity 6: Change the background color

Activity 5: Add slide transitions and object animations

Activity 4: Insert a linked chart

Activity 3: Change formatting and add speaker notes

Activity 2: Use themes and layouts

Activity 1: Start a project in Google Slides

Activity 7: Company challenge: A case of cinnamon

Activity 6: Search for a message

Activity 5: Create a Chat room

Activity 4: Create a group chat

Activity 3: Add a meeting agenda Google Doc to Calendar

Activity 2: Google Meet link and dial-in information

Activity 1: Schedule an event and add a Google Meet link

Activity 7: Company challenge: Seroja’s secret recipe

Activity 6: Create a Google Doc from a template

Activity 5: Work with files and folders in a shared drive

Activity 4: Work with folders in My Drive

Activity 3: Create a new folder in My Drive and add files

Activity 2: Understand Collaborator roles

Activity 1: Explore Google Drive

Activity 7: Company challenge: The case of the global brand

Activity 6: Use comments and assign action items

Activity 5: Download in different formats

Activity 4: Use versions and shareable links

Activity 3: Insert images in a Google Doc

Activity 2: Name a Google Doc, star it, and save as a PDF

Activity 1: Create and format a Google Doc

Activity 6: Company challenge: Coordinated collaboration

Activity 5: Create and share a calendar

Activity 4: Mark yourself out of office and set a reminder

Activity 3: Use Google Calendar search

Activity 2: Add a guest and attach a file from Google Drive

Activity 1: Create and modify an event in Google Calendar

Gmail Activity 10: Company challenge Anthony’s email

Gmail Activity 9: Explore Gmail search

Gmail Activity 8: Create a Gmail filter

Gmail Activity 7: Enable an Out-of-Office automatic reply

Gmail Activity 6: Create a canned response template

Gmail Activity 5: Create a new email signature

Gmail Activity 4: Create a personal contact and group

Activity 3: Create an event from Gmail and view in Calendar

Gmail Activity 2: Create and use labels

Gmail Activity 1: Compose an email message