Module Details

Module Code: BUSS C2404
Module Title: Business Applications 3
Title: Business Applications 3
Module Level:: 6
Credits:: 5
Module Coordinator: Martin Meagher
Module Author:: John Fogarty
Domains:  
Module Description: 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 will be able to:
# Learning Outcome Description
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.
Dependencies
Module Recommendations

This is prior learning (or a practical skill) that is recommended before enrolment in this module.
No recommendations listed
Co-requisite Modules
No Co-requisite modules listed
Additional Requisite Information
No Co Requisites listed
 
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.
Module Content & Assessment
Assessment Breakdown%
Continuous Assessment100.00%

Assessments

Full Time

Continuous Assessment
Assessment Type Practical/Skills Evaluation % of Total Mark 100
Timing n/a Learning Outcomes 1,2,3
Non-marked No
Assessment Description
Practical assessments
No Project
No Practical
No End of Module Formal Examination
Reassessment Requirement
Repeat examination
Reassessment of this module will consist of a repeat examination. It is possible that there will also be a requirement to be reassessed in a coursework element.
Reassessment Description
The repeat assessment will be a 2 hour exam covering the material in the module.

SETU Carlow Campus reserves the right to alter the nature and timings of assessment

 

Module Workload

Workload: Full Time
Workload Type Workload Category Contact Type Workload Description Frequency Average Weekly Learner Workload Hours
Laboratory Contact Demonstration and practice of advanced Excel application features Every Week 3.00 3
Independent Learning Non Contact Student practice of new features Every Week 6.00 6
Total Weekly Contact Hours 3.00
Workload: Part Time
Workload Type Workload Category Contact Type Workload Description Frequency Average Weekly Learner Workload Hours
Lecture Contact No Description Every Week 1.50 1.5
Independent Learning Time Non Contact No Description Every Week 7.50 7.5
Total Weekly Contact Hours 1.50
 
Module Resources
Supplementary Book Resources
  • Khan, S.. (2015), Mastering Google Drive and Docs, Prentice Hall, New Jersey, [ISBN: 978-073566913].
  • Monk , E., Brady, J., Cook, G. S. & Mendelsohn, E.. (2105), Problem Solving Cases In Microsoft Access and Excel, 13. Prentice Hall, New Jersey.
  • Cynthia Gardner,Eugene Rathswohl. (2012), MIS Cases, 2nd. Wiley, p.168, [ISBN: 978-1-118-29161-0].
  • Valerie M. Sue,Matthew T. Griffin. (2016), Data Visualization & Presentation with Microsoft Office, Sage Publications, Incorporated, p.360, [ISBN: 1483365158].
This module does not have any article/paper resources
This module does not have any other resources
Discussion Note: