116940 – Use a Graphical User Interface (GUI)-based spreadsheet application to solve a given problem – NQF Level 03 – CREDITS -3
People credited with this unit standard are able to:
- Prepare and produce a spreadsheet to provide a solution to a given problem.
- Adjust settings to customise the view and preferences of the spreadsheet application.
- Work with multiple worksheets.
- Apply formulae to worksheets to provide alternative solutions to a problem.
- Apply simple built-in functions of the spreadsheet application to the given problem.
- Apply formatting to a spreadsheet applicable to the given problem.
- Use special effects to improve the presentation of the spreadsheet.
- Evaluate a spreadsheet.
-
Untitled
-
Poe guide
- 116940 -2-1 CONTACT DETAILS
- 116940-2-2 COMPETENCE
- 116940-2-3 ASSESSMENT PREPARATION
- 116940-2-4 AGREED ASSESSMENT PLAN
- 116940-2-5 Interview (RPL Purposes)
- 116943-116940-2-6 LETTER OF COMMITMENT FROM THE LEARNER
- 116940-2-7 Declaration of Authenticity
- 116940-2-8 PORTFOLIO BUILDING
- 116940-2-9 RECORD OF LEARNING
- 116943-116940-2-10 ASSESSMENT DECISION & EVIDENCE EVALUATION RECORD
- 116943-116940-2-11 Assessor’s feedback report to the candidate
- 116943-116940-2-12 Moderator’s Report
- -116940-2-13 ASSESSMENT REVIEW
- -116940-2-14 Candidate Appeal Form
- -116940-2-15 Assessor’s Contingency Plan
-
Leaner Guide
- 116940-2-1 SayPro Lesson Setting Up Your Excel Environment
- 116940-2-2 SayPro Lesson Starting a Workbook
- 116940-2-3 SayPro Lesson Adjusting settings to preferences
- 116940-2-4 SayPro Lesson Working with Worksheets
- 116940-2-5 SayPro Lesson Creating Simple Formulas
- 116940-2-6 SayPro Lesson Creating Complex Formulas
- 116940-2-7 SayPro Lesson Working with Basic Functions
- 116940-2-8 SayPro Lesson Using Templates
- 116940-2-9 SayPro Lesson Aligning Text and cell
- 116940-2-10 SayPro Lesson Working with Cells
- 116940-2-11 SayPro Lesson Evaluating the accuracy of a spreadsheet
-
Formative Assessment-Pre-Assignment
- 116940-3-1 Formative Assessment Question 1 (SO 1, AC 2)
- 116940-3-2 Formative Assessment Question 2 (SO 2, AC 2)
- 116940-3-3 Formative Assessment Question 3 (SO 2, AC 2)
- 116940-3-4 Formative Assessment Question 4 (SO 2, AC 5)
- 116940-3-5 Formative Assessment Question 5 (SO 3, AC 1)
- 116940-3-6 Formative Assessment Question 6 (SO 4, AC 3)
- 116940-3-7 Formative Assessment Question 7 (SO 5, AC 1)
- 116940-3-8 Formative Assessment Question 8 (SO 7, AC 3)
-
Summative Assessment
- 116940-4-1 Summative Assessment Question 1 (SO 1, AC 1, AC 2; SO 2, AC 1, AC 2, AC 3, AC 4, AC 5, AC 6)
- 116940-4-2 Summative Assessment Question 2 (SO 3, AC 1, AC 2, AC 3, AC 4, AC 5)
- 116940-4-3 Summative Assessment Question 3 (SO 4, AC 1, AC 2, AC 3, AC 4, AC 5, AC 6)
- 116940-4-4 Summative Assessment Question 4 (SO 5, AC 1, AC 2, AC 3; SO 6, AC 3, AC 4, SO 7, AC 1, AC 2, AC 3, AC 4, SO 8, AC 1, AC 2)
- 116940-4-5 Summative Assessment Question 5 (SO 6, AC 1, AC 2)
-
Suggestions and Improvement
- 116940-5-1 What did you like about this course.Accept and comment below.
- 116940-5-2 What other courses do you think we can add. Accept and comment below
- 116940-5-3 What can you suggest more to Southern Africa Youth Academy. Accept and comment below
- 116940-5-4 What do you suggest we can do in future to improve our services. Accept and comment below.
