The eLearning Center for the eLearning Centre

Administrative Professionals are the largest segment of the office workforce!

Over 4.1 million secretaries/administrative assistants are employed in the United States, according to the latest statistics from the U.S. Bureau of Labor. In addition, approximately 300,000 secretaries/administrative professionals are employed in Canada, and millions more work in businesses all over the world.

The Administrative Professional plays an increasingly vital and skilled role in today's (and tomorrow's) office...

• The Administrative Professional's job today requires skills in management functions and technology, including project management, integrated computer software applications, organization and scheduling, Internet/Intranet communications and research, document preparation, storage, and retrieval, with emphasis on electronic record-keeping, customer service, and public relations.
• Administrative Professionals are handling a wider variety of duties beyond strictly clerical roles. Today's AP often purchases office equipment and supplies, plans meetings and special events, works closely with vendors and suppliers, creates and gives presentations, interviews, orients and supervises other staff, writes and edits documents, schedules events and facilities, coordinates direct mailings, maintains multiple schedules and calendars, handles messages and correspondence (with voice mail, e-mail, and regular postal mail), maintains computer files, directories, and databases, and more.

A typical day for today's administrative assistant can include:

• Developing a production report using spreadsheet software
• Preparing charts, slides, and handouts for a management presentation
• Corresponding via phone, fax, or e-mail with clients all over the world
• Researching a topic on the Internet
• Coordinating a videoconference
• Scheduling an airline flight and purchasing tickets over the Internet
• Supervising and training a coworker
• Effectively representing management at a meeting

Gatlin Education Services Administrative Professional with MOS course is designed to give students the valuable skills that will give an edge in the workforce. Our unique course gives students the skills needed to be a successful administrative professional as well as training on the Microsoft Office Suite of programs and optional QuickBooks training.

Note: Students should have these Microsoft products already loaded on your computer in order to take this course: Word 2003; Excel 2003, Access 2003; Outlook 2003 and PowerPoint 2003.

Upon registering, you are given an initial six months to complete the program. Should you need more time, you may request a 6-month extension at no additional charge.

Course Objectives

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

• Understand and be able to perform the basic administrative skills, tasks and processes, required for employment as an Administrative Professional in a business office environment, including, but not limited to:

• Effective Communication and Language Usage
• Business Correspondence
• Planning Meetings and Travel
• Records Management and Mail Handling
• Leadership and Management
  
• Understand and be able to perform the basic financial skills, tasks and processes, required for employment as an Administrative Professional in a business office environment, including, but not limited to:
  
• Accounts Payable
• Accounts Receivable
• Banking
• Inventory Control and Ordering


• Use the Microsoft Office suite of software office productivity products effectively and knowledgeably. The programs include:


• Word (word processing program)
• Excel (spreadsheet program)
• PowerPoint (presentation software)
• Access (database management software)
• Outlook (scheduling and email program)

Unit 1 - Administrative Professional

1. Rating Chart (self-analysis)
2. Training Needs
3. Career Opportunities
4. 21st Century Skills
5. A Professional Image
6. Ethical Behavior (with interactivity)
7. Internal Relations
8. Make-up of Team
9. External Relationships
10. Communications

Unit 2 - Work Environment

1. Today's Office
2. Today's Worker Skills
3. 21st Century Skills
4. Working in Office Team (w/ interactivity)
5. Office Security
6. Virtual Office Workers
7. Workplace Ethics

Unit 3 - Time and Task Management

1. AP Work Area (w/ interactivity)
2. AP Responsibilities
3. Time Management (w/ interactivity)
4. Appointment Scheduling
5. The Admin Pro and Stress

Unit 4 - Telecommunications

1. Equipment and Systems
2. Special Equipment
3. Voice Messages
4. Phone Responsibilities (w/ interactivity)
5. Incoming Calls
6. Outgoing Calls

Unit 5 - Records Management

1. Records Management Defined
2. Records Management Practices
3. Records Retrieval
4. Archives
5. Records Retention
6. Retention Schedule
7. Records Transfer
8. Records Disposal
9. ARMA Rules (Assn/Records Managers and Administrators)
10. Storage Methods (w/ interactivity)

Unit 6 - Language Usage

1. Grammar
2. Language Usage and Style
3. Common English Usage Problems
4. Spelling
5. Pronunciation
6. Punctuation
7. Numerals
8. The Business Letter
9. Other Written Communications
10. Forms of Addresses
11. Legal Documents and Terms
12. Keyboarding Skills
13. Word Processing
14. Multimedia and Presentation Software
15. Desktop Publishing

Unit 7 - Microsoft Office Word - Basic

1. Section I: MICROSOFT OFFICE - WORD Basic& Intermediate
   1. Introducing Word
   2. Creating and Saving Documents
   3. Working with Text
   4. Formatting Paragraphs
   5. Managing Page Appearance
   6. Introducing Tables and Tabs
   7. Using Templates and Wizards
   8. Using Graphic Effects and Hyperlinks
   9. Proofing and Printing Documents
   
   
2. Section II: MICROSOFT OFFICE - WORD Advanced
   1. Enhancing Documents with Styles, Columns, and Art
   2. Using Templates and Forms
   3. Mail Merging
   4. Designing Web Pages
   5. Tracking Changes in Documents
   6. Using Outline View
   7. Emailing Messages and Documents
   8. Connecting with Other Office Programs

Unit 8 - Business Documents and Reports

1. Written Messages
2. Writing Characteristics (w/ interactivity)
3. The Planning Steps
4. Email and Memos
5. Letters
6. Message Checklist
7. Proofreading Tips
8. Formatting Guidelines
9. Reports
10. Proposal Writing
11. Collaborative Writing

Unit 9 - Microsoft Power Point

1. Creating a Presentation
2. Working with a Presentation
3. Printing a Presentation
4. Adding and Modifying Text
5. Drawing and Modifying Objects
6. Inserting Information into PowerPoint
7. Producing a Slide Show
8. Creating an Internet Presentation

Unit 10 - Office Mail

1. Outing Mail (w/ interactivity)
2. State Abbreviations (w/ interactivity)
3. Incoming Mail
4. Mail Classifications
5. Electronic Services
6. Future Mail Trends

Unit 11 - Microsoft Outlook

1. Jumping into Your Email
2. Working with Email
3. Managing Contacts
4. Appointments, Meetings, and Events
5. Taking Charge of Tasks
6. Managing and Protecting Files
7. Using Outlook with Other Office Programs

Unit 12 - Planning Meetings and Conferences

1. Meeting Elements
2. Facilitator's Role
3. Role of Participants
4. Meeting Types
5. Role of AP in Meetings (w/ interactivity)
6. Role of AP in Conferences and Conventions

Unit 13 - Ergonomics in the Workplace

1. Ergonomics and You
2. History of Ergonomics
3. Ergonomics Today
4. Ergonomic Environment
5. Ergonomic Workstation
6. Posture and Body

Unit 14 - Financial Management

1. Bookkeeping and Accounting
2. Business Taxes
3. Banking
4. Special Business and Financial Information for the Small Business
5. Weights and Measures
6. Office Equipment/Computers
7. Database Management

Unit 15 - Microsoft Excel

1. Section I: MS Excel Basic & Intermediate
   1. Introduction
   2. Setting up a Worksheet
   3. Adding Formulas
   4. Formatting a Worksheet
   5. Filtering and Fiding Information
   6. Organizing and Sorting Data
   7. Working with Multiple Files and Charts
   8. Printing Worksheets and Charts
   
   
2. Section II: MS Excel Advanced
   1. PivotTables and PivotChart Reports
   2. Distributing Information Online
   3. Sharing Information
   4. Integrating with Microsoft Office Programs
   5. Using Date from Other Sources
   6. Working with Macros
   7. Manipulating and Summarizing Lists
   8. Customizing Charts and Creating Maps

Unit 16 - Microsoft Access

1. Database Management
2. Introducing Access
3. Using Tables and Sub-forms
4. Using Filters and Reports
5. Managing Database Change
6. Keeping Database Information Reliable
7. Working with External Data
8. Using Queries
9. Form and Report Techniques

Unit 17 - Leadership and Management

1. Value of Leadership
2. Leadership vs. Management
3. Management Defined
4. Leadership Qualities
5. Leadership Tasks
6. Summary (w/ interactivity)

Unit 18 - Planning Your Career

1. Self Assessment
2. Career Options
3. Specialty Areas
4. Certification Areas
5. Research Careers
6. Job Application
7. Resume Planning (w/ interactivity)
8. Interview Preparation
9. Job Application
10. Summary (w/ interactivity)

Unit 19 - QuickBooks (Optional Unit)

1. The First Time in QB
2. Setting up Accounting
3. Entering Historical Data
4. Managing Accounts and Lists
5. Invoices and Sales Tax
6. Paying Bills
7. Managing Assets and Reports
8. Paying Employees
9. Managing Taxes
10. Online Banking and Budgets