Menu
close
Apply Now
Contact
Parent Programme
Bachelor of Business Level 7 NFQ
NFQ Level & Reference
Level 6 / Ref: M1.10
Duration
12 Weeks X 3 Hours per week
MODULE TITLE
Computer Applications 2
STAGE
1
Module Credit Unit
ECTS: 5

Computer Applications 2 Module

Introducing Computer Applications 2

This Computer Applications 2 module will provide learners with the knowledge and skills needed to thrive in the modern data-driven business environment. The module will enhance learner’s ability to manipulate and retrieve data easily and effectively.

Indicative Syllabus Content

Computer Applications

Spreadsheet Functions

  • Creating Spreadsheets
  • Working with Spreadsheets
  • Saving Spreadsheets
  • Understanding Cells
  • Inserting, Selecting, and Editing Data
  • Copying, Moving and Deleting Data
  • Understanding Worksheets
  • Using Cell References and Arithmetic Operators
  • Good Practice in Formula Creation
  • Using Functions

Formatting Spreadsheets

  • Managing Rows and Columns
  • Modifying Widths and Heights
  • Formatting Numbers
  • Changing cell content appearance
  • Formatting cell content or background
  • Copying cell formatting
  • Alignment and Border Effects
  • Creating and Editing Charts
  • Preparing Outputs and Printing

Creating Databases

  • Understanding key database concepts
  • Designing and structuring databases
  • Creating, saving and relating databases
  • Working with tables
  • Populating new databases
  • Designating primary key
  • Importing and exporting in various formats

Working with Databases

  • Creating database queries
  • Querying databases and retrieving data that matches multiple criteria
  • Implementing forms
  • Applying input masks
  • Manipulating and editing database contents
  • Cataloguing, organising, and filtering database contents
  • Generating Reports
  • Understanding how databases function in conjunction with other software

Minimum Intended Learning Outcomes (MIMLOs)

Upon successful completion of this module, the learner should be able to:
LO 1
Prepare spreadsheet and database documents and save them in appropriate formats.
LO 2
Insert data and charts into spreadsheet documents, and apply formatting in a way that recognises good practice and improves productivity.
LO 3
Apply functions, formulas and operators as part of a spreadsheet workflow.
LO 4
Review spreadsheet documents and prepare them for print output.
LO 5
Design, create, and populate new database documents using best practice.
LO 6
Search, retrieve, manipulate and catalogue data in a pre-existing database document in an efficient and productive manner.
LO 7
Explain how to correctly structure a simple searchable database.

Assessment

MIMLOs
Assessment
Percentage
1, 2, 3, 4
In-class Spreadsheet Exam
30%
1, 5, 6, 7
In-class Database Exam
30%
1, 5, 6
Practical Database Project
40%

Reassessment Opportunity

Where the combined marks of the assessment and examination do not reach the pass mark the learner will be required to repeat the element of assessment that they failed. Reassessment materials will be published on Moodle after the Examination Board Meeting and will be aligned to the MIMLOs and learners will be capped at 40% unless there are personal mitigating circumstances.

Aims & Objectives

The aims of this computer Applications module are to enable the learner to advance their knowledge and skills of prominent spreadsheet software.    Familiarity with the capabilities offered by spreadsheet software, and the ability to leverage such capabilities, is an important tool within contemporary business.

  • Provide learners with these important business skills.
  • Competently use spreadsheets and databases in a given scenario.
  • Embed functions and processes into a spreadsheet or database to more efficiently complete a given process.
[TheChamp-Sharing]
APPLY NOW
Top