MS Word Introduction

Course content

What is Word?? Understand the functions of text editor, word processor, and DTP applications • Recognise the different elements of the Word application window

Creating a Document Create a new document • Enter text • Change page display modes (Print Layout, Normal, Reading Layout, Full Screen) • Use zoom to view a document at different magnification • Print a single copy of a document

Editing a Document Move the insertion point • Select text • Insert new text • Use Click-and-Type • Type over existing text • Delete text • Use the Undo, Redo, and Repeat commands • Insert the date and time • Insert symbols and special characters • Use the automatic spelling checker

Moving and Copying Data Cut, Copy, and Paste with the Windows Clipboard using the menu, toolbar, and keyboard • Move and copy text from one document to another • Use the Paste Options smart tag to change the format of pasted text • Use drag-and-drop to move and copy text • Use Paste Special to choose different formats for data

Page Setup Set the default measurement units • Show and hide the rulers • Set page orientation and paper size • Set margins • Insert page breaks

Paragraph Layout Set left, right, hanging, and first line indents • Align paragraphs relative to the margins • Control automatic hyphenation of words • Set line and paragraph spacing options • Remove paragraph formats

Character Formatting Select and change font and font size • Apply font formats (bold, underline, and italics) • Apply character effects and colours • Copy formats using the Format Painter • Remove text enhancements

Printing a Document Use Print Preview • Print a document • Print the current page, selected text, or a range of pages • Print multiple copies of a document • Set print options • Cancel a print job • Troubleshoot printing

Using a Template Use a template to create a new document • Create a new document using a wizard • Work within a document created from a template

Applying a Style Apply a paragraph style • Apply a character style • Apply a list style • Apply a table style • Use the Styles and Formatting pane

Formatting a Simple List Start a bulleted or numbered list automatically • Add bullets and numbering to a list • Change the appearance of bullet characters

Paragraph Borders and Shading Apply borders and shading to paragraphs • Remove borders and shading

Inserting Pictures and Clip Art Understand Object Linking and Embedding • Insert a Clip Art object • Insert a picture from a file • Insert a Print Screen graphic • Insert an image from a scanner or digital camera • Modify a picture using the Picture toolbar • Crop a picture

Working with Objects Select, position, and delete an object • Resize an object • Move or copy an object

Headers and Footers Create and modify headers and footers • Insert fields in headers and footers to show variable data (page number, date, file location, author, document title, file name) • Format page numbering

Proofing Tools Use the Spelling and Grammar Checker to correct errors in a document • Add unrecognised words to the custom dictionary • Use the Browse Selector and Go To to locate specific elements in a document • Find and replace text

Basic Reviewing Tools Show, hide, and print document markup • Add and review document comments • Highlight text in document 

Excel  Introduction

Course content

What is Excel? Understand the functions of spreadsheet application • Recognise the different elements of the Excel screen

Creating a Workbook Create a new workbook • Move around the worksheet using the mouse and keyboard • Select cells using the mouse and the keyboard • Use zoom to view a worksheet at different magnification • Use Undo and Redo

Entering and Editing Data Enter text, values, and dates in cells • Edit cell contents • Print a single copy of a worksheet

Creating a Formula Understand what a formula is and how to create simple calculations • Use AutoSum • Enter a formula by typing or by using the Formula bar • Enter a range within a formula using the mouse • Use relative and absolute cell references

Moving and Copying Data Use the AutoFill tool • Create a custom list • Use Drag-and-Drop to move or copy cell contents • Move, copy, and paste data using the Windows Clipboard

Editing a Formula Create a formula using functions • Revise a formula • Use Insert Function • Use basic arithmetic functions (SUM, AVERAGE, COUNT, MIN, MAX) • Recognise and resolve common error messages • Interpret spreadsheet data

Formatting Cell Values Apply value formats (currency, percent, date, comma) • Adjust the decimal place • Change the currency symbol • Apply other formats (accounting, time, text, general)

Formatting Cell Contents Apply font styles (typeface, size, colour, enhancements) • Modify the alignment and orientation of cell contents • Merge and unmerge cells (to centre headings across columns) • Indent text in a cell • Use the Format Painter to copy cell formats • Clear cell contents or formats

Structuring a Worksheet Modify the size of columns and rows • Insert and delete rows and columns • Insert and delete selected cells

Page Layout Change paper size and orientation • Set page margins and alignment • Scale print output to fit a defined number of pages • Print column and row titles and set other options • View a worksheet in Print Preview • Change margin and column widths in Print Preview • Insert and remove a page break • Set up headers and footers • Add fields in headers and footers (page number, date/time, file information)

Printing Worksheets and Workbooks Print a worksheet • Print a workbook (all sheets in book) • Display formulas in worksheet cells • Print a range of cells • Set, print, and clear a print area • Print a group of worksheets • Print to a file

Creating a Chart Use the Chart Wizard to create different chart types • Reposition, resize, and delete a chart • Change the chart type • Preview and print a chart • Move and copy a chart

PowerPoint (Level 1)

Course content

What is PowerPoint? Understand the functions of a presentation graphics application • Understand some principles of presentation design • Recognise the different elements of the PowerPoint window • Select different views • Change the zoom setting

Creating a Presentation Create a new presentation • Create a specific type of slide • Enter text onto a slide • Delete a slide

Entering and Editing Text Move the insertion point • Select text • Insert new text • Type over existing text • Delete text • Use the Undo, Redo, and Repeat commands • Insert the date and time • Insert symbols and special characters • Create and modify speaker notes

Working with Objects Select, position, and delete an object • Resize an object • Move or copy an object

Moving and Copying Data Cut, Copy, and Paste with the Windows Clipboard using the menu, toolbars, and keyboard • Move and copy text from one presentation to another • Use the Paste Options smart tag to change the format of pasted text • Use drag-and-drop to move and copy text • Use Paste Special to choose different formats for data • Change the order of slidesvMove and copy slides between files • Delete slides

Inserting Pictures and Clip Art Understand Object Linking and Embedding • Insert a Clip Art object • Insert a picture from a file • Insert a Print Screen graphic • Insert an image from a scanner or digital cameravModify a picture using the Picture toolbar • Crop a picture

Formatting Tools Understand the proper use of fonts and formatting for a slide show • Change text fonts, enhancements, and colour • Change the text alignment • Change paragraph and line spacing • Add different graphical bullets • Add AutoNumber bullets • Use the Format Painter to copy formatting • Apply a slide background colour

Formatting Objects Format shapes and objects (line, border, shading, shadow, 3-D)

Running a Slide Show Start a slide show on any slide • Get Help during a slide show • Use on-screen navigation tools • Hide a slide • Add animated transitions between slides • Animate objects on a slide using a preset scheme

Printing Slides and Handouts Select an output format for a presentation • Preview the presentation in Print Preview • Preview a presentation in black and white and greyscale • Print slides in a variety of formats • Add and print speaker notes • Print audience handouts

Using Templates and Designs Create a presentation using a content template • Create a presentation using the AutoContent Wizard • Create a presentation from a design template • Apply a design template to an existing presentation or to selected slides

Editing Text in Outline View Enter and edit text in Outline view • Promote and demote text • Modify slide sequence in Outline view • Import text from Microsoft Word

Proofing Tools Check spelling • AutoCorrect typing errors • Find and replace text

Creating a Simple Drawing Insert a picture or drawing canvas • Use the Drawing toolbar to create basic shapes and lines • Draw and modify AutoShapes • Add text to a shape

Outlook 

Overview

• Basics of Outlook
• Outlook Today

Sending and Receiving Internal & External Emails

• Composing new mail
• Using the Address Book
• Replying/ Forwarding mail
• Changing the appearance of mail
• Configuring notifications of arrivals, sent mails etc.
• Tracking Options

Calendar

• Creating a new appointment
• Creating recurring appointments
• Creating meeting requests
• Planning meetings- Attendee availability
• Canceling meetings /appointments

Contacts

• New contacts
• New distribution list
• Letter to contacts
• Calling contacts
• Sending meeting requests

Tasks

• Creating new tasks
• Following up with the tasks
• Assigning Tasks to others

Others

• Using MS Office with Outlook
• Configuring Outlook
• Different Views for the Outlook Desktop
• Importing and exporting files, Databases etc.
• Customizing the way Outlook organizes the daily desktop. 
  

Overview of Outlook

• Basics of Outlook
• Outlook Today

Sending and Receiving Internal & External Emails

• Composing new mail
• Using the Address Book
• Replying/ Forwarding mail
• Changing the appearance of mail
• Configuring notifications of arrivals, sent mails etc.
• Tracking Options

Calendar

• Creating a new appointment
• Creating recurring appointments
• Creating meeting requests
• Planning meetings- Attendee availability
• Canceling meetings /appointments

Contacts

• New contacts
• New distribution list
• Letter to contacts
• Calling contacts
• Sending meeting requests

Tasks

• Creating new tasks
• Following up with the tasks
• Assigning Tasks to others

Journal

• Viewing the Journal Entries
• Creating new entries

Others

• Using Ms- Office with Outlook
• Configuring Outlook
• Different Views for the Outlook Desktop
• Importing and exporting files, Databases etc.
• Customizing the way Outlook organizes the daily desktop.