Course Overview

This comprehensive curriculum provides training for beginners as well as advanced users, and covers 5 of the most recognised business applications in the world – Access 2000, Excel 2000, Outlook 2000, PowerPoint 2000 and Word 2000.

With the skills and knowledge you gain from this curriculum, you'll have increased job opportunities and salary potential. Built-in assessments that personalise your learning path make it the perfect tool for those upgrading from an early version of Office. Filter out the information you already know and focus your time on the content you need! This curriculum has been approved by Microsoft to ensure you are receiving accurate information and to prepare you for Microsoft Office Specialist (MOS) certification exams.

Pre-requisites

Students should be familiar with basic PC functions and Microsoft Windows.

Qualification

This course will help you prepare for the Microsoft Office Specialist (MOS) qualification

Support

You'll have access to the ICS online Student Community, where you can interact with other students, browse our resource library and take part in surveys. 

Key Topics

• Microsoft Word 2000

Learn how to insert, modify, move and format text. Explore paragraph formatting, as well as bulleting and tabs. Examine headers, footers, column settings and tables. Discover how to print documents, envelopes and labels. Learn how to create documents from templates, and how to insert graphics. Discover how to convert documents into webpages.

• Microsoft Excel 2000

Learn how to enter and edit cell data and how to use AutoFill. Discover how to create workbooks from templates. Learn how to apply styles. Learn how to work with formulae and functions, and how to create and modify charts and graphics. Discover how to convert worksheets into webpages.

• Microsoft PowerPoint 2000

Discover how to create presentations both manually and from automated tools, and how to import text from Word and charts from Excel. Learn how to add tables and graphics to slides. Explore animation, slide transitions and the formatting of presentations and individual slides. Discover how to add speaker notes, and how to publish presentations to the Web.

• Microsoft Access 2000

Learn how to create and modify tables, how to use the Lookup Wizard and how to modify field properties. Discover how to create and modify select queries. Explore the creation and modification of forms. Learn how to enter, edit, delete and sort records. Learn how to create one-to-many relationships and how to enforce referential integrity. Discover how to create reports.

• Microsoft Outlook 2000

Learn how to read, send and respond to e-mails. Discover how to attach files to emails and how to create a personal signature. Explore e-mail organisation and the creation and editing of contacts. Learn how to accept, decline and delegate tasks. Discover how to create and modify appointments, meetings and events. Examine notes and learn how to book office resources directly (for example, conference rooms).

Course code

808

Hours of study

100 hours

Technical requirements

The minimum system spec required to run our CD-ROMs is: PC with a Pentium with 233 MHz or better with a minimum of 64 MB RAM. The PC should be running Microsoft Windows 98 or later. Microsoft Internet Explorer 5.0 with Service Pack 2 or higher; or Netscape Navigator 4.76 or higher. The browser must support cookies, Java and JavaScript. 800 x 600 screen resolution; 256 color. For audio, MPCI compliant sound card with speakers or headphones.

Outline

The Microsoft Office 2000 Specialist certification is made up of five exams. However, only one exam needs to be passed to become certified as a Microsoft Office 2000 Specialist. Nevertheless, it is recommended that you sit and pass all five exams, because each pass proves your ability to work with a different program in the Microsoft Office suite.

The ICS course material also introduces you to the knowledge you need to become Specialist (Expert) certified, which is a step above basic Specialist certification. The Microsoft Office 2000 Specialist (Expert) certification is made up of two exams. Again, only one exam needs to be passed to become certified as a Microsoft Office 2000 Specialist (Expert). However, by passing both exams, you will prove your ability to be able to work proficiently with both Word and Excel.

Additionally, please note that if you pass Word 2000 Expert, Excel 2000 Expert, PowerPoint 2000 and EITHER Access 2000 OR Outlook 2000, you will achieve Microsoft Office Specialist (Master) certification.

Assessment Breakdown

Specialist Exams

• Word 2000: This exam is performance-based and you will be required to complete 30-35 multi-task questions using Microsoft Word 2000.
• Excel 2000: This exam is performance-based and you will be required to complete 30-36 multi-task questions using Microsoft Excel 2000.
• PowerPoint 2000: This exam is performance-based and you will be required to complete 25-30 multi-task questions using Microsoft PowerPoint 2000.
• Access 2000: This exam is performance-based and you will be required to complete 20-30 multi-task questions using Microsoft Access 2000.
• Outlook 2000: This exam is performance-based and you will be required to complete 30-15-20 multi-task questions using Microsoft Outlook 2000.

Specialist (Expert) Exams

• Word 2000 Expert: This exam is performance-based and you will be required to complete 23-30 multi-task questions using Microsoft Word 2000.
• Excel 2000 Expert: This exam is performance-based and you will be required to complete 30-36 multi-task questions using Microsoft Excel 2000.

Notes

All Microsoft Office Specialist exams for Microsoft Office 2000 last 45 minutes.

All exams can be sat at your local testing centre.

Please note that exam fees are additional to your course fees.