OXMAN COLLEGE
School of Nursing and Technology
Microsoft Word I
Lesson 1: Introduction to Word
Introduction to Word; Backstage View; Getting Help
Lesson 2: Creating Documents
Entering Text; Working with Non-Printing Characters; Saving and Opening Documents
Lesson 3: Navigating and Editing Documents
Keyboard Shortcuts; Find, Replace, and Go To Commands; Editing Techniques; AutoCorrect; Selecting Text; Cut, Copy and Paste
Lesson 4: Formatting
Text Character Formatting Options; Format Painter; Numbering a List; Working with Bullets; Creating a Multilevel List; Sorting a List
Lesson 5: Text Spacing and Alignment
Alignment Options; Line Spacing Options; Indentation; Working with Tabs
Lesson 6: Using Styles
Working with Styles; Creating Styles; Editing Styles
Lesson 7: Controlling Page Layout and Elements
Working with Page Breaks; Working with Columns; Adding a Watermark; Headers and Footers
Lesson 8: Working with Tables
Working with Tables; Sorting in a Table; Converting Data to a Table; Quick Tables; Using Formulas in Tables
Lesson 9: Adding Images
Inserting Pictures; Picture Options
Lesson 10: Adding Shapes
Icons, 3D Models, SmartArt, Charts, and Screenshots Shapes; Icons and 3D Models; SmartArt, Charts, and Screenshots; Grouping Objects; Aligning Objects
Lesson 11: Finalising and Printing a Document
Using the Thesaurus and Spell Check; Adding Comments; Page Setup Options; Printing
Lesson 12: Word Features to Assist Users
Setting Word Options; Keyboard Shortcuts; ScreenTips; Using the Ruler
Lesson 1: Working with Views
Using Read Mode; Using Print and Web Layout Views; Using Draft and Outline Views; the Immersive Group
Lesson 2: Searching and Replacing
Content Finding and Replacing Formatting and Special Characters; Using the Navigation Pane and Go To; AutoCorrect and AutoComplete
Lesson 3: Working with Envelopes and Labels
Working with Envelopes and Labels
Lesson 4: Performing Mail Merges
What is Mail Merge? Creating a Merge Document; Merging Envelopes and Labels; Merging a Directory
Lesson 5: Using QuickParts
Creating and Editing Building Blocks; Using AutoText
Lesson6: Creating an Index and a Table of Contents
Creating an Index; Using AutoMark to Create an Index; Creating a Table of Contents
Lesson 7: Advanced Table Features
Creating a Table Style; Table Breaks and Repeat Headings; Using Formulas and Tables
Lesson 8: Formatting Graphics and Pictures
Inserting and Formatting WordArt; Filling Shapes with Pictures; Working with Icons and 3D Models
Lesson 9: Using Captions & Creating a Table of Figures
Inserting a Caption; Creating a Table of Figures
Lesson 10: Using Text Boxes
The Text Box Gallery; Text Alignment and Margins; Sidebars; Linking Text Boxes
Lesson 11: Page Layout and Sections Layout Tab Overview
Inserting Breaks; Sections with Headers & Footers; Sections for Page Borders; Document Properties & Fields; Column Breaks; Master and Subdocuments
Lesson 12: Using Links
Inserting links; Linking to Excel Data
Microsoft Excel I
Lesson 1 Excel basics
Lesson 2 Introduction to the Excel spreadsheet environment
Lesson 3 Creating a basic worksheet, entering data and navigating in a worksheet
Lesson 4 Creating formulas
Lesson 5Moving and copying data
Lesson 6Formatting worksheets and data
Lesson 7 Preparing a document for printing
Microsoft Excel II
Lesson 1 Working with advanced formulas
Lesson 2 How to create and modify tables
Lesson 3 How to present your data using charts
Lesson 4 Analysing your data using PivotTables
Lesson 5 Working with graphic objects in your spreadsheets
Lesson 6 Customising and enhancing your Excel environment
Microsoft Excel III
Lesson 1 Streamlining workflows
Lesson 2 Security and collaborating with other users
Lesson 3 Auditing worksheets
Lesson 4 Analysing your data
Lesson 5 Working with multiple workbooks
Importing and exporting data
Integrating excel data with the web
Microsoft PowerPoint
Lesson One: Creating a new blank presentation, entering and editing text, working with bulleted text, the undo/redo button, resetting to default formatting, adding slides, the principles of presentation planning and design, checking spelling, applying different themes, saving a presentation, viewing the presentation as a slide show.
Lesson Two: Understanding the importance of knowing your audience, opening an existing presentation, adding new slides, using different slide layouts, changing the appearance of the text, changing the alignment of paragraphs, using format painter, using variants, slide sorter view, moving slides, deleting slides.
Lesson Three: Creating a themed presentation, background formatting, adding, modifying and removing transition effects, adding and removing transition sounds, applying animation effects, the animation painter, viewing a presentation in Reading view.
Lesson Four: Creating a table, inserting and delete rows and columns, adjusting the table dimensions, merging cells, applying a background, changing the table design, the Draw table tool, inserting a chart and adding spreadsheet data, selecting and changing chart types, layout and style, adding and removing chart elements, selecting, formatting and removing chart elements, repositioning and resizing a chart
Lesson Five: Using the ruler, gridlines and guides, working with shapes – drawing, shading, rotating and moving, grouping and formatting, moving and resizing, adding shape effects, changing the order on a slide, adding text, using pictures, merging shapes, formatting the outline; adding multiple animations, using the animation pane.
Lesson Six: SmartArt Graphics – creating, changing the type and layout, adding text and shapes, converting text to a SmartArt graphic, animating SmartArt; Text boxes – inserting and formatting, moving and resizing; WordArt – creating, formatting and enhancing, animating.
Lesson Seven: Using the zoom controls; Photographs – inserting, applying artistic effects and corrections, cropping, compressing; Audio – inserting from a file, using the playback ribbon, removing audio; Video – inserting and linking video files; Hyperlinks – inserting and editing, hyperlinks between slides, using pictures, linking to other files and websites; Action buttons.
Lesson Eight: Autofit, Using data from Word and Excel, moving and resizing placeholders, line spacing, copying text and slides between open presentations, reusing slides, adding footers to the entire presentation/selected slides, slide numbers, adding a date/time, using Notes.
Lesson Nine: Outline view, working with a slide master, multiple slide masters, creating a new theme, using templates, creating new templates, generating and printing handouts
Lesson Ten: Rehearsing slide timings, working with the rehearsal toolbar, changing timings, setting up a slide show, Slide Show view, Presenter view, creating and running a custom slide show, selecting show types.
