Menu
close
Apply Now
Contact
Parent Programme
Bachelor of Business (Level 7 NFQ)
MODULE NFQ
Level 6
MODULE CREDIT UNITS
ECTS: 5
MODULE TITLE
Advanced Spreadsheets
Reference Code: BB7 614
STAGE
Year 2
Fall Semester 1
12 Weeks Full-Time X 2.30 Hours per week
12 Weeks Part-Time X Hours per week

Spreadsheet Module

Advanced Spreadsheets

The indicative syllabus of this module is outlined below:

The role of spreadsheets:

    • Use of spreadsheets in business;
    • basic capabilities of spreadsheets;
    • Terminology associated with spreadsheets.

Designing worksheets 1:

    • Layout of data; commenting within a spreadsheet;
    • auditing of information requirement.

Designing worksheets 2:

    • Protecting cells; hiding cells; formatting cells.

Getting data:

    • Where to get data; importing data from sources;
    • converting data. 

Data analysis:

    • Data cleansing; grouping data; extracting data;
    • simple statistics tests.

Functions in Spreadsheets:

    • Prominent functions; using the formula tab;
    • building functions; automating tasks.

On completion of this module, the learner should be able to:

  • Explain concepts and terminology related to spreadsheets.
  • Identify, select and apply a range of spreadsheet techniques in order to prepare data for analysis..
  • Apply a wide range of spreadsheet techniques in order to analyse a variety of business decisions.
  • Design worksheets in a structured manner to ensure ease-of-use and ease of maintenance.

Minimum Intended Learning Outcomes (MIMLOs)

Upon successful completion of this module, the learner should be able to:
LO 1
Explain concepts and terminology related to spreadsheets.
LO 2
Identify, select and apply a range of spreadsheet techniques in order to prepare data for analysis.
LO 3
Apply a wide range of spreadsheet techniques in order to analyse a variety of business decisions.
LO 4
Design worksheets in a structured manner to ensure ease-of-use and ease of maintenance.

Assessment

MIMLOs
Assessment
Percentage
2, 3
CA
60%
1, 2, 3, 4
Practical Examination
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.

  • Gain familiarity with the capabilities offered by spreadsheet software, and the ability to leverage such capabilities, is an important tool within contemporary business.
  • Understand the organisation of data, and the deriving of insights from data which can allow businesses to increasing productivity improvements from existing resources.
[TheChamp-Sharing]
APPLY NOW
Top