AIN3701 Assignment 2 (Due 13 June 2025) – (721274) Full Solutions + VBA Code + IFRS Guide

n t
d e
S t u
AIN3701
a r – DATA ANALYSIS AND
Y e
ird AUTOMATION
Th
ASSIGNMENT 2 – 2025 u d
S t
UNIQUE NUMBER: 721274 e ar
d Y
DEADLINE: 13 JUNE 2025, AT 22:00 PM
h ir t
ThirdYearStudent T e n
t u d
Here’s your AIN3701 Assignment 2 Checklist – you can copy this into your a rSnotes or a
print it to track your progress: Y e Y e
ir td d
ir t
T h n T h n
AIN3701 Assignment 2 – Submission Checklist
d e d e
t u t u
Understanding the Assignment
a rS a rS

Y
I understand the purpose of the assignment e (VBA + IFRS + clear reporting)
Y e
i r
I’ve gone through the activities and
dknow what each one expectsird

T h ThirdYearStudent
n t T h n t
File Preparation
d e d e

S
My Excel file is named correctly tu(e.g. 12345678_Thusi_Q1.xlsm) S tu
My Word documente is a
r ar

Y complete and saved as a PDF
Y e
 Each question d
ir t in Word starts on a new ir t
page d
T h n T h n
VBA Coding
d e e
dcoding sheet
 t
I only used u
approved code from the AIN3701 t u
a rS a rS
– just basics like If, For,ThirdYearStudent
Y

e No
Y e
advanced arrays or collections Do While

ir d 
ir d
I commented my code clearly
h
T ThirdYearStudent

h
T is included in the VBA comments
My student number

Testing




THIRDYEARSTUDENT