lOMoAR cPSD| 32110785
Open Rubric
Downloaded by Vincent Cosmas ()
, lOMoAR cPSD| 32110785
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
Downloaded by Vincent Cosmas ()
, lOMoAR cPSD| 32110785
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.
[TURN OVER]
Downloaded by Vincent Cosmas ()
, lOMoAR cPSD| 32110785
9. Proposed timetable (avoid deviating from this as far as possible):
Question number Subject Marks Ti
me
(min
utes)
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.
Downloaded by Vincent Cosmas ()
Open Rubric
Downloaded by Vincent Cosmas ()
, lOMoAR cPSD| 32110785
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
Downloaded by Vincent Cosmas ()
, lOMoAR cPSD| 32110785
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.
[TURN OVER]
Downloaded by Vincent Cosmas ()
, lOMoAR cPSD| 32110785
9. Proposed timetable (avoid deviating from this as far as possible):
Question number Subject Marks Ti
me
(min
utes)
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.
Downloaded by Vincent Cosmas ()
