course-details-portlet

DIFT1006 - Economic analysis and reporting using spread sheets

About

Examination arrangement

Examination arrangement: Project work
Grade: Passed / Not Passed

Evaluation Weighting Duration Grade deviation Examination aids
Project work 100/100

Course content

A review of financial analysis of accounting information is provided with key figure calculations for assessing profitability and financing. We see how spreadsheets can be used as tools for financial support, financial analysis and reporting in companies. The course is based on theory covered in the course Economic Management and Accounting (7,5 credits). The project in the course will give the candidates training in writing a relatively comprehensive financial report. The course provides a thorough introduction to the use of spreadsheets (Excel). Best practices for developing spreadsheets, the most important functions for financial analysis in Excel, and pivot objects and reports are reviewed. Furthermore, an introduction to microeconomic analysis is given.

Learning outcome

Knowledge

The candidate can:

  • Read and understand economic analyzes.
  • Select current analyzes and reports based on a specific issue (case).
  • Demonstrate insight into the basic principles of microeconomic analysis
  • Explain how spreadsheets should be built and structured to achieve user-friendly, maintenance-friendly and as error-free solutions as possible.
  • Explain the function of key objects in Excel.

Skills

The candidate can:

  • Conduct an analysis of a company's profitability and financing based on accounting information
  • Explain the adaptation of consumers and companies in a market
  • Explain different market forms
  • Use spreadsheets in practical financial management in a project or in an organization
  • Use spreadsheets as a tool to structure theories and models from financial management and accounting.
  • Can use spreadsheets as a tool for managing finances and project work.
  • Develop good spreadsheets
  • Use the most important financial features in spreadsheets
  • Import and export data to and from the spreadsheet
  • Use pivot tables to generate reports.

General competence

Candidates:

  • Has a conscious relationship to quality assurance of spreadsheets and testing of such.
  • Can connect microeconomic theory to the individual business

Learning methods and activities

The teaching of the course consists of lectures followed by practical problem solving. In addition, it is planned that the students will apply the competence they acquire in compulsory exercises and in the implementation of a larger project.

Compulsory assignments

  • Mandatory assignments

Further on evaluation

Mandatory work requirements: Exercises are delivered individually. All exercises must be approved to have the project delivered and evaluated.

The project is carried out in groups. Individual assessment of the project can be given. The project is presented in groups. All group members must contribute to the presentation. Attendance is mandatory at all convened group meetings and at the presentation.

In the event of voluntary repetition, fail (F) or valid absence, the project must be retaken in a semester with teaching. Evaluations are only held in semesters with teaching.

Specific conditions

Admission to a programme of study is required:
Digital Business Development (ITBAITBEDR)

Credit reductions

Course code Reduction From To
IBED2005 7.5 AUTUMN 2019
IINI2013 5.0 AUTUMN 2020
IFUD1114 5.0 AUTUMN 2020
INFT2507 7.5 AUTUMN 2021
More on the course

No

Facts

Version: 1
Credits:  7.5 SP
Study level: Intermediate course, level II

Coursework

Term no.: 1
Teaching semester:  SPRING 2025

Language of instruction: Norwegian

Location: Trondheim

Subject area(s)
  • Informatics
  • Economics
Contact information
Course coordinator: Lecturer(s):

Department with academic responsibility
Department of Computer Science

Examination

Examination arrangement: Project work

Term Status code Evaluation Weighting Examination aids Date Time Examination system Room *
Spring ORD Project work 100/100 INSPERA
Room Building Number of candidates
  • * The location (room) for a written examination is published 3 days before examination date. If more than one room is listed, you will find your room at Studentweb.
Examination

For more information regarding registration for examination and examination procedures, see "Innsida - Exams"

More on examinations at NTNU