![]() |
All qualifications and part qualifications registered on the National Qualifications Framework are public property. Thus the only payment that can be made for them is for service and reproduction. It is illegal to sell this material for profit. If the material is reproduced or quoted, the South African Qualifications Authority (SAQA) should be acknowledged as the source. |
SOUTH AFRICAN QUALIFICATIONS AUTHORITY |
REGISTERED UNIT STANDARD THAT HAS PASSED THE END DATE: |
Use a Graphical User Interface (GUI)-based spreadsheet application to solve a given problem |
SAQA US ID | UNIT STANDARD TITLE | |||
116940 | Use a Graphical User Interface (GUI)-based spreadsheet application to solve a given problem | |||
ORIGINATOR | ||||
SGB Computer Sciences and Information Systems | ||||
PRIMARY OR DELEGATED QUALITY ASSURANCE FUNCTIONARY | ||||
- | ||||
FIELD | SUBFIELD | |||
Field 10 - Physical, Mathematical, Computer and Life Sciences | Information Technology and Computer Sciences | |||
ABET BAND | UNIT STANDARD TYPE | PRE-2009 NQF LEVEL | NQF LEVEL | CREDITS |
Undefined | Regular-Fundamental | Level 3 | NQF Level 03 | 6 |
REGISTRATION STATUS | REGISTRATION START DATE | REGISTRATION END DATE | SAQA DECISION NUMBER | |
Passed the End Date - Status was "Reregistered" |
2018-07-01 | 2023-06-30 | SAQA 06120/18 | |
LAST DATE FOR ENROLMENT | LAST DATE FOR ACHIEVEMENT | |||
2026-06-30 | 2029-06-30 |
In all of the tables in this document, both the pre-2009 NQF Level and the NQF Level is shown. In the text (purpose statements, qualification rules, etc), any references to NQF Levels are to the pre-2009 levels unless specifically stated otherwise. |
This unit standard replaces: |
US ID | Unit Standard Title | Pre-2009 NQF Level | NQF Level | Credits | Replacement Status |
7567 | Produce and use spreadsheets for business | Level 3 | NQF Level 03 | 5 |
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: The performance of all elements is to a standard that allows for further learning in this area. |
LEARNING ASSUMED TO BE IN PLACE AND RECOGNITION OF PRIOR LEARNING |
The credit value of this unit standard is calculated assuming a person is competent in:
|
UNIT STANDARD RANGE |
This standard is applicable to any spreadsheet application that runs on any Graphical User Interface(GUI) operating system:
|
Specific Outcomes and Assessment Criteria: |
SPECIFIC OUTCOME 1 |
Prepare and produce a spreadsheet to provide a solution to a given problem. |
ASSESSMENT CRITERIA |
ASSESSMENT CRITERION 1 |
An outline solution is developed to meet the requirements of a given brief. |
ASSESSMENT CRITERION 2 |
The spreadsheet produced addresses the given problem. |
SPECIFIC OUTCOME 2 |
Adjust settings to customise the view and preferences of the spreadsheet application to suite the solution created for the given problem. |
ASSESSMENT CRITERIA |
ASSESSMENT CRITERION 1 |
Toolbar menus are switched off and on. |
ASSESSMENT CRITERION 2 |
The view of the spreadsheet is enlarged and made smaller. |
ASSESSMENT CRITERION 3 |
The way that the spreadsheet is viewed is changed. |
ASSESSMENT CRITERION 4 |
Cells are frozen to prevent scrolling. |
ASSESSMENT CRITERION RANGE |
Row, column, both. |
ASSESSMENT CRITERION 5 |
The default file location is changed. |
ASSESSMENT CRITERION 6 |
A user name is added to the file. |
SPECIFIC OUTCOME 3 |
Work with multiple worksheets to suite the solution to the given problem. |
ASSESSMENT CRITERIA |
ASSESSMENT CRITERION 1 |
The purpose of using multiple worksheets within one spreadsheet file are explained with examples. |
ASSESSMENT CRITERION 2 |
New worksheets are opened. |
ASSESSMENT CRITERION RANGE |
Minimum 3 worksheets. |
ASSESSMENT CRITERION 3 |
Worksheets are renamed in terms of their purpose within the solution to the given problem. |
ASSESSMENT CRITERION RANGE |
Each worksheet to have a different name, with a purpose within the solution. |
ASSESSMENT CRITERION 4 |
Cells are manipulated between worksheets. |
ASSESSMENT CRITERION RANGE |
Cell range at least two of:
Type of manipulation: |
ASSESSMENT CRITERION 5 |
A worksheet within a workbook (or spreadsheet) is deleted. |
SPECIFIC OUTCOME 4 |
Apply formulae to worksheets to provide alternative solutions to the given problem. |
OUTCOME RANGE |
Formulae to include at least 3 of:
|
ASSESSMENT CRITERIA |
ASSESSMENT CRITERION 1 |
Formulae are entered taking into consideration the natural order of operation. |
ASSESSMENT CRITERION 2 |
Formulae are entered to deliberately change the natural order of operation. |
ASSESSMENT CRITERION 3 |
Formula error messages are correctly interpreted and the formula corrected accordingly. |
ASSESSMENT CRITERION 4 |
The difference between relative and absolute cell addressing is demonstrated by using it in a formula. |
ASSESSMENT CRITERION 5 |
Data are changed to test possible solutions to the given problem without having to change formulae. |
ASSESSMENT CRITERION 6 |
Scenarios are created that demonstrate different possible outcomes. |
SPECIFIC OUTCOME 5 |
Apply simple built-in functions of the spreadsheet application to the given problem. |
ASSESSMENT CRITERIA |
ASSESSMENT CRITERION 1 |
Functions are explained in terms of their purpose, use and construct. |
ASSESSMENT CRITERION RANGE |
At least one function to be used as an example. |
ASSESSMENT CRITERION 2 |
Simple Mathematical functions are applied to the given problem. |
ASSESSMENT CRITERION RANGE |
At least the following functions:
|
ASSESSMENT CRITERION 3 |
Statistical functions are applied that achieve the anticipated result. |
ASSESSMENT CRITERION RANGE |
At least two of the following functions:
|
SPECIFIC OUTCOME 6 |
Apply formatting to a spreadsheet applicable to the given problem. |
ASSESSMENT CRITERIA |
ASSESSMENT CRITERION 1 |
Methods of automatically formatting a spreadsheet are explained. |
ASSESSMENT CRITERION RANGE |
Templates, styles, manual. |
ASSESSMENT CRITERION 2 |
A spreadsheet is created using a template. |
ASSESSMENT CRITERION 3 |
Cells are formatted using styles. |
ASSESSMENT CRITERION RANGE |
Number, date, currency, percentage. |
ASSESSMENT CRITERION 4 |
Formats are copied between cells. |
SPECIFIC OUTCOME 7 |
Use special effects to improve the presentation of the spreadsheet. |
ASSESSMENT CRITERIA |
ASSESSMENT CRITERION 1 |
Text is centered across a cell range. |
ASSESSMENT CRITERION 2 |
Orientation of text within a cell is changed. |
ASSESSMENT CRITERION 3 |
A border is applied to cells and removed from cells. |
ASSESSMENT CRITERION RANGE |
Cell, range of cells, entire column, entire row. |
ASSESSMENT CRITERION 4 |
Fill (shading) is applied to cells and removed from cells. |
ASSESSMENT CRITERION RANGE |
Cell, range of cells, entire column, entire row. |
SPECIFIC OUTCOME 8 |
Evaluate a spreadsheet to comply with the given problem. |
ASSESSMENT CRITERIA |
ASSESSMENT CRITERION 1 |
The spreadsheet is evaluated for compliance with a given problem, appropriate formatting, readability, legibility, presentation, accuracy, and data integrity. |
ASSESSMENT CRITERION 2 |
The spreadsheet is modified if required and compliance with the brief is confirmed. |
UNIT STANDARD ACCREDITATION AND MODERATION OPTIONS |
The relevant Education and Training Quality Authority (ETQA) must accredit providers before they can offer programmes of education and training assessed against unit standards.
Moderation Process: |
UNIT STANDARD ESSENTIAL EMBEDDED KNOWLEDGE |
UNIT STANDARD DEVELOPMENTAL OUTCOME |
N/A |
UNIT STANDARD LINKAGES |
N/A |
Critical Cross-field Outcomes (CCFO): |
UNIT STANDARD CCFO IDENTIFYING |
Identify and solve problems in which responses display that decisions using critical and creative thinking have been made by using a spreadsheet application to perform calculations. |
UNIT STANDARD CCFO ORGANISING |
Organise and manage oneself and one`s activities responsibly and effectively by using a spreadsheet application to organize information into rows and columns for a specific purpose. |
UNIT STANDARD CCFO COLLECTING |
Collect, analyse, organise, and critically evaluate information by using a spreadsheet application to organize and perform calculations. |
UNIT STANDARD CCFO COMMUNICATING |
Communicate effectively using visual, mathematical and/or language skills in the modes of oral and/or written persuasion when engaging with the subject by using a spreadsheet application to organize information into rows and columns for a specific purpose to each communication. |
UNIT STANDARD CCFO SCIENCE |
Use science and technology effectively and critically, showing responsibility towards the environment and health of others by using a spreadsheet application effectively. |
UNIT STANDARD ASSESSOR CRITERIA |
N/A |
REREGISTRATION HISTORY |
As per the SAQA Board decision/s at that time, this unit standard was Reregistered in 2012; 2015. |
UNIT STANDARD NOTES |
This unit standard replaces unit standard 7567, "Produce and use spreadsheets for business", Level 3, 5 credits.
Assessor Notes: Abbreviations: |
QUALIFICATIONS UTILISING THIS UNIT STANDARD: |
ID | QUALIFICATION TITLE | PRE-2009 NQF LEVEL | NQF LEVEL | STATUS | END DATE | PRIMARY OR DELEGATED QA FUNCTIONARY | |
Core | 61591 | National Certificate: Information Technology: End User Computing | Level 3 | NQF Level 03 | Passed the End Date - Status was "Reregistered" |
2023-06-30 | As per Learning Programmes recorded against this Qual |
Core | 49155 | Further Education and Training Certificate: Shipping | Level 4 | NQF Level 04 | Passed the End Date - Status was "Reregistered" |
2023-06-30 | TETA |
Elective | 58975 | National Certificate: Automated Packaging Operations | Level 3 | NQF Level 03 | Passed the End Date - Status was "Reregistered" |
2023-06-30 | As per Learning Programmes recorded against this Qual |
Elective | 58375 | National Certificate: Bookkeeping | Level 3 | NQF Level 03 | Passed the End Date - Status was "Reregistered" |
2023-06-30 | FASSET |
Elective | 50308 | National Certificate: Bread and Flour Confectionery Baking | Level 3 | NQF Level 03 | Passed the End Date - Status was "Reregistered" |
2023-06-30 | FOODBEV |
Elective | 74189 | National Certificate: Cereals, Snacks, Pasta and Condiments Manufacturing | Level 3 | NQF Level 03 | Passed the End Date - Status was "Reregistered" |
2023-06-30 | FOODBEV |
Elective | 78528 | National Certificate: Chemical Operations | Level 3 | NQF Level 03 | Passed the End Date - Status was "Reregistered" |
2023-06-30 | As per Learning Programmes recorded against this Qual |
Elective | 58537 | National Certificate: Chemical Operations | Level 3 | NQF Level 03 | Passed the End Date - Status was "Registered" |
2009-06-17 | Was CHIETA until Last Date for Achievement |
Elective | 93997 | National Certificate: Contact Centre and Business Process Outsourcing Support | Level 3 | NQF Level 03 | Passed the End Date - Status was "Reregistered" |
2023-07-30 | As per Learning Programmes recorded against this Qual |
Elective | 49752 | National Certificate: Environmental Practice | Level 3 | NQF Level 03 | Passed the End Date - Status was "Reregistered" |
2023-06-30 | LG SETA |
Elective | 58882 | National Certificate: Fluid Power | Level 3 | NQF Level 03 | Passed the End Date - Status was "Reregistered" |
2023-06-30 | MERSETA |
Elective | 66449 | National Certificate: Foundry Operations | Level 3 | NQF Level 03 | Passed the End Date - Status was "Reregistered" |
2013-11-07 | MERSETA |
Elective | 59386 | National Certificate: Fresh Meat Processing | Level 3 | NQF Level 03 | Passed the End Date - Status was "Reregistered" |
2023-06-30 | FOODBEV |
Elective | 58950 | National Certificate: Gas Installations | Level 3 | NQF Level 03 | Passed the End Date - Status was "Reregistered" |
2023-06-30 | CHIETA |
Elective | 57828 | National Certificate: Glass Forming | Level 3 | NQF Level 03 | Passed the End Date - Status was "Reregistered" |
2023-06-30 | CHIETA |
Elective | 57880 | National Certificate: Meat Processing | Level 3 | NQF Level 03 | Passed the End Date - Status was "Reregistered" |
2023-06-30 | FOODBEV |
Elective | 50285 | National Certificate: Professional Driving | Level 3 | NQF Level 03 | Passed the End Date - Status was "Reregistered" |
2023-06-30 | TETA |
Elective | 50398 | National Certificate: Project Support Service | Level 3 | NQF Level 03 | Passed the End Date - Status was "Reregistered" |
2023-06-30 | SERVICES |
Elective | 61971 | National Certificate: Pulp and Paper Operations | Level 3 | NQF Level 03 | Passed the End Date - Status was "Reregistered" |
2023-06-30 | FPMSETA |
Elective | 48654 | National Certificate: Seed Analysis | Level 3 | NQF Level 03 | Passed the End Date - Status was "Reregistered" |
2023-06-30 | AgriSETA |
Elective | 50543 | National Certificate: Small Craft Construction | Level 3 | NQF Level 03 | Passed the End Date - Status was "Registered" |
2009-08-31 | Was MERSETA until Last Date for Achievement |
Elective | 63929 | National Certificate: Spirits Production | Level 3 | NQF Level 03 | Passed the End Date - Status was "Reregistered" |
2023-06-30 | FOODBEV |
Elective | 63869 | National Certificate: Winemaking | Level 3 | NQF Level 03 | Passed the End Date - Status was "Reregistered" |
2023-06-30 | FOODBEV |
Elective | 58376 | Further Education and Training Certificate: Bookkeeping | Level 4 | NQF Level 04 | Passed the End Date - Status was "Reregistered" |
2023-06-30 | FASSET |
Elective | 67461 | Further Education and Training Certificate: Event Support | Level 4 | NQF Level 04 | Passed the End Date - Status was "Reregistered" |
2023-06-30 | As per Learning Programmes recorded against this Qual |
Elective | 61450 | Further Education and Training Certificate: Film and Television Production Operations | Level 4 | NQF Level 04 | Passed the End Date - Status was "Reregistered" |
2023-06-30 | MICTS |
Elective | 66489 | Further Education and Training Certificate: Foundry Operations | Level 4 | NQF Level 04 | Passed the End Date - Status was "Reregistered" |
2013-11-07 | MERSETA |
Elective | 50021 | Further Education and Training Certificate: Inspection and Assessment (Non-Metallics) | Level 4 | NQF Level 04 | Passed the End Date - Status was "Reregistered" |
2023-06-30 | MERSETA |
Elective | 48651 | Further Education and Training Certificate: Meat Classification | Level 4 | NQF Level 04 | Passed the End Date - Status was "Reregistered" |
2023-06-30 | AgriSETA |
Elective | 77963 | Further Education and Training Certificate: Mining/Exploration Geology | Level 4 | NQF Level 04 | Passed the End Date - Status was "Reregistered" |
2023-06-30 | MQA |
Elective | 49553 | Further Education and Training Certificate: Pipeline Operations | Level 4 | NQF Level 04 | Passed the End Date - Status was "Reregistered" |
2016-12-31 | TETA |
Elective | 50329 | Further Education and Training Certificate: Radiation Protection | Level 4 | NQF Level 04 | Passed the End Date - Status was "Reregistered" |
2023-06-30 | EWSETA |
Elective | 65949 | Further Education and Training Certificate: Supervision of Construction Processes | Level 4 | NQF Level 04 | Passed the End Date - Status was "Reregistered" |
2023-06-30 | CETA |
PROVIDERS CURRENTLY ACCREDITED TO OFFER THIS UNIT STANDARD: |
This information shows the current accreditations (i.e. those not past their accreditation end dates), and is the most complete record available to SAQA as of today. Some Primary or Delegated Quality Assurance Functionaries have a lag in their recording systems for provider accreditation, in turn leading to a lag in notifying SAQA of all the providers that they have accredited to offer qualifications and unit standards, as well as any extensions to accreditation end dates. The relevant Primary or Delegated Quality Assurance Functionary should be notified if a record appears to be missing from here. |
1. | A4 Consultancy CC |
2. | Academy at Vaal Triangle (AVT |
3. | Academy for Construction Skills (Pty) Ltd (ACS) |
4. | Action for Blind and Disabled |
5. | Akane Training Academy |
6. | Andebe Training and Skills Development |
7. | Aspirations Communication Training CC |
8. | Atvance Institute (Pty) Ltd |
9. | AVAX SA 481 CC. T/A Mandisa Development Services |
10. | Balefile Trading and Services |
11. | BANA BA THARI MINING TRANING AND DEVELOPMENT ACADEMY |
12. | Bephaswana Skills Development (Pty) Ltd |
13. | BLC Entertainment |
14. | Blue Crane Skills Development |
15. | Bokamoso Skills and Economic Development Centre |
16. | BPO Skills Academy Pty Ltd |
17. | Buena Vista Learning Academy |
18. | Centre for Logistics Excellence (Pty) Ltd |
19. | Clearline Consulting Pty Ltd |
20. | College Africa Group (Pty) Ltd |
21. | CSL Accountants |
22. | CSS Credit Solutions Services (Pty) Ltd |
23. | Eagle Computer Training |
24. | Edu Power Skills Academy |
25. | Ekasi IT Solutions Centre |
26. | Ekurhuleni Artisans and Skills Training Centre Pty Ltd |
27. | Elangeni Training Institute |
28. | Elchees Software Solutions |
29. | ERGO BUSINESS DEVELOPMENT ACADEMY NPC |
30. | Eshybrand Pty Ltd |
31. | ESS Holdings (PTY) Ltd |
32. | EYETHU NATIONAL COMPUTER COLLEGE PTY LTD |
33. | Felix Risk Training Consultants |
34. | Finweb Business Consultancy |
35. | Foster-Melliar (Pty) Ltd |
36. | Fourways Private College |
37. | Furniture World Training Centre |
38. | Global Institute for Capacity |
39. | GOLDEN ARROW BUS SERVICES PTY LTD |
40. | Golden Arrow Bus Services_pty Ltd |
41. | GREENRIM TRAINING PTY LTD |
42. | Growth Link |
43. | Growth Management Consulting |
44. | HAVOHEJ CONSULTANCY |
45. | Hazyview Computer College |
46. | HCI Skills Training Pty Ltd |
47. | He and She Driver Training Centre |
48. | HILLCROSS BUSINESS SCHOOL (PTY |
49. | Hlanganani ICT (Pty) Ltd |
50. | Ikusasa Lethu Projects and Training (Pty) Ltd |
51. | Ikusasalethu Youth Development Project NPC |
52. | Inkqubela Consultants |
53. | Inqubeko Institute (Pty) Ltd |
54. | Intercept Consulting and Training Solutions |
55. | IQ Skills Academy (PTY) LTD. |
56. | IT Academy |
57. | IT Portal |
58. | Jeppe College of Commerce and |
59. | Jobafrik Consulting |
60. | Josmap Training Institute |
61. | K Boneng Consulting Services P |
62. | K Centre Business Enterprise (PTY) LTD |
63. | Kahisano Skills Development and Training |
64. | Kay Beez Development Projects |
65. | KOKANO PROJECTS PTY LTD |
66. | Learning and Performance Academy |
67. | Lewerb Holdings (PTY) Ltd |
68. | Little Treehouse Holdings (PTY) Ltd |
69. | Loomee Group |
70. | Madidi Supply Chain Institute & Business Consultant |
71. | Masakhane Training and Consult |
72. | MD TRAINING SERVICES (PTY) LTD |
73. | Mementos Training Pty Ltd |
74. | METSKILL PTY LTD |
75. | Mogapi Education Group (Pty) Ltd |
76. | Mortarboard Training Solutions |
77. | Moving Ahead Development Agenc |
78. | MSPD Consulting(Pty)Ltd |
79. | Musengavhadzimu Media |
80. | Natfin Holdings Pty Ltd |
81. | Ndulita Solutions |
82. | Nemalale Eagles Consultancy CC |
83. | P and R Development and Training (Pty) Ltd |
84. | PAL PASSENGER BUS SERVICES |
85. | PFIM Trading (Pty) Ltd |
86. | Phephani Learnerships cc |
87. | Polokwane Technology Institute (Pty) Ltd |
88. | Progressive School of Business |
89. | PRX SCHOOL TEST |
90. | Quality Solutions |
91. | Quantum Leap College Pty Ltd |
92. | QUARPHIX (PTY) LTD |
93. | Redefine Human Capital (PTY) L |
94. | Richfield Graduate Institute of Technology Pty Ltd |
95. | Rostec Technical FET College (Pty) Ltd |
96. | Royal Impression Academy |
97. | RUDO CONSULTING cc |
98. | Sabile Human Resources Consult |
99. | SADHANA GOVENDER PROJECT CONSULTANTS (PTY)LTD |
100. | Safe and Eco Driving Pty Ltd |
101. | SANDM IT TRAINING (PTY) LTD |
102. | SC Training |
103. | Selldirect Marketing (Pty) Ltd |
104. | Sherq Technical Solutions (Pty) Ltd. |
105. | Silulo Ulutho Technologies |
106. | Simmek Holdings |
107. | South African Transport Centre of Excellence |
108. | SPINA Consultancy cc Cape Town |
109. | Synergistic Covenant Network NPO |
110. | Techtisa (pty) Ltd |
111. | Thando Consulting Services |
112. | The Finishing College (Pty) Lt |
113. | Thwala Training Services (Pty) Ltd |
114. | Titan Trade Technologies |
115. | TLD Consulting |
116. | TORQUE TECHNICAL COMPUTER TRAINING PTY LTD |
117. | Twin Mark Strategy and Management Consultants (Pty) Ltd |
118. | Ucademy Pty Ltd |
119. | Ukwakhile Projects Pty Ltd |
120. | UNIVERSITY OF BUSINESS EXCELLENCE(PTY)LTD |
121. | University of Venda |
122. | Varsity Institute of Science & Technology (Pty)Ltd |
123. | VEB CELE & ASSOCIATES PTY LTD |
124. | Vleisopleidingsentrum cc. |
125. | VSL General Trading CC |
126. | Wellinkwise Pty Ltd |
127. | Whitestone College |
128. | ZA WIT (PTY) LTD |
129. | Zealot Business College |
All qualifications and part qualifications registered on the National Qualifications Framework are public property. Thus the only payment that can be made for them is for service and reproduction. It is illegal to sell this material for profit. If the material is reproduced or quoted, the South African Qualifications Authority (SAQA) should be acknowledged as the source. |