![]() |
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: |
Using a Graphical User Interface (GUI)-based spreadsheet application, enhance the functionality and apply graph /charts to a spreadsheet |
SAQA US ID | UNIT STANDARD TITLE | |||
116943 | Using a Graphical User Interface (GUI)-based spreadsheet application, enhance the functionality and apply graph /charts to a spreadsheet | |||
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 4 | NQF Level 04 | 3 |
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 does not replace any other unit standard and is not replaced by any other unit standard. |
PURPOSE OF THE UNIT STANDARD |
This unit standard is intended for people who need to enhance spreadsheet appearance 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 |
Specific Outcomes and Assessment Criteria: |
SPECIFIC OUTCOME 1 |
Create and edit a graph. |
OUTCOME RANGE |
Graph refers to all types of graphs and/or charts. |
ASSESSMENT CRITERIA |
ASSESSMENT CRITERION 1 |
The major graph types are defined in terms of their purpose. |
ASSESSMENT CRITERION RANGE |
At least 3 of: Pie, Bar, Column, Line, Scatter, Area. |
ASSESSMENT CRITERION 2 |
A graph is created from a given data source. |
ASSESSMENT CRITERION RANGE |
At least 2 of: Pie, Bar, Column, Line, Scatter, Area. |
ASSESSMENT CRITERION 3 |
A graph is edited. |
ASSESSMENT CRITERION RANGE |
At least 3 of: Graph title, axis titles, data labels, background colour, line or bar colour. |
ASSESSMENT CRITERION 4 |
The graph type is changed. |
ASSESSMENT CRITERION 5 |
A graph is copied and moved based on given specifications. |
ASSESSMENT CRITERION RANGE |
Within a worksheet, to a different worksheet, to a different spreadsheet file. |
ASSESSMENT CRITERION 6 |
A graph is resized. |
ASSESSMENT CRITERION 7 |
A graph is deleted from a spreadsheet. |
SPECIFIC OUTCOME 2 |
Load data from an external data source to produce a given spreadsheet result. |
ASSESSMENT CRITERIA |
ASSESSMENT CRITERION 1 |
The external data file is checked to ensure that the input into a spreadsheet will achieve the required results. |
ASSESSMENT CRITERION 2 |
The format of the input file is determined to ensure correct input into a spreadsheet. |
ASSESSMENT CRITERION RANGE |
Tables from another source. |
ASSESSMENT CRITERION 3 |
The data is copied into the spreadsheet. |
ASSESSMENT CRITERION 4 |
The resulting spreadsheet is in accordance with the given spreadsheet result. |
SPECIFIC OUTCOME 3 |
Insert and edit objects into a spreadsheet. |
OUTCOME RANGE |
Any 2 of the following objects: pictures, images, charts, autoshapes. |
ASSESSMENT CRITERIA |
ASSESSMENT CRITERION 1 |
An object is inserted into a spreadsheet. |
ASSESSMENT CRITERION RANGE |
At least 2 of the following: picture, image, chart, autoshape. |
ASSESSMENT CRITERION 2 |
A selected object is manipulated in a spreadsheet. |
ASSESSMENT CRITERION RANGE |
At least 2 of the following: move, copy, resize. |
ASSESSMENT CRITERION 3 |
Use a drawing tool to draw an object in the spreadsheet. |
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 CCFO DEMONSTRATING |
Demonstrate an understanding of the world as a set of related systems by understanding the application of formats, effects and graphics in documents. |
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 |
Assessor Notes:
The following must be made available to the learner at the start of the assessment: GUI functions like printing, using a pointing device and using the HELP facility are covered in a generic unit standard (ID 117902) and should be assessed as part of the mentioned standard. Possible laws applicable to this standard could include acts like Access to Information Acts; Copyright Acts, Constitution of the Country being assessed in. 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 |
Elective | 50479 | Further Education and Training Certificate: Advertising | Level 4 | NQF Level 04 | Passed the End Date - Status was "Reregistered" |
2023-06-30 | MICTS |
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 | 59037 | Further Education and Training Certificate: Tissue Conversion | Level 4 | NQF Level 04 | Passed the End Date - Status was "Reregistered" |
2015-06-30 | FPMSETA |
Elective | 57631 | National Certificate: Radiation Protection | Level 5 | Level TBA: Pre-2009 was L5 | Passed the End Date - Status was "Reregistered" |
2023-06-30 | EWSETA |
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. | Academy at Vaal Triangle (AVT |
2. | Academy Training Group |
3. | Acorser Corporate & Business Consulting t/a Acorser Academy |
4. | Action for Blind and Disabled |
5. | Action4 |
6. | Affirmations Training |
7. | Africa Learn (Pty) Ltd |
8. | Afrika Tikkun NCC |
9. | All Nation Group Five Trading and Projects |
10. | Amadi Institute of Management And Technology (Pty) Ltd |
11. | Amilak Training Center |
12. | Angie Technologies |
13. | Answer The Call Skills and Entrepreneurship |
14. | ASMO INSTITUTE OF BUSINESS AN |
15. | Aspirations Communication Training CC |
16. | ATTI IT SOLUTIONS (Bloemfontei |
17. | ATTI Nelspruit Pty Ltd |
18. | Atvance Institute (Pty) Ltd |
19. | AVUXENI COMPUTER ACADEMY KZN |
20. | Balefile Trading and Services |
21. | Basadipele Skills Development and Training |
22. | BEE Clinic Pty Ltd |
23. | Bells Technical College |
24. | Bokamoso Skills and Economic Development Centre |
25. | Brainwave Projects 1430 cc |
26. | Business Optimization Training Institute (Pty) Ltd |
27. | Careers IT |
28. | CENTRE FOR EXCELLENCE & PROFESSIONAL TRAINING |
29. | CHILI PEPPER INFORMATION TECHNOLOGY SOLUTIONS |
30. | Claas Illustration |
31. | Clean Heat Academy |
32. | College Africa Group (Pty) Ltd |
33. | Columbus Consulting Pty Ltd |
34. | Common Vision Young Specialist Trading cc |
35. | COMPUSTEPS COLLEGE (PTY) LTD |
36. | CSL Accountants |
37. | CTU Training Solutions |
38. | CYBAX SYSTEMS |
39. | DC Academy (PTY)LTD |
40. | Decade Pulse (Pty) Ltd |
41. | Dee's Training (Pty) Ltd |
42. | Delight Computer Training |
43. | Eagle Computer Training |
44. | Eagle High IT Training |
45. | EAST LONDON MANAGEMENT INSTITUTE |
46. | ED-U Options Academy |
47. | Ekasi IT Solutions Centre |
48. | Ekurhuleni Artisans and Skills Training Centre Pty Ltd |
49. | Elangeni Training Institute |
50. | Elchees Software Solutions |
51. | Emalahleni Institute of Techno |
52. | Epitome Villa (Pty)Ltd |
53. | Eshybrand Pty Ltd |
54. | EYETHU NATIONAL COMPUTER COLLEGE PTY LTD |
55. | Finweb Business Consultancy |
56. | Foster-Melliar (Pty) Ltd |
57. | Fourways Private College |
58. | Futurekids SA (Fochville) |
59. | Genii Institute PTY LTD |
60. | Gigimo Tourism Academy |
61. | Global Institute for Capacity |
62. | Greater Tzaneen Community Foundation |
63. | Gurandbuilt Management Development |
64. | HAVOHEJ CONSULTANCY |
65. | Hazyview Computer College |
66. | Hectic Productions cc |
67. | HILLCROSS BUSINESS SCHOOL (PTY |
68. | Hlanganani ICT (Pty) Ltd |
69. | Home of Compassion/Grace Ministries |
70. | HUAWEI Technologies Africa (PTY) LTD |
71. | Ikusasa Technology Solutions |
72. | Ikusasalethu Youth Development Project NPC |
73. | iLearn Corporate Services PTY LTD |
74. | Information Technology Resource Centre |
75. | Inqubeko Institute (Pty) Ltd |
76. | IT Academy |
77. | IT-HI-Q Training (PTY) Ltd |
78. | Iyam Training Services |
79. | Jeppe College of Commerce and |
80. | K Boneng Consulting Services P |
81. | K Centre Business Enterprise (PTY) LTD |
82. | Keybase Training Solutions Cc |
83. | KN Training Specialist |
84. | KT Mobile Services |
85. | Kundani Trading |
86. | L and P Computer Academy Pty Ltd |
87. | LETAGO DEVELOPMENT CONSULTING |
88. | LIMPOPO COMPUTER COLLEGE BK |
89. | LINDAMAHLE MANAGEMENT SYSTEMS (PTY) LTD |
90. | Loomee Group |
91. | LYFE COMPUTER TECHNOLOGIES (PTY) LTD |
92. | Makhophila Training |
93. | Malope It Solutions (Pty) Ltd |
94. | Masakhane Training and Consult |
95. | Mash Computer Training |
96. | MBOWA COLLEGE PTY LTD |
97. | Metanoia Ratings PTY LTD |
98. | MMELA VILLAGE TECHNOLOGIES (PT |
99. | MND Training and Projects |
100. | Mogapi Education Group (Pty) Ltd |
101. | Motlhamme Executive Management |
102. | Moving Ahead Development Agenc |
103. | MP Avuxeni Computer Academy |
104. | Mpande Technologies cc |
105. | Mufuka Business and Technical |
106. | Musengavhadzimu Media |
107. | Natfin Holdings Pty Ltd |
108. | NBC Technologies |
109. | NCC - Vereeniging |
110. | NCM Computer and Business Academy |
111. | Ndulita Solutions |
112. | New Era Computer Training Centre (Hidobyte CC) |
113. | New Link Computer Skills |
114. | Nolwazi Stem Education for The |
115. | Ntamunde Investment |
116. | Ntandokazi Holdings Pty Ltd |
117. | NW Avuxeni Computer Academy |
118. | Nyankwavi Inverstment |
119. | Nyathela Business College |
120. | Olrich Home of Technology |
121. | On the Ball College Pty ltd |
122. | OPELONG BUSINESS INSTITUTE (PT |
123. | Paramixed Pty Ltd |
124. | Parkton College of Catering & Tourism Studies |
125. | Peo Entle HIV Wellness Management and Youth Skills Development NPO |
126. | Pioneer Business Consulting |
127. | Polokwane Technology Institute (Pty) Ltd |
128. | Pretoria Technical College |
129. | Priha Projects Pty Ltd |
130. | Progressive School of Business |
131. | Prophesy Training College (Pty) Ltd |
132. | PRX SCHOOL TEST |
133. | QUALITATIVE INNOVATIVE SOLUTIONS |
134. | QUARPHIX (PTY) LTD |
135. | Ramotec Business College |
136. | Rand Training College |
137. | Redefine Human Capital (PTY) L |
138. | Richfield Graduate Institute of Technology Pty Ltd |
139. | Rostec Technical FET College (Pty) Ltd |
140. | Sabile Human Resources Consult |
141. | SANDM IT TRAINING (PTY) LTD |
142. | SED Computer Academy |
143. | Sesk Facilitation Development (PTY) LTD |
144. | Silulo Ulutho Technologies |
145. | Sisekelo Sustainability Institute |
146. | SIYAFUNDA COMMUNITY TECHNOLOGY CENTRE NPC |
147. | SOUTH AFRICAN CORPORATE TRAINING ASSOCIATION (PTY) LTD |
148. | Spears Business and Life Couch Consulting (Pty) Ltd |
149. | SPLS Consultants (Pty) Ltd |
150. | SUCCESS BUILDERS INTERNATIONAL CC |
151. | Success Christian Training Cen |
152. | Succinct Investments (Pty) Ltd |
153. | SUPREME ICT CONSULTANTS |
154. | Synergistic Covenant Network NPO |
155. | Tech-Com Solutions cc |
156. | Techtisa (pty) Ltd |
157. | Terrawood |
158. | Terry Computer Services cc |
159. | Thalita Koume Directions (Pty) Ltd |
160. | The Finishing College (Pty) Lt |
161. | Think Tank T2 (Pty) Ltd |
162. | Titan Trade Technologies |
163. | Tlou Foundation College |
164. | TORQUE TECHNICAL COMPUTER TRAINING PTY LTD |
165. | Tshwane College of Commerce an |
166. | Tsima Consulting Development S |
167. | TSP COLLEGE |
168. | TURFLOOP TRAINING SERVICES CC |
169. | Ubuhlanti Sances Trading (Pty) Ltd |
170. | Ukwazi Academy and Corporate S |
171. | Umbrella Training and Development |
172. | Umbusi Consulting Services |
173. | UTHINGO BRITE SERVICES |
174. | Varsity Institute of Science & Technology (Pty)Ltd |
175. | Visionary Skill Academy |
176. | Vukani Solutions |
177. | VUTHLARI MARKETING CONSULTING |
178. | Waterberg TVET College |
179. | Wellinkwise Pty Ltd |
180. | Whitestone College |
181. | WORK SKILLS RESOURCES CC |
182. | Working Solution International |
183. | Xylo Trading 12 (Pty) Ltd |
184. | YITRO INNOVATIONS |
185. | Yonet Training Academy |
186. | ZA WIT (PTY) LTD |
187. | Zealot Business College |
188. | Zikode Development Trust |
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. |