AIN3701
EXAM PACK
, lOMoARcPSD|18222662
AIN3701
October – November 2024 Examinations
UNIVERSITY EXAMINATIONS
Oct/Nov 2024
AIN3701
AUTOMATION AND DATA ANALYSIS
100 marks
3 hours
EXAMINATION PANEL AS APPOINTED BY THE DEPARTMENT
Use of a computer (laptop or desktop) is compulsory.
No handwritten scripts will be accepted.
Limited open-book examination.
Only the following material are allowed in the examination:
• Pre-seen information
• VBA Coding Sheet 2024
The examination question paper remains the property of the University of South Africa and may not be distributed
beyond its intended use for this examination.
THIS PAPER CONSISTS OF EIGHTEEN (18) PAGES.
INSTRUCTIONS:
1. This is a limited open-book examination. The only material you are allowed to use during the
examination is:
a. Pre-seen information.
b. VBA Coding Sheet 2024.
You are not allowed to copy from or consult any other sources. This includes but is not limited to your
study material, websites, and artificial intelligence tools. You are also not allowed to consult any third
party for the duration of the exam session.
2. This is an individual assessment and collaboration with other students (or groupwork) is not allowed.
3. This paper consists of five (5) questions with subsections.
4. You are strongly advised to carefully read the required before attempting the questions concerned.
.
5. All questions and sub-sections must be answered.
6. Each question must be commenced on a new (separate) page.
7. All workings, where applicate must be shown.
8. Include your student number in your VBA comments and PDF answer file.
, lOMoARcPSD|18222662
AIN3701
October – November 2024 Examinations
9. Proposed timetable (avoid deviating from this as far as possible):
Question Subject Marks Time
number (minutes)
1 Automation using VBA 40 72
2 Emerging technologies 14 25
3 Cyber security 11 20
4 Data analytics 21 38
5 Data analytics & Dashboards 14 25
TOTAL 100 180
10. Please remember to complete the Honesty Declaration.
Honesty Declaration:
By submitting my solution to the exam, I declare that:
• I know what plagiarism is, that plagiarism is wrong and that disciplinary steps can be taken
against me if I am found guilty of plagiarism.
• This solution, submitted by myself, is my own work.
• I have not assisted any other student in any manner, and I have not had the assistance of
any other person, in completing this exam.
• I will not assist any other student in any manner, and I will not obtain the assistance of any
other person, in completing this exam.
• I know that if I am found to be in violation of this declaration, I will have to face a disciplinary
hearing.
Please note:
By submitting your solution, you automatically declare that you adhere to all the above with regards
to this specific assessment.
, lOMoARcPSD|18222662
AIN3701
October – November 2024 Examinations
THE INVIGILATOR APP
Instructions on the day of the assessment:
• Ensure you are connected to the internet in order to log into the Invigilator App and scan this QR code.
• If you encounter difficulty in scanning the QR code, you can alternatively enter the Exam Access Code
below the QR code to start the invigilation.
• If you finish your assessment before the app timer has run out you need to press the ‘Finish
Assessment’ button and follow instructions before you exit or minimise the app.
• Scan the QR code at the start time of the assessment, unless otherwise specified by your institution,
note that you can only scan this QR code once.
The Invigilator App may request you to take photos of your examination script after the assessment.
Please follow the instructions on the app and take note that your academic institution may still require
you to submit your script on the relevant portal.
• The QR code is only scannable for a limited time and it should therefore be scanned as soon as
possible after the assessment commencement time.
• Keep the Invigilator App open on your smartphone for the full duration of the assessment. You are not
allowed to minimise or leave the app during your assessment.
• You must adhere to the assessment time limit communicated to you by your institution. The timer
displayed in the Invigilator may vary depending on the start time of invigilation.
Further guidance
• If you only have one device you may access your assessment in the application by pressing the ‘Access
Browser’ button in the top right corner of your app.
• Once the QR code is scanned, ensure your media volume is turned up and place your smartphone
next to you.
• The Invigilator App will notify you with a notification beep when you are required to action a photo
request, which you should then perform as soon as possible.
• We recommend that you keep your smartphone on charge for the duration of the assessment.
• Ensure you are connected to the internet when commencing invigilation. You also need to be connected
to the internet at the end of the assessment in order to upload the app data.
• If your assessment has multiple online sections, tests or attempts, you should NOT finish the invigilation
until your entire assessment has been completed.
• Should you encounter any technical difficulty, please WhatsApp the Invigilator Helpdesk on
+27 (0)73 505 8273
EXAM PACK
, lOMoARcPSD|18222662
AIN3701
October – November 2024 Examinations
UNIVERSITY EXAMINATIONS
Oct/Nov 2024
AIN3701
AUTOMATION AND DATA ANALYSIS
100 marks
3 hours
EXAMINATION PANEL AS APPOINTED BY THE DEPARTMENT
Use of a computer (laptop or desktop) is compulsory.
No handwritten scripts will be accepted.
Limited open-book examination.
Only the following material are allowed in the examination:
• Pre-seen information
• VBA Coding Sheet 2024
The examination question paper remains the property of the University of South Africa and may not be distributed
beyond its intended use for this examination.
THIS PAPER CONSISTS OF EIGHTEEN (18) PAGES.
INSTRUCTIONS:
1. This is a limited open-book examination. The only material you are allowed to use during the
examination is:
a. Pre-seen information.
b. VBA Coding Sheet 2024.
You are not allowed to copy from or consult any other sources. This includes but is not limited to your
study material, websites, and artificial intelligence tools. You are also not allowed to consult any third
party for the duration of the exam session.
2. This is an individual assessment and collaboration with other students (or groupwork) is not allowed.
3. This paper consists of five (5) questions with subsections.
4. You are strongly advised to carefully read the required before attempting the questions concerned.
.
5. All questions and sub-sections must be answered.
6. Each question must be commenced on a new (separate) page.
7. All workings, where applicate must be shown.
8. Include your student number in your VBA comments and PDF answer file.
, lOMoARcPSD|18222662
AIN3701
October – November 2024 Examinations
9. Proposed timetable (avoid deviating from this as far as possible):
Question Subject Marks Time
number (minutes)
1 Automation using VBA 40 72
2 Emerging technologies 14 25
3 Cyber security 11 20
4 Data analytics 21 38
5 Data analytics & Dashboards 14 25
TOTAL 100 180
10. Please remember to complete the Honesty Declaration.
Honesty Declaration:
By submitting my solution to the exam, I declare that:
• I know what plagiarism is, that plagiarism is wrong and that disciplinary steps can be taken
against me if I am found guilty of plagiarism.
• This solution, submitted by myself, is my own work.
• I have not assisted any other student in any manner, and I have not had the assistance of
any other person, in completing this exam.
• I will not assist any other student in any manner, and I will not obtain the assistance of any
other person, in completing this exam.
• I know that if I am found to be in violation of this declaration, I will have to face a disciplinary
hearing.
Please note:
By submitting your solution, you automatically declare that you adhere to all the above with regards
to this specific assessment.
, lOMoARcPSD|18222662
AIN3701
October – November 2024 Examinations
THE INVIGILATOR APP
Instructions on the day of the assessment:
• Ensure you are connected to the internet in order to log into the Invigilator App and scan this QR code.
• If you encounter difficulty in scanning the QR code, you can alternatively enter the Exam Access Code
below the QR code to start the invigilation.
• If you finish your assessment before the app timer has run out you need to press the ‘Finish
Assessment’ button and follow instructions before you exit or minimise the app.
• Scan the QR code at the start time of the assessment, unless otherwise specified by your institution,
note that you can only scan this QR code once.
The Invigilator App may request you to take photos of your examination script after the assessment.
Please follow the instructions on the app and take note that your academic institution may still require
you to submit your script on the relevant portal.
• The QR code is only scannable for a limited time and it should therefore be scanned as soon as
possible after the assessment commencement time.
• Keep the Invigilator App open on your smartphone for the full duration of the assessment. You are not
allowed to minimise or leave the app during your assessment.
• You must adhere to the assessment time limit communicated to you by your institution. The timer
displayed in the Invigilator may vary depending on the start time of invigilation.
Further guidance
• If you only have one device you may access your assessment in the application by pressing the ‘Access
Browser’ button in the top right corner of your app.
• Once the QR code is scanned, ensure your media volume is turned up and place your smartphone
next to you.
• The Invigilator App will notify you with a notification beep when you are required to action a photo
request, which you should then perform as soon as possible.
• We recommend that you keep your smartphone on charge for the duration of the assessment.
• Ensure you are connected to the internet when commencing invigilation. You also need to be connected
to the internet at the end of the assessment in order to upload the app data.
• If your assessment has multiple online sections, tests or attempts, you should NOT finish the invigilation
until your entire assessment has been completed.
• Should you encounter any technical difficulty, please WhatsApp the Invigilator Helpdesk on
+27 (0)73 505 8273
