Course Overview

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

The Office Applications Specialist 1 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) core tests for Word 2000, Excel 2000, Access 2000 and PowerPoint 2000. 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 1

Course Goals

The goals of the Office Applications Specialist 1 course are:

1. Successfully complete SAM assessment tests with a score of at least 80% on Microsoft Word, Excel, Access and PowerPoint 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 1 Course Competencies

The Following represent general outcomes and specific competencies for the Microsoft Office Specials 1 course.

WORD 2000

Working with text

• Use the Undo, Redo, and Repeat command
• Apply font formats (Bold, Italic and Underline)
• Use the SPELLING feature
  
• Use the THESAURUS feature
  
• Use the GRAMMAR feature
  
• Insert page breaks
  
• Highlight text in document
  
• Insert and move text
  
• Cut, Copy, Paste, and Paste Special using the Office Clipboard
  
• Copy formats using the Format Painter
  
• Select and change font and font size
  
• Find and replace text
  
• Apply character effects (superscript, subscript, strike through, small caps and outline)
  
• Insert date and time
  
• Insert symbols
  
• Create and apply frequently used text with AutoCorrect

Working with paragraphs

• Align text in paragraphs (Center, Left Right and Justified)
  
• Add bullets and numbering
  
• Set character, line, and paragraph spacing options
  
• Apply borders and shading to paragraphs
  
• Use indentation options (Left, Right, First Line and Hanging Indent)
  
• Use TABS command (Center, Decimal, Left and Right)
  
• Set tabs with leaders

Working with documents

• Print a document
  
• Use print preview
  
• Use Web Page Preview
  
• Navigate through a document
  
• Insert page numbers
  
• Set page orientation
  
• Set margins
  
• Use GoTo to locate specific elements in a document
  
• Create and modify page numbers
  
• Create and modify headers and footers
  
• Align text vertically
  
• Create and use newspaper columns
  
• Revises column structure
  
• Prepare and print envelopes and labels
  
• Apply styles
  
• Create sections with formatting that differs from other sections
  
• Use click & type

Managing files

• Use save
  
• Locate and open an existing document
  
• Use Save As (different name, location or format
  
• Create a folder
  
• Create a new document using a Wizard
  
• Save as Web Page
  
• Use templates to create a new document
  
• Create Hyperlinks
  
• Use the Office Assistant
  
• Send a Word document via e-mail

Using tables

• Create and format tables
  
• Add borders and shading to tables
  
• Revise tables (insert & delete rows and columns, change cell formats)
  
• Modify table structure (merge cells, change height and width)
  
• Rotate text in a table

Working with pictures and charts

• Use the drawing toolbar
  
• Insert graphics into a document (WordArt, ClipArt, Images)

Excel 2000

Working with cells

• Use Undo and Redo
  
• Clear cell content
  
• Enter text, dates, and numbers
  
• Edit cell content
  
• Go to a specific cell
  
• Insert and delete selected cells
  
• Cut, copy, paste, paste special and move selected cells, use the Office Clipboard
  
• Use Find and Replace
  
• Clear cell formats
  
• Work with series (AutoFill)

Working with files

• Use Save
  
• Use Save As (different name, location, format)
  
• Locate and open an existing workbook
  
• Create a folder
  
• Use templates to create a new workbook
  
• Save a worksheet/workbook as a Web Page
  
• Send a workbook via email
  
• Use the Office Assistant

Formatting worksheets

• Apply font styles (typeface, size, color and styles)
  
• Apply number formats (currency, percent, dates, comma)
  
• Modify size of rows and columns
  
• Modify alignment of cell content
  
• Adjust the decimal place
  
• Use the Format Painter
  
• Apply auto format
  
• Apply cell borders and shading
  
• Merging cells
  
• Rotate text and change indents
  
• Define, apply, and remove a style

Page setup and printing

• Preview and print worksheet & workbooks
  
• Use Web Page Preview
  
• Print a selection
  
• Change page orientation and scaling
  
• Set page margins and centering
  
• Insert and remove a page break
  
• Set print, and clear a print area
  
• Set up headers and footers
  
• Set print titles and options (gridlines, print quality, row & column headings)

Working with worksheets & workbooks

• Insert and delete rows and columns
  
• Hide and unhide rows and columns
  
• Freeze and unfreeze rows and columns
  
• Change the zoom setting
  
• Move between worksheets in a workbook
  
• Check spelling
  
• Rename a worksheet
  
• Insert and Delete worksheets
  
• Move and copy worksheets
  
• Link worksheets & consolidate data using 3D References

Working with formulas & functions

• Enter a range within a formula by dragging
  
• Enter formulas in a cell and using the formula bar
  
• Revise formulas
  
• Use references (absolute and relative)
  
• Use AutoSum
  
• Use Paste Function to insert a function
  
• Use basic functions (AVERAGE, SUM, COUNT, MIN, MAX)
  
• Enter functions using the formula palette
  
• Use date functions (NOW and DATE)
  
• Use financial functions (FV and PMT)
  
• Use logical functions (IF)

Using charts and objects

• Preview and print charts
  
• Use chart wizard to create a chart
  
• Modify charts
  
• Insert, move, and delete an object (picture)
  
• Create and modify lines and objects

Access 2000

Planning and Designing Databases

• Determine appropriate data inputs for your database
  
• Determine appropriate data outputs for your database
  
• Create table structure
  
• Establish table relationships

Working with Access

• Use the Office Assistant
  
• Select an object using the Objects Bar
  
• Print database objects (tables, forms, reports, queries)
  
• Navigate through records in a table, query, or form
  
• Create a database (using a Wizard or in Design View)

Building and modifying tables

• Create tables by using the Table Wizard
  
• Set primary keys
  
• Modify field properties
  
• Use multiple data types
  
• Modify tables using Design View
  
• Use the Lookup Wizard
  
• Use the input mask wizard

Building and modifying forms

• Create a form with the Form Wizard
  
• Use the Control Toolbox to add controls
  
• Modify Format Properties (font, style, font size, color, caption, etc) of controls
  
• Use form sections (headers, footers, detail)
  
• Use a Calculated Control on a form

Viewing and organizing information

• Use the Office Clipboard
  
• Switch between object Views
  
• Enter records using a datasheets
  
• Enter records using a form
  
• Delete records from a table
  
• Find a record
  
• Sort records
  
• Apply and remove filters (filter by form and filter by selection)
  
• Specify criteria in a query
  
• Display related records in a sub datasheet
  
• Create a calculated field
  
• Create and modify a multi-table select query

Defining relationships

• Establish relationships
  
• Enforce referential integrity

Producing reports

• Create a report with the Report Wizard
  
• Preview and print a report
  
• Move and resize a control
  
• Modify format properties (font, style, font size, color, caption, etc.)
  
• Use the Control Toolbox to add controls
  
• Use report sections (headers, footers, detail)
  
• Use a Calculated Control in a report

Integrating with other applications

• Import data to a new table
  
• Save a table, query, form as a Web page
  
• Publish a presentation to the Web
  
• Add Hyperlinks

Using Access Tools

• Print Database Relationships
  
• Backup and Restore a database
  
• Compact and Repair a database

Powerpoint 2000

Creating a presentation

• Delete slides
  
• Create a specified type of slide
  
• Create a presentation from a template and/or a Wizard
  
• Navigate among different views (slide, outline, sorter, tri-pane)
  
• Create a new presentation from existing slides
  
• Copy a slide from one presentation into another
  
• Insert headers and footers
  
• Create a Blank presentation
  
• Create a presentation using the AutoContent Wizard
  
• Send a presentation via e-mail
  

Modifying a presentation

• Change the order of slides using Slide Sorter view
  
• Find and replace text
  
• Change the layout for one or more slides
  
• Modify the Slide Master
  
• Modify slide sequence in the outline pane
  
• Apply a design template

Working with text

• Check spelling
  
• Change and replace text fonts (individual slide and entire presentation)
  
• Enter text in tri-pane view
  
• Import Text from Word
  
• Change the text alignment
  
• Create a text box for entering text
  
• Use the Wrap text in TextBox feature
  
• Use the Office Clipboard
  
• Use the Format Painter
  
• Promote and Demote text in slide & outline panes

Working with visual elements

• Add a picture from the ClipArt Gallery
  
• Add and group shapes using WordArt or the Drawing Toolbar
  
• Apply formatting
  
• Add text to a graphic object using a text box
  
• Scale and size an object including ClipArt
  
• Create tables within PowerPoint
  
• Rotate and fill an object

Customizing a presentation

• Add AutoNumber bullets
  
• Add speaker notes
  
• Add graphical bullets
  
• Add slide transitions
  
• Animate text and objects

Creating output

• Preview presentation in black and white
  
• Print slides in a variety of formats
  
• Print audience handouts
  
• Print speaker notes in a specified format

Delivering a presentation

• Start a slide show on any slide
  
• Use on screen navigation tools
  
• Print a slide as an overhead transparency
  
• Use the pen during a presentation

Managing files

• Save changes to a presentation
  
• Save as a new presentation
  
• Publish a presentation to the Web
  
• Use Office Assistant
  
• Insert hyperlink

Office Applications Specialist 1 Course Outline

Word 2000 - 16 hours

• Working with Text
  
• Working with paragraphs
  
• Working with documents
  
• Managing files
  
• Using Tables
  
• Working with pictures and charts

Excel 2000 - 24 hours

• Working with Cells
  
• Working with files
  
• Formatting worksheets
  
• Page setup and printing
  
• Working with worksheets & workbooks
  
• Working with formulas & functions
  
• Using charts and objects

Access 2000 - 24 hours

• Working with cells
  
• Planning and designing databases
  
• Working with Access
  
• Building and modifying tables
  
• Building and modifying forms
  
• Viewing and organizing information
  
• Defining relationships
  
• Producing reports
  
• Integrating with other applications
  
• Using Access Tools

PowerPoint 2000 - 20 hours

• Create a Presentation
  
• Add Textual Information
  
• Add Visuals Elements
  
• Bring in Data from other Sources
  
• Modify a presentation
  
• Prepare for Distribution
  
• Customize a Presentation
  
• Deliver Presentations

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

Exams /Quizzes/Presentations	50%
Labs	40%
Participation/Business Habits	10%

 

Office Applications Specialist 1 Resources

Required Tests:

ComputerPrep Learning Guides I and II for Word, Excel, Access and PowerPoint 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