Software

Microsoft 365

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 Microsoft 365. You will learn to create documents using Microsoft Word, Microsoft Excel, Microsoft PowerPoint and Microsoft OneNote. Furthermore, you will develop skills to use these products in mobile, web and desktop format.

Sessions

  • Session 1

    Producing written documents (using Microsoft word) Part 1

    Required existing laptop/tablet skills:

    Entry Level Basic

    Points gained:

    5 PD Points

    Session description:

    After the session, you will :

    • be able to use a word processing app (Microsoft Word)
    • be able to open and save documents
    • be able to do basic formatting
    • know how to use copy/cut/paste
    • be able to use page view, page layout, page setup
    • be able to use layout and paragraph formatting
    • know how to use spelling and grammar checking
    • be able to decide on various printing options
    • be able to apply useful Word formatting for teachers.

    Document created: Announcement.

  • Session 2

    Producing written documents (using Microsoft word) 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
    • know how to use more advanced layout and paragraph formatting
    • know how to insert bulleted and numbered lists
    • know how to insert tables, page breaks and section breaks
    • know how to insert illustrations: pictures
    • know how to add a word to the dictionary and to autocorrect
    • know how to use the review tab
    • know how to use the find and replace feature
    • be able to insert basic headers and footers
    • know how to insert automatic page numbering.

    Document created: Classroom notes.
    Required prior knowledge: Content in Session 1 (Basic functions of Word) of
    this course.

  • Session 3

    Producing written documents (using Microsoft word) Part 3

    Required existing laptop/tablet skills:

    Entry Level Novice

    Points gained:

    5 PD Points

    Session description:

    After the session, you will:

    • be able to copy and paste text from other documents
    • know how to create multilevel lists
    • know how to create tab settings
    • be able to insert text boxes
    • be able to insert symbols and maths equations
    • be able to use the help function effectively.

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

  • Session 4

    Processing numerical data (using Microsoft Excel) Part 1

    Required existing laptop/tablet skills:

    Entry Level Basic

    Points gained:

    5 PD Points

    Session description:

    After the session, you will:

    • be able to use a data processing app (Focus on Microsoft Excel)
    • appreciate the skills Excel has in common with word processing
    • understand the basic concepts of Excel
    • know how to format and edit cells
    • know how to use the autofill feature
    • know how to use different number formats
    • be able to resize rows and columns
    • know how to sort data
    • be able to format and edit spreadsheets.

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

  • Session 5

    Processing numerical data (using Microsoft Excel) Part 2

    Required existing laptop/tablet skills:

    Entry Level Novice

    Points gained:

    5 PD Points

    Session description:

    After the session, you will:

    • be able to use formulae to perform calculations
    • be able to use basic functions to solve simple problems
    • be able to identify problems based on error indicators
    • be able to troubleshoot basic errors in formulae and functions
    • be able to work with sheets in a workbook
    • be able to perform calculations using Functions
    • know how to create graphs/charts from given data and choose
    appropriate graph types

    • be able to edit graphs
    • know how to troubleshoot basic problems in graphs.

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

  • Session 6

    Preparing Presentations (using Microsoft PowerPoint)

    Required existing laptop/tablet skills:

    Entry Level Basic

    Points gained:

    5 PD Points

    Session description:

    After the session, you will:

    • be able to use a presentation app (Focus on Microsoft PowerPoint)
    • be able to explain the purpose of a presentation
    • appreciate the skills PowerPoint has in common with word processing
    • be able to create a new presentation
    • know how to design slides
    • be able to insert animations, Illustrations (shapes and pictures), media
    (video, audio, screencast), SmartArt graphics
    • know how to apply transitions to slides
    • know how to record a presentation
    • appreciate the characteristics of an excellent presentation.

    Document created: Lesson presentation.
    Required prior knowledge: Content in Sessions 1 to 5 of this course would
    be useful.

  • Session 7

    Keeping things together (using Microsoft OneNote)

    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 note-taking app (Focus on Microsoft OneNote)
    • be able to create and organise notebooks in Microsoft OneNote
    • know how to open, edit, format, save and share notes in Microsoft
    OneNote
    • know how to add multimedia and other documents to a note
    • be able to use templates.

    Required prior knowledge: Content in Sessions 1 to 6 of this course would
    be useful.

  • Session 8

    Mastering online and mobile Microsoft apps for classroom success

    Required existing laptop/tablet skills:

    Entry Level Basic

    Points gained:

    5 PD Points

    Session description:

    After the session, you will:

    • understand the benefits of using online and mobile Microsoft applications
    in the classroom
    • know how to use Microsoft Word Online and on mobile devices for
    creating and editing documents
    • know how to use Microsoft Excel Online and on mobile devices for
    managing data and creating charts
    • know how to use Microsoft PowerPoint Online and on mobile devices for
    creating engaging presentations
    • know how to use Microsoft OneNote Online and on mobile devices for
    organising lesson plans and collaborating with learners
    • know how to use Microsoft OneDrive Online and on mobile devices for
    storing and sharing documents and files with learners
    • understand how to switch seamlessly between desktop, online and mobile
    versions of Microsoft applications.

    Required prior knowledge: Content in Sessions 1 to 7 of this course is
    required.

R1000
5% off when buying the whole course