Course code BUS133

BUS133 Excel for Business

Norsk emneinformasjon

Search for other courses here

Showing course contents for the educational year 2016 - 2017 .

Course responsible: Kolbjørn Christoffersen
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: Annually
First time: Study year 2007-2008
Course contents:

Formulas and functions in Excel, cell references, formatting, charts, data table, lists, sorting and filtering, conditional formatting, data validation, pivot table, database connections, goal seek and solver, macros.

A detailed plan for the course will be presented in the first lecture.

Learning outcome:
The course shall give the students basic knowledge about and skills in Excel, an important computer program in business. An important goal of the course is that students will benefit from using Excel in conjunction with their studies and in their future job.
Learning activities:
Lectures: Demonstration of Excel. Exercises in the computer lab.
Syllabus:
Excel textbook/handbook (will be presented at course start).
Prerequisites:
BUS100 Cost Accounting, Fundamentals (can be taken concurrently). ECN110 Introduction to Microeconomics (can be taken concurrently)
Recommended prerequisites:
Assessment:

Take-home exam using Excel: 40 % of total grade.  Duration 2,75h.

Final written exam: 60 % of total grade.  Duration 3h.

The take-home exam will only be held once at the end of the teaching period. The result of this take-home exam is valid for 8 months, and can thus be weighted together with the result from ordinary written exam and a new / postponed written exam in May / June.

Nominal workload:
150 hours.
Entrance requirements:
Minimum requirements for entrance to higher education in Norway (generell studiekompetanse)
Type of course:
Lectures: 2 hours per week. Excercises: 2 hours per week. Total: Approximately 52 hours.
Examiner:
External examiner will control the quality of syllabus, questions for the final examination, and principles for the assessment of the examination answers.
Allowed examination aids: No calculator, no other aids
Examination details: Continuous exam: A - E / Ikke bestått