MET3 Business Data Processing

• 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 consist of physical/digital meetings, video lectures, physical/digital 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.

• Grading Scale

  A-F

• Literature

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

  A compendium, lecture notes and selected articles.