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

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.