UNIVERSITY EXAMINATIONS
Assessment 2 - 2023 (Semester 1)
AIN2601
Practical Accounting Data Processing
90 Marks
Duration 2 Hours
This paper consists of twelve (12) pages.
Instructions:
1. All questions must be answered
2. Download the MS Excel Workbook from myUnisa, which contains the templates for
this assessment
3. Questions must be answered in an MS Excel Worksheet
4. Your workbook must be saved as an Excel Macro-Enabled Workbook (*.xlsm)
5. Answer sheets may not be completed on any other application
6. There is no invigilation app for this assessment
7. Answer must be loaded within the required time on myUnisa
8. This paper consists of four (4) questions:
QUESTION TOPIC MARKS
1 Spreadsheets, Formula and Functions 38
2 Pivot Tables, Slicers and Graphs 20
3 Macros 15
4 VBA 17
90
Declaration: By submitting your online assessment you confirm that you accept and will
adhere to the terms of the university’s plagiarism and infringement policy. If you are in
violation of the declaration you will receive 0% for this examination. If you copied all or a
portion of your exam from someone else, both you and the person you copied from will
receive 0%. If found in violation of the university plagiarism and infringement policy, you will
also be subject to disciplinary action. This declaration holds you accountable for completing
your examination on your own.
CONFIDENTIAL Page 1 of 12 [TURN OVER]
, AIN2601
ASS-2/SEM1 2023
Additional student instructions
1. Students must save and upload their answer sheet in an Excel Macro-Enabled
Workbook (*.xlsm) file (answer scripts must not be password protected or
uploaded as “read only” files).
2. Incorrect file formats will not be considered.
3. NO emailed scripts will be accepted.
4. Students are advised to preview submissions (answer sheet) to ensure legibility
and that the correct answer script file has been uploaded.
5. Incorrect answer scripts and/or submissions made on unofficial examinations
platforms (including the invigilator cell phone application) will not be marked and no
opportunity will be granted for resubmission.
6. Mark awarded for incomplete submission will be the student’s final mark. No
opportunity for resubmission will be granted.
7. Mark awarded for illegible scanned submission will be the student’s final mark. No
opportunity for resubmission will be granted.
8. Submissions will only be accepted from registered student accounts.
9. Students suspected of dishonest conduct during the examinations will be subjected
to disciplinary processes. UNISA has zero tolerance for plagiarism and/or any other
forms of academic dishonesty.
10. Students are provided 30 minutes to submit their answer sheet after the official
examination time. Submissions made after the upload time will be rejected by the
examination regulations and will not be marked.
11. As this assessment falls within the rules of continuous assessment, there will be no
supplementary opportunity.
12. Students experiencing technical challenges, must email AIN2601-23-
, within the assessment time up to 5 minutes before the
assessment closure time. ONLY communication from your myLIfe account will be
considered.
CONFIDENTIAL Page 2 of 12 [TURN OVER]
Assessment 2 - 2023 (Semester 1)
AIN2601
Practical Accounting Data Processing
90 Marks
Duration 2 Hours
This paper consists of twelve (12) pages.
Instructions:
1. All questions must be answered
2. Download the MS Excel Workbook from myUnisa, which contains the templates for
this assessment
3. Questions must be answered in an MS Excel Worksheet
4. Your workbook must be saved as an Excel Macro-Enabled Workbook (*.xlsm)
5. Answer sheets may not be completed on any other application
6. There is no invigilation app for this assessment
7. Answer must be loaded within the required time on myUnisa
8. This paper consists of four (4) questions:
QUESTION TOPIC MARKS
1 Spreadsheets, Formula and Functions 38
2 Pivot Tables, Slicers and Graphs 20
3 Macros 15
4 VBA 17
90
Declaration: By submitting your online assessment you confirm that you accept and will
adhere to the terms of the university’s plagiarism and infringement policy. If you are in
violation of the declaration you will receive 0% for this examination. If you copied all or a
portion of your exam from someone else, both you and the person you copied from will
receive 0%. If found in violation of the university plagiarism and infringement policy, you will
also be subject to disciplinary action. This declaration holds you accountable for completing
your examination on your own.
CONFIDENTIAL Page 1 of 12 [TURN OVER]
, AIN2601
ASS-2/SEM1 2023
Additional student instructions
1. Students must save and upload their answer sheet in an Excel Macro-Enabled
Workbook (*.xlsm) file (answer scripts must not be password protected or
uploaded as “read only” files).
2. Incorrect file formats will not be considered.
3. NO emailed scripts will be accepted.
4. Students are advised to preview submissions (answer sheet) to ensure legibility
and that the correct answer script file has been uploaded.
5. Incorrect answer scripts and/or submissions made on unofficial examinations
platforms (including the invigilator cell phone application) will not be marked and no
opportunity will be granted for resubmission.
6. Mark awarded for incomplete submission will be the student’s final mark. No
opportunity for resubmission will be granted.
7. Mark awarded for illegible scanned submission will be the student’s final mark. No
opportunity for resubmission will be granted.
8. Submissions will only be accepted from registered student accounts.
9. Students suspected of dishonest conduct during the examinations will be subjected
to disciplinary processes. UNISA has zero tolerance for plagiarism and/or any other
forms of academic dishonesty.
10. Students are provided 30 minutes to submit their answer sheet after the official
examination time. Submissions made after the upload time will be rejected by the
examination regulations and will not be marked.
11. As this assessment falls within the rules of continuous assessment, there will be no
supplementary opportunity.
12. Students experiencing technical challenges, must email AIN2601-23-
, within the assessment time up to 5 minutes before the
assessment closure time. ONLY communication from your myLIfe account will be
considered.
CONFIDENTIAL Page 2 of 12 [TURN OVER]
