• • 
•  
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

Administrative Professional with Microsoft Office Specialist

GES 802 -- 240 hours

Course Objectives

Upon successful completion of the Administrative Professional section of the Administrative Professional with Microsoft Office Specialist Program, the student should:



• Identify changes that are occurring in the workplace.
• Define common types of business organizational structures.
• Determine major challenges confronting both management and administrative professionals.
• Explain crucial skills and qualities for an administrative professional.
• Determine how an effective administrative professional sets goals and makes decisions.
• Identify virtual workplace considerations including personal characteristics, virtual workforce skills, and challenges.
• Describe an effective work environment for virtual workers.
• Describe the personal characteristics and work characteristics that contribute to a positive professional image.
• Identify the components of a professional appearance.
• Understand the conventions of business etiquette.
• Determine the effects of stress in the • Compose written communications.
• Apply characteristics of effective correspondence.
• Apply appropriate planning and writing guidelines.
• Engage in collaborative writing and research.
• Identify elements of effective verbal communication.
• Demonstrate effective verbal and nonverbal communication.
• Explain how effective communication can help resolve conflicts.
• Prepare and deliver a verbal presentation using visuals.
• Describe the importance of effective customer service to an organization.
• Identify characteristics of companies that value customer service.
• Develop effective customer service skills.
• Describe types of computers, input devices, storage devices, and networks commonly found in businesses.
• Describe the function of applications software and systems software.
• Understand threats and solutions related to computer security and privacy.
• Identify telecommunications messaging services and the etiquette associated with their use.
• Understand the importance of records management.
• Describe the considerations in managing paper and electronic records.
• Identify the factors associated with records retention, transfer, and disposal.
• Describe the characteristics of effective meetings and the wide variety of meeting formats.
• Implement organizational travel procedures.
• Understand your skills, interests, and abilities as they relate to a career.
• Determine a job search plan.
• Identify sources of job information and research organizations of interest.
• Prepare a resume and letter of application.
• Demonstrate effective interview skills.
• Develop job advancement strategies.
• Define leadership and describe leadership traits.
• Define management and describe the functions of management.
• Determine the administrative professional’s job responsibilities.
• Discuss the benefits of a healthy lifestyle, including proper diet and physical exercise.



Upon successful completion of the Microsoft Office Specialist section of the Administrative Professional with Microsoft Office Specialist Program, the student should:



Microsoft Excel
Description: The Complete Guide to Excel teaches users how to create spreadsheets from simple checkbooks to price sheets, market forecast and scenarios.

Objectives: On completion, users will be able to:
• Create a spreadsheet.
• Create formulas with the Function Wizard or manually.
• Audit equations and troubleshoot errors.
• Analyze data by Sort, Filter, Subtotal, and PivotTables.
• Format spreadsheets, graphs and lists for printing

Length: There are three levels of Excel: Beginning, Intermediate and Advanced. Each lesson has 3 or 4 modules. Each module can be completed in 30 minutes or less.

Microsoft Word
Description: The Complete Guide to Word teaches users how to create documents from simple letterheads and envelopes to custom web pages.

Objectives: On completion, users will be able to:
• Create a document.
• Format fonts, paragraphs, bullets and tables
• Use tables for on-line forms and webpage designs.
• Automate mail merges
• Share documents with a workgroup.

Length: There are three levels of Word: Beginning, Intermediate and Advanced. Each lesson has 3 or 4 modules. Each module can be completed in 30 minutes or less.

Microsoft PowerPoint
Description: The Complete Guide to PowerPoint offers examples of colorful, animated slideshows.

Objectives: On completion, users will be able to:
• Create a slideshow.
• Format fonts, paragraphs, bullets and text boxes
• Use custom animation, slide transitions and effects.
• Use graphics, sound and on-screen navigation.
• Prepare a slide show for live presentations and kiosk demonstrations.

Length: There are two levels of PowerPoint: Beginning and Advanced. Each lesson has 3 or 4 modules. A module can be completed in 30 minutes or less.

Microsoft Outlook
Description: The Complete Guide to Outlook teaches users how to set up and use email, an electronic calendar, contacts, tasks, and journal entries effectively. Security, administration and backups are also demonstrated.

Objectives: On completion, users will be able to:
• Use email, Contacts, and work with attachments safely.
• Organize the Inbox and filter junk mail.
• Schedule meetings, recurring appointments, and tasks
• Analyze Outlook data in Microsoft Excel or Access.

Length: There are three levels of Outlook: Email, Calendar, and Administration. Each lesson has 3 or 4 modules. A module can be completed in 30 minutes or less.

Microsoft Access
Description: The Complete Guide to Access teaches users how to create database tables, forms, queries and reports. The focus is on optimizing the databases for efficient data entry and generating comprehensive reports.

Course Objectives: On completion, users will be able to:
• Create tables, forms and reports.
• Use queries to find, filter, update and calculate.
• Create forms that handle data automatically
• Optimize the database for easy navigation, and data input.

Length: There are three levels of Access: Beginning, Intermediate and Advanced. Each lesson has 5 modules. Each module can be completed in 30 minutes or less.




---