European Computer Driving Licence 4.0

Concepts of Information Technology (IT)

This course provides an overview of computer hardware and software, networking, and the use of computers in a number of everyday applications

• Identify various kinds of computers, from mainframes to microcomputers
• Distinguish between computer hardware and software
• Identify the main parts of a personal computer
• Identify the steps in developing a computer-based system
• List several ways that networking extends the capabilities of a personal computer
• List several precautions to follow to prevent damage to a computer
• List several ways to protect data from being corrupted, stolen, or destroyed
• Distinguish differences among copyrighted software, shareware, and freeware

• 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

Using the Computer and Managing Files

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

• Start, shut down, and restart a personal computer
• Display information about the operating system and the desktop
• Format a diskette
• Use application help
• Move and use icons to start programs
• Identify the parts of an application window
• Manage folders and files Edit and print data

• 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

Word Processing

This course 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 course 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 test can be taken with any word processing application, and although this course demonstrates a specific application, the tasks it teaches can be applied to other applications as well.

• Start and exit a word processing application
• Create, save, and close a document
• Open, revise, and save a document to another file type
• Use application help
• Change display settings
• Use templates
• Format characters and paragraphs
• Search and replace text
• Apply styles
• Prepare a document for printing
• Check spelling in a document
• Preview and print a document
• Create, manipulate, and format a table
• Add and manipulate graphics and objects
• Use a mailing list

• 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
  

Spreadsheets

This course 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 course 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 test can be taken with any spreadsheet application, and although this course demonstrates a specific application, the tasks it teaches can be applied to other applications as well.

• Create and save a spreadsheet
• Open, revise, and close a spreadsheet
• Use application help
• Change display settings
• Insert, select, copy, move, and delete data
• Undo and redo actions
• Search and replace data
• Sort data
• Create and copy a formula
• Use functions such as SUM, AVERAGE, and IF
• Format data
• Preview and prepare a spreadsheet for printing
• Import an object and text file into a spreadsheet
• Create, adjust, move, and delete a chart

• 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
  

Database

This course 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 course 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 test can be taken with any database application, and although this course demonstrates a specific application, the tasks it teaches can be applied to other applications as well.

• Open and close a database
• Revise and save records
• Use application help
• Create a database
• Update a database
• Create, use, and revise a data entry form
• Create and refine a query
• Select and sort data
• Create and edit a report

• Database concepts
• Opening and closing a database application
• Adjusting settings
• Defining table fields
• Finalising 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

Presentations

This course 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 course 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 test can be taken with any presentation application, and although this course demonstrates a specific application, the tasks it teaches can be applied to other applications as well.

• Create and save a presentation document
• Open, revise, and close a presentation document
• Change display settings
• Export a presentation document to an application or Web site
• Create a presentation
• Add text and an image to a slide
• Use a master slide
• Copy, move, and delete text, images, and slides
• Format a presentation document
• Draw and change objects in a presentation
• Create and change graphics and charts
• Preview and print a presentation document
• Add special effects and deliver the slide show

• 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 organisational charts
• Drawing objects
• Editing drawn objects
• Copying, moving, and deleting objects
• Adding slide show effects
• Preparing presentations
• Printing and delivering a presentation

Information and Communication

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

• Open and close a Web browsing application
• Display a Web page
• Search the Web for information and navigate among pages
• Open and close an electronic mail application
• Create and send a message
• Use an address book
• Use a distribution list
• Receive and save a message
• Reply to or forward a message

• Getting Started Browsing the Web
• Searching the Web
• Getting Started Using Electronic Mail
• Creating Messages
• Using Message Features
• Receiving Messages