Course Overview

The Office Applications Specialist 2 (MOS 2 EXPERT) is part of the Business and Marketing program within the Business and Marketing career pathway.

The Office Applications Specialist 2 course is conducted in a manner that meets the standards for vocational education as defined by the Office of State Superintendent of Public Instruction as being in conformance with the Washington State Plan for Vocational Education as approved by the office of Workforce Training and Education Coordinating Board for Washington State.

This course is dual credited with the South King County Tech Prep Consortium.

Course of Study Description

This semester class teaches the competencies necessary to complete MOS (Office Applications Specialist) expert tests for Word 2000 and Excel 2000, as well as the core test for Outlook. The MOS program is the only Microsoft approved certification program designed to measure and validate users' skills with the Microsoft Office suite of desktop productivity applications. Upon completion, students may pursue taking the certification test.

Curriculum For Office Applications Specialist 2

Course Goals

The goals of the Office Applications Specialist 2 course are:

1. Successfully complete SAM assessment tests with a score of at least 80% on Microsoft Word (expert), Excel (expert), and Outlook core MOS competencies.

2. Practice personal management and leadership through successful completion of leadership activities, personal management techniques and involvement in Future Business Leaders of America (FBLA and/or DECA).

3. Demonstrate knowledge of and respect of computer ethics and standards of behavior.

4. Demonstrate the ability to practice safety guidelines and procedures in the classroom and whenever working at a keyboard.

Office Applications Specialist 2 Course Competencies

The Following represent general outcomes and specific competencies for the Office Applications Specialists 2 course.

WORD (Expert) 2000

Working with paragraphs

• Apply paragraph and section shading
  
• Use text flow options (Windows/Orphans options and keeping lines together)
  
• Sort lists, paragraphs, tables

Working with documents

• Create and modify page borders
  
• Format fist page differently than subsequent pages
  
• Use bookmarks
  
• Use find and replace with formats, special characters and non-printing elements
  
• Balance column length (using column breaks appropriately)
  
• Create or revise footnotes and endnotes
  
• Work with master documents and subdocuments
  
• Create and modify a table of contents
  
• Create cross-reference
  
• Create and modify an index

Using tables

• Embed worksheets in a table Perform calculations in a table
  
• Perform calculations in a table
  
• Modify worksheets in a table

Working with pictures and charts

• Add bitmapped graphics
  
• Delete and position graphics
  
• Create and modify charts
  
• Import data into charts

Using mail merge

• Create main document
  
• Create data source
  
• Sort records to be merged
  
• Merge main document and data source
  
• Generate labels
  
• Merge a documents and data source
  
• Generate labels
  
• Merge a document using alternate data sources

Using advance features

• Insert a field
  
• Create, apply and edit macros
  
• Create and modify form
  
• Create and modify a form control (e.g., add an item to a drop-down list)
  
• Use advanced text alignment features with graphics
  
• Customize toolbars

Collaborating with workgroups

• Create and format tables
  
• Insert comments
  
• Protect documents
  
• Create multiples versions of a document
  
• Track changes to a document
  
• Set default file location for workgroup templates
  
  

Excel 2000 (Expert)

Importing and exporting data

• Import data from text files (insert, drag and drop)
  
• Import from other applications
  
• Import a table from an HTML file (insert, drag and drop-including HTML round tripping)
  
• Export to other applications

Using templates

• Apply templates
  
• Edit templates
  
• Create templates

Using multiple workbooks

• Using a workspace
  
• Link workbooks

Formatting numbers

• Apply number formats (accounting, currency, number)
  
• Create custom number formats
  
• Use conditional formatting

Printing workbooks

• Print and preview multiple worksheets
  
• Use the Report Manager

Working with names rages

• Add and delete a named range
  
• Use a named range in a formula
  
• Use Lookup Functions (Hlookup or Vloookup)

Working with toolbars

• Hide and display toolbars
  
• Customize a toolbar
  
• Assign a macro to a command button

Using macros

• Record macros
  
• Run macros
  
• Editing macros
  
  Auditing a worksheet

• Work with the Auditing Toolbar
  
• Trace errors (find and fix errors)
  
• Trace precedents (find cells referred to in a specific formula)
  
• Trace dependents (find formulas that refer to a specific cell)
  
• Displaying and Formatting Data
  
• Apply conditional formats
  
• Perform single and multi-level sorts
  
• Use grouping and outlines
  
• Use data forms
  
• Use subtotaling
  
• Apply data filters
  
• Extract data
  
• Query databases
  
• Use data validation

Using analysis tools

• Use PivotTable autoformat
  
• Use Goal Seek
  
• Create pivot chart reports
  
• Work with Scenarios
  
• Use solver
  
• Use data analysis and PivotTables
  
• Create interactive PivotTables for the Web
  
• Add fields to a PivotTable using the Web browser

Collaborating with workgroups

• Create, edit and remove a comment
  
• Apply and remove worksheet and workbook protection
  
• Change workbook properties
  
• Apply and remove file passwords
  
• Track changes (highlight, accept, and reject)
  
• Create a shared workbook
  
• Merge workbooks

Outlook 2000

Use Outlook Mail to communicate with others inside and outside your company

• Read mail
  
• Send mail
  
• Compose mail by entering text
  
• Print mail
  
• Address mail by entering text
  
• Use the mail features (forward, reply, recall)
  
• Use address book to address mail
  
• Flag mail messages
  
• Navigate within mail
  
• Find messages
  
• Configure basic mail print options
  
• Work with attachments
  
• Add a signature to mail
  
• Customize the look of mail
  
• Use mail templates (themes) to compose mail
  
• Integrate and use mail with other Outlook components
  
• Customize menu and task bars

Use Outlook

• Create folders
  
• Sort mail
  
• Set viewing options
  
• Archive mail messages
  
• Filter a view

Use the Outlook calendar

• Navigate within the calendar
  
• Schedule appointments and events
  
• Set reminders
  
• Print in calendar
  
• Schedule multi-day events
  
• Configure calendar print options
  
• Customize the calendar view
  
• Schedule recurring appointments
  
• Customize menu and task bars
  
• Add and remove meeting attendees
  
• Plan meetings involving others
  
• Save a personal or team calendar as a Web page
  
• Book office resources directly (e.g., conference rooms)
  
• Integrate calendar with other Outlook components

Navigate and use Outlook effectively

• Use Outlook Help and Office Assistant
  
• Move items between folders
  
• Navigate between Outlook components
  
• Modify the Outlook Master Categories List
  
• Assign items to a category
  
• Sort information using categories
  
• Use the Office Clipboard

Use Contacts

• Create, edit, and delete contacts
  
• Send contact information via e-mail
  
• Organize contacts by category
  
• Manually record an activity in a journal
  
• Link activities to a Contact
  
• Sort contacts using fields

Use Tasks

• Create and update one-team tasks
  
• Accept and decline tasks
  
• Organize tasks using categories
  
• Assign tasks to others
  
• Create tasks from other Outlook components
  
• Change the view for tasks

Integrate Office applications and other applications with Outlook components

• Create and use Office documents inside Outlook

Use Notes

• Create and edit notes
  
• Organize and view notes
  
• Customize notes

Office Applications Specialist 2 Course Outline

Word (expert) 2000 - 24 hours

• Working with Text
  
• Working with paragraphs
  
• Working with documents
  
• Managing files
  
• Using Tables
  
• Working with pictures and charts
  
• Using mail merge
  
• Using advanced features
  
• Collaborating with workgroups
  
• Round trip documents from HTML

Excel (expert) 2000 - 30 hours

• Working with text
  
• Importing and exporting data
  
• Using templates
  
• Using multiple workbooks
  
• Formatting numbers
  
• Working with named ranges
  
• Working with toolbars
  
• Using macros
  
• Auditing a worksheet
  
• Displaying and formatting data
  
• Using analysis tools
  
• Collaborating with workgroups

Outlook 2000 - 30 hours

• Communicate inside and outside a company
  
• Manage messages
  
• Use the calendar in Outlook
  
• Navigate and use Outlook effectively
  
• Use Contacts
  
• Use Tasks
  
• Use Notes
  
• Producing reports
  
• Integrate office applications and other applications with Outlook components
  
  Leadership and Personal Management Traits - 5 hours

• Follow oral and written directions
  
• Time management skills
  
• Complete leadership activities and be active in Future Business Leaders of
• America and/or DECA
  
• Demonstrate personal management traits; for example, exhibit appropriate grooming and hygiene, develop and exhibit proper manners, dress in a businesslike manner, etc.

Safety - 1 hour

• Describe and practice classroom safety guidelines and procedures
  
• Hold the hands, wrists, and arms properly when working the keyboard so as to prevent strain or injury to the hands, wrists, and arms.
  
• Sit properly at the keyboard so as to prevent strain or injury to the back.
  
• Adjust the computer monitor in such a way as to prevent eye strain.
  
• Demonstrate and practice proper electrical safety guidelines and procedures in the classroom and with computer.

TOTAL HOURS 90 HOURS

Grading

Office Applications Specialist 2 Resources

Required Tests:

• ComputerPrep Learning Guides III and IV for Word, Excel and Outlook 2000
  Published by ComputerPrep, Inc., Phoenix, Arizona

Supplemental Texts:

• Office 2000 Magazine
  
• A Guide to Microsoft Office 2000: Troubleshooting and Problem Solving
  0-619-01519-5

www.wopr.com -- excellent online support for office products

Software:

• Microsoft Office 2000
• SAM 2000