MENY
This is the study programme for 2019/2020. It is subject to change.


The course uses Excel to analyse different buisness- and microeconomic decision problems. The course focuses on analyzing real world examples to show how to solve relevant economic decision problems using Excel.

Learning outcome

On successful completion of this module, students should be able to: * Develop spreadsheet models for quantitative analysis of decision problems - optimisation and simulation. * Interpret results from quantitative analysis. * Sensitivity Analysis. * Use Excel

Contents

The course uses the spreadsheet program Excel, a powerful and useful tool for quantitative analysis. We analyze different examples of firm- and microeconomic decision problems. Focus will be on develping spreadsheet models which are both logically corret and easy to read, in addition to sensitivity analysis. Mathematical methods for problem solving will not be part of the course. The main subjects are optimization models, simulation models, decision trees and data analysis.
The lectures are streamed and available online. Access will be given to university computers at specified computer rooms. The course allows students to use their own computers with the Excel software (add-ins) used in the course. This software is available by purchasing a new course textbook. This software does not work on mac computers, and to practice and follow the lectures with your own computer you need a pc with Windows operating system. If you do not have access to this, you have to use one of the school (stationary) computers.

Required prerequisite knowledge

None.

Recommended previous knowledge

Basic knowledge in business economics, mathematics, micro-economics, statistics and use of spreadsheet

Exam

Weight Duration Marks Aid
Home exam1/13 daysA - FAll.

Coursework requirements

Mandatory assignments
Two mandatory assignments during the semester. Must be passed in order to take the exam. Can be done in groups of up to four people.

Course teacher(s)

Course teacher
Lars Christian Bruno
Course coordinator
Atle Øglend
Head of Department
Tore Markeset

Method of work

Normally four hours lectures/problem solving on pc per week. Lectures will be given in English. Student will follow the lectures using their own laptops (not mac), or using the university computers.

Overlapping courses

Course Reduction (SP)
Decision analysis with Excel (MIN240_1) 10

Open to

Master in Industriial Economics and master in Business and Administration at the UiS Business School

Course assessment

Form and/or discussion

Literature

Albright & Winston: Practical Management Science, 6th ed. plus additional material.


This is the study programme for 2019/2020. It is subject to change.

Sist oppdatert: 17.06.2019