|
European Computer
Driving Licence
ECDL is a Europe-wide qualification. It enables people to
demonstrate their competence in computer skills covering all
aspects of the computer. This qualification opens up
opportunities and confirms to potential employers that the
person has practical and up to date computer skills.
The course consists of 7 modules:
Module 1: Basic Concepts of IT
This module covers the theory of computer across the
following areas: basic concepts of IT; applications and
computers; IT and the society; security, copyright and law;
hardware, software, ergonomics; information networks.
Module 2: Using the Computer
This involves an understanding of the basic housekeeping
functions required for the efficient use of the computer.
- Switch on and shut down properly
- Understand the folder structure
- Create folders and sub-folders
- Create and save files in specified folders
- Identify file location, size, date
- Rename, copy, move and delete files
- Format and save to floppy disk, use printer.
Module 3: Word
Processing
- Access and load word processing software
- Create a new document or edit existing one
- Create/import a table, import graphics, import text
- Use common functions such as copy, paste, headers,
footers, italics, bold, fonts, line-spacing, justification
- Use a spell check and help functions
- Indentation, use and set tabs, hyphenation
- Use mail merge
- Use templates
- Use integrated software
- Format documents to an appropriate style.
Module 4: Spreadsheets
- Create new spreadsheet or edit existing one
- Enter numbers, text, formulae, insert rows and columns,
sort data, use functions eg totals, averages
- Add headers and footers
- Use relative and absolute cell references
- Produce and print charts and graphs
- Move information between spreadsheets
- Use integrated software.
Module 5: Databases
- Design a database, create a record structure
- Enter and edit data. Add and delete records
- Edit existing database
- Search for, select and sort data
- Present data in various sequences
- Modify database structure.
Module 6:
Presentation and Drawing
Module 7: Information Networks
- Send and receive e-mails
- Connect to the Internet to retrieve specific
information.
Back to
top
Advanced ECDL
Word Processing and Spreadsheets only
There are currently only two modules available in Advanced
ECDL - Word Processing and Spreadsheets. Each module is a
certified qualification on its own.
The syllabus for Advanced ECDL is over and
above the skills and underpinning knowledge contained within
ECDL core level. The advanced level anticipates that the
candidate has already mastered the necessary skills required
for ECDL core.
Module AM3 Word Processing (Advanced
Module 3)
This level requires the candidate to use the word procesing
application to produce what are deemed to be advanced word
processing documents and will be able to
- Illustrate sophisticated typographical, formattting and
layout presentation
- Create/edit advanced tables, forms and graphics
- Use tools such as macros
- Carry out advanced mail merge operations.
Module AM4 Spreadsheets (Advanced Module
4)
The candidate shall be able
to produce advanced level spreadsheets and will be able to
- Edit and enhance numeric, text and graphical data
- Sort, query and link data
- Carry out advanced formatting
- Use presentation operations on charts and graphs
- Use functions such as those associated with logical,
statistical or mathematical operations
- Use available analysis and audit tools and run and
record simple macros.
Back to
top
Level 1 Certificate in I.T. (New CLAIT)
To achieve the full New CLAIT candidates must achieve
the one mandatory unit and four optional units. There are
ten optional units to choose from, covering areas from the web
to desktop publishing, meaning there is something to suit
everybody.
Mandatory Unit:
Optional Units:
- Word Processing
- Electronic Communication
- Spreadsheets
- Databases
- Desktop Publishing
- Computer Art
- Graphs and Charts
- Web Pages
- Presentation Graphics
- BBC Becoming Webwise.
Back to
top
Level 2 Certificate in I.T.
(CLAIT Plus)
In order to achieve the full CLAIT Plus (level 2)
qualification, candidates must achieve one mandatory unit and
three optional units. There are 20 optional units to select
from.
Mandatory Unit:
- Create, Manage and
Integrate Files
 Optional
Units:
- Spreadsheets
- Databases
- Desktop Publishing
- Presentation Graphics
- Computer Art
- Web Pages
- Spreadsheets
- Graphs and Charts
- Spreadsheets Solutions
- Database Solutions
1 mandatory
unit + 3 optional
units = Full
Qualification
Level 3 Certificate in I.T.
(Advanced CLAIT)
In order to achieve the full Advanced CLAIT (level 3)
qualification, candidates must achieve three mandatory units
and one optional unit. There are 8 optional units on offer
including some Microsoft Office Specialist units.
Mandatory Units:
- Understanding I.T.
- Creating I.T. Solutions for Other Users
- Managing I.T. Resources
Optional Units:
- Advanced Document Production
- Advanced Databases
- Advanced Spreadsheets
- Presentation Graphics
- Advanced Web Pages
- Advanced Computer Art
- Advanced Presentation Graphics
- Word Processing (Microsoft Office Specialist Word
Expert)
- Spreadsheets (Microsoft Office Specialist Excel Expert)
3 mandatory
units + 1 optional
unit = Full Qualification
Back to
top
Word/Text
Processing
Stages 1, 2 and 3
There are 3 stages to this qualification and 2 parts to
each stage.
Stage 1
Part one aims to assess the candidates’ ability to produce
various simple documents which includes a letter, memo and a
short report or article. The overall aim is to meet the
business document production requirements of an employer.
This Award tests knowledge and skill at a level suitable
for further development and training. Part two involves
recalling text and making amendments. The type of documents
to be produced are a notice for display, an article and a
three column table.
Stage 2
This level is intended for those with sufficient skills,
knowledge and command of English to carry out the production
of business documents without supervision. Part two involves
producing documents from recalled text, handwritten and
typewritten drafts and making a number of amendments to text.
Candidates are required to produce a notice for display, an
article, lists of alphabetical/numerical/chronological
information, a table and a standard document which includes
phrases from a phrase file.
Stage 3
Part 1 involves applying advanced processing and production
skills to produce business documents. The documents to be
produced include a letter, memo and a report or article. This
level tests the candidates’ ability to identify grammatical
and spelling errors.
Part 2 tests candidates’ ability to produce a variety of
complex and specialist business documents. Candidates will be
required to produce a multi-page report, a landscape document
with ruling, a two column article and a letter or memo.
M.O.U.S Microsoft
Office User Specialist
The Microsoft Office User Specialist (MOUS) program is the
only comprehensive certification program designed to validate
desktop computer skills using Microsoft Office applications,
MOUS proves literacy, measures proficiency, improves
productivity and identifies opportunities for skills
enhancement.
The exams are not a written test,
instead, they feature real-world assignments that are based on
the way you actually use your computer. Using an actual
document, for example, you’ll be asked to perform a series of
tasks that clearly demonstrate your desktop computing skills.
The Microsoft Office Specialist program
offers two levels of certification: Core and Expert.
Individuals can also pass additional exams to achieve
Microsoft Office Specialist Master Certification.
The level you choose depends on your skills and experience.
Core Certification: Candidates must successfully complete
any of the core examinations
- Word 2000 Core
- Excel 2000 Core
- Powerpoint 2000 Core
- Access 2000 Core
- Outlook 2000 Core
Expert Certification: Candidates
must successfully complete any one of the Expert examinations.
- Word 2000 Expert
- Excel 2000 Expert
Master Certification: Candidates
must successfully complete all five of the required
examinations.
- Word 2000 Expert
- Excel 2000 Expert
- Powerpoint 2000 Core
- Access 2000 Core
- Outlook 2000 Core
Internet
Technologies
Internet Technologies is a qualification
designed to assess the candidate’s ability to use the Internet
for communication, information gathering and publishing
within a vocational context. Candidates are assessed by means
of three examinations. Each examination covers one element of
certification and can be taken at any time. To achieve the
complete Internet Technologies qualification, candidates must
achieve all three elements.
The three elements that make up this
qualifications are:
Use Electronic Mail for
Business Communication
-
Transmit messages electronically:
reply, forward, multiple send, copy, attach file, use
address books, save and print.
-
Receive messages electronically:
access and store message and attachment, store address,
delete message.
-
Use software accurately: select
appropriate software, enter date, access mail server, print
messages and attachment.
Use the Internet for
On-Line Research
-
Navigate the World Wide Web to access
remote data: use hyperlinks, access specific pages, store
and retrieve addresses.
-
Use on-line search techniques to
retrieve remote data: use local and general search engines,
retrieve specified data, retrieve specified page.
-
Select appropriate software, print web
pages.
Publish information on
a Web Site
-
Compose and edit a web page: create web
page, insert image, use emphasis, align page items, change
background colour.
-
Create a web structure: link pages, add
new page, add external link, add e-mail link, test links,
store web pages.
-
Select appropriate software, enter
data, print source code, print web pages.
Back to
top
Web Page Design
This is not a certified qualification as
yet, though can be used towards the OCR Internet Technologies
qualification.
This course is designed to enable you to
create an interactive web site using FrontPage 2000. This is
a highly visual, intuitive software package allowing use of
WSIWYG (what you see is what you get) facilities. You will
also be able to use the in-built text editor to view and edit
HTML (Hypertext Markup Language) coding.
The course will detail fully how to:
-
Utilise existing templates to create
corporate web structures
-
Create new web pages (which
incorporates)
-
Planning a new web site
-
Creating a web folder/navigation
structures
-
Adding banners to a web site
-
Including graphics and photographs
-
Creating hyperlinks to remote locations
-
Creating forms (including search forms)
-
Using tables
-
Adding HTML and FLASH components
The course will also look at how to use
the Internet to research and purchase a Web Domain name.
Following this we will cover how to host and publish a web
site using free and paying host Internet Service Provider
companies. Also covered is how to become listed by search
sites and other advertising methods.
Back to
top
Certificates in Accounting
Levels 1 and 2
Level 1: :This new qualification has been
designed to provide candidates with a flexible and modern
introduction to key topics in book-keeping. Candidates will
be able to avail of the opportunity to take manual units
alongside computerised units and to combine these into one
qualification and receive an understanding of the fundamental
principles that underlie book-keeping practices. This
involves:
Mandatory Unit:
Unit 1 - Posting to Accounts
Non-Mandatory Units:
-
Unit 2 - Maintaining Petty Cash
-
Unit 3 - Maintaining the Cash Book
-
Unit 4 - Maintaining Ledgers
(Computerised)
-
Unit 5 - Processing Sales and Purchases
Documents (computerised)
To achieve the OCR Level 1 qualification
candidates must achieve the mandatory unit plus two
non-mandatory units.
Level 2: This level is suitable for those
who already have book-keeping/accounting knowledge and who
wish to develop further knowledge of the principles and
practices employed in accounting work.
Mandatory
Unit:
Non-Mandatory Units
-
Unit 2 -
Process ledger transactions and prepare control accounts
-
Unit 3 - Make
journal entries and adjustments and produce a revised trial
balance
-
Unit 4 - Process nominal ledger
transactions (computerised)
-
Unit 5 - Carry out stock control
processes (computerised)
To achieve the OCR Level 2 Certificate in
Accounting candidates must pass Unit 1 plus any other two
non-mandatory units.
Back to
top
SAGE Accounting and Payroll
This course involves using SAGE Line 50
Accounting software. Candidates will demonstrate competence in
using a computerised accounting system to process nominal
ledger transactions: process routine payments and receipts,
process salary journals, prepare A VAT report, reconcile the
main bank account, correct transactions errors and print
appropriate reports.
At the end of the course, the candidate
will be able to:
-
Process nominal ledger transactions
-
Process petty cash payments and
receipts
-
Process cash receipts and payments
-
Process routine bank transactions
-
Reconcile bank account against bank
statement
-
Enter bank statement adjustments
-
Process salary journals
-
Produce monthly VAT analysis
-
Print specified accounting reports:
trial balance, audit trail, bank reports, bank statement
report, VAT report.
Candidates will use SAGE Line 50
computerised accounting system to carry out stock control
processes: to add and amend stock records, produce sales and
purchase orders, generate and print stock invoices and stock
credit notes. The candidate will be able to:
-
Carry out stock control processes
-
Create and amend stock records
-
Process sales orders
-
Process purchase orders
-
Process stock invoices and stock credit
notes
Print specified accounting reports: trail
balance, stock details report, stock valuation report, stock
re-order report, sales order reports, purchase order reports.
Back to
top
Adobe Photoshop
Training in currently offered in the use
of Photoshop V7. Photoshop is a
powerful software programme which is used to manipulate
images. Pictures can be dramatically changed using
Photoshop; colours changed, images sharpened, parts of the
picture removed or moved, old photographs repaired..... to
name a few examples.
-
Making use of the full
range of selection tools including the pen tool
-
Looking at how
Photoshop uses layers and filters
-
Basic scanning
techniques
-
Repairing old
Photographs, colourising black and white photographs
-
The art of creating
montages
-
Understanding alpha
channels
-
Learning about
Photoshop actions
-
Basic digital
photography techniques
-
Use of Photoshop in
creating web pages
|
7
