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

Ballymena

Monday
-Tuesday
1pm -5pm 


Wed-Thur
10am - 12midday 

Wednesday also
7pm -  9pm

Friday
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 info@cflni.com




Registered  with the Charity Commission for Northern Ireland Charity NIC100428

CITB- approved courses

An opportunity to upskill with support from CITB.


The following courses both accredited and non accredited are listed on the CITB-Construction Skills Training Directory.  If you are registered with CITB then you may be able to access these programmes FREE!  Contact CITB for confirmation of your eligibility at -

www.citbcsni.org.uk


This includes

Intermediate            Word Processing


What will you learn:-


  • Find, Replace and Select text
  • using Tabs and Special Indents
  • Tables
  • Formatting Tables
  • Convert Text to Table
  • Sorting Tables and Text
  • Page Setup and Page Background
  • Themes
  • Headers and Footers
  • Columns and Hyphenation
  • Text Objects
  • Illustrations
  • Mail Merge
  • Envelopes and Labels




   


Access             Advanced                                                                                                                                          


On completion of this module the candidate will be able to:

  •     Understand key concepts of database development and usage
  •     Create a relational database using advanced table creation features and complex relationships between tables
  •     Design and use queries to create a table, update, delete and append data. Refine queries using wildcards, parameters and
    calculations
  •     Use controls and subforms to enhance forms and improve functionality
  •     Create report controls to perform calculations. Create subreports and enhance report presentation
  •     Enhance productivity by working with macros and use linking and importing features to integrate data

What are the benefits of this module?

  •     Allows users to become more confident, efficient and effective in using a database application
  •     Proves mastery of the application
  •     Enables users to retrieve and produce higher quality management information
  •     Improves user’s productivity
  •     Developed with input from computer users, subject matter experts and practising computer professionals from all over the world. This process ensures the relevance and range of module content

- ©     See more at: http://www.ecdl.org/programmes

On completion of this module the candidate will be able to:

    Understand key concepts of database development and usage
    Create a relational database using advanced table creation features and complex relationships between tables
    Design and use queries to create a table, update, delete and append data. Refine queries using wildcards, parameters and calculations
    Use controls and subforms to enhance forms and improve functionality
    Create report controls to perform calculations. Create subreports and enhance report presentation
    Enhance productivity by working with macros and use linking and importing features to integrate data

What are the benefits of this module?

    Allows users to become more confident, efficient and effective in using a database application
    Proves mastery of the application
    Enables users to retrieve and produce higher quality management information
    Improves user’s productivity
    Developed with input from computer users, subject matter experts and practising computer professionals from all over the world. This process ensures the relevance and range of module content

- See more at: http://www.ecdl.org/programmes/index.jsp?p=2929&n=2952#sthash.ZUvtp80W.dpufBOn completion of this module the candidate will be able to:

  • Understand key concepts of database development and usage
  • Create a relational database using advanced table creation features and complex relationships between tables
  • Design and use queries to create a table, update, delete and append data. Refine queries using wildcards, parameters and calculations
  • Use controls and subforms to enhance forms and improve functionality
  • Create report controls to perform calculations. Create subreports and enhance report presentation
  • Enhance productivity by working with macros and use linking and importing features to integrate data

What are the benefits of this module?

  • Allows users to become more confident, efficient and effective in using a database application
  • Proves mastery of the application
  • Enables users to retrieve and produce higher quality management information
  • Improves user’s productivity
  • Developed with input from computer users, subject matter experts and practising computer professionals from all over the world. This process ensures the relevance and range of module content
- See more at: http://www.ecdl.org/programmes/index.jsp?p=2929&n=2952#sthash.ZUvtp80W.dpuf


POWERPOINT IMAGE





PowerPoint Advanced


On completion of this module the candidate will be able to_


  •     Understand target audience and venue considerations in presentation planning
  •     Create and modify templates and format slide backgrounds
  •     Enhance a presentation using built-in drawing and image tools
  •     Apply advanced chart formatting features and create and edit diagrams
  •     Insert movies and sound and apply built-in animation features
  •     Use linking, embedding, importing and exporting features to integrate data
  •     Work with custom slide shows, apply slide show settings, and control a slide show

    What are the benefits of this module?

    •     Allows users to become more confident, efficient and effective in using a presentation application
    •     Proves mastery of the application
    •     Enables users to plan and design more effective presentations
    •     Improves user’s productivity
    •     Developed with input from computer users, subject matter experts, and practising computer professionals from all over the world. This    process ensures the relevance and range of module

    - See more at: http://www.ecdl.org/programmes/



    EXCEL  Advanced                  &


    On completion of this module the candidate will be able to:

    •     Apply advanced formatting options such as conditional formatting and customised number formatting and handle worksheets
    •     Use functions such as those associated with logical, statistical, financial and mathematical operations
    •     Create charts and apply advanced chart formatting features
    •     Work with tables and lists to analyse, filter and sort data. Create and use scenarios
    •     Validate and audit spreadsheet data
    •     Enhance productivity by working with named cell ranges, macros and templates
    •     Use linking, embedding and importing features to integrate data
    •     Collaborate on and review spreadsheets. Apply spreadsheet security features

    What are the benefits of this module?

    •    Allows users to become more confident, efficient and effective in using a spreadsheet application
    •     Proves mastery of the application
    •     Enables users to produce better reports with deeper data analysis
    •     Improves user’s productivity
    •     Developed with input from computer users, subject matter experts and practising computer professionals from all over the world.   This   process ensures the relevance and range of module content


    © See more at: http://www.ecdl.org/programmes/






    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



      WORD Advanced 


      Examines the advanced features of word processing applications enabling learners to enhance their work, improve productivity and save time

      On completion of this module the candidate will be able to:

          Apply advanced text, paragraph, column and table formatting. Convert text to a table and vice versa

          Work with referencing features like footnotes, endnotes and captions. Create tables of contents, indexes and cross-references

          Enhance productivity by using fields, forms and templates

          Apply advanced mail merge techniques and work with automation features like macros

          Use linking and embedding features to integrate data

          Collaborate on and review documents. Work with master documents and subdocuments. Apply document security features

          Work with watermarks, sections, and headers and footers in a document

      What are the benefits of this module?

          Allows users to become more confident, efficient and effective in using a word processing application

          Proves mastery of the application

          Enables users to produce and manage large, complex word processing outputs

          Improves user’s productivity and saves time

          Developed with input from computer users, subject matter experts and practising computer professionals from all over the world. This process ensures the relevance and range of module content


      -© See more at: http://www.ecdl.org/programmes/



      Introduction to Word Processing


      What will you learn:-

      • Getting Started with Microsoft Word
      • Document Windows and Views
      • Basic Word Processing Features
      • Using the Help System
      • Saving, Opening and Closing Documents
      • Creating New Documents
      • Navigating Documents
      • Selecting Text
      • Basic Text Formatting
      • Basic Paragraph Formatting
      • Undo, Redo and Repeat
      • Move and Copy Text
      • Proofing Documents
      • Print Preview and Page Setup
      • Printing Documents






      You will learn how to:- 


      • recognise the elements of a spreadsheet, cells, sheet names, columns, rows, formula/bar,
      • Open up Excel-  start a new spreadsheet/worksheet
      • format, add and delete data,
      • save sheet
      • use formula and simple functions
      • use page set-up functions

      • change  margins/orientation
      • create and amend charts/graphs,
      • print spreadsheet/chart


      For more information please call us on 028 2582 1184 or email us at info@cflni.com.

      European Computer Driving LicenceOCR - Recognising AchievementMicrosoft Office Specialist