|
 |
 |
|
|
| Microsoft Office User Specialist - Specialist |
|
| MOS - Specialist |
|
| Duration: 7 Hours |
|
|
|
| Offered at the following locations: |
| |
|
|
|
|
| The Microsoft Office Specialist program is committed to providing students and information workers with the opportunity to certify their Microsoft Office skills. Office Specialists enjoy increased competence and productivity with Microsoft Office programs as well as increased credibility with employers, coworkers and clients. Students in the MOUS Specialist Certification Track must successfully complete any one (1) required specialist tracks and specialist exams. Track: MOUS Specialist Certification consist of one required track in Word, Excel, PowerPoint, Access or Outlook:
Audience Profile
Microsoft Office Word 2003 certification is intended for students and information workers whose responsibilities include the use of Microsoft Office Word to manage, format and communicate information in organizations of every size.
Skill Standards
This exam measures your ability to productively use Microsoft Office Word 2003. Before taking the exam, you should be proficient in the following program skills:
Creating Content
· Insert and edit text, symbols and special characters
· Insert frequently used and pre-defined text
· Navigate to specific content
· Insert, position and size graphics
· Create and modify diagrams and charts
· Locate, select and insert supporting information
Organizing Content
· Insert and modify tables
· Create bulleted lists, numbered lists and outlines
· Insert and modify hyperlinks
Formatting Content
· Format text
· Format paragraphs
· Apply and format columns
· Insert and modify content in headers and footers
· Modify document layout and page setup
Collaborating
· Circulate documents for review
· Compare and merge documents
· Insert, view and edit comments
· Track, accept and reject proposed changes
Formatting and Managing Documents
· Create new documents using templates
· Review and modify document properties
· Organize documents using file folders
· Save documents in appropriate formats for different uses
· Print documents, envelopes and labels
· Preview documents and Web pages
· Change and organize document views and windows
Audience Profile
Microsoft Office Excel 2003 certification is intended for students and information workers whose responsibilities include the use of Microsoft Excel to create, modify, and manage common business workbooks and worksheets in organizations of every size.
Skill Standards
This exam measures your ability to productively use Microsoft Office Excel 2003. Before taking the exam, you should be proficient in the following program skills:
. Creating Data and Content
. Enter and edit cell content
. Navigate to specific cell content
. Locate, select, and insert supporting information
. Insert, position, and size graphics
. Analyzing Data
. Filter lists using AutoFilter
. Sort lists
. Insert and modify formulas
. Use statistical, date and time, financial, and logical functions
. Create, modify, and position diagrams and charts based on worksheet data
. Formatting Data and Content
. Apply and modify cell formats
. Apply and modify cell styles
. Modify row and column formats
. Format worksheets
. Collaborating
. Insert, view, and edit comments
. Managing Workbooks
. Create new workbooks from templates
. Insert, delete, and move cells
. Create and modify hyperlinks
. Organize worksheets
. Preview data in other views
. Customize Window layout
. Setup pages for printing
. Print data
. Organize workbooks using file folders
. Save data in appropriate formats for different uses
Audience Profile
Microsoft Office PowerPoint 2003 certification is intended for students and information workers whose responsibilities include the use of Microsoft PowerPoint to create presentations using automated tools, modify slides, slide masters, and print and deliver presentations in organizations of every size.
Skill Standards
This exam measures your ability to productively use Microsoft Office PowerPoint 2003. Before taking the exam, you should be proficient in the following program skills:
. Creating Content
. Create new presentations from templates
. Insert and edit text-based content
. Insert tables, charts, and diagrams
. Insert pictures, shapes, and graphics
. Insert objects
. Formatting Content
. Format text-based content
. Format pictures, shapes, and graphics
. Format slides
. Apply animation schemes
. Apply slide transitions
. Customize slide templates
. Work with masters
. Collaborating
. Track, accept, and reject changes in a presentation
. Add, edit, and delete comments in a presentation
. Compare and merge presentations
. Managing and Delivering Presentations
. Organize a presentation
. Set up slide shows for delivery
. Rehearse timing
. Deliver presentations
. Prepare presentations for remote delivery
. Save and publish presentations
. Print slides, outlines, handouts, and speaker notes
. Export a presentation to another Microsoft Office program
Audience Profile
Microsoft Office Access 2003 Specialist certification is intended for students and information workers whose responsibilities include the use of Microsoft Office Access to organize, structure, and manage data in organizations of every size.
Skill Standards
This exam measures your ability to productively use Microsoft Office Access 2003. Before taking the exam, you should be proficient in the following program skills:
. Structuring Databases
. Create Access databases
. Create and modify tables
. Define and modify field types
. Modify field properties
. Create and modify one-to-many relationships
. Enforce referential integrity
. Create and modify queries
. Create forms
. Add and modify form controls and properties
. Create reports
. Add and modify report control properties
. Create a data access page
. Entering Data
. Enter, edit, and delete records
. Find and move among records
. Import data to Access
. Organizing Data
. Create and modify calculated fields and aggregate functions
. Modify form layout
. Modify report layout and page setup
. Format datasheets
. Sort records
. Filter records
. Managing Databases
. Identify object dependencies
. View objects and object data in other views
. Print database objects and data
. Export data from Access
. Back up a database
. Compact and repair databases
Audience Profile
Microsoft Office Outlook 2003 certification is intended for students and information workers whose responsibilities include the use of Microsoft Outlook to create and manage messages, tasks, contacts and appointments, and use Outlook with other Office applications in organizations of every size.
Skill Standards
This exam measures your ability to productively use Microsoft Office Outlook 2003. Before taking the exam, you should be proficient in the following program skills:
. Messaging
. Originate and respond to e-mail and instant messages
. Attach files to items
. Create and modify a personal signature for messages
. Modify e-mail message settings and delivery options
. Create and edit contacts
. Accept, decline, and delegate tasks
. Scheduling
. Create and modify appointments, meetings, and events
. Update, cancel, and respond to meeting requests
. Customize Calendar settings
. Create, modify, and assign tasks
. Organizing
. Create and modify distribution lists
. Link contacts to other items
. Create and modify notes
. Organize items
. Organize items using folders
. Search for items
. Save items in different file formats
. Assign items to categories
. Preview and print items |
| |
| Course Prerequisites: |
|
Introduction to PC's |
| |
| |
| Next Steps: |
|
MOUS - Expert |
|
|
|
|
This outline is subject to change and is used as a reference only. |
| |
|
|
|
