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.]
Here is the Students Area for this course. You will find assignments, lecture notes and other resources here.
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
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
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
- 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.