Lab sessions - communication of knowledge by demonstration from the lecturer to the student. E-Learning - the module will be supported with online learning materials. Self-Directed Independent Learning - the emphasis on independent learning will develop strong and autonomous work and learning practices.
Module Aim:
The aim of the subject is to build on the skills developed in Business Applications I and to provide the students with the essential information technology skills required for entering the workplace or for continued studies.
Learning Outcomes
On successful completion of this module the learner should be able to:
LO1
Demonstrate the ability to model spreadsheet for business applications.
LO2
Demonstrate the ability to use the advanced functions of Excel.
LO3
Apply What-if analysis tools appropriately.
Pre-requisite learning
Module Recommendations
This is prior learning (or a practical skill) that is recommended before enrolment in this module.
No recommendations listed
Incompatible Modules
These are modules which have learning outcomes that are too similar to the learning outcomes of this module.
No incompatible modules listed
Co-requisite Modules
No Co-requisite modules listed
Requirements
This is prior learning (or a practical skill) that is mandatory before enrolment in this module is allowed.
Business Applications I
Module Content & Assessment
Indicative Content
Advanced Spreadsheets (100%).
Develop advanced excel skills including absolute and relative referencing;
advanced functions IF, VLOOKUP, HLOOKUP, PMT, ROUND, RAND;
importing data from other sources; finding and correcting errors in formulae;
what-if analysis (Goal Seek; Scenarios and data tables);
using Solver to find optimal solutions;
Pivot tables & Pivot charts;
Data analytics,
Presentation behaviour; Dashboards;
Creating and editing charts; advanced formatting; protecting cells and sheets.
Assessment Breakdown
%
Continuous Assessment
100.00%
Continuous Assessment
Assessment Type
Assessment Description
Outcome addressed
% of total
Assessment Date
Practical/Skills Evaluation
Practical assessments
1,2,3
100.00
n/a
No Project
No Practical
No End of Module Formal Examination
SETU Carlow Campus reserves the right to alter the nature and timings of assessment