THE UNIVERSITY of EDINBURGH

DEGREE REGULATIONS & PROGRAMMES OF STUDY 2017/2018

University Homepage
DRPS Homepage
DRPS Search
DRPS Contact
DRPS : Course Catalogue : Business School : Business Studies

Undergraduate Course: Business Analytics and Information Systems (BUST08032)

Course Outline
SchoolBusiness School CollegeCollege of Humanities and Social Science
Credit level (Normal year taken)SCQF Level 8 (Year 2 Undergraduate) AvailabilityAvailable to all students
SCQF Credits20 ECTS Credits10
SummaryThis course demonstrates how information systems and decision support tools can be effectively integrated to analyse and solve business problems. (This course was previously entitled BUST08007 Management Science and Information Systems.)
Course description The goal of this course is to demonstrate how information systems and decision support tools can be used in synergy to address business problems. More specifically, our aim is to:
1. Illustrate how data can be modelled, stored and retrieved in order to effectively support decision making.
2. Introduce a range of quantitative approaches to decision making.
3. Apply state-of-the-art data management and decision support tools to tackle business problems.

Syllabus
1. Data Management and Database Design
2. Linear Programming
3. Project Management
4. Decision Analysis

Student Learning Experience
The course is taught by means of lectures, computer labs, tutorials, and group activities. Lectures cover topics in information systems and data management, such as database design and SQL; as well as a number of management science techniques, such as linear programming and decision analysis. Computer labs let students acquire the skills that are necessary to apply these techniques in practice by using state of the art software packages. Tutorials provide an understanding of the theory underpinning the aforementioned techniques. Group activities are designed to let students experience challenges and opportunities that stem from the integration of decision support models and information systems.
Entry Requirements (not applicable to Visiting Students)
Pre-requisites Students MUST have passed: Foundations of Business (BUST08025) OR Economics 1 (ECNM08013) OR Economic Principles and Applications (ECNM08002) OR ( Industrial Management 1 (BUST08002) AND Techniques of Management (MAEE08002)) OR Introduction to Business (BUST08026)
Co-requisites
Prohibited Combinations Other requirements None
Information for Visiting Students
Pre-requisitesVisiting students should usually have at least 1 introductory level Business Studies course at grade B or above (or be predicted to obtain this) for entry to this course. We will only consider University/College level courses.
High Demand Course? Yes
Course Delivery Information
Academic year 2017/18, Available to all students (SV1) Quota:  None
Course Start Semester 2
Timetable Timetable
Learning and Teaching activities (Further Info) Total Hours: 200 ( Lecture Hours 20, Seminar/Tutorial Hours 5, Summative Assessment Hours 8, Programme Level Learning and Teaching Hours 4, Directed Learning and Independent Learning Hours 163 )
Assessment (Further Info) Written Exam 40 %, Coursework 30 %, Practical Exam 30 %
Additional Information (Assessment) Your work will be assessed in three ways:
1. Direct assessment of the work you complete within computer sessions (30% of the Final Mark; each of the 3 computer labs contributing to 10% of the Final Mark).
2. Essay of 1500 words in which each group of 4 or 5 students report their findings stemming from the analysis of a management decision problem (30% of the Final Mark); peer assessment from other group members carried out via WebPA moderates of the Essay mark for each group member.
3. A degree examination (40% of the Final Mark).
Feedback 1. Generic feedback on the COMPUTER LAB ASSESSMENTS, together with individual marks, will be posted on Learn during the week following the assessment.
2. Generic feedback on the GROUP COURSEWORK PROJECT, together with individual marks, will be posted on Learn within 15 working days after the submission deadline; also the individual feedback for your group coursework will be available to collect from the Business School Undergraduate Office (Room 1.11, Business School, 29 Buccleuch Place), but you will not be able to take away the original piece of coursework, as it may be required by the Board of Examiners.
3. The compulsory TUTORIALS provide the opportunity for testing your understanding and getting direct feedback. The tutorial exercises are included in the course booklet as well as posted in the 'Tutorials' folder on Learn and students are expected to complete the exercises before the tutorial so that any problems can be discussed at the tutorial.
4. The EXAMINATION marks will be posted on Learn together with generic feedback and examination statistics as soon as possible after the Board of Examiners' meeting (normally early-mid June). During the summer months (i.e. mid/end June - end August), you may come into the Business School Undergraduate Office (Room 1.11, Business School, 29 Buccleuch Place) to look at your examination scripts. Continuing students will also be given the opportunity to review their examination scripts early in the new academic year in Semester 1 (i.e. in October).
Exam Information
Exam Diet Paper Name Hours & Minutes
Main Exam Diet S2 (April/May)2:00
Learning Outcomes
On completion of this course, the student will be able to:
  1. Discuss state of the art techniques for data modelling, storage and retrieval in database management systems.
  2. Discuss the key elements of a linear programming model and its underlying assumptions; illustrate possible solution methods for solving linear programs.
  3. Discuss selected approaches to decision making under uncertainty and illustrate possible solution methods.
  4. Discuss selected techniques in project management.
  5. Discuss the key steps that should be executed to tackle a management decision problem.
Reading List
Wayne L. Winston, Operations Research Applications and Algorithms (3rd ed.), Brooks/Cole Publishing 1997, ISBN 0534520200

David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, R. Kipp Martin, An Introduction to Management Science: Quantitative Approaches to Decision Making (12th ed), West Publishing 2008, ISBN 0324399804. (Note that other editions of this text have similar content.)

Frederick S. Hillier and Gerald J. Lieberman, Introduction to Operations Research (9th ed.), McGraw-Hill, 2009, ISBN 0071324836

Bernard W. Taylor, Introduction to Management Science (10th ed), Pearson Education 2009, ISBN 0132371197.

Jeffrey H. Moore and Larry R. Weatherford, Decision Modeling with Microsoft Excel (6th ed), Prentice Hall 2001, ISBN 013017789x

Thomas Connolly, Carolyn Begg, Database Systems: A Practical Approach to Design, Implementation and Management: International Edition, 5th Edition, Pearson, Dec 2012, Paperback, 1400 pages, ISBN13: 9780321601100.
Additional Information
Graduate Attributes and Skills Intellectual Skills
1. Design a database suitable for a given dataset.
2. Build a decision support model for a given management decision problem.
3. Integrate a database and a decision support model to derive management recommendations for a given management decision problem.
4. Identify what combination techniques covered is most suitable to address a management decision problem.

Professional Skills/Subject Specific/Practical Skills
1. Model a given set of data using the relational modelling paradigm.
2. Store and retrieve data from a database management system.
3. Build, solve and analyse linear programming or decision analysis models in Excel.
4. Use a project management decision support tool to schedule project activities.

Transferable skills
1. Demonstrate report writing skills.
2. Demonstrate problem analysis and problem solving skills.
Additional Class Delivery Information 20 lectures (1hr each)
3 assessed computer labs (2hr each)
5 tutorials (1hr each)
KeywordsBusiness Analytics & Information Systems
Contacts
Course organiserDr Roberto Rossi
Tel: (0131 6)51 5239
Email:
Course secretaryMs Patricia Ward-Scaltsas
Tel: (0131 6)50 3823
Email:
Navigation
Help & Information
Home
Introduction
Glossary
Search DPTs and Courses
Regulations
Regulations
Degree Programmes
Introduction
Browse DPTs
Courses
Introduction
Humanities and Social Science
Science and Engineering
Medicine and Veterinary Medicine
Other Information
Combined Course Timetable
Prospectuses
Important Information
 
© Copyright 2017 The University of Edinburgh - 6 February 2017 6:28 pm