Requirements
- National Identity Document, Passport, Work Permit or Asylum
- Have physical Address where you will receive a certificate
- Have a functioning cell phone number and the email address
Target audiences
- All Ages Qualify
- Everyone Qualifies for our Courses
- All countries qualifies for our Courses
SAQA ID: 116940 Use a Graphical User Interface (GUI)-based spreadsheet application to solve a given problemĀ NQF Level 03 Credits 06
PURPOSE OF THE UNIT STANDARD
This unit standard is intended for people who need to plan, produce, use and spreadsheets to solve problems using a Graphical User Interface (GUI)-based spreadsheet application either as a user of computers or as basic knowledge for a career needing this competency, like the ICT industry.
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.
-
Portfolio of Evidence Guide
- 116940-669784B – 0-0 SayPro Announcement
- 116940-669874B-1-1 CONTACT DETAILS
- 116940-669874B-1-2 COMPETENCE
- 116940-669874B-1-3 ASSESSMENT STRATEGY
- 116940-669874B-1-4 ASSESSMENT PREPARATION
- 116940-669874B-1-5 AGREED ASSESSMENT PLAN
- 116940-669874B-1-6 Interview (RPL Purposes)
- 116940-669874B-1-7 LETTER OF COMMITMENT FROM THE LEARNER
- 116940-669874B-1-8 Declaration of Authenticity
- 116940-669874B-1-9 PORTFOLIO BUILDING
- 116940-669874B-1-10 RECORD OF LEARNING
- 116940-669874B-1-11 ASSESSMENT DECISION & EVIDENCE EVALUATION RECORD
- 116940-669874B-1-12 Assessor’s feedback report to the candidate
- 116940-669874B-1-13 Moderator’s Report
- 116940-669874B-1-14 ASSESSMENT REVIEW
- 116940-669874B-1-15 Candidate Appeal Form
- 116940-669874B-1-16 Assessor’s Contingency Plan
-
Learner Guide
- 116940-669874B-2-1 SayPro Lesson Setting Up Your Excel Environment
- 116940-669874B-2-2 SayPro Lesson Starting a Workbook
- 116940-669874B-2-3 SayPro Lesson Adjusting settings to preferences
- 116940-669874B-2-4 SayPro Lesson Working with Worksheets
- 116940-669874B-2-5 SayPro Lesson Creating Simple Formulas
- 116940-669874B-2-6 SayPro Lesson Creating Complex Form
- 116940-669874B-2-8 SayPro Lesson Using Templates
- 116940-669874B-2-9 SayPro Lesson Aligning Text and cell
- 116940-669874B-2-10 SayPro Lesson Working with Cells
- 116940-669874B-2-11 SayPro Lesson Evaluating the accuracy of a spreadsheet
-
Formative Assessment-Pre -Assignment
- 116940-669874B-3-1 Formative Assessment Question 1 (SO 1, AC 2)
- 116940-669874B-3-2 Formative Assessment Question 2 (SO 2, AC 2)
- 116940-669874B-3-3 Formative Assessment Question 3 (SO 2, AC 2)
- 116940-669874B-3-4 Formative Assessment Question 4 (SO 2, AC 5)
- 116940-669874B-3-5 Formative Assessment Question 5 (SO 3, AC 1)
- 116940-669874B-3-6 Formative Assessment Question 6 (SO 4, AC 3)
- 116940-669874B-3-7 Formative Assessment Question 7 (SO 5, AC 1)
- 116940-669874B-3-8 Formative Assessment Question 8 (SO 7, AC 3)
-
Summative Assessment
- 116940-669874B-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-669874B-4-2 Summative Assessment Question 2 (SO 3, AC 1, AC 2, AC 3, AC 4, AC 5)
- 116940-669874B-4-3 Summative Assessment Question 3 (SO 4, AC 1, AC 2, AC 3, AC 4, AC 5, AC 6)
- 116940-669874B-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-669874B-4-5 Summative Assessment Question 5 (SO 6, AC 1, AC 2)
-
suggestions and improvements
- 116940-669874B-5-1 Course Evaluation Form
- 116940-669874B-5-2 What other courses do you think we can add. Accept and comment below
- 116940-669874B-5-3 What can you suggest more to Southern Africa Youth Academy. Accept and comment below
- 116940-669874B-5-4 What do you suggest we can do in future to improve our services. Accept and comment below