Course Descriptions

• Understand the files system of Windows: files, folders, drives/disks and paths
• Identify the elements of a window
• Expand/Compress folders
• View commands and options
• Use folder options
• Find data using search
• Customize a search – use wildcards and alter advanced options
• Sort a search
• Identify file associations and extensions
• Use program shortcuts to desktop/start menu
• Selecting files

• Arrange files (sort)
• Create folders
• Move and copy files, folders, storage devices
• Back up files
• Burn a CD – backup/duplication
• Create compressed files
• Rename a file/folder
• Delete a file/folder
• Restore/Empty the recycle bin
• Create/change/delete shortcuts to data files and folders
• Navigate between folders within a software application
• Use disk management features: Scan disk and defragmentation

• Understand the files system of a Mac including files, folders, drives, disks and locations of items
• Identify elements of the Desktop and Finder
• Manage stacks
• Create, sort, expand and compress folders and files
• View and manage folder commands and options
• Find data using spotlight
• Use spring loaded delay
• Identify file associations and extensions

• Select, move and copy files/folders (includes the use of portable storage devices)
• Back up files

• Burn a CD – backup/duplication
• Rename and delete files/folders
• Restore/Empty Trash
• Create aliases
• Navigate between folders within a software application
• Change system preferences and understand Time Machine

• Move around in a worksheet
• Navigate in a workbook
• Open, save, close and delete existing workbooks
• Access on-line help
• Understand the difference between workbooks and worksheets
• Understand cell and range references
• Enter and edit text, values, and formulas
• Utilize the SUM, MIN, MAX AVERAGE, COUNT and ROUND functions
• Select cells, ranges, rows, columns and the entire worksheet
• Insert and remove rows and columns
• Adjust column widths and row heights
• Hide and unhide columns and rows
• Use AutoFill and other fill commands
• Move and copy cell contents
• Move and copy worksheets

• Format cells and their contents in a variety of ways
• Clear cell contents and formatting
• Use introductory page setup options
• Preview and print a worksheet
• Preview and print a workbook
• Understand the order of mathematical operations
• Use relative, absolute, and mixed cell references in formulas
• Understand a variety of toolbar and menu commands
• Create and edit column and pie charts
• Rename worksheets
• Delete worksheets
• Spell check worksheets
• Use AutoFormat
• Document a workbook
  

• Create and use named ranges
• Use function wizard
• Use IF functions
  • Use nested IF functions (2 levels deep)
• Use date and time functions
• Use multiple worksheets
• Protect worksheets
• Apply conditional formatting
• Validate data entry
• Use VLookup function

• Use Goal Seek and Solver
• Use simple scenarios
• Use data management functions
  • Create and maintain a list
  • Find and sort data in a list
  • Filter a list
  • Subtotal a list
  • Pivot tables (overview only)
• Use chart options
• Use templates
• Add comments to worksheets
• Create macros (intro only)

• Create and define a variety of basic relational data models
• Create, open, and close an Access database
• Tables:
  • Design, create, and save a table
  • Add, edit and delete data in a table
  • Create relationships between tables
  • Define parent, child & lookup tables
• Forms:
  • Design, create and save a basic form
  • Use AutoForm and the form wizards
  • Arrange and view data in a form

• Queries:
  • Design, create, run, and save a variety of select queries
  • Enhance and modify a query
• Reports:
  • Create, save, preview and print a report
  • Use AutoReport and the report wizards
  • Sort and summarize records in a report

• Understand presentations and how to target an audience
• Create, save, close, and open presentations
• Work in different views
• Move around efficiently within a presentation
• Enter, edit, and delete text
• Work with bulleted lists
• Format and enhance text, change alignment and spacing
• Format slides with colours, fills, textures and gradients
• Add photos, clip art and word art
• Add slide transitions

• Add and modify animation and sounds
• Create and apply design templates
• Modify the slide master to manipulate all slides
• Use spell check and print options
• Use auto shapes
• Use tables, charts and diagram layouts
• Display a slide show with timings
• Package a slide show to CD
• Create speakers notes and audience handouts
• Use the auto content wizard

• Understand different type of graphics, eg. gif, bmp,
  jpg (overview only)
• Find and use a wide variety of clipart
• Work with Photographs from a variety of sources
  • scanned
  • from digital camera
  • off the web
• Use autoshapes
• Wrap text around, through and behind graphics
• Group and ungroup images
  • clipart
  • autoshapes

• Create watermarks
• Download graphics from the internet
  • copy only
  • download to a file
• Adjust/Enhance images
  • brightness
  • contrast
  • cropping
• Position graphics in a document
  • copying
  • moving
  • sizing

Overview of Outlook

Creating Email

• Use stationery
• Apply formatting
• Request read receipts
• Use Voting Buttons
• Add and open attachments (includes zipping)
• Create and apply signatures
• Set priorities
• Recall messages
• Set permissions
• Use forms for standardized messages
• Create and use Out of Office replies

Managing Email

• Save attachments
• Use flags effectively
• Use Reply and Forward options
• Add contacts
• Organize folders
• Delete deleted items
• Sort, filter and arrange fields
• Apply colour coding
• Apply rules & alerts

Contacts

• Add/Delete/Print
• Change views
• Create distribution lists
• Create categories/activities
• Use journal

Calendar

• Change views
• Use the schedule functions
• Create, edit and delete appointments
• Understand and adjust permissions
• Apply print options

Tasks

• Add, edit and assign
• Check and edit status
• Generate status report
• Delete

• Link & Embed in Microsoft Word
  • Copy an Excel sheet into Word
  • Link an Excel sheet in Word
  • Create a new Excel sheet in Word
  • Link an Excel chart in Word
• Link & Embed in Access
  • Copy an Access table/query in Word
  • Merge an Access table/query in Word
  • Publish an Access table/query in Word
  • Analyze Access data with Excel

• Link & Embed in PowerPoint
  • Embed a Word table in PowerPoint
  • Embed an Excel sheet in PowerPoint
  • Embed an object in PowerPoint
  • Send a presentation to Word
• Link & Embed in Excel
• Copy a Word document into Excel
• Link a Word document in Excel
• Embed a Word document in Excel
• Create a new Word document in Excel
• Other
  • Handle Typical Linking & Embedding Problems
    
  • Copy/Paste, Link & Embed Objects
    
  • Insert and manage hyperlinks

• Recognize different views and elements of a word window
• Use the menu bar, scroll bars, toolbars and task pane
• Use help features and smart tags
• Create, edit, save, name, print, close, and open documents
• Cut, copy, insert & move text
• Use clipboard for multiple copies
• Use the spell check and thesaurus. Work with language features and foreign characters
• Format text: fonts, enhancements (bold, italic, underline, colour, animation, drop caps, highlight)
• Format paragraphs (alignments, line spacing, indents)

• Search and replace text
• Insert symbols
• Insert page breaks and section breaks
• Use and set tabs
• Create basic tables
• Convert text to tables and tables to text
• Apply simple borders
• Apply bullets and numbering
• Create/print mailing labels and envelopes
• Modify page setup (margins, pagination, page numbering, paper size, paper orientation, page borders)

• Work with multiple and multi-page documents
• Create headers and footers with different first-page, different odd/even, different sections (useful for manuals and large documents)
• Work with columns – generate a folded brochure and/or newsletter
• Create, modify and enhance tables (add borders and shading)
• Create tables and basic forms
• Sort text and tables
• Generate a mail merge – create multiple original documents, one main document and a database

• Create business cards
• Create and modify templates
• Create and modify styles (to save time formatting complex documents)
• Create and insert auto text entries to eliminate repetitive text.
• Use autocorrect to simplify data insertion
• Work with graphics including clipart and word art
• Add footnotes and endnotes
• Add a table of contents