Show/hide contentOpenClose All
Curricular information is subject to change
On completion of the module students should be able to:
Explain the potential roles of spreadsheet modelling in decision support within an organisation; Discuss the structure, conceptual basis and utility of specific models used to support business decision making; Use spreadsheets in key business applications including data analysis and simulation modelling.
The module includes the following topics:
(1) Decision support systems and the role of spreadsheet applications
(2) Introductory concepts in modelling with Microsoft Excel
(3) Use of functions: mathematical, financial, logical and statistical
(4) Cost-Volume-Profit model
(5) Analysis of financial data
(6) Investment appraisal model
(7) Inventory management model
(8) Simulation modelling: validation and verification strategies
(9) Stochastic simulation models.
Student Effort Type | Hours |
---|---|
Lectures | 12 |
Practical | 24 |
Specified Learning Activities | 20 |
Autonomous Student Learning | 44 |
Total | 100 |
AERD20030 - Business Management (or equivalent)
Description | Timing | Component Scale | % of Final Grade | ||
---|---|---|---|---|---|
Class Test: Practical Test | Week 12 | n/a | Graded | No | 30 |
Class Test: Theory test comprising short-answer questions to be completed online | 1 hour End of Trimester Exam | n/a | Graded | No | 40 |
Continuous Assessment: Short exercises completed weekly | Throughout the Trimester | n/a | Graded | No | 30 |
Resit In | Terminal Exam |
---|---|
Spring | Yes - 1 Hour |
• Feedback individually to students, on an activity or draft prior to summative assessment
• Feedback individually to students, post-assessment
Assessment for this module comprises 3 components: in-class exercises (30%); practical exam (30%), and a theory test (40%). In-class exercises are completed throughout the trimester and students will receive prompt feedback on their performance. This formative feedback supports students' preparation for a practical exam in Week 12. Students will receive feedback on their practical test within a target time of 2 weeks after completion. The end-of-trimester written examination is a summative assessment with each student receiving a grade for their exam and overall module performance. Students can receive feedback on their exam by appointment with the lecturer.