Information on individual educational components (ECTS-Course descriptions) per semester

Degree programme: Bachelor International Business Part-time
Type of degree: FH Bachelor´s Degree Programme
Part-time
Summer Semester 2022

Course unit title Advanced Spreadsheets in Management Accounting
Course unit code 025027042001
Language of instruction English
Type of course unit (compulsory, optional) Compulsory optional
Semester when the course unit is delivered Summer Semester 2022
Teaching hours per week 2
Year of study 2022
Number of ECTS credits allocated First Cycle (Bachelor)
Number of ECTS credits allocated 3
Name of lecturer(s) Said TRARI


Prerequisites and co-requisites

Basics of the module Accounting & Finance


Course content

Excel-based functions Advanced Excel functions in the field of economic computing, statistics, text editing Advanced graphics display Principles for designing reports


Learning outcomes

Knowledge - Students know advanced functionalities of MS Excel. - They know advanced techniques of designing spreadsheets, e.g. conditional formatting. Comprehension - Students understand the conceptual basis of the construction of advanced Excel spreadsheets. Application - Students can implement simple and advanced quantitative business problems in Excel. - They are able to implement simple control mechanisms to verify the accuracy of the spreadsheet. - They can extend the scope of Excel spreadsheets with database functions. - Students are able to generate target group -elated reports from existing Excel spreadsheets. Analysis/Synthesis - Students are able to work through simple and advanced quantitative business problems analytically. - Students design and document an Excel tool for the solution of practical quantitative business problems.


Planned learning activities and teaching methods

Lecture, exercises on the computer, presentations by students


Assessment methods and criteria

Development (Excel tool, 50%) and documentation (at least 5,000 characters, 50%) of an advanced Excel tool for controlling; various topics are available.


Comment

Students bring their laptop to the course. MS Excel 2010 or later must be installed on the computer.


Recommended or required reading

Nugus, Sue (2009): Financial Planning Using Excel: Forecasting, Planning and Budgeting Techniques. Wokingham: Cima Publishing Scheels, Ignaz; Seidel, Uwe M. (2013): Excel im Controlling: Professionelle Lösungen für Controlling, Projekt- und Personalmanagement. München: Hanser. Schüller, Andreas (2011): Finanzmanagement mit Excel - Grundlagen und Anwendungen. München: Vahlen.


Mode of delivery (face-to-face, distance learning)

Seminar on computers, mandatory attendance, group work