lOMoAR cPSD| 16857960
AIN3701
EXAM PACK
, 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
Open Rubric
, lOMoAR cPSD| 16857960
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.
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.
, lOMoAR cPSD| 16857960
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
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.
AIN3701
EXAM PACK
, 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
Open Rubric
, lOMoAR cPSD| 16857960
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.
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.
, lOMoAR cPSD| 16857960
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
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.