MET3 Business Data Processing
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.
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
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.
A group-based home exam (groups of 3-4 students) which counts 100%. A 5 days home exam.
PC-use- Regneark for økonomer: Excel (2021)
A compendium, lecture notes and selected articles.
- ECTS Credits
Autumn. Offered autumn 2021.
Associate Professor Trond Vegard Johannessen, Department of Strategy and Management.