ECDL resources added in 2017

  • Overview of the unit
    This level 1 unit is called IT Security for Users and requires you to identify day-to-day security risks and laws/guidelines that affect the use of IT.
    At this level you are required to demonstrate the skills and knowledge needed to protect hardware, software and data within an IT system against theft, malfunction and unauthorised access. Any aspect that is unfamiliar to you may require support and advice from others.
    This guide is designed to be used with Microsoft Windows and Microsoft Office and contains exercises covering the following topics:
     Identifying Viruses
     Virus Checking
     Avoiding Malware
     Backing Up
     Protecting IT Systems
     Secure Networks
     Keeping Information Secure
     Laws and Guidelines
    Aims and objectives
    The purpose of this guide is to provide the knowledge and techniques necessary to meet the learning outcomes and assessment criteria for this optional unit.
    After completing this guide you will be able to:
     Recognise threats to IT systems and their performance
     Keep information safe and secure
     Use appropriate security precautions to minimise risk
     Appreciate the laws, guidelines and procedures for using IT
     Understand the importance of backing-up your data
  • Aims:
    The aim of this guide is to provide you with the practical skills required to use
    modern ICT devices safely and securely. You will learn how to use Windows 7 to
    work effectively and create, store and manage files.

    Objectives:
    After completing this guide you will be able to:
    · Understand key ICT concepts
    · Use the main features of the Windows 7 operating system
    · Adjust computer settings
    · Understand the main concepts of file management and be able to efficiently
    organise files and folders so that they are easy to identify and find
    · Create, edit, store and print a simple text document
    · Use utility software to compress and extract large files, and use antivirus
    software to protect against computer viruses and other malware
    · Appreciate the importance of data security and backing up
    · Be aware of important environmental, legal, and health and safety issues that
    apply to ICT users.
  • AIMS:
    To demonstrate the ability to use a word processing application on a personal computer to produce everyday letters and documents. To understand and accomplish basic operations associated with creating, formatting and finishing a word processed document ready for its distribution. To demonstrate some of the more advanced features covering creating standard tables, using pictures and images within a document, importing objects and using mail merge tools.

    OBJECTIVES:
    After completing the guide the user will be able to:
    • Work with documents and save them in different file formats
    • Choose built in options to enhance productivity
    • Create and edit small word processing documents that will be ready to share and distribute
    • Apply different formats to documents to enhance them before distribution; recognise good practice in choosing the appropriate formatting options
    • Insert tables, images and drawn objects into documents
    • Prepare documents for mail merge operations
    • Adjust document page settings and check and correct spelling before finally printing documents.
  • AIMS: To provide the student with an understanding of fundamental spreadsheet concepts, practical experience in spreadsheet design and implementation of the basic functions involved within spreadsheets.

    OBJECTIVES: After completing the guide the user will be able to: · Work with spreadsheets and save them in different file formats · Choose built in options, such as the Help function, within the application to enhance productivity · Enter data into cells and use good practice in creating lists; select, sort, copy, move and delete data · Edit rows and columns in a worksheet; copy, move, delete and appropriately rename worksheets · Create mathematical and logical formulas using standard spreadsheet functions; use good practice in formula creation and be able to recognise error values in formulas · Format numbers and text content in a spreadsheet · Choose, create and format charts to communicate information meaningfully · Adjust spreadsheet page settings and check and correct spreadsheet content before finally printing spreadsheets.
  • Aims
    To provide the student with an understanding of fundamental database concepts, practical experience in database design and implementation of the basic functions involved within databases. To familiarise the user with the main operating features of Microsoft Access.

    Objectives
    After completing the guide the user will be able to:
    • Understand what a database is and how it is organised and operated
    • Create a simple database and view the database content in various modes
    • Create a table, define and modify fields and their properties; enter and edit data in a table
    • Sort and filter a table or form; create, modify and run queries to retrieve specific information from a database
    • Understand what a form is and create a form to enter, modify and delete records and data in records
    • Create routine reports and prepare outputs ready for distribution.
  • Aims
    To demonstrate the ability to use a presentation application on a personal computer. To understand and accomplish basic operations associated with PowerPoint.

    Objectives
    After completing the guide the user will be able to:
    • Work with presentations and save them in different file formats
    • Choose built in options such as the Help function within the application to enhance productivity
    • Understand different presentation views and when to use them, choose different slide layouts and designs and edit slides
    • Enter, edit and format text in presentations. Recognise good practice in applying unique titles to slides
    • Choose, create and format charts to communicate information meaningfully
    • Insert and edit pictures, images and drawn objects
    • Apply animation and transition effects to presentations and check and correct presentation content before finally printing and giving presentations.
  • Aims
    The aim of this guide is to familiarise you with the main features of Microsoft Outlook and provide an understanding of fundamental e-mail concepts. This includes practical experience in sending and receiving e-mail and working with a calendar.

    Objectives
    After completing this guide you will be able to:
    • Understand and use Outlook
    • Effectively compose, send and receive e-mail
    • Forward and reply to e-mails
    • Manage e-mail settings
    • Attach files to an e-mail
    • Organise and search for e-mail
    • Change e-mail priority and flag important messages
    • Use an address book of contacts
    • Create and manage calendar appointments