Course code BUS133F

BUS133F Excel for Business - Online version

Norsk emneinformasjon

Search for other courses here

Showing course contents for the educational year 2022 - 2023 .

Course responsible: Øystein Dahl
ECTS credits: 5
Faculty: School of Economics and Business
Teaching language: NO
(NO=norsk, EN=Engelsk)
Teaching exam periods:
This course starts in Autumn parallel. This course has teaching/evaluation in Autumn parallel.
Course frequency: Yearly
First time: Study year 2021-2022
Course contents:

The course gives a basic introduction to Microsoft Excel, an essential computer tool used in business. An important objective of the course is that the students can use Excel in other courses.

Demonstrations and practical exercises in the use of formulas and functions and data tables. Presentation of models using formatting and graphics. Analysis and management of data, including external data, filtering and use of pivot tables.

Demonstrations and practical exercises in making simple financial models.

Learning outcome:

Knowledge:

The candidate has:

  • knowledge about the different components of Excel

The candidate can:

  • use the help tool in Excel
  • create, save and open Excel work books
  • input data into cells
  • format cells
  • create formulas and use Excel functions
  • copy data and formulas
  • create graphs and charts in various formats based on numerical data
  • make simple financial models
  • sort and filter data
  • handle data from external sources
  • use excels internal table functionality 
  • make PivotTables

Skills:

The candidate can:

  • develop efficient and structured models in Excel
  • work fast with Excel
Learning activities:

All lectures are on prerecorded videos.

The videos are 5-30 minutes long and grouped pr week. For each week there are exercises and a quiz.

The students are offered exercise lessons with teaching assistanses. The exercise lessons are given digitally.  

Syllabus:
No compulsory textbook, but recommended learning support in "Excel for økonomistudenter", Morten Helbæk, Børre Anton Olsen. Universitetsforlaget. Released 2019.
Recommended prerequisites:
Mandatory activity:

Weekly quiz.

The students must have 50 % correct on at least 2/3 of the quizzes to pass.

Assessment:
3 hours, home exam, on excel, with all aids. 
Nominal workload:
125 hours.
Entrance requirements:
Minimum requirements for entrance to higher education in Norway (generell studiekompetanse)
Reduction of credits:
5 ECTS overlap with BUS133 and BUS134B.
Type of course:

All lectures are on prerecorded videos.

The videos are 5-30 minutes long and grouped pr week. For each week there are exercises and a quiz.

The students are offered exercise lessons with teaching assistanses. The exercise lessons are given digitally.  

Examiner:
External examiner will control the quality of syllabus, questions for the final examination, and principles for the assessment of the examination answers.
Examination details: Written home exam: Passed / Not Passed