2 FETAC Level 4 accreditation
General Aims
Learners who successfully complete this module will:
Develop the skills to create and query a databaseDevelop the skills to enter and manipulate data from a spreadsheet packageDevelop the skills to produce and manipulate images using a drawing packageDevelop good work habits in the use and care of the computer and equipment
Units
Specific learning outcomes are grouped as three Units.
Unit 1 Introduction to DatabasesUnit 2 Introduction to SpreadsheetsUnit 3 Introduction to Graphics
Specific Learning Outcomes
Unit 1 Introduction to Databases
The learner should be able to:
Identify applications suitable for databaseUnderstand the terms database | file | record | field | data typeIdentify a key fieldIdentify possible data types as numeric | character/text | date and logicalAccess a database systemIdentify the component parts of a record structureCreate a database file from a given structureEnter dataEdit dataAdd new recordsDelete individual recordsAdd new field to existing record structureSave a databaseRecall an existing databaseBrowse the databaseQuery the database on a single fieldOrganise (sort and/or index) the database on a single fieldOutput data to screen and printerExit from the database using proper procedures
Unit 2 Introduction to Spreadsheets
Identify applications suitable for spreadsheetsUnderstand the terms spreadsheet row | column | cell | label | value and formulaAccess a spreadsheet packageIdentify a cell by its grid referenceEnter numeric data in a spreadsheetEnter character/text data in a spreadsheetGenerate formulae using cell references and arithmetic operatorsReplicate/copy formulae over a range of cells using relative cell referencesChange formulaSave the spreadsheetOpen an existing spreadsheetInsert rows/columnsDelete rows/columnsAdjust column widthsFormat column entries (i.e. decimal | currency | alignment)Use the basic functions SUM and AVERAGESort a portion of a spreadsheetPrint a spreadsheetExit from the spreadsheet application using proper procedures
Unit 3 Introduction to Graphics
Access a graphics packageOperate one graphic software packageUse icons to carry out graphic operationsProduce basic geometrical shapesDemonstrate electronically freehand drawingInput and manipulate clipartEnhance graphics with colourEdit drawings using: Colour | Shape | SizePrint hard copies in either landscape or portraitInput and manipulate textEnhance textExit from a graphics package using proper procedures
