Latest News

Community Focus Learning are now operating from 26 Market Road Ballymena, BT43 6EL

Tel number remains- 028 2582 1184

more news
Connect with us
028 2582 1184 Email usFollow us on Facebook

Office hours


1pm -5pm 

10am - 12midday 

Wednesday also
7pm -  9pm

9am - to 5pm lunch 1pm-2pm

Your calls are important to us, however we are not always available to take your calls, please do leave a message and we will get back to you on our return, (24 hour messaging service) or you can send through an email to

Registered  with the Charity Commission for Northern Ireland Charity NIC100428

ITQ Cert L2

These units are the same as ECDL Extra

This includes

What you need to know for ECDL L2  in Word Processing:-

  •    Screen layout
  •     Menus, toolbars and the task pane
  •     Help
  •     Access the Word application, open new documents
  •     Editing and formatting text
  •     Change style
  •     Use format painter
  •     Insert/delete/copy images
  •     Alignment, indentation and spacing
  •     Mailmerge documents
  •     Save, open and close documents
  •     Save in different formats-RTF/Text
  •     Insert symbols
  •     Add/amend  tables- insert/delete rows/columns
  •     Set and clear tab stops
  •     Add headers/footers
  •     Cut, copy and paste
  •     Search and replace text
  •     Document setup
  •     Insert headers, footers and page numbers

What you need to know for ECDL tests in Spreadsheets L2

Screen Layout

  • Open up Excel-  start a new spreadshseet/worksheet
  • Format data
  • Edit cells
  • Basic Formulas
  • Add and amend functions- including sum, average, max, min, count, counta and round
  • Use absolute cell references
  • Use  if statements
  • Saving, opening and closing workbooks
  • Saving in various formats
  • manipulating sheets
  • Using multiple workbooks and sheets
  • Inserting/deleting rows and columns
  • page setup
  • sorting data
  • Create and amend charts/graphs, e.g. add data labels, add/change chart name
  • Copy worksheets, rename, delete
  • print spreadsheet

    ECDL logo

    You will learn how to:-

    •    Open up Power point application

    •   save,open and close files

    •   set up a presentation

     •    add, copy, amend and move  slides
    •    Use formatting functions

    •    Use header and footer

    •    Amend table, delete/add  columns/rows

    •    use the slide master

    •    add animation

    •    set up a slide show

    This unit tests your ability to use IT tools and systems to improve the productivity and efficiency of work activities in a variety of contexts.


    At Level 2  you are expected to be able to demonstrate knowledge and carry out instructions and  be able to plan and review your use of predefined or commonly used IT tools for tasks and activities. For example:-

    • Consider the requirements of the task for e.g. the time needed to complete the task, what it is for? have you everything you need to carry out the task?


    • Do you need clarification?  have you to do further research? who is your audience?


    • How accessible is the source?  do you need passwords? permissions? etc, 

    The techniques required will involve a number of steps and at times may be unfamiliar or non-routine. As a result of reviewing your work, you will be able to identify and use automated methods or alternative ways of working to improve productivity.

    In the assignment for the test you will be given a case study, you will be the administrator in post as it were and will have to carry out a list of instructions:-

    •  Explain why IT is used
    • Choosing appropriate software for specific tasks
    • Understanding guidelines and any limitations
    • Using shortcuts
    • Changing and adapting use of IT tools and systems
    • Developing and testing results to meet varying requiremnents


    For more information please call us on 028 2582 1184 or email us at

    European Computer Driving LicenceOCR - Recognising AchievementMicrosoft Office Specialist