Recent Changes - Search:

Welcome to CAVI, the Cisco Academy for the Vision Impaired.

Course Fees Linux Wiki HTML Wiki Documentation Index PmWiki FAQ

Edit SideBar


Note: This course has now been split into short courses. For information, please check the links under the short corses heading in the sidebar. [at the top of the page for screen reader users.] Courses run generally once per semester. Get in touch with us to find out when a course will run.

Need to brush up your Office skills? Have you always been interested in learning how to use Office with your screen reader, but didn't know quite how to start? Are you daunted by the size and complexity of the Office programs? You've come to the right place. Welcome to CAVI's brand new MS Office course. We'll show you how to use Word, Excel, Outlook and Powerpoint efficiently and productively.

We strongly recommend using Jaws for this course as it has the highest compatibility with the Office suite.

Students are required to have Office 2010 or newer for this course. [There is a subscription for Office 2013 that is $10 a month if buying a full version is not in a student's budget.]

Students Area

Here is the Students Area for this course. You will find assignments, lecture notes and other resources here.

Course Outline

Here is a tentative outline for the course for semester 1 of 2014. THis outline is subject to change based on class needs and dynamic.

Week 1: Intro.

  • Introduction to course.
  • Using the Office ribbons.
  • Office options, including tips for setting it up accessibly, using sounds if desired, etc.
  • Getting help with Office

Section 1 - Word

Week 2: The basics.

  • Creating a document from a blank document and from a template
  • Word Options
  • The Document Window
  • Spell checking and thesaurus
  • Page setup and printing
  • Saving files

Week 3: Text manipulation and basic formatting

  • Working with text. Navigation, find/replace, ETC.
  • Fonts, themes, styles, etc.
  • simple headers and footers, inserting watermarks, inserting page numbers

Week 4: Beyond The Basics

  • Working with sections
  • bulleted and numbered lists
  • Tables

Week 5: Customization and Macros

  • customizing the quick access toolbar, keyboard commands and ribbon,
  • recording simple macros, assigning shortcut keys, managing macro security

Section 2: Excel

Week 6: The Basics

  • Opening worksheets from blank or templates
  • Navigating worksheets.
  • Creating, moving, and renaming sheets.
  • Entering text and numbers
  • Finding data
  • Saving
  • Printing

Week 7: Working with Cell data

  • Absolute VS. relatatve cell locations
  • Formatting Cells
  • Simple formulas

Week 8: Data Entry and Basic Formatting

  • Data filling
  • Column sorting and filtering
  • inserting and deleting columns and rows, adjusting row height and column width
  • changing workbook themes, changing font and style,
  • headers and footers, page numbers, watermarks
  • Merging cells, modifying cell alignment and indentation, wrapping text within cells
  • Cell formatting

Week 9: Beyond The Basics

  • Applying conditional formatting,
  • transposing columns and rows,
  • Working with named ranges
  • creating and working within outlines

Week 10: Formulas In Depth

  • Using and understanding functions

Week 11: Charts, graphs, and objects

  • Creating and manipulating charts and graphs
  • Inserting text boxes
  • inserting SmartArt
  • inserting images
  • Adding and positioning objects and changing their properties and appearance

Week 12: Sharing data between Office applications

  • Linking Office Documents
  • Mail Merge

Section 3: Outlook

Week 13: The Basics

  • Navigating and customizing the Outlook interface
  • Adding an email account
  • Outlook Options
  • Managing Multiple Accounts
  • Printing And Saving
  • Data Files

Week 14: Messages

  • Creating, replying to, sending, forwarding messages
  • Formatting of Text and messages
  • Deleting, moving and sorting messages
  • Working with Attachments
  • Flagging, ignoring or marking messages
  • Creating filters and Rules
  • Creating Autoreplies
  • Searching in Outlook

Week 15: Calendars

  • Creating calendars or calendar groups
  • Creating appointments, meetings and events
  • Managing appointments, meetings and events

Week 16: Notes, Tasks and Contacts

  • working with Notes
  • Working with Tasks
  • Working with the Journal
  • Creating and managing contacts and Groups

Section 4: Power Point

Week17:The Basics

  • Creating a presentation from blank or Template
  • Importing text files or word documents into presentations
  • Page setup, and printing selections or the whole presentation
  • Saving presentations as web pages and packaging presentations for CD
  • Maintaining Backword Compatibility

Week 18: Formatting Presentations Using Slide Masters

  • applying a slide master,
  • adding new layouts,
  • modifying existing layouts,
  • adding background images,
  • controlling page numbers,
  • inserting headers and footers,

Week 19: Manipulating and formatting text and Slides

  • Hiding, moving, deleting and duplicating slides
  • Adding slides layouts, changing fonts, styles and themes.
  • Merging from other presentations
  • Formatting text, Inserting hyperlinks
  • Creating, inserting and editing lists and tables

Week 20: Finalizing and Sharing Presentations

  • Protecting and Sharing Presentations
  • Checking for Accessibility and compatibility Issues
  • Shoing the Presentation

Section 5: Misc

Week 21: Office 365

Week 22: overflow, or time for topic based on class interest.

Edit - History - Print - Recent Changes - Search
Page last modified on July 25, 2015, at 01:57 AM