Course Description

Computer applications Word, Excel, Database (Access) and Graphics

Pinnacle Training



The purpose of this QQI module is to provide learners with a comprehensive understanding of widely used computer applications and empower them to develop skills in Database, Spreadsheets, and Computer Graphics.

This course qualifies as a component certificate and counts as 10 credits towards QQI (Level 4) Certificates. It is a recognised module within the NFQ.

Although Microsoft Word is not assessed on this course, we cover many elements of Microsoft Word on this course.

COURSE CONTENT

UNIT 1 – INTRODUCTION TO DATABASES:
Specific Learning Outcomes Performance Criteria

– Identify applications suitable for database
– Understand the terms database, file, record, field, data type
– Identify a key field
– Identify possible data types as numeric, character/text, date and logical
– Access a database system
– Identify the component parts of a record structure
– Create a database file from a given structure
– Enter data
– Edit data
– Add new records
– Delete individual records
– Add new field to existing record structure
– Save a database
– Recall an existing database
– Browse the database
– Query the database on a single field
– Organise (sort and/or index) the database on a single field
– Output data to screen and printer
– Exit from the database using proper procedures.


UNIT 2 – INTRODUCTION TO SPREADSHEETS (EXCEL):
Specific Learning Outcomes Performance Criteria

– Identify applications suitable for spreadsheets
– Understand the terms spreadsheet, row, column, cell, label, value and formula
– Access a spreadsheet package
– Identify a cell by its grid reference
– Enter numeric data in a spreadsheet
– Enter character/text data in a spreadsheet
– Generate formulae using cell references and arithmetic operators
– Replicate/copy formulae over a range of cells using relative cell references
– Change formula
– Save the spreadsheet
– Open an existing spreadsheet
– Insert rows/columns
– Delete rows/columns
– Adjust column widths
– Format column entries (i.e. decimal, currency, alignment)
– Use the basic functions SUM and AVERAGE
– Sort a portion of a spreadsheet
– Print a spreadsheet
– Exit from the spreadsheet application using proper procedures.


UNIT 3 – INTRODUCTION TO GRAPHICS:
Specific Learning Outcomes Performance Criteria

– Access a graphics package
– Operate one graphic software package
– Use icons to carry out graphic operations
– Produce basic geometrical shapes
– Demonstrate electronically freehand drawing
– Input and manipulate clipart
– Enhance graphics with colour
– Edit drawings using:
– colour
– shape
– size
– Print hard copies in either landscape and portrait
– Input and manipulate text
– Enhance text
– Exit from a graphics package using proper procedures.


Course Code 4N1112
College Name Pinnacle Training
Course Category Computer Applications, Computers & IT (Information Technology)
Course Type Classroom Based
Course Qualification Level 4 Certificate
Course Location Coolock, Dublin, Ireland
Location Postcode Dublin 17
Delivery mode Classroom based
Course Start Date 9th April 2024
Course End Date 2nd May 2024
Course Fee 199
Course Duration 8 Classes (2 Classes a Week for 4 Weeks)
Course Times Course Dates: Tuesday 9th April , Thursday 11th April Tuesday 16th April, Thursday 18th April Tuesday 23rd April, Thursday 25th April Tuesday 30th April, Thursday 2nd May
Awarding Body QQI
Title of Awarding Computer Applications NFQ Level 4 (4N1112)
Entry Requirements No previous qualifications are required. However, basic knowledge of computers or the completion of the Computer Literacy QQI Level 3 course would be beneficial to the learner.
Career Path Learners will learn essential administrative skills that can be effectively applied within a professional setting. They may also use skills and knowledge learned on this course to progress onto the QQI Level 5 Word Processing course.
For information about Pinnacle Training, please visit our college page on www.nightcourses.com by clicking here.

Course Provider

Pinnacle Training



01 8675226
Northside Enterprise Centre Bunratty Drive, Coolock, Dublin, Republic of Ireland

Make Enquiry

Please insert your contact details and any additional information you require and we will forward your request to Pinnacle Training.
Captcha code        I confirm I have read the Privacy Policy, Terms and Conditions & Cookie Information and agree to join the Nightcourses.com community.
 

Map

Pinnacle Training
Northside Enterprise Centre Bunratty Drive
Coolock, Dublin
Republic of Ireland
Visit Website