ICDL/ECDL: Syllabus 4: Office 2003 Study Guide

0-619-24241-8 © 2006 Publish date: February 24, 2005 1012 pages

Buy Now: $59.99

Course ID: icdl-ecdl-s4-office-2003-sg

CBT Planet brings you the ICDL/ECDL Syllabus 4 Office 2003 study guide to help you learn the basics of Microsoft Office 2003, Professional Edition. This is an exceptional self-directed study format that covers the fundamental concepts of IT along with the use of Microsoft Word, Excel, PowerPoint, Access, and Outlook.

By following the ICDL/ECDL Syllabus 4 Office 2003 courseware, you will also learn about basic file management using Windows XP and how to browse the Internet by using Internet Explorer.

This training manual is comprehensive with thirty one full units of high-quality instruction. Each unit prepares you for the next section of learning. Challenging review questions and hands-on exercises at the conclusion of each unit keep you on track as you progress through the course.

When you choose one of our computer training books, you are choosing a terrific training program that's available for you whenever you want to study. The ICDL/ECDL Syllabus 4 Office 2003 courseware is certified by the ECDL foundation and it covers all of ECDL Syllabus 4 objectives for Office 2003. Because of this, this study guide teaches you everything you need for preparing for taking the ECDL theoretical test along with the six ECDL practical tests.

Course Objectives

At the conclusion of this course, you will understand what information technology is and be able to discuss computer's influences on society. In addition, you will learn about file management techniques, how to perform basic computer operations, how to explore the contents of a hard disk, and how to use basic text editors for creating and saving documents.

You will learn about printer management, how to monitor print jobs, how to scan files for viruses, and how to protect computers from viruses.

This coursewareWill teach you how to start and explore Microsoft Word, use the included templates, change basic view settings, and where to get help by using Help and the Office Assistant. In addition, you'll learn how to add text, insert special characters, how to use the Undo and Redo commands, and how to edit text, find and replace text, and format text.

You'll also learn about formatting paragraphs and documents, creating and managing tables, inserting clip art, charts, and images, adding AutoShapes, creating form letters and data sources, and using Mail Merge for creating labels.

Course Contents

Unit 1 introduces concepts of information technology

• An overview of information technology
• Hardware and storage devices
• Software
• Networks

Unit 2 covers computers and society

• Computers in daily use
• The impact of IT on society
• Security and legal issues

Unit 3 goes over using computers and managing files

• Basic computer operations
• Accessing the Help and Support Center
• The Windows desktop
• Working with windows
• Windows XP system settings

Unit 4 covers folder and file management

• File and folder structures
• Text editing
• How to manipulate files and folders
• How to manage files and folders
• How to delete and restore files

Unit 5 discusses printer and virus management

• Printer management
• Viruses

Unit 6 covers word processing

• Getting started with word processing
• Basic view settings
• Getting help

Unit 7 discusses adding and modifying text

• Working with text
• How to edit documents
• Finding and replacing text
• Formatting text

Unit 8 covers paragraphs and tables

• How to format paragraphs
• How to format documents
• How to create and manage tables

Unit 9 talks about graphics and mail merge

• Graphics
• Letters and mailings

Unit 10 covers proofing and printing documents

• Proofing your documents
• Printing your documents

Unit 11 discusses spreadsheets

• Getting started with spreadsheets
• Working in the Excel environment

Unit 12 covers spreadsheet structure

• How to enter and edit data
• How to find, replace, and sort data
• Manipulating your worksheets

Unit 13 discusses formulas and formats

• Formulas and functions
• Formatting

Unit 14 covers charts and printing

• Working with charts in Excel
• How to print and proof your worksheets

Unit 15 goes over databases

• Database basics
• Getting started
• Database tables
• Getting help

Unit 16 covers using tables

• Using fields
• Manipulating records
• Managing tables
• Relating tables
• Printing options

Unit 17 covers forms and queries

• How to create forms
• How to modify forms
• Finding, sorting, and filtering records
• Working with queries
• Previewing and printing forms and queries

Unit 18 covers reports

• Creating reports
• Working with reports
• Printing reports

Unit 19 covers presentations

• Getting started with presentations
• Getting help
• Saving and closing presentations

Unit 20 covers creating and formatting presentations

• Creating presentations
• Formatting text
• Using text

Unit 21 talks about working with drawing tools

• Drawing objects
• Using text in objects
• Using graphics

Unit 22 talks about customizing presentations

• Using templates
• Slide masters
• Customizing your slide shows
• Customizing the environment
• Using speaker notes

Unit 23 covers charts

• How to create and format charts
• Organization charts

Unit 24 talks about proofing and delivering presentations

• Proofing presentations
• Printing presentations
• Saving presentations for web delivery

Unit 25 discusses the Internet and Internet Explorer

• Introduction to the Internet
• Introduction to Internet Explorer
• Getting help

Unit 26 goes over exploring the Web

• Web pages
• How to search the Internet
• Advanced searches
• Customizing Search features

Unit 27 talks about using Web pages

• Favorites
• Links and toolbars
• Viewing the History list
• How to print Web content

Unit 28 covers Internet transactions and security

• Internet transactions
• Web security

Unit 29 goes over Outlook basics

• Understanding e-mail basics
• Working with Outlook
• Accessing Outlook Help

Unit 30 discusses using e-mail messages

• E-mail accounts
• E-mail messages
• Working with attachments

Unit 31 discusses e-mail management

• Using personal folders
• How to search and sort messages
• How to print messages
• Using address books

Appendix A contains the ICDL/ECDL exam objectives map