ABL-C1102 - Hands-On Analytics on Accounting Information Systems, Lecture, 1.3.2023-19.4.2023

Guest access
Please note! Course description is confirmed for two academic years, which means that in general, e.g. Learning outcomes, assessment methods and key content stays unchanged. However, via course syllabus, it is possible to specify or change the course execution in each realization of the course, such as how the contact sessions are organized, assessment methods weighted or materials used.

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: 01.03.2023 - 19.04.2023

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
Prerequisites
SDG: Sustainable Development Goals

    8 Decent Work and Economic Growth

FURTHER INFORMATION

Further Information

  • valid for whole curriculum period:

    Teaching Language : English

    Teaching Period : 2022-2023 Spring IV
    2023-2024 Spring IV

    Enrollment :

    Registration for courses: in Sisu.

Rules of Conduct - Students´ Rights and Responsibilities (in force from 1 August 2020)

Aalto University Code of Academic Integrity and Handling Violations Thereof