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

    Teaching is organised as plenary lectures and group exercises in teaching rooms.

  • 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.

Please note: Due to the present corona situation, please expect parts of this course description to be changed before the autumn semester starts. Particularly, but not exclusively, this relates to teaching methods, mandatory requirements and assessment.

Course responsible

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