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: |
Manipulate data and ensure integrity |
SAQA US ID | UNIT STANDARD TITLE | |||
258882 | Manipulate data and ensure integrity | |||
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 | Level 4 | NQF Level 04 | 4 |
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 | |||
2024-06-30 | 2027-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 produce and/or modify sophisticated spreadsheets in a variety of industry and economic sectors.
A person credited with this unit standard is capable of: |
LEARNING ASSUMED TO BE IN PLACE AND RECOGNITION OF PRIOR LEARNING |
It is assumed that the learner is competent in the following:
|
UNIT STANDARD RANGE |
Specific Outcomes and Assessment Criteria: |
SPECIFIC OUTCOME 1 |
Validate and sort data in a spreadsheet. |
ASSESSMENT CRITERIA |
ASSESSMENT CRITERION 1 |
Data validation is applied to data in a spreadsheet to ensure consistency and integrity. |
ASSESSMENT CRITERION RANGE |
Data validation includes but not limited to text length (must be limited to at least ten [10] characters). |
ASSESSMENT CRITERION 2 |
Validated data properties are edited in accordance with user requirements. |
ASSESSMENT CRITERION 3 |
Data validation is removed from data in accordance with changing spreadsheet requirements. |
ASSESSMENT CRITERION 4 |
A simple data sort is performed in order to organise information for ease access. |
ASSESSMENT CRITERION RANGE |
Sorting includes but is not limited to ascending order, descending order. |
ASSESSMENT CRITERION 5 |
Data is sorted by columns to organise information in accordance with user requirement. |
ASSESSMENT CRITERION 6 |
Data is sorted by months and weekdays in order to provide breakdown summaries. |
SPECIFIC OUTCOME 2 |
Apply security settings to a spreadsheet. |
OUTCOME RANGE |
Security settings include but not limited to password protect to open spreadsheet, password protect to modify spreadsheet, password protect to modify worksheet. |
ASSESSMENT CRITERIA |
ASSESSMENT CRITERION 1 |
Security settings are explained in terms of their use. |
ASSESSMENT CRITERION 2 |
Security settings are applied to restrict and/or limit access to information. |
ASSESSMENT CRITERION 3 |
Security settings are changed in accordance with user requirements. |
ASSESSMENT CRITERION 4 |
Security settings are removed in accordance with changing requirements. |
SPECIFIC OUTCOME 3 |
Use a range of functions within a spreadsheet. |
ASSESSMENT CRITERIA |
ASSESSMENT CRITERION 1 |
Date and time functions are used to manipulate chronological data. |
ASSESSMENT CRITERION 2 |
Mathematical functions are used to facilitate the efficiency of calculations. |
ASSESSMENT CRITERION RANGE |
Mathematical functions include but are not limited to SumIf, RoundDown, RoundUp, Even, Odd. |
ASSESSMENT CRITERION 3 |
Statistical functions are used to analyse statistics. |
ASSESSMENT CRITERION RANGE |
Statistical functions include but are not limited to CountIf, Counta, Trend, Large, Small. |
ASSESSMENT CRITERION 4 |
Financial functions are used to facilitate the efficiency of monetary calculations. |
ASSESSMENT CRITERION RANGE |
Financial functions include but are not limited to FV, NPV, PMT, IPMT, NPER, PV, Rate. |
ASSESSMENT CRITERION 5 |
Subtotalling features are inserted and removed to provide data breakdown for analyses. |
ASSESSMENT CRITERION RANGE |
Subtotalling includes but is not limited to Individual subtotals, Nested subtotals. |
ASSESSMENT CRITERION 6 |
Text functions are used to facilitate the formatting of data for reporting purposes. |
ASSESSMENT CRITERION RANGE |
Text functions include but are not limited to Upper, Lower, Proper, Concatenate. |
ASSESSMENT CRITERION 7 |
Lookup and Reference functions are used for retrieving data. |
ASSESSMENT CRITERION RANGE |
Functions include but are not limited to Lookup VLookUp, HLookUp. |
ASSESSMENT CRITERION 8 |
Logical functions are used to select and organise data. |
ASSESSMENT CRITERION RANGE |
Logical functions include but are not limited to IF, AND, OR, NOT, TRUE, FALSE, nested IF function. |
ASSESSMENT CRITERION 9 |
A mixed reference is used in a formula in order to analyse data. |
ASSESSMENT CRITERION 10 |
A named range is used in a formula to select a data source or sub-source. |
SPECIFIC OUTCOME 4 |
Use formula, mixed references and named ranges to provide solutions to a problem. |
ASSESSMENT CRITERIA |
ASSESSMENT CRITERION 1 |
The input to a result is found in a formula by adjusting a value. |
ASSESSMENT CRITERION 2 |
Scenarios are created to demonstrate different possible outcomes. |
ASSESSMENT CRITERION 3 |
Scenarios are edited to establish different outcomes. |
ASSESSMENT CRITERION 4 |
A scenario summary report is created to provide an overview of the implications of the data. |
ASSESSMENT CRITERION 5 |
Ranges are create and used to select specific data. |
ASSESSMENT CRITERION 6 |
Named ranges in a spreadsheet are analysed in terms of their use and impact. |
ASSESSMENT CRITERION RANGE |
Uses include but not limited to:
|
ASSESSMENT CRITERION 7 |
A named range is created to facilitate referencing of data. |
ASSESSMENT CRITERION RANGE |
Range includes but is not limited to cells, formula, labels. |
ASSESSMENT CRITERION 8 |
A named range is deleted and/or edited in accordance with user requirements. |
ASSESSMENT CRITERION 9 |
A named range is navigated in order to access named data. |
SPECIFIC OUTCOME 5 |
Audit formula to ensure data integrity. |
ASSESSMENT CRITERIA |
ASSESSMENT CRITERION 1 |
An error in a formula is traced in order to identify the correct data to be required. |
ASSESSMENT CRITERION 2 |
An error in a formula is edited to rectify data in accordance with data integrity requirements. |
ASSESSMENT CRITERION 3 |
Precedent and dependent cells are traced for a selected cell in order to determine the value of other cells. |
ASSESSMENT CRITERION 4 |
Trace precedent and dependent arrows are removed in accordance with user requirements. |
ASSESSMENT CRITERION 5 |
Formulae are displayed and viewed in order to ensure that the value required is accurately determined in a worksheet. |
ASSESSMENT CRITERION 6 |
Formula are hidden from view in a worksheet to facilitate focus on overall data presented. |
UNIT STANDARD ACCREDITATION AND MODERATION OPTIONS |
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 |
Identifying and solving problems in which responses display that responsible decisions using critical and creative thinking have been made when:
|
UNIT STANDARD CCFO WORKING |
Working effectively with others as a member of a team, group, organisation, and community during:
|
UNIT STANDARD CCFO ORGANISING |
Organising and managing oneself and one's activities responsibly and effectively when:
|
UNIT STANDARD CCFO COLLECTING |
Collecting, analysing, organising and critically evaluating information when:
|
UNIT STANDARD CCFO COMMUNICATING |
Communicating effectively using visual, mathematical and/or language skills in the modes of oral and/or written persuasion when:
|
UNIT STANDARD CCFO SCIENCE |
Using science and technology effectively and critically, showing responsibility towards the environment and health of others when:
|
UNIT STANDARD CCFO DEMONSTRATING |
Demonstrating an understanding of the world as a set of related systems by recognising that problem-solving contexts do not exist in isolation when:
|
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 |
N/A |
QUALIFICATIONS UTILISING THIS UNIT STANDARD: |
ID | QUALIFICATION TITLE | PRE-2009 NQF LEVEL | NQF LEVEL | STATUS | END DATE | PRIMARY OR DELEGATED QA FUNCTIONARY | |
Elective | 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 |
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. | Assured Vocational Skill Institute |
17. | ATTI (Advanced Technonogy Training Institute) |
18. | ATTI IT SOLUTIONS (Bloemfontei |
19. | ATTI Nelspruit Pty Ltd |
20. | Atvance Institute (Pty) Ltd |
21. | Balefile Trading and Services |
22. | Basadipele Skills Development and Training |
23. | baseni |
24. | BEE Clinic Pty Ltd |
25. | Bells Technical College |
26. | Bokamoso Skills and Economic Development Centre |
27. | Brainwave Projects 1430 cc |
28. | BTC Campus (Pty) Ltd |
29. | Business Optimization Training Institute (Pty) Ltd |
30. | Cape Innovation Technology Initiative |
31. | Careers IT |
32. | CENTRE FOR EXCELLENCE & PROFESSIONAL TRAINING |
33. | CHILI PEPPER INFORMATION TECHNOLOGY SOLUTIONS |
34. | Claas Illustration |
35. | Clean Heat Academy |
36. | College Africa Group (Pty) Ltd |
37. | Columbus Consulting Pty Ltd |
38. | Common Vision Young Specialist Trading cc |
39. | CompEd IT Training |
40. | COMPUSTEPS COLLEGE (PTY) LTD |
41. | CSL Accountants |
42. | CYBER-CITY IT SOLUTIONS |
43. | DC Academy (PTY)LTD |
44. | Decade Pulse (Pty) Ltd |
45. | Dee's Training (Pty) Ltd |
46. | Delight Computer Training |
47. | Eagle Computer Training |
48. | Eagle High IT Training |
49. | EAST LONDON MANAGEMENT INSTITUTE |
50. | Eastern Cape Academy of Technology |
51. | ED-U Options Academy |
52. | Ekasi IT Solutions Centre |
53. | Ekurhuleni Artisans and Skills Training Centre Pty Ltd |
54. | Elangeni Training Institute |
55. | Elchees Software Solutions |
56. | Emalahleni Institute of Techno |
57. | Enter on Stilts |
58. | Eshybrand Pty Ltd |
59. | EYETHU NATIONAL COMPUTER COLLEGE PTY LTD |
60. | Finweb Business Consultancy |
61. | Foster-Melliar (Pty) Ltd |
62. | Fourways Private College |
63. | Futurekids SA (Fochville) |
64. | Genii Institute PTY LTD |
65. | Gert Sibande FET College |
66. | Gigimo Tourism Academy |
67. | Global Institute for Capacity |
68. | Greater Tzaneen Community Foundation |
69. | Growth Management Consulting cc |
70. | Gurandbuilt Management Development |
71. | HAVOHEJ CONSULTANCY |
72. | Hazyview Computer College |
73. | HILLCROSS BUSINESS SCHOOL (PTY |
74. | Hlanganani ICT (Pty) Ltd |
75. | Home of Compassion/Grace Ministries |
76. | HUAWEI Technologies Africa (PTY) LTD |
77. | iCollege College |
78. | Ikusasa Technology Solutions |
79. | Ikusasalethu Youth Development Project NPC |
80. | iLearn Corporate Services PTY LTD |
81. | Imbizo Training and Development Consultants Cc |
82. | Information Technology Resource Centre |
83. | Inqubeko Institute (Pty) Ltd |
84. | IT Academy |
85. | IT-HI-Q Training (PTY) Ltd |
86. | Iyam Training Services |
87. | Jeppe College of Commerce and |
88. | K Boneng Consulting Services P |
89. | K Centre Business Enterprise (PTY) LTD |
90. | Keep The Dream 285 |
91. | Keybase Training Solutions Cc |
92. | King Sabata Dalindyebo TVET College |
93. | KN Training Specialist |
94. | KT Mobile Services |
95. | Kundani Trading |
96. | L and P Computer Academy Pty Ltd |
97. | Learnfast Training Solutions ( |
98. | Leseding Computer Systems |
99. | LETAGO DEVELOPMENT CONSULTING |
100. | LIMPOPO COMPUTER COLLEGE BK |
101. | LINDAMAHLE MANAGEMENT SYSTEMS (PTY) LTD |
102. | Loomee Group |
103. | LYFE COMPUTER TECHNOLOGIES (PTY) LTD |
104. | Makhophila Training |
105. | Masakhane Training and Consult |
106. | Mash Computer Training |
107. | MBOWA COLLEGE PTY LTD |
108. | Metanoia Ratings PTY LTD |
109. | MMELA VILLAGE TECHNOLOGIES (PT |
110. | MND Training and Projects |
111. | Mogapi Education Group (Pty) Ltd |
112. | Moripe Business Training and C |
113. | MORTERBOARD TRAINING SOLUTIONS |
114. | Motlhamme Executive Management |
115. | Moving Ahead Development Agenc |
116. | MP Avuxeni Computer Academy |
117. | Mpande Technologies cc |
118. | Mthonyama Technologies cc |
119. | Mufuka Business and Technical |
120. | Musengavhadzimu Media |
121. | Nape Angwato Trading |
122. | Natfin Holdings Pty Ltd |
123. | NBC Technologies |
124. | NCC - Vereeniging |
125. | Ndulita Solutions |
126. | New Link Computer Skills |
127. | Ntamunde Investment |
128. | Ntandokazi Holdings Pty Ltd |
129. | NW Avuxeni Computer Academy |
130. | Nyankwavi Inverstment |
131. | Nyathela Business College |
132. | Nyelati Trading Enterprise |
133. | Olrich Home of Technology |
134. | On the Ball College Pty ltd |
135. | OPELONG BUSINESS INSTITUTE (PT |
136. | Paramixed Pty Ltd |
137. | Parkton College of Catering & Tourism Studies |
138. | Peo Entle HIV Wellness Management and Youth Skills Development NPO |
139. | Pioneer Business Consulting |
140. | Polokwane Technology Institute (Pty) Ltd |
141. | Pretoria Technical College |
142. | Priha Projects Pty Ltd |
143. | Progressive School of Business |
144. | Prophesy Training College (Pty) Ltd |
145. | PRX SCHOOL TEST |
146. | QUARPHIX (PTY) LTD |
147. | Ramotec Business College |
148. | Rand Training College |
149. | Redefine Human Capital (PTY) L |
150. | Richfield Graduate Institute of Technology Pty Ltd |
151. | Rostec Technical FET College (Pty) Ltd |
152. | Sabile Human Resources Consult |
153. | SANDM IT TRAINING (PTY) LTD |
154. | SED Computer Academy |
155. | Sesk Facilitation Development (PTY) LTD |
156. | Silulo Ulutho Technologies |
157. | Sisekelo Sustainability Institute |
158. | Sivile Housing Association RSA |
159. | SIYAFUNDA COMMUNITY TECHNOLOGY CENTRE NPC |
160. | SOUTH AFRICAN CORPORATE TRAINING ASSOCIATION (PTY) LTD |
161. | Spears Business and Life Couch Consulting (Pty) Ltd |
162. | SPLS Consultants (Pty) Ltd |
163. | SUCCESS BUILDERS INTERNATIONAL CC |
164. | Success Christian Training Cen |
165. | Succinct Investments (Pty) Ltd |
166. | SUPREME ICT CONSULTANTS |
167. | Synergistic Covenant Network NPO |
168. | Tech-Com Solutions cc |
169. | Techtisa (pty) Ltd |
170. | Terrawood |
171. | Terry Computer Services cc |
172. | Thalita Koume Directions (Pty) Ltd |
173. | The Finishing College (Pty) Lt |
174. | THE SKILLS DEVELOPMENT CORPORA |
175. | Think Tank T2 (Pty) Ltd |
176. | Tinotel Communications |
177. | Titan Trade Technologies |
178. | Tlou Foundation College |
179. | TORQUE TECHNICAL COMPUTER TRAINING PTY LTD |
180. | Tshwane College of Commerce an |
181. | Tsima Consulting Development S |
182. | TSP COLLEGE |
183. | TURFLOOP TRAINING SERVICES CC |
184. | Ubuhlanti Sances Trading (Pty) Ltd |
185. | Ukwazi Academy and Corporate S |
186. | Umbrella Training and Development |
187. | Umbusi Consulting Services |
188. | UTHINGO BRITE SERVICES |
189. | Varsity Institute of Science & Technology (Pty)Ltd |
190. | Visionary Skill Academy |
191. | Vukani Solutions |
192. | VUTHLARI MARKETING CONSULTING |
193. | Waterberg TVET College |
194. | Wellinkwise Pty Ltd |
195. | Whitestone College |
196. | WORK SKILLS RESOURCES CC |
197. | Working Solution International |
198. | Xylo Trading 12 (Pty) Ltd |
199. | YITRO INNOVATIONS |
200. | Yonet Training Academy |
201. | Youth Media Movement |
202. | ZA WIT (PTY) LTD |
203. | Zealot Business College |
204. | Zikode Development Trust |
205. | ZIPHELELE RURAL DEVELOPMENT AC |
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. |