Description

The Microsoft Office Specialist programme from Gatlin International is a comprehensive, performance-based MOS certification programme which is approved by Microsoft as a means to verify the desktop computer skills of users in Microsoft Office productivity software including Microsoft Word, Microsoft Excel, Microsoft Power Point, Microsoft Outlook and Microsoft Access. Our Microsoft Office Specialist certification training course offers students a number of benefits that have been proven to increase their chances for success. Unlike some Microsoft Office training courses, our Microsoft Office Specialist (MOS) certification course is delivered using state of the art curricula in an anytime, anywhere, online learning approach that accommodates even the busiest of schedules.

We employ the Comma Method of Microsoft® Office Specialist certification training which was designed and developed to meet the varied needs of students, educators, administrators and business professionals. In recent years the demand for Microsoft Office 2003 training has increased significantly. In fact, Microsoft Office Specialist, or MOS, certification is now a requirement in most educational environments as well as in virtually all technical and professional jobs. Most small companies have also found that Office 2003 training is a competitive advantage for their businesses. Microsoft has issued over 2 million MOS certifications and grants approximately 38,000 additional Microsoft Office Specialist certificates per month.

"We've made the course a lot of fun," said Elizabeth Nofs, the current creative director for Comma Project LLC. "We use a lot of real-life examples in order to make the course more practical and memorable. The course focuses on teaching the skills the employers want their employees to have. Why wade through a lot of information you'll never use? It’s a very effective course."

Standards and Alignment The Microsoft Office Specialist (MOS) programme is aligned with the following standards:
MOS Microsoft Office Specialist Certification Requirements
ISTE NETS standards for Teachers, Administrators and Students
Michigan Grade Level Expectations and Benchmarks for 6th grade Technology, Math and Science

Our Microsoft Office Specialist certification training course is a performance-based programme that teaches students to be proficient in Microsoft Office 2003: Word, Excel, Power Point, Outlook, and Access. The MOS program provides computer-program literacy, measures proficiency, and identifies opportunities for skills enhancement. Participants receive a certificate of completion from the college upon successful completion of the course. Students are then well prepared to take the Microsoft Office Specialist Certification Test.

How to Become MOS Certified To earn the Microsoft Office Specialist (Office Specialist) certification for Microsoft Office or Microsoft Project, a student must pass one or more certification exams. Office Specialist exams provide a valid and reliable measure of technical proficiency and expertise by evaluating your overall comprehension of Office or Microsoft Project programs, your ability to use their advanced features, and your ability to integrate the Office programs with other software programs.

Note: Students enrolling in the Microsoft Office Specialist certification training course 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 in the MOS certification course, 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.

Level 1-Beginning Windows
At the end of this unit, the student will be able to: Highlight text in document, Apply font formats: bold, italic, underline, Use the Spelling and Grammar checker (commands), Highlight text in document, understand beginning hardware troubleshooting, file management and administration features/procedures.

Level 2-Beginning Word
At the end of this unit, the student will be able to: Cut, copy, and paste, Insert pictures from ClipArt Menus: Edit Undo, Redo, Copy, Paste, Insert Picture Activity: Drag and drop editing, Move text, Insert ClipArt, and Resize pictures

Level 3-Beginning Word
At the end of this unit, the student will be able to: Insert date and time, Insert picture from file, Format font and font size, File Save As a template

Level 4-Beginning Word
At the end of this unit, the student will be able to: Locate and insert an existing document, Format newspaper columns, Use Paste Special Beginning Excel: Enter text, dates and numbers, Use AutoFill, Use the Chart Wizard, Modify Charts.

Level 5-Beginning Excel
At the end of this unit, the student will be able to: Format font styles (size, color, and styles), Apply number formats (currency, percent), Format borders and shading, Use AutoSum, Insert and delete rows or columns, Hide and unhide rows and columns, Set up headers and footers, Use references (relative), Use Functions: Average and IF

Level 6-Intermediate Word
At the end of this unit, the student will be able to: Use advanced text alignment, Use Mail Merge: Create main document, Create data source, Sort records to be merged, Merge the document and data. Intermediate Excel: Single and multilevel sorts

Level 7-Intermediate Word
At the end of this unit, the student will be able to: Create and format tables, Add borders and shading, Merge Cells, Save as a Web Page, Create Hyperlinks, Use Design Gallery Live, Practice Working with TABS Using Bookmarks with Hyperlinks

Level 8-Outlook
At the end of this unit, the student will be able to: Read, Compose and Address Mail, Use Address Book, Use mail features: Forward, Reply and Recall, Flag Mail messages, Send Mail, Work with attachments, Work with Contacts, Create a Distribution List, Use Inbox Rules, Handle Junk Mail, Archive Outlook, Instant Messaging

Level 9-Intermediate Excel
At the end of this unit, the student will be able to: Schedule appointments, Schedule events, Recurring appointments, Add and remove attendees. Plan meetings with others, Track the responses, Create Tasks, Assign a task, Work with the Journal, Find an appointment, Customize the calendar view. Intermediate Excel: Use Conditional Formatting, Merge and Center Cells, Use references (relative), Create form controls

Level 10-Intermediate Excel
At the end of this unit, the student will be able to: Rename a worksheet, Copy or Move worksheets, Link worksheets and consolidate data. Advanced Excel: Use Relative References, Absolute References, Work with Scenarios, Use Goal Seek, Use the Auditing Toolbar to trace errors. Calculate Revenue, Create a grand total from several spreadsheets, Understand Absolute and Relative References

Level 11-Beginning PowerPoint
At the end of this unit, the student will be able to: Navigate different views, Create a presentation from a template or a wizard, Use the Outline View, Use Bullets and numbers, Work with Graphics, Work with text boxes, Use the Slide Sorter, Add slide transitions, View the Slide Show, Modify the Slide Master, Insert headers and footers, Apply formatting, Add and group shapes, Animate text and objects, Custom Animation, Animation Effects, On screen navigation tools, Add and Print speaker notes.

Level 12-Advanced Word and Excel
At the end of this unit, the student will be able to: Create and modify forms, Make controls: Drop Down Lists, Date and Time Fields, Protect the document, Activity: Create an on-line form with drop down lists and default text values. Advanced Excel: Create a PivotTable, Use PivotTable auto format, Analyze data with a PivotTable.

Level 13-Advanced Topics
At the end of this unit, the student will be able to: Create and edit styles, Create a Table of Contents, Use Headers and Footers, Create Section Breaks, Use the Document Map. Advanced Excel: Filter the Data, Create Subtotals, Group and Outline Data, Use the VLookup Function

Level 14- Advanced PowerPoint
At the end of this unit, the student will be able to: Use advanced formatting and design, Add new slides from an Outline, from Word, from another presentation, Modify the slide design, customize a presentation with sound, narration, and action buttons. Prepare a presentation for different formats: speaker, kiosk, CD.

Level 15: Beginning Access
At the end of this unit, the student will be able to: Use and design tables, forms, and queries in Microsoft Access, create Queries to find and select records by criteria, write and test update queries.

Level 16: Intermediate Access
At the end of this unit, the student will be able to: Create forms with subforms to represent one-to-many relationships, use criteria, parameters, concatenation, and operators in Query designs: calculate with DateDif(),Left(), and IIF(), improve report designs with Sorting and Grouping.

Level 17: Advanced Access
At the end of this unit, the student will be able to: link information and automate data entry, create a Search Form that uses a Combo Box to filter the records, use Microsoft Access and Word together in a Mail Merge, as well as publish an Access report to Word, optimize a database for multiple users.

Our Microsoft Office training course is compatible with the Windows Vista operating system.

Textbooks-----

Your tuition includes the following textbooks:

Beginning Guide to Microsoft® Word
Intermediate Guide to Microsoft® Word
Advanced Guide to Microsoft® Word
Beginning Guide to Microsoft® Excel
Intermediate Guide to Microsoft® Excel
Advanced Guide to Microsoft® Excel
Beginning Guide to Microsoft® Access
Intermediate Guide to Microsoft® Access
Advanced Guide to Microsoft® Access
Complete Guide to Microsoft® PowerPoint®
Complete Guide to Microsoft® Outlook®

It is recommended that these Microsoft products already be loaded on the computer in order to take the Microsoft Office training course: Word 2003; Excel 2003, Access 2003; Outlook 2003 and PowerPoint 2003.

Older versions of Microsoft Office or Microsoft Office XP may be used to take this course, but be aware there will be discrepancies between the textbook, online content, and your Microsoft Office software.

PC Requirements-----

• IBM-compatible (PC) computer running Windows 2000 or later or Windows XP
• 
  
  
• Microsoft Office 2003 including:
• 
  
• Word
• 
  
• Excel
• 
  
• PowerPoint
• 
  
• Outlook
• 
  
• Access
• 
  
  Adobe Flash Player and Adobe Acrobat Reader are required for this course.
  Click here to download the Acrobat Reader.
  Click here to download the Flash Player.
  
  
• Preferred: Cable or DSL Internet access.
• 
  
• If your Internet service provider uses only dial-up, a minimum of 56K connection rate is recommended.
• The Microsoft Office Specialist course cannot be taken from a Mac computer.
  
  

Outline

Demo

Click hereto see a demo of this class.

Additional Info

Languages

English

Course Length

120.00 hours

Duration of Access

Instructor

Elizabeth Ann Nofs is co-founder and the Creative Director for Comma Project, LLC. Her research on how men and women approach computer learning provided the foundation for the Comma Method of training, as well as The Computer Mama Show, a pilot produced with WFUM/TV28 (PBS), Flint, Michigan.

Elizabeth is the Computer Mama! She is the designer and developer of the Complete Computer Guide series. The teaching methodology incorporated into the Guide is a breakthrough in producing gender balanced training with outstanding student completion, retention, and mastery rates.

Elizabeth has been a network administrator for many businesses as well as a Microsoft course instructor. Elizabeth has taught several thousand men and women from government, manufacturing, small business, and education. She has developed Microsoft Office solutions and databases since 1993.

She is the author of several books including The Computer Mama Guide to Computers (2001), The Comma Method of Computer Training (2003), The Comma Teachers Edition (2003) and The Complete Computer Guide (2005).

Elizabeth received her B.A. degree in Biology from the University of Michigan., Ann Arbor.

Prerequisites/Audience

Requirements/Materials Included