Course Overview

It's an excellent way to learn how to use this popular and versatile suite of applications, and the new features included in programs such as Microsoft Word, Excel, PowerPoint and more – as well as the overall improvements included in Office XP. This course is intended for anyone already familiar with Office 97 or Office 2000.

Pre-requisites

Students should be familiar with Microsoft Windows before starting this course.

Qualification

The course maps directly on to 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 2002

Learn how to insert, modify, move and format text. Explore paragraph formatting, as well as bulleting and tabs. Examine headers, footers, column settings, tables and Page Setup options. Discover how to print documents, envelopes and labels. Learn how to create documents from templates, and how to insert images, diagrams and charts. Discover how to compare and merge documents, and how to convert documents into webpages.

• Microsoft Excel 2002

Learn how to enter and edit cell data and how to work with a subset of data by filtering lists. Discover how to create workbooks from templates. Explore cell, row and column formats, as well as row and column settings. Learn how to apply styles and how to use automated tools to format worksheets. Learn how to create and revise formulae, and how to create and modify charts and graphics. Discover how to convert worksheets into webpages.

• Microsoft PowerPoint 2002

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, charts, clip art, images, OfficeArt, videos and sounds to slides. Explore animation schemes, slide transitions and the formatting of presentations and individual slides. Discover how to publish presentations to the Web.

• Microsoft Access 2002

Learn how to create and modify tables, how to create Lookup fields 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, sort and filter records. Learn how to create one-to-many relationships and how to enforce referential integrity. Discover how to create and format reports.

• Microsoft Outlook 2002

Learn how to originate and respond to e-mail and instant messages. Discover how to attach files to emails and how to create a personal signature. Explore e-mail message settings and delivery options, 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, and how to update, cancel and respond to meeting requests. Examine distribution lists, notes and the customisation of Calendar settings.

• Microsoft FrontPage 2002

Gain an understanding of the basics of Web design and the operation of hyperlinks. Learn how to format a webpage, work with themes and add graphics. Explore photo galleries, Web components, tables, frames and forms. Discover how to publish a website.

Course code

809

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 XP Specialist certification is made up of five exams. However, only one exam needs to be passed to become certified as a Microsoft Office XP 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 Microsoft Office XP Specialist course from ICS will provide you with the knowledge you need to pass all five exams – and will additionally teach you how to operate Microsoft FrontPage 2002 (for which there is no exam).

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 XP Specialist (Expert) certification is made up of two exams. Again, only one exam needs to be passed to become certified as a Microsoft Office XP 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 2002 Expert, Excel 2002 Expert, PowerPoint 2002 and EITHER Access 2002 OR Outlook 2002, you will achieve Microsoft Office Specialist (Master) certification.

Assessment Breakdown

Specialist Exams

• Word 2002: This exam is performance-based and consists of 18-20 questions. You will be required to perform 47-51 tasks using Microsoft Word 2002.
• Excel 2002: This exam is performance-based and consists of 16-18 questions. You will be required to perform 33-37 tasks using Microsoft Excel 2002.
• PowerPoint 2002: This exam is performance-based and consists of 18-21 questions. You will be required to perform 49-58 tasks using Microsoft PowerPoint 2002.
• Access 2002: This exam is performance-based and consists of 17-20 questions. You will be required to perform 38-45 tasks using Microsoft Access 2002.
• Outlook 2002: This exam is performance-based and consists of 21-24 questions. You will be required to perform 49-56 tasks using Microsoft Outlook 2002.

Specialist (Expert) Exams

• Word 2002 Expert: This exam is performance-based and consists of 14-16 questions. You will be required to perform 35-39 tasks using Microsoft Word 2002.
• Excel 2002 Expert: This exam is performance-based and consists of 14-16 questions. You will be required to perform 35-39 tasks using Microsoft Excel 2002.

Notes

All Microsoft Office Specialist exams for Microsoft Office XP last between 45 and 50 minutes.

All exams can be sat at your local testing centre.

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