lOMoAR cPSD| 16857960
, lOMoAR cPSD| 16857960
UNIVERSITY EXAMINATIONS
January/February 2025
AIN3701
AUTOMATION AND DATA ANALYSIS
100 Marks
Duration: 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 FIFTEEN (15) PAGES.
, lOMoAR cPSD| 16857960
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. The Invigilator App is compulsory for this assessment/exam.
3. This is an individual assessment and collaboration with other students (or groupwork) is not allowed.
4. This paper consists of three (3) questions with subsections.
5. You are strongly advised to carefully read the required before attempting the questions concerned.
6. All questions and sub-sections must be answered.
7. Each question must be commenced on a new (separate) page.
8. All workings, where applicate must be shown.
9. Include your student number in your VBA comments and PDF answer file.
10. Proposed timetable (avoid deviating from this as far as possible):
Question Subject/Topic Marks Time
number (minutes)
Ethical concerns of artificial intelligence.
1 Cyber security. 27 49
2 Automation using VBA 40 72
3 Data analytics 33 59
TOTAL 100 180
, lOMoAR cPSD| 16857960
11. 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.
, lOMoAR cPSD| 16857960
UNIVERSITY EXAMINATIONS
January/February 2025
AIN3701
AUTOMATION AND DATA ANALYSIS
100 Marks
Duration: 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 FIFTEEN (15) PAGES.
, lOMoAR cPSD| 16857960
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. The Invigilator App is compulsory for this assessment/exam.
3. This is an individual assessment and collaboration with other students (or groupwork) is not allowed.
4. This paper consists of three (3) questions with subsections.
5. You are strongly advised to carefully read the required before attempting the questions concerned.
6. All questions and sub-sections must be answered.
7. Each question must be commenced on a new (separate) page.
8. All workings, where applicate must be shown.
9. Include your student number in your VBA comments and PDF answer file.
10. Proposed timetable (avoid deviating from this as far as possible):
Question Subject/Topic Marks Time
number (minutes)
Ethical concerns of artificial intelligence.
1 Cyber security. 27 49
2 Automation using VBA 40 72
3 Data analytics 33 59
TOTAL 100 180
, lOMoAR cPSD| 16857960
11. 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.
