Postgraduate Course: Problem Solving and Spreadsheet Modelling Skills (CMSE11117)
Course Outline
School | Business School |
College | College of Humanities and Social Science |
Credit level (Normal year taken) | SCQF Level 11 (Postgraduate) |
Availability | Available to all students |
SCQF Credits | 15 |
ECTS Credits | 7.5 |
Summary | This course aims to equip students with a range of tools and frameworks for decision making and solving problems to common business and marketing problems. Students will be introduced to the basics of constructing decision support models, the basics of linear programming and simulation modelling, and decision-making under uncertainty using case studies and real life examples. The course further develops students' modelling skills using Microsoft Excel and through the application of the techniques to a range of practical problems.
This course builds on students' knowledge gained in the core courses of the MSc Marketing and Business Analysis programme, therefore complementing the other courses and minimising overlap of materials. |
Course description |
Not entered
|
Entry Requirements (not applicable to Visiting Students)
Pre-requisites |
Students MUST have passed:
Marketing Decision Analysis (CMSE11120)
|
Co-requisites | |
Prohibited Combinations | |
Other requirements | For Business School PG students only, or by special permission of the School. Please contact the course secretary. |
Information for Visiting Students
Pre-requisites | None |
Course Delivery Information
|
Academic year 2014/15, Available to all students (SV1)
|
Quota: None |
Course Start |
Semester 2 |
Timetable |
Timetable |
Learning and Teaching activities (Further Info) |
Total Hours:
150
(
Lecture Hours 20,
Supervised Practical/Workshop/Studio Hours 24,
Summative Assessment Hours 2,
Programme Level Learning and Teaching Hours 3,
Directed Learning and Independent Learning Hours
101 )
|
Assessment (Further Info) |
Written Exam
70 %,
Coursework
30 %,
Practical Exam
0 %
|
Additional Information (Assessment) |
Assessment of this course is through an exam (weighted 70%) and assignment (problem formulation and solution, weighted 30%). |
Feedback |
Not entered |
Exam Information |
Exam Diet |
Paper Name |
Hours & Minutes |
|
Main Exam Diet S2 (April/May) | Problem Solving and Spreadsheet Modelling Skills | 2:00 | |
Learning Outcomes
A. Knowledge and understanding of
* the nature of problem solving and decision making in business and marketing management;
* the modelling of decisions using decision trees;
* various methods for structuring management decision problems;
* techniques for modelling as an aid to decision making;
* the techniques and relative merits of using linear programming in decision making;
* the techniques and relative merits of using simulation in decision making;
* methods for solving certain types of business models.
B. Intellectual skills
Students will develop skills such as:
* the ability to build models to assist management decision making;
* the ability to critically assess models for management decision making;
* the ability to interpret decision-making models in light of possible courses of action for a given business/marketing problem or situation;
* the ability to understand methods of model solution.
C. Professional/subject specific/practical skills
Students will gain:
* an appreciation of methods involved in problem solving and construction of decision trees;
* an appreciation of methods involved in business modelling;
* experience in identifying problems in which model building methods can be applied;
* experience in using commercial software to tackle management decision problems.
D. Transferable skills
By the end of the course students will be expected to:
* be able to plan and carry out analyses based on construction and solution of appropriate models;
* be able to employ analytical and problem-solving skills;
* show that they can report results in a concise way;
* have enhanced their skills in using commercial software products.
|
Additional Information
Graduate Attributes and Skills |
Not entered |
Keywords | PSSMS |
Contacts
Course organiser | Dr Daniel Black
Tel: (0131 6)51 1491
Email: Dan.Black@ed.ac.uk |
Course secretary | Miss Ashley Harper
Tel: (0131 6)51 5671
Email: Ashley.Harper@ed.ac.uk |
|
© Copyright 2014 The University of Edinburgh - 12 January 2015 3:40 am
|