Apply Now
Contact
Parent Programme
Bachelor of Business
MODULE NFQ
Level 6
MODULE CREDIT UNITS
ECTS: 5
MODULE TITLE
Computer Applications 2
Reference Code: BB7 608
STAGE
Year 1
Spring Semester 2
12 Weeks Full-Time X 3.15 Hours per week
12 Weeks Part-Time X 1.75 Hours per week

Module Units

Spreadsheet Functions

The indicative syllabus of this module is outlined in the units below:

Spreadsheets

  • 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

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

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

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 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 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.
APPLY NOW
Top
X