Software

Google Workspace

In this course you will learn the key skills required to create, publish and share documents created using the word-processing, spreadsheet and presentation tools in Google Workspace. You will learn to create documents using Google Docs, Google Sheets, Google Slides and Google Keep. Furthermore, you will develop skills to use Gmail and Google Drive.

Sessions

  • Session 1

    Getting started with Google

    Required existing laptop/tablet skills:

    Entry Level Basic

    Points gained:

    5 PD Points

    Session description:

    After the session, you will:

    • be able to explain what Google Workspace is
    • understand the value of working in Google Workspace
    • be able to explain how Google Workspace works in the cloud
    • know where the various apps can be found for different devices
    • know how to download and install Google Chrome
    • have created a Google Account
    • know how to sign into and use a Gmail Account
    • know how to sign into and use Google Calendar
    • know how to sign into and use Google Drive
    • be able to point out the similarities and differences between using Google
    Drive in a browser or on a mobile device
    • know how to set files to be accessed offline
    • know how to use Google Keep.

    Documents created: eMails, calendar entries, notes.

  • Session 2

    Producing written documents (using Google Docs) Part 1

    Required existing laptop/tablet skills:

    Entry Level Basic

    Points gained:

    5 PD Points

    Session description:

    After the session, you will:

    • know how to use a word processing app (Google Docs)
    • know how to open and save documents
    • understand basic formatting
    • know how to use the copy/cut/paste commands
    • know how to use page view, page layout, page setup
    • know how to use layout and paragraph formatting functions
    • know how to use spelling and grammar checking functions
    • be able to decide on various printing options.

    Document created: Announcement.
    Required prior knowledge: Content in Session 1 of this course.

  • Session 3

    Producing written documents (using Google Docs) Part 2

    Required existing laptop/tablet skills:

    Entry Level Basic

    Points gained:

    5 PD Points

    Session description:

    After the session, you will:

    • know how to use styles effectively
    • understand heading levels
    • be able to apply built-in styles to format text
    • understand layout and paragraph formatting
    • understand the use of bullets and numbered lists
    • know how to increase and decrease indents
    • have an advanced understanding of how to work with tables in a
    document
    • know how to use the show or hide non-printing characters option
    • be able to insert page and section breaks
    • understand how to use illustrations in Google Docs
    • understand picture formats
    • know how to apply wrapping options to pictures
    • have a deepened understanding of how to proof documents
    • understand how to use and insert headers, footers and page numbers.

    Document created: Classroom notes.
    Required prior knowledge: Content in Sessions 1 and 2 of this course.

  • Session 4

    Producing written documents (using Google Docs) Part 3

    Required existing laptop/tablet skills:

    Entry Level Novice

    Points gained:

    5 PD Points

    Session description:

    After the session, you will:

    • know how to copy and paste text from one document into another
    • be able to use layout and paragraph formatting
    • know how to create multilevel lists
    • understand how to insert tabs, shapes and textboxes
    • know how to insert basic symbols, diacritics and maths equations
    • know how to use the help menu.

    Document created: Assessment Test.
    Required prior knowledge: Content in Sessions 1 to 3 of this course.

  • Session 5

    Processing numerical data (using Google Sheets) Part 1

    Required existing laptop/tablet skills:

    Entry Level Basic

    Points gained:

    5 PD Points

    Session description:

    By the end of this session, you will:

    • understand the purpose of a spreadsheet
    • understand the concepts of a cell, a row, a column and a sheet
    • understand the use of cell references
    • be able to format and edit cells
    • know how to use autofill
    • know how to use number formats
    • know how to resize rows and columns
    • know how to format and edit spreadsheets
    • know how to set a print area and print titles.

    Document created: Class list.
    Required prior knowledge: Content in Sessions 1 to 4 of this course would
    be useful.

  • Session 6

    Processing numerical data (using Google Sheets) Part 2

    Required existing laptop/tablet skills:

    Entry Level Novice

    Points gained:

    5 PD Points

    Session description:

    By the end of this session, you will:

    • know how to use formulae to perform calculations
    • understand the order of preference
    • understand the difference between and among cell names, ranges and
    references
    • know how to use basic functions to solve simple problems
    • identify problems based on error indicators
    • understand how to troubleshoot basic errors in formulae and functions
    • know how to work with sheets in a spreadsheet
    • know how to perform calculations using functions
    • be able to present numerical data
    • know how to create graphs/charts from given data and choose
    appropriate graph types
    • be able to edit graphs
    • understand how to troubleshoot basic problems in graphs.

    Document created: Mark sheet, graphs/charts.
    Required prior knowledge: Content in Sessions 1 to 5 of this course would
    be useful.

  • Session 7

    Preparing presentations (using Google Slides)

    Required existing laptop/tablet skills:

    Entry Level Basic

    Points gained:

    5 PD Points

    Session description:

    By the end of this session, you will:

    • be able to identify and explain the differences between and among
    presentation apps
    • know how to create a new Google Slides presentation
    • know how to use slide templates, add, duplicate and delete slides
    • be able to format slide text and edit a slide presentation
    • know how to change slide backgrounds, work with images, shapes, tables,
    charts and diagrams
    • know how to create animations and transitions
    • be able to create a set of speaker notes and know how to use them
    • know how to add interactive elements to a presentation
    • know how to prepare for and present a good presentation.

    Document created: Lesson presentation.
    Required prior knowledge: Content in Sessions 1 to 6 would be useful.

R875
5% off when buying the whole course