ECDL v4: Unit E Using IT

Designed For

Those who wish to gain understanding and knowledge of IT to the ECDL syllabus

Prerequisites

Knowledge of Windows and using a mouse.

Objectives

To enable students to take the BCS Unit E Using IT test

Know how to use Excel in order to sit the ECDL modular test

The flexibility and value of a self-study course designed to enable you to work at your own pace

A personalised workbook to use as a reference guide on completion of the course

Duration

20 hrs

Course Content

Chapter 1 Legal and Security Issues: Data Protection Act, Data Confidentiality, Data Integrity, Copyright, Computer Misuse and Abuse, Malicious Code, Data Backups,

Chapter 2 Health and Safety: General H&S Considerations, Ergonomics, Repetitive Strain Injury, Disposal, Safety, Energy Wastage, Recycling

Chapter 3 Good Practice: Original Data Source, Directory Structure, Viewing Files, Copying and Moving Files, File and Folder Access, Deleting Files, Searching

Chapter 4 Program Integration: Application Suites, Limitation of Storing Data, Sorting Data, Data Types, Logical Operators, Wildcards

Chapter 5 Data Integrity: Coding – Adding References, Spreadsheet Construction and Cell Referencing, Zero Values, Calculated Fields, Original Data and Data Entry, Modelling using Cell Edits, Chart Generation

Chapter 6 Information Presentation: Sorting, Formatting and Data Emphasis, Use of Headers and Footers, Use of Style Sheets and Templates