Provides an overview of computer hardware and software, networking, and the use of computers in a number of everyday applications.

  TOPICS COVERED

Information technology
Understanding computer types
Main parts of a personal computer
Computer performance
Input and output
Computer storage devices
Software
Types of software
Systems development
Networks
The electronic world
Health, safety, and environment
Security
Copyright and the law

Shows users how to start, shut down, and restart the computer; display system and desktop information and online help; work with icons and windows; organize files and folders; and edit and print data. This section describes how to meet European Computer Driving Licence (ECDL) objectives on a personal computer that uses a Windows operating system. The ECDL/ICDL test can be taken with any system/application, and although this section demonstrates a specific system/application, the tasks it teaches can be applied to other systems/applications as well.

  TOPICS COVERED

Starting and shutting down the PC
Displaying system information
Changing the PC's desktop configuration
PC setup operations
Introduction to icons
Working with desktop icons
Working with windows
Using help
Text editing
File management
Working with folders and files
Deleting and restoring folders and files
Searching for folders and files
Compressing files
Viruses
Printer setup

Shows users how to use a word processing application to create documents and manipulate and format text. It also shows how to prepare a document for printing, preview and print a document, create tables, import objects, and merge a mailing list with a document. This section describes how to meet European Computer Driving Licence (ECDL) objectives using Microsoft Word on a personal computer that uses a Windows operating system. The ECDL/ICDL test can be taken with any word processing application, and although this section demonstrates a specific application, the tasks it teaches can be applied to other applications as well.

  TOPICS COVERED

Opening and closing a word processing application and documents
Saving documents
Adjusting settings
Inserting data
Selecting and editing data
Copying, moving, and deleting text
Search and replace
Formatting text
Working with text formats
Working with paragraphs
Working with lists and borders
Document formatting
Headers and footers
Creating tables
Working with tables
Inserting pictures, images, and charts
Working with pictures, images, and charts
Mail merge
Preparing documents for output
Printing documents

Shows users how to work with a spreadsheet application to insert and manipulate data. It also shows how to create formulas and functions, format and print a spreadsheet, import objects, and create and adjust charts. This section describes how to meet European Computer Driving Licence (ECDL) objectives using Microsoft Excel on a personal computer that uses a Windows operating system. The ECDL/ICDL test can be taken with any spreadsheet application, and although this section demonstrates a specific application, the tasks it teaches can be applied to other applications as well.

  TOPICS COVERED

Opening and closing spreadsheets
Creating and saving spreadsheets
Using help
Adjusting settings
Cells
Rows and columns
Editing data
Copying data
Moving and deleting data
Search and replace
Sorting data
Handling worksheets
Working with formulas
Cell referencing
Working with functions
The IF function
Formatting numbers and dates
Formatting cell contents
Working with alignments and border effects
Creating charts and graphs
Editing charts and graphs
Worksheet setup
Printing worksheets

Shows users how to work with a database application to create a database; create, use, and change a data entry form; retrieve information; and create reports. This section describes how to meet European Computer Driving Licence (ECDL) objectives using Microsoft Access on a personal computer that uses a Windows operating system. The ECDL/ICDL test can be taken with any database application, and although this section demonstrates a specific application, the tasks it teaches can be applied to other applications as well.

  TOPICS COVERED

Database concepts
Opening and closing a database application
Adjusting settings
Defining table fields
Finalizing tables
Creating table relationships
Adding and revising records
Working with forms
Searching records
Filtering and sorting records
Queries
Advanced query functions
Creating reports
Working with reports
Printing information

Shows users how to work with a presentation application to insert, manipulate, and format text, images, and slides. It also shows how to draw objects and produce charts for a presentation; how to print and distribute a presentation; and how to add special effects to a slide presentation. This section describes how to meet European Computer Driving Licence (ECDL) objectives using Microsoft PowerPoint on a personal computer that uses a Windows operating system. The ECDL/ICDL test can be taken with any presentation application, and although this section demonstrates a specific application, the tasks it teaches can be applied to other applications as well.

  TOPICS COVERED

Opening and closing an application and presentations
Using help
Adjusting settings
Presentation views
Slides and design templates
The master slide
Adding and editing text
Formatting the slide layout
Inserting images
Creating charts and graphs
Creating organizational charts
Drawing objects
Editing drawn objects
Copying, moving, and deleting objects
Adding slide show effects
Preparing presentations
Printing and delivering a presentation

Shows users how to open a Web browsing application, search for information on the Web, and use electronic mail to send and receive messages. This section describes how to meet European Computer Driving Licence (ECDL) objectives using Microsoft Internet Explorer and Microsoft Outlook on a personal computer that uses a Windows operating system. The ECDL/ICDL test can be taken with any browser application and electronic mail application, and although this section demonstrates specific applications, the tasks it teaches can be applied to other applications as well.

  TOPICS COVERED

Internet concepts
Security considerations
Using a Web browser
Adjusting settings
Accessing Web pages
Using bookmarks
Using a search engine
Printing Web pages
E-mail concepts and security considerations
Opening and closing an e-mail application
Using help
Adjusting settings
Reading mail messages
Replying to mail messages
Sending mail messages
Advanced messaging options
Copying, moving, and deleting messages
Mail management techniques
Using address books
Organizing messages
Printing messages

only £79.00
(approx $137 USD)