HIGHER EDUCATION PROGRAMMES
MEMORANDUM
Academic Year 2023: January - June
Formative Assessment 1: Computer Literacy Advanced
(HCLT108-1)
NQF Level, Credits: 5, 10
Weighting: 25%
Assessment Type: Essay Questions
Educator: I.Musakwa
Examiner: I. Musakwa
Due Date: 31 March 2023
Total: 50 Marks
Instructions:
• This paper consists of three (3) questions.
• It is based on Unit 1 - Unit 5 of your Study Guide.
• All questions are compulsory.
• Submit an excel spreadsheet and a pdf with your answers to all the questions
Learning Outcomes
• Utilise mathematical and statistical functions
• Create, edit, and format charts
• Utilise financial functions (PMT, FV)
1 HCLT108-1-Jan-June2023-FA1-Memo-IM-V.4-14032023
, Question 1 [20]
Cape Distributors is a liquor wholesaler based in Cape Town. Customers who place
the exact order quantities weekly get a 5% discount on their invoice value.
Management has put forward a proposal to apply a 5% discount on invoice values
only above R100 000. Below is the information provided. Answer the following
questions.
Notes: Do not complete calculations manually. Total marks will only be awarded if
formulas are used.
Required:
1.1 Create a spreadsheet with the provided information. (3 marks)
1.2 Arrange the liquor brand in ascending order (2 marks)
1.2 The total quantities of liquor sold. (2 marks)
5 288 (√)(√)(√)
1.3 If a 5% discount is applied to every sales invoice, calculate the discount value.
(3 marks)
R91 731,50(√)(√)
Page 2 of 8 HCLT108-1-Jan-June2023-FA1-Memo-IM-V.4-14032023
MEMORANDUM
Academic Year 2023: January - June
Formative Assessment 1: Computer Literacy Advanced
(HCLT108-1)
NQF Level, Credits: 5, 10
Weighting: 25%
Assessment Type: Essay Questions
Educator: I.Musakwa
Examiner: I. Musakwa
Due Date: 31 March 2023
Total: 50 Marks
Instructions:
• This paper consists of three (3) questions.
• It is based on Unit 1 - Unit 5 of your Study Guide.
• All questions are compulsory.
• Submit an excel spreadsheet and a pdf with your answers to all the questions
Learning Outcomes
• Utilise mathematical and statistical functions
• Create, edit, and format charts
• Utilise financial functions (PMT, FV)
1 HCLT108-1-Jan-June2023-FA1-Memo-IM-V.4-14032023
, Question 1 [20]
Cape Distributors is a liquor wholesaler based in Cape Town. Customers who place
the exact order quantities weekly get a 5% discount on their invoice value.
Management has put forward a proposal to apply a 5% discount on invoice values
only above R100 000. Below is the information provided. Answer the following
questions.
Notes: Do not complete calculations manually. Total marks will only be awarded if
formulas are used.
Required:
1.1 Create a spreadsheet with the provided information. (3 marks)
1.2 Arrange the liquor brand in ascending order (2 marks)
1.2 The total quantities of liquor sold. (2 marks)
5 288 (√)(√)(√)
1.3 If a 5% discount is applied to every sales invoice, calculate the discount value.
(3 marks)
R91 731,50(√)(√)
Page 2 of 8 HCLT108-1-Jan-June2023-FA1-Memo-IM-V.4-14032023
