ICDL/ECDL:
Syllabus 4.0, Office 2003

Topic-Level Outline

Days: 5

Prerequisites: Windows XP: Basic or equivalent experience

Unit 1 : Concepts of information technology

Topic A: 0 Overview of information technology

A-1: Understanding hardware and software

A-2: Identifying types of computers

A-3: Identifying the parts of a personal computer

Topic B: 0 Hardware and storage devices

B-1: Discussing the features of a CPU

B-2: Identifying input and output devices

B-3: Identifying the two types of memory

B-4: Discussing storage units

B-5: Identifying types of storage devices

B-6: Discussing computer performance factors

Topic C: 0 Software

C-1: Discussing operating systems

C-2: Identifying application software

C-3: Discussing the software development process

Topic D: 0 Networks

D-1: Discussing networking

D-2: Discussing the Internet, intranets, and extranets

D-3: Discussing network utilities

Unit 2 : Computers and society

Topic A: 0 Computers in daily life

A-1: Discussing the use of computers in daily life

A-2: Discussing e-mail

Topic B: 0 Impact of IT on society

B-1: Discussing the information superhighway and e-commerce

B-2: Discussing computer health hazards

B-3: Discussing social issues

B-4: Discussing environmental issues

Topic C: 0 Security and legal issues

C-1: Identifying computer security issues

C-2: Discussing copyrights and data protection

Unit 3 : Using computers and managing files

Topic A: 0 Basic computer operations

A-1: Starting, restarting, and shutting down your computer

A-2: Viewing system information

A-3: Formatting a disk

A-4: Installing and uninstalling a software application

A-5: Closing a non-responding application

Topic B: 0 The Help and Support Center

B-1: Using the Search box

B-2: Using the Index

B-3: Using the Favorites list

B-4: Using the History list

B-5: Using online support

Topic C: 0 The desktop

C-1: Starting and switching between programs

C-2: Creating a desktop shortcut

C-3: Using a desktop shortcut

C-4: Deleting a desktop shortcut

Topic D: 0 Working with windows

D-1: Exploring a window

D-2: Moving and resizing windows

D-3: Using the Control buttons

Topic E: 0 Windows XP system settings

E-1: Changing display properties

E-2: Using date, time, and volume options

E-3: Changing the keyboard language

E-4: Using the Print Screen facility

Unit 4 : Folder and file management

Topic A: 0 File and folder structure

A-1: Using View options

A-2: Browsing the contents of a hard disk

A-3: Expanding and collapsing a folder

A-4: Viewing and changing file and folder attributes

Topic B: 0 Basic text editing

B-1: Creating a document

B-2: Saving a document

Topic C: 0 Manipulating files and folders

C-1: Creating a folder and a subfolder

C-2: Selecting and renaming a file

C-3: Moving a file and a folder

C-4: Copying a file and a folder

C-5: Backing up a file and a folder

C-6: Copying a group of objects

Topic D: 0 Managing files and folders

D-1: Searching for files by name

D-2: Searching for files containing specific text

D-3: Sorting files in a folder

D-4: Compressing and decompressing a file

D-5: Encrypting files

Topic E: 0 Deleting and restoring files

E-1: Deleting files

E-2: Examining the contents of the Recycle Bin

E-3: Restoring deleted objects from the Recycle Bin

E-4: Emptying the Recycle Bin

Unit 5 : Printer and virus management

Topic A: 0 Printer management

A-1: Installing a printer

A-2: Setting a default printer

A-3: Previewing and printing a document

A-4: Monitoring printing progress

A-5: Setting printer options

Topic B: 0 Viruses

B-1: Discussing viruses

B-2: Using antivirus software

B-3: Discussing antivirus software updates

Unit 6 : Word processing

Topic A: 0 Getting started

A-1: Starting and exploring Microsoft Word 2003

A-2: Creating a document

A-3: Using a template to create a document

A-4: Saving a document

A-5: Opening a document

A-6: Switching between open documents

A-7: Closing documents and exiting Word

Topic B: 0 Basic view settings

B-1: Changing the page display mode

B-2: Setting the magnification level

B-3: Working with toolbars

B-4: Using the Options dialog box

Topic C: 0 Getting help

C-1: Using the Type a question for help box

C-2: Using Office Assistant

C-3: Using the Word Help task pane

Unit 7 : Adding and modifying text

Topic A: 0 Working with text

A-1: Inserting text and showing nonprinting characters

A-2: Using the Undo and Redo commands

A-3: Inserting special characters and symbols

Topic B: 0 Editing documents

B-1: Selecting and editing text

B-2: Copying and moving text

B-3: Deleting text

Topic C: 0 Finding and replacing text

C-1: Finding text in a document

C-2: Replacing text in a document

Topic D: 0 Formatting text

D-1: Using the Font dialog box

D-2: Using the Style list

D-3: Using the Format Painter

D-4: Using the Reveal Formatting task pane

D-5: Changing case

D-6: Controlling hyphenation

Unit 8 : Paragraphs and tables

Topic A: 0 Formatting paragraphs

A-1: Aligning text

A-2: Setting indents and line spacing

A-3: Using tab stops

A-4: Setting tabs and tab leaders

A-5: Applying bullets and numbering

A-6: Applying a border

Topic B: 0 Formatting documents

B-1: Modifying page orientation

B-2: Changing a document’s vertical alignment

B-3: Inserting and deleting page breaks

B-4: Modifying the document margins

B-5: Inserting headers and footers

B-6: Inserting page numbers

Topic C: 0 Creating and managing tables

C-1: Creating a table

C-2: Adding and editing text in a table

C-3: Selecting and formatting a table

C-4: Aligning a table

C-5: Inserting rows and columns in a table

C-6: Using AutoFormat to format a table

C-7: Deleting rows, columns, and a table

Unit 9 : Graphics and mail merge

Topic A: 0 Graphics

A-1: Inserting clip art

A-2: Inserting a chart

A-3: Inserting and formatting a picture

A-4: Inserting an AutoShape

A-5: Copying and deleting a graphic

A-6: Resizing and moving a graphic

Topic B: 0 Letters and mailings

B-1: Using the Letter Wizard to create a letter

B-2: Creating a data source

B-3: Creating a form letter

B-4: Adding fields to a form letter

B-5: Merging a data source with a form letter

B-6: Merging addresses with mailing labels

Unit 10 : Proofing and printing documents

Topic A: 0 Proofing documents

A-1: Correcting misspelled words

A-2: Manually checking for misspelled words

A-3: Checking grammar

Topic B: 0 Printing

B-1: Previewing a document

B-2: Printing a document

Unit 11 : Spreadsheets

Topic A: 0 Getting started

A-1: Starting Excel and opening a workbook

A-2: Navigating between workbooks and worksheets

A-3: Creating and saving a workbook

A-4: Saving a workbook in another file format

A-5: Using Help

A-6: Closing workbooks and Excel

Topic B: 0 Working in the Excel environment

B-1: Changing view options

B-2: Modifying basic options

B-3: Zooming in and out on a large worksheet

B-4: Showing and hiding toolbars

B-5: Freezing rows and columns

Unit 12 : Spreadsheet structure

Topic A: 0 Entering and editing data

A-1: Entering data and values

A-2: Selecting a range

A-3: Inserting and modifying cell contents

A-4: Using the Undo and Redo commands

A-5: Copying data within a worksheet

A-6: Copying data by using the fill handle

A-7: Moving data within a worksheet

A-8: Deleting a range

Topic B: 0 Finding, replacing, and sorting data

B-1: Finding and replacing data

B-2: Sorting a list

Topic C: 0 Manipulating worksheets

C-1: Inserting and deleting rows and columns

C-2: Modifying column width and row height

C-3: Inserting worksheets

C-4: Deleting worksheets

C-5: Moving and copying worksheets

C-6: Renaming worksheets

Unit 13 : Formulas and formats

Topic A: 0 Formulas and functions

A-1: Entering a formula by typing

A-2: Using the mouse to enter cell references

A-3: Recognizing standard error messages

A-4: Observing the limitations of relative references

A-5: Using absolute references

A-6: Using the SUM and AVERAGE functions

A-7: Using IF to return values based on a condition

Topic B: 0 Formatting

B-1: Formatting numbers

B-2: Applying conditional formatting

B-3: Using date and time formats

B-4: Formatting text

B-5: Setting alignment and orientation

B-6: Using the Format Painter

Unit 14 : Charts and printing

Topic A: 0 Working with charts

A-1: Creating a chart

A-2: Exploring chart elements

A-3: Changing the chart type

A-4: Formatting chart objects

A-5: Moving, resizing, copying, and deleting chart objects

Topic B: 0 Printing and proofing worksheets

B-1: Changing worksheet orientation and margins

B-2: Inserting headers and footers

B-3: Proofing a worksheet

B-4: Previewing a worksheet

B-5: Changing print options

B-6: Printing a worksheet

Unit 15 : Databases

Topic A: 0 Database basics

A-1: Discussing database terminology

A-2: Planning a database

Topic B: 0 Getting started

B-1: Opening a database

B-2: Creating and saving a database

B-3: Using a template to create a database

B-4: Examining views

B-5: Working with toolbars

B-6: Closing a database and Access

Topic C: 0 Database tables

C-1: Using the Table Wizard to create a table

C-2: Using Design view

C-3: Entering data in a table and closing a table

C-4: Examining table view modes

C-5: Deleting a table

Topic D: 0 Getting help

D-1: Using the Type a question for help box

D-2: Using the Office Assistant

Unit 16 : Working with tables

Topic A: 0 Working with fields

A-1: Inserting and deleting fields

A-2: Modifying and moving fields

A-3: Editing field properties

A-4: Setting the primary key

A-5: Creating single- and multiple-field indexes

Topic B: 0 Manipulating records

B-1: Adding a record to a table

B-2: Finding and replacing data

B-3: Deleting a record and a field from a table

Topic C: 0 Managing tables

C-1: Sorting records by single and multiple fields

C-2: Filtering records

C-3: Navigating in a table

C-4: Moving and resizing columns

Topic D: 0 Relating tables

D-1: Creating relationships

D-2: Deleting a relationship

Topic E: 0 Printing options

E-1: Using the Page Setup dialog box

E-2: Printing a table

Unit 17 : Forms and queries

Topic A: 0 Creating forms

A-1: Creating a form by using the Form Wizard

A-2: Creating a form in Design view and switching between views

Topic B: 0 Modifying forms

B-1: Entering data in a form

B-2: Modifying controls and form properties

B-3: Aligning controls

B-4: Using a form to modify and delete data

B-5: Saving, closing, and deleting a form

Topic C: 0 Finding, sorting, and filtering records

C-1: Using a form to find a record

C-2: Using a form to sort records

C-3: Applying and removing a filter

Topic D: 0 Using queries

D-1: Creating a single-table query

D-2: Modifying a query

D-3: Specifying criteria in a query

D-4: Creating a two-table query

D-5: Closing and deleting a query

Topic E: 0 Previewing and printing forms and queries

E-1: Previewing and printing a form

E-2: Printing a query

Unit 18 : Reports

Topic A: 0 Creating reports

A-1: Creating a report by using the Report Wizard

A-2: Creating a report by using a query

A-3: Saving and closing a report

A-4: Examining report views

Topic B: 0 Working with reports

B-1: Grouping and sorting records in a report

B-2: Summarizing information

B-3: Modifying the layout of a report

B-4: Working with headers and footers

B-5: Deleting a report

Topic C: 0 Printing reports

C-1: Using the Page Setup dialog box

C-2: Printing a report

Unit 19 : Presentations

Topic A: 0 Getting started

A-1: Opening and running a presentation

A-2: Switching between presentations

A-3: Examining the PowerPoint environment

A-4: Changing views

Topic B: 0 Getting help

B-1: Using the Type a question for help box

B-2: Using the Office Assistant

B-3: Using help on the Web

Topic C: 0 Saving and closing presentations

C-1: Saving a presentation

C-2: Closing a presentation and closing PowerPoint

Unit 20 : Creating and formatting presentations

Topic A: 0 Creating presentations

A-1: Creating a presentation

A-2: Changing slide layouts

A-3: Entering text on a slide

A-4: Adding, copying, and deleting slides

A-5: Using the AutoContent Wizard

Topic B: 0 Formatting text

B-1: Using the Formatting toolbar

B-2: Using the Font dialog box

B-3: Applying a bullet style to text

B-4: Applying a numbered list

B-5: Changing text case and page magnification

Topic C: 0 Working with text

C-1: Using the Cut and Paste commands

C-2: Copying text between slides

C-3: Using the Undo and Redo commands

Unit 21 : Using drawing tools

Topic A: 0 Drawing objects

A-1: Using the Drawing toolbar

A-2: Duplicating and moving objects

A-3: Formatting objects

A-4: Arranging and aligning objects

A-5: Deleting objects

Topic B: 0 Working with text in objects

B-1: Adding text to objects

B-2: Fitting text in an object

B-3: Modifying text in an object

Topic C: 0 Working with graphics

C-1: Inserting a graphic object

C-2: Moving and resizing a graphic object

C-3: Applying color effects

Unit 22 : Customizing presentations

Topic A: 0 Using templates

A-1: Creating a presentation based on a template

A-2: Applying a design template to an existing presentation

Topic B: 0 Working with slide masters

B-1: Examining the elements of a slide master

B-2: Modifying a slide master

B-3: Adding and deleting a picture on a slide master

B-4: Adding a footer to a slide master

B-5: Adding the date and time to the footer

Topic C: 0 Customizing slide shows

C-1: Setting transitions and timings

C-2: Animating text and objects

C-3: Reordering the animation effects for a slide

C-4: Setting up a slide show

C-5: Creating a custom slide show

C-6: Hiding and showing slides

Topic D: 0 Customizing the environment

D-1: Customizing a toolbar

D-2: Using the Options dialog box

Topic E: 0 Working with speaker notes

E-1: Adding speaker notes

E-2: Adding headers and footers to notes

Unit 23 : Charts

Topic A: 0 Creating and formatting charts

A-1: Creating a chart

A-2: Moving, copying, duplicating, and deleting a chart

A-3: Using a Microsoft Graph Chart object

A-4: Formatting a chart

Topic B: 0 Organization charts

B-1: Creating an organization chart

B-2: Adding and deleting levels in an organization chart

B-3: Modifying an organization chart

Unit 24 : Proofing and delivering presentations

Topic A: 0 Proofing presentations

A-1: Checking the spelling in a presentation

A-2: Using the Style checker tool

Topic B: 0 Printing presentations

B-1: Using the Page Setup dialog box

B-2: Printing a presentation

B-3: Printing handouts and Notes pages

Topic C: 0 Saving presentations for Web delivery

C-1: Saving and publishing a presentation

C-2: Adding a hyperlink to text in a presentation

C-3: Linking text on a slide to another application file

C-4: Sending a presentation through e-mail

Unit 25 : The Internet and Internet Explorer

Topic A: 0 Introducing the Internet

A-1: Discussing the Internet

A-2: Discussing IP and e-mail addresses

Topic B: 0 Introducing Internet Explorer

B-1: Starting Internet Explorer

B-2: Navigating in Internet Explorer

B-3: Changing the browser’s home page

Topic C: 0 Getting help

C-1: Using Internet Explorer’s Help

C-2: Using Web Help to access Support Online

Unit 26 : Exploring the Web

Topic A: 0 Working with Web pages

A-1: Opening a Web page in a new window

A-2: Stopping a download and refreshing a Web page

A-3: Saving and copying the content of a Web page

A-4: Downloading files from a Web site

Topic B: 0 Searching the Internet

B-1: Using the Search Companion pane

B-2: Searching for a person’s address

B-3: Using Auto Search

Topic C: 0 Performing advanced searches

C-1: Using the search operators

C-2: Using the Advanced Search options

Topic D: 0 Customizing Search features

D-1: Customizing the Auto Search feature

D-2: Customizing the Search Companion pane

Unit 27 : Working with Web pages

Topic A: 0 Working with Favorites

A-1: Using the Favorites list

A-2: Adding a new Favorite

A-3: Creating a folder in the Favorites list

A-4: Organizing Favorites

Topic B: 0 Using links and toolbars

B-1: Using the Links bar

B-2: Customizing the Links bar

Topic C: 0 Using the History list

C-1: Viewing the History list

C-2: Adding a History link to Favorites

C-3: Examining and deleting temporary Internet files

C-4: Changing History settings

C-5: Changing AutoComplete settings

Topic D: 0 Printing Web content

D-1: Using the Page Setup dialog box

D-2: Printing Web pages

Unit 28 : Internet transactions and security

Topic A: 0 Internet transactions

A-1: Discussing Web-based order forms

A-2: Discussing the use of credit cards on the Internet

Topic B: 0 Web security

B-1: Discussing cookies and caching

B-2: Discussing Web site protection

B-3: Discussing digital certificates

B-4: Discussing encryption

B-5: Discussing firewalls

Unit 29 : Outlook basics

Topic A: 0 Understanding e-mail basics

A-1: Discussing e-mail

A-2: Discussing e-mail security

Topic B: 0 Using Outlook

B-1: Exploring the Outlook window

B-2: Using and adding a shortcut to a folder

B-3: Using the Folder List pane

B-4: Changing the size of toolbar buttons

B-5: Customizing a toolbar

Topic C: 0 Using Outlook Help

C-1: Using the Type a question for help box

C-2: Using the Office Assistant

C-3: Using the Outlook Help task pane

Unit 30 : Working with e-mail messages

Topic A: 0 E-mail accounts

A-1: Discussing Microsoft Exchange Server

A-2: Configuring a Hotmail account

A-3: Configuring a POP3 client account

Topic B: 0 E-mail messages

B-1: Exploring the Inbox

B-2: Opening, reading, and closing a message

B-3: Creating and sending a message

B-4: Replying to and saving a message

B-5: Copying and formatting messages

B-6: Checking for spelling errors in a message

Topic C: 0 Working with attachments

C-1: Adding and removing an attachment

C-2: Saving an attachment

C-3: Forwarding a message

C-4: Setting a message’s priority

C-5: Flagging an e-mail message

Unit 31 : Managing e-mail

Topic A: 0 Using personal folders

A-1: Creating a personal folder

A-2: Copying and moving messages between folders

A-3: Deleting and restoring messages

Topic B: 0 Searching and sorting messages

B-1: Using the Find feature

B-2: Finding messages by using Advanced Find

B-3: Sorting messages

Topic C: 0 Printing messages

C-1: Customizing page setup

C-2: Printing a message

Topic D: 0 Using address books

D-1: Creating and using a distribution list

D-2: Updating an address book

D-3: Deleting an e-mail address from the address book

Appendix A : Exam objectives map

Topic A: 0 ICDL/ECDL exam objectives