Statusmelding

Kun tilgjengelig på engelsk

EBA 3610 Decision modelling using spreadsheet

EBA 3610 Decision modelling using spreadsheet

Course code: 
EBA 3610
Department: 
Accounting and Operations Management
Credits: 
7.5
Course coordinator: 
Atle Nordli
Erna Engebrethsen
Course name in Norwegian: 
Decision modelling using spreadsheet
Product category: 
Bachelor
Portfolio: 
Bachelor of Business Analytics - Programme Courses
Semester: 
2021 Autumn
Active status: 
Active
Level of study: 
Bachelor
Teaching language: 
English
Course type: 
One semester
Introduction

The course combines consideration of realistic decision-making problems with theory and methodologies in building and solving spreadsheet models. Examples from finance, marketing, supply chain and other business  areas illustrate management science applications and solutions methods using spreadsheet tools widely used in most  of the organizations.

Learning outcomes - Knowledge

During the course, students should have acquired:

  • Basic knowledge in Spreadsheet Modeling.
  • Basic knowledge of Optimization with Linear, as well as Nonlinear Programming Models.
  • Basic knowledge in Queueing Models.
Learning outcomes - Skills

After completing the course, students shall be able to:

  • Identify and apply modelling approach to solve decision problems.
  • Use spreadsheets for various business applications.
  • Model and solve LP Problems and sensitivity analysis.
  • Model decisions under uncertainty.
General Competence

The students will learn how to analyze a decision problem, evaluate the data and how to select a modelling and solution approach.

Course content
  • Introduction to Spreadsheet Modeling.
  • IIntroduction to Optimization and Linear Programming Models.
  • Modeling and solving LP Problems  and sensitivity analysis.
  • Network Models.
  • Optimization Models with Integer Variables.
  • Nonlinear Optimization Models.
  • Solution methods: Simplex and Evolutionary Solver.
  • Decision Making Under Uncertainty.
  • Introduction to Simulations.
  • Queueing Models.
  • Regression and Forecasting Models.
  • Multiobjective Decision Making.
  • Inventory and Supply Chain Models.
Teaching and learning activities

The course will include/entail a combination of Lectures and exercises using Excel.

Students are expected to solve a number of spreadsheet exercises, which will be given after each lecture.

Software tools
Software defined under the section "Teaching and learning activities".
Qualifications

Higher Education Entrance Qualification

Covid-19

Due to the Covid-19 pandemic, there may be deviations in teaching and learning activities as well as exams, compared with what is described in this course description.

Teaching

Information about what is taught on campus and other digital forms will be presented with the lecture plan before the start of the course each semester.

Required prerequisite knowledge

EBA 2910 Mathematics for Business Analytics, EBA 2904 Statistics or equivalent courses.

Exam categoryWeightInvigilationDurationSupport materialsGroupingComment exam
Exam category:
Submission
Form of assessment:
Written submission
Exam code:
EBA 36101
Grading scale:
ECTS
Grading rules:
Internal and external examiner
Resit:
Examination every semester
100Yes4 Hour(s)
  • No support materials
Individual Exam includes several tasks to be solved based on a spreadsheet
Exams:
Exam category:Submission
Form of assessment:Written submission
Weight:100
Invigilation:Yes
Grouping (size):Individual
Support materials:
  • No support materials
Duration:4 Hour(s)
Comment:Exam includes several tasks to be solved based on a spreadsheet
Exam code: EBA 36101
Grading scale:ECTS
Resit:Examination every semester
Type of Assessment: 
Ordinary examination
Total weight: 
100
Student workload
ActivityDurationComment
Teaching
45 Hour(s)
Group work / Assignments
96 Hour(s)
Student's own work with learning resources
55 Hour(s)
Examination
4 Hour(s)
Sum workload: 
200

A course of 1 ECTS credit corresponds to a workload of 26-30 hours. Therefore a course of 7,5 ECTS credit corresponds to a workload of at least 200 hours.