ECDL Courseware - ICDL Courseware

ECDL / ICDL Unit E (BCS UK Only)
Approved Courseware Training Resources

Unit Goals- Unit E

This module requires the candidate to demonstrate knowledge and understanding of a series of theoretical elements such as legal issues associated with computing, health and safety and good practice. Additionally the candidate will be required to demonstrate their understanding of integration between computer applications and the relevance of each to everyday tasks.

Legal Issues

Understand the rights of an individual to be informed of, and to access, data held about them by an organization (Data Protection Act)
Understand the legal issues when gathering data, and the need for consent to hold such data.
Understand need for confidentiality of information (employer and clients)
Know management responsibility for honesty and accuracy in recording, manipulating and presenting data
Understand the rules associated with Computer misuse / inappropriate use.
Understand problems regarding the creation, transmission, storage, downloading or display of any offensive, obscene, indecent, or menacing images, data or other material.
Understand the issue of copyrights over published electronic data belonging to individuals and organizations.
Know the concepts of the need to ensure data security, backup systems, data recovery.
Use a computer's system software to safely and securely create and manage files and folders.

Health and Safety

Know the correct procedures for working with IT equipment, including ergonomic arrangements, safety of individuals and equipment.
Understand the causes of Repetitive Strain Injury, and how the risk of RSI can be minimized.
Understand implications when disposing of computer equipment and consumables with respect to environmental issues. E.g. Print consumables- recycling or disposing of used equipment, safe disposal of hardware
Recognize some of the ways that energy efficiency can be improved- Energy Saving Software, use of screen savers, use of environmentally friendly monitors.
Understand the importance of print preview to minimize paper wastage and improve output.

Integration

Work with data files to select and import data across applications
Understand the capability to link information between packages - e.g. mail merge using spreadsheet or database file.
Distinguish between the storing and displaying of information in different office applications
Understand the mechanism used to combine information from one application into another - e.g. use a spreadsheet chart in a word processed document.
Understand how to resize linked data as appropriate
Know the major vehicles for cross-platform transfer of information (rtf, txt, dif, csv etc).
Understand how to open/ import data from generic files and appreciate limitations of these format
Understand the procedures when transferring data between files when using the clipboard.
Know the limitations when copying data to another document (need to update)

Good Practice

Understand the importance of maintaining integrity of imported data
Understand common generic methods for accessing files and folders
Understand how to create, name and rename folders and sub-folders
Understand the advantages of using the search and replace functions over manual methods to find and replace specific data
Understand the purpose of copy/move/delete files
Identify and access appropriate software for the task
Distinguish between documents/files and executable applications and appreciate the function of file extensions.
Understand how to access existing files (text, database, spreadsheet, image, chart) Understand the need for accurate data entry in documents
Understand the need for using appropriate date and time formats
Understand the use and purpose of using codes for data entry
Understand the importance of maintaining the original proportions of images and charts
Understand the concept of good spreadsheet design - refer to data entered in cells rather than re-entering, enter formulas from left to right, top to bottom where appropriate.
Understand the use and purpose of not replicating zero values over blank cells
Understand how amendments to data may affect dependent formulae and appreciate the uses of this in the efficient modeling and projection of data
Understand how to minimize the risk of attack by Viruses
Know the importance of Backups, and different methods to create and maintain records (Full/ incremental backups, rotation of files, grandfather/ father/ son)

Application Selection

Understand how to sort data maintaining the integrity of corresponding data. Know the limitations of packages in doing this.
Understand the limitations of spreadsheets when used as a database (sorting doesn't maintain record integrity, all data is held in memory, maximum 3 levels of sort)
Understand the use and purpose of various field types (text, number, date/ time, currency, auto number)
Understand the use of OR between two fields and within a field
Understand the use and purpose of using combined logical and range operators when defining search criteria (Boolean Logic)
Understand the use of wild cards when searching for data

Presenting Information

Understand the use and purpose of calculated fields
Understand the effects on data of different types of sorting (alphabetical, numeric, chronological)
Understand the purpose and effect of formatting numeric data (percentage, date, time, negative, currency, general)
Understand the use and purpose of headers and footers
Understand the use of fields in headers and footers
Understand the concept of standard documents and use of styles to create uniform documents.
Understand the use and importance of style sheets for consistent formatting of text (typeface, size, weight etc)
Distinguish between exploding pie charts, bar/ column charts, line-column graphs and XY scatter graphs and understand when to use them
Understand the importance of emphasizing particular data

Please visit the BCS web site for more information.

ECDL / ICDL Unit E (BCS UK Only) Approved Courseware Training Resources