course-details-portlet

DIFT1006

Economic analysis and reporting using spread sheets

Choose study year
Credits 7.5
Level Intermediate course, level II
Course start Spring 2025
Duration 1 semester
Language of instruction Norwegian
Location Trondheim
Examination arrangement Project work

About

About the course

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
IBED2005 7.5 sp Autumn 2019
IINI2013 5 sp Autumn 2020
IFUD1114 5 sp Autumn 2020
INFT2507 7.5 sp Autumn 2021
This course has academic overlap with the courses in the table above. If you take overlapping courses, you will receive a credit reduction in the course where you have the lowest grade. If the grades are the same, the reduction will be applied to the course completed most recently.

Subject areas

  • Informatics
  • Economics

Contact information

Course coordinator

Lecturers

Department with academic responsibility

Department of Computer Science