LEARNING OUTCOMES
After the course students are able to:
(1) Understand the principles of Accounting Information System (AIS) and Enterprise Resource Planning Systems (ERP), including documentation, change planning and implementation
(2) Understand and apply hands on data analysis (using databases, SQL, and advanced excel techniques) for accounting and controlling purposes
(3) Analyze key AIS/ERP risks (e.g., fraud)
(4) Apply internal control and risk management strategies/frameworks
Credits: 6
Schedule: 02.03.2022 - 12.04.2022
Teacher in charge (valid for whole curriculum period):
Teacher in charge (applies in this implementation): Vikash Sinha
Contact information for the course (applies in this implementation):
CEFR level (valid for whole curriculum period):
Language of instruction and studies (applies in this implementation):
Teaching language: English. Languages of study attainment: English
CONTENT, ASSESSMENT AND WORKLOAD
Content
valid for whole curriculum period:
The course covers understanding of Accounting Information Systems (AIS) and Enterprise Resource Planning (ERP) systems along with documentation, change planning, and implementation of AIS/ERPs. Students learn about risk management, fraud detection and internal control approaches suited for digitalized business environments. Furthermore, students learn about backend databases, use of SQL for fetching data and application of advanced excel techniques suited for accounting and controlling purposes.
Assessment Methods and Criteria
valid for whole curriculum period:
INDIVIDUAL ASSIGNMENTS: Hands-On Practice assignments - SQL, Excel, Database (Individual) (20%); Individual Case Assignment Applying SQL, Excel, and Databse knowledge (Individual) (20%)
GROUP ASSIGNMENTS: Group Case assignments - Fraud, Risk Management, Internal Control (Group) (30%)
EXAM (individual) (30%)
To PASS:
Individual and Group Assignments (50% out of 70 points), Exam (50% out of 30 points), Overall (50% out of 100 points)
A minimum of 50% from the exam AND a minimum of 50% from the exercises is required to pass the course. Overall 50% from the course
Workload
valid for whole curriculum period:
Cases 20 hours
Contact teaching 18 hours
SQL, database, and Advanced Excel Module 50 hours
ERP Module 15 hours
Exam 3 hours
Independent Study (includes all materials suggested in MyCourses including pre-recorded lectures, reading book chapters and others) 54 hours
TOTAL 160 hours
DETAILS
Substitutes for Courses
valid for whole curriculum period:
Prerequisites
valid for whole curriculum period:
FURTHER INFORMATION
Further Information
valid for whole curriculum period:
Teaching Language : English
Teaching Period : 2022-2023 Spring IV
2023-2024 Spring IVEnrollment :
Registration for courses: in Sisu.