BUS133 Excel – From Data to Information

Credits (ECTS):5

Course responsible:Øystein Dahl

Campus / Online:Taught campus Ås

Teaching language:Norsk

Course frequency:Annually

Nominal workload:125 hours.

Teaching and exam period:This course starts in Autumn parallel. This course has teaching/evaluation in Autumn parallel.

About this course

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. To the extent possible models used will deal with relevant aspects from the first autumn parallel.

Learning outcome

Knowledge

The student has

• knowledge of the structure of Microsoft Excel

• Knowledge of the functionality needed to build financial models

• knowledge of the various components of Excel

• knowledge of techniques for turning data into information

Skills

The student is able to:

• Set up master data for use in a model - register, paste and import data

• Structure basic data - adapting formats, quality assuring, adjusting and using names

• Analyze data - four types of calculations, simple statistics, sort

• Present data - formatting, customizing, and creating graphs

• Use Excel's built-in table feature

• Create pivot tables

General competency:

The student is able to:

• develop efficient and structured Excel models

• handle a process for transforming data to information - e.g. raw data to a graph

• work efficiently with Excel

  • Learning activities

    Live lectures on campus. Demonstration of Excel.

    Exercises in the computer lab with teaching assistants.

  • Assessment method
    Final exam (on Campus) entirely done in Excel: 100 % of total grade. Duration 3 hours.

  • Examiner scheme
    External examiner will control the quality of syllabus, questions for the final examination, and principles for the assessment of the examination answers.
  • Mandatory activity
    -
  • Teaching hours
    Lectures: 2 hours per week. Excercises: 2 hours per week. Total: Approximately 52 hours.
  • Reduction of credits
    5 ECTS overlap with BUS133F and BUS134-B.
  • Admission requirements
    Minimum requirements for entrance to higher education in Norway (generell studiekompetanse)