Microsoft Office Word

Lesson 1: Multiple Documents

• Open a Word Document
• Open a file in Word
• Page View Modes
• Zoom in our out of a document
• Other Zoom options
• Select a Document View
• Print Layout View
• Full Screen Reading
• Web Layout View
• Outline View
• Read documents in Word
• Read Two documents at the same time
• Backstage View
• Protected view
• Copy and Move
• Use Drag-And_Drop to Move and Copy
• Use Paste Options
• Use Drag-And-Drop to Move and Copy
• Use Paste Options
• Copy and Move Text between documents
• Use Paste Special
• Print Preview
• Hyphenate Text
• Remove Hyphenation
• Fonts
• Apply Font Effects
• Remove Character Formats
• Copy Enhancements Using the Format Painter
• Copy Enhancements Using the Keyboard
• Format Case

Lesson 2: Format Text

• Insert
• AutoCorrect
• Add a text entry to the AutoCorrect list
• Insert a Symbol
• Insert a Special Character
• Change the spacing between characters

Lesson 3: Format Paragraphs

• Format a Paragraph
• What is a Paragraph
• To show the Ruler
• To Display Paragraph Marks
• Remove Paragraph Formats
• Set the spacing for a Paragraph
• Set the line Spacing
• Indenting your Work
• Increase or Decrease the left Indent of an entire paragraph
• Create a First-Line Indent
• Indenting Text with the Paragraph Dialogue Box
• Bullets and Numbering
• Apply bullets
• The Bullets dialogue Box
• Remove bullets and numbering
• Use a different bullet Character
• Change the style of bullets
• Add Borders and Shading to Text
• Add a border to paragraphs
• Set Options for the Border Style
• Add Shading to a Paragraph
• Remove Borders and Shading

Lesson 4: Format Pages

• Page Setup
• Change Measurement Units and use the Rulers
• Change the Default Measurement Units
• View the Rulers
• Change Page Orientation and Paper Size
• Set Page Margins
• Add a Border to a Page
• Page Breaks
• Insert Hard Page Breaks
• Control Widow and Orphan Lines
• Prevent Page Breaks from Occurring in the Middle of Text
• Force a Page break before a Specific Paragraph

Lesson 5: Format a Document with Styles

• Apply a Style to Text
• Mixing Styles
• Change Styles and Formatting
• Add or Remove Styles from the Styles group
• Add a Header and Footer Toolbar
• Section Breaks
• Types of Section breaks
• Insert a Section Break
• Change the type of Section Break
• Types of Formats you can set for Sections
• Delete a Section Break
• Footnotes and Endnotes
• Insert a Footnote or Endnote
• Move or Copy a footnote or endnote

Lesson 6: Templates

• Create a Document using a Template
• Create a new Document based on a Document Template
• Work within a Template

Unit Standard Alignment:

• US 117924, Use a Graphical User Interface (GUI)-based word processor to format documents, NQF 2, 5 Credits

 

---

 

Microsoft Office Excel

Lesson 1: Principles of Spreadsheets

• Purpose of a Spreadsheet
• Properties of a Spreadsheet
• The Excel Window
• Use of Spreadsheets
• Benefits of Spreadsheets
• A short history of Spreadseets
• Examples of Spreadsheet applications

Lesson 2: Create, Open and Save Spreadsheets

• Start Excel
• Moving around in a Workbook
• Select cells, ranges, rows, or columns
• Select the contents of cells
• Select one or multiple worksheets
• Use the arrow keys to move through a worksheet
• Use the scroll bars to move through a worksheet
• Scroll and zoom by using the mouse
• Enter data into cells
• Change the column width
• Wrap text in a cell
• Change the number format
• Format numbers as text
• Enter Dates or Times
• Edit Cell Contents
• Saving your work
• Naming your document
• Save your workbook
• Save a copy of a file
• Save a file to another format
• Closing a Workbook
• Opening a New Workbook
• Open an Existing Workbook

Lesson 3: Produce a Spreadsheet

• Formatting Numbers
• Entering Formulas into Cells
• Error Messages
• Add a Column using the Autosum Button
• Subtracting
• Multiplication
• Division
• Cell Reference
• Create a cell reference on the same worksheet
• Change a cell reference to another cell reference
• Using names in Formulas
• Syntax rules for names
• Values
• Display numbers a fractions
• Set up Data Entry Validations
• Prevent invalid data entry in a worksheet

Lesson 4: Edit a Spreadsheet

• Move or Copy Cell Data
• Move or Copy entire Cells
• Use AutoFill
• Find and Replace

Lesson 5: Format a Spreadsheet

• Format fonts
• Changing the Position of Text and Numbers
• Text alignment
• Text control
• Right-to-Left
• Adjust Columns Width and Row Height
• Apply Cell Borders
• Apply Cell Shading
• Fill Cells with solid colours
• Fill Cells with Patterns
• Apply AutoFormat

Lesson 6:

• Check Spelling
• Use Custom Dictionaries
• Create a Custom Dictionary
• Use AutoCorrect

Lesson 7: Printing

• Print your Worksheet
• Preview your worksheet
• Printing options
• Page Setup

Unit Standard Alignment:

• US 116937, Use a Graphical User Interface(GUI)-based spreadsheet application to create and edit spreadsheets, NQF 2, 4 credits

 

---

 

Microsoft Office Powerpoint

Lesson 1: Adjust Settings

• Toolbars
• Customize the Quick Access Toolbar
• Customize the Ribbon
• Navigate among different views
• To change te View
• Normal View
• Outline view
• Notes Page View
• Slide Sorter View
• The Zoom Setting
• Change the slide format of a presentation
• Change the size of a page
• Change te orientation of a page

Lesson 2: Format a Presentation

• Change the Slide Layout
• To Re-apply the Slide Layout
• Insert a New Slide
• Use a Content Placeholder to add Objects to a Slide
• Insert an Object using a content Slide Layout
• Copy an Object to a Placeholder
• Copy an Object without using a Placeholder
• Add text to a Placeholder
• Create a text box for entering Text
• Create a Presentation using a Presentation Template
• Slide Master
• Create a Presentation using a Design Template
• Apply a design template to an existing presentation

Lesson 3: Presentation Effects

• Formatting Text Slides Effectively
• Change Paragraph and Line Spacing
• Apply different Graphical Bullets
• Change the sape of Bullets
• Add Autonumber Bullets
• Apply an automatic numbering style
• Use the Format Painter to copy Formatting
• Copy Enhancement using the Format Painter
• Format the Slide Background
• Apply a Background Colour to Slides
• To display indents and tab stops
• Change Indents
• Set Tab Stops
• Set and clear Tab Settings
• Change the distance between tab settings
• Format Objects
• The Drawing Tab
• Change fill, Line and Font colours in an object
• Apply a Fill Effect to an Object
• Apply Border and Line Formatting
• Apply Shadow and 3-D Shadow Effects

Lesson 4: Special Formatting

• Insert Headers, Footers, and Numbering
• Number Slides
• Add Date and Time
• Remove slide numbers and date and time
• Insert or Modify a Footer on a slide
• Notes Page View
• Edit Notes Text
• Create and Modify Speaker notes
• Select an Output format for a Presentation
• Change the Page Setup
• Preview a Presentation in Print Preview
• Print Notes Pages of Handouts

Lesson 5: Multiple Presentations

• Move Text (Cut-And-Paste)
• Use the Paste Options Smart Tag
• Copy Text (Copy-And-Paste)
• Use Drag-And-Drop to Move and Copy Text
• Use Paste Special

Lesson 6: Customize the Presentation

• Switch to Slide Sorter View
• Select a Slide in Slide Sorter View
• Delete a Slide in Slide Sorter View
• Move a Slide in Slide Sorter View
• Copy a Slide in Slide Sorter View
• Change the Order of Slides in Normal View
• Navigate to another Slide
• Delete a Slide in Normal View
• Move or Copy a Slide in Normal View
• Hide a Slide
• Unhide a Slide
• Display a Hidden Slide During a Slide Show
• Set Up a Slide Show
• Deliver a Slide Show
• To Get Help during A Slide Show
• Use On-Screen Navigation Tools
• Use the Shortcut Menu
• Use the Pen To Annotate Slides
• Erase All Annotations

Unit Standard Alignment:

• US 117923, Use a Graphical User Interface (GUI)-based presentation application to prepare and produce a presentation according to a given brief, NQF 2, 3 credits

Prerequisites : Basic Numeracy and literacy skills, Using MS Windows

NQF Level : 3

Articulation:

Credits obtained during this skills programme will contribute towards qualification 61591, National Certificate: Information Technology, End user computing, NQF Level 3.

Delivery Method:

The programme is facilitated by a competent subject matter specialist/s, who utilises the following techniques to ensure that the session is practical and experiential: Discussion; Role Plays; Exercises & Case Studies; Simulations, Videos/DVDs; and learner evaluation.

Delivery Message: English

The programme is facilitated by a competent subject matter specialist/s, who utilises the following techniques to ensure that the session is practical and experiential: Discussion; Role Plays; Exercises & Case Studies; Simulations, Videos/DVDs; and learner evaluation.

Language of delivery:

English

Certification:

• Upon completion, the learner will receive a Turnstone Certificate of Attendance.
• Upon verified Competence, the learner will receive a Certificate of Competence from Turnstone and MICT SETA.

Accreditation and Registration:
MICT SETA: LPA/00/2013/07/963

Save