Business Data Processing

MET3 Business Data Processing

Autumn 2020

  • Topics

    The aim of the course is to provide students with basic knowledge of data processing and information technology, and to develop practical skills in the use of the Office package, in particular Excel and Power Pivot. There will be an emphasis on learning methods to formulate, analyse and solve economics/business issues

    The course is divided into three main parts:

    Building financial models and conducting analyses in Excel and Power Pivot,

    • Databases and data modelling

    • General introduction to the use of modern information technology, management systems and Business Intelligence

    In each main part, theory, principles and methods will be illustrated. A booklet with practical exercises linked to the three main parts of the course is available on Canvas alongside suggested answers to the exercises.

  • Learning outcome

    Knowledge - the candidate

    • has basic knowledge of economics/business data processing
    • has knowledge of information technology and the challenges of using information technology in business and society
    • has knowledge of databases and their uses
    • has knowledge of ethical issues related to data protection and data processing

    Skills - the candidate

    • can build financial models in Excel and Power Pivot
    • can create data models in third normal form and simple dimensional data models

    General competence - the candidate

    • can apply his/her knowledge and skills to create efficient databases and spreadsheet solutions for own use in a business context
    • can communicate with ICT consultants about needs relating to specific database and spreadsheet solutions

  • Teaching

    The course will be offered digitally and will consist of video lectures, digital meetings, digital/physical group work

  • Credit reduction due to overlap

    MET is the equivalent to MET030. Students will not get credit for both courses.

  • Assessment

    A group-based home exam (groups of 3-4 students) which counts 100%. A 5 days home exam with issue 

  • Grading Scale

    A-F

  • Literature

    PC-use- Regneark for økonomer: Excel (2020)

    A compendium, lecture notes and selected articles.

Overview

ECTS Credits
7.5
Semester

Autumn. Offered autumn 2020.

Course responsible

Associate Professor Trond Vegard Johannessen, Department of Strategy and Management.