The module aims to equip students with data manipulation tools to assist with decision making in business.
Learning Outcomes
On successful completion of this module the learner will be able to:
LO1
Analyse techniques for collecting and presenting business data.
LO2
Manipulate economic functions using microsoft excel to present and interpret data.
LO3
Forecast trend values using time series analysis.
LO4
Calculate and interpret various investment appraisal techniques.
Pre-requisite learning
Module Recommendations
This is prior learning (or a practical skill) that is strongly recommended before enrolment in this module. You may enrol in this module if you have not acquired the recommended learning but you will have considerable difficulty in passing (i.e. achieving the learning outcomes of) the module. While the prior learning is expressed as named CIT module(s) it also allows for learning (in another module or modules) which is equivalent to the learning specified in the named module(s).
No recommendations listed
Incompatible Modules
These are modules which have learning outcomes that are too similar to the learning outcomes of this module. You may not earn additional credit for the same learning and therefore you may not enrol in this module if you have successfully completed any modules in the incompatible list.
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. You may not enrol on this module if you have not acquired the learning specified in this section.
No requirements listed
Co-requisites
No Co Requisites listed
Module Content & Assessment
Indicative Content
Business Research Analysis Tools
Data concepts, how data supports decision making, data collection and data visualisation techniques.
Data Manipulation
Manipulate demand and consumption functions using microsoft excel and data visualisation.
Business Forecasting
Analyse sales trends, prices and indices using microsoft excel and data visualisation.
Investment Appraisal Methods
Discounting and present values net present values and internal rate of return.
Assessment Breakdown
%
Course Work
100.00%
Course Work
Assessment Type
Assessment Description
Outcome addressed
% of total
Assessment Date
Practical/Skills Evaluation
Microsoft Excel based examination on demand and consumption functions.
1,2
30.0
Week 7
Practical/Skills Evaluation
Microsoft Excel based examination on sales trends using forecasting techniques.
3
30.0
Week 11
Short Answer Questions
Exam on investment appraisal techniques, business forecasting, data manipulation and business research analysis tools.
1,2,3,4
40.0
Week 13
No End of Module Formal Examination
Reassessment Requirement
Coursework Only This module is reassessed solely on the basis of re-submitted coursework. There is no repeat written examination.
The institute reserves the right to alter the nature and timings of assessment
Module Workload
Workload: Full Time
Workload Type
Workload Description
Hours
Frequency
Average Weekly Learner Workload
Lecture
Formal Lecture
3.0
Every Week
3.00
Lab
Practical Application
1.0
Every Week
1.00
Independent & Directed Learning (Non-contact)
Reading/Study
3.0
Every Week
3.00
Total Hours
7.00
Total Weekly Learner Workload
7.00
Total Weekly Contact Hours
4.00
Workload: Part Time
Workload Type
Workload Description
Hours
Frequency
Average Weekly Learner Workload
Lecture
Formal Lecture
1.5
Every Week
1.50
Lab
Practical Application
0.5
Every Week
0.50
Independent & Directed Learning (Non-contact)
Reading/Study
5.0
Every Week
5.00
Total Hours
7.00
Total Weekly Learner Workload
7.00
Total Weekly Contact Hours
2.00
Module Resources
Recommended Book Resources
James R. Evans 2012, Business Analytics, 2nd Ed., Pearson [ISBN: 9780321997821]