Information on individual educational components (ECTS-Course descriptions) per semester | |
| Degree programme: | Bachelor International Business Full-time |
| Type of degree: | FH Bachelor´s Degree Programme |
| Full-time | |
| Summer Semester 2023 | |
| Course unit title | Advanced Spreadsheets in Management Accounting |
| Course unit code | 025017042001 |
| Language of instruction | English |
| Type of course unit (compulsory, optional) | Compulsory optional |
| Semester when the course unit is delivered | Summer Semester 2023 |
| Teaching hours per week | 2 |
| Year of study | 2023 |
| Level of course unit (e.g. first, second or third cycle) | 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 |
| Summer Semester 2023 | go Top |