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: |
Ensure spreadsheet integrity to enhance reliability |
SAQA US ID | UNIT STANDARD TITLE | |||
258878 | Ensure spreadsheet integrity to enhance reliability | |||
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 | 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 | |||
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 work with spreadsheets and for whom the reliability of the data produced is critical.
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 will be competent in the following:
|
UNIT STANDARD RANGE |
Specific Outcomes and Assessment Criteria: |
SPECIFIC OUTCOME 1 |
Set up a spreadsheet. |
ASSESSMENT CRITERIA |
ASSESSMENT CRITERION 1 |
The purpose of the spreadsheet is analysed and stated to ensure a spreadsheet is the most appropriate tool. |
ASSESSMENT CRITERION 2 |
The identity requirements of the spreadsheet are distinguished in order to ensure traceability and currency. |
ASSESSMENT CRITERION RANGE |
Identity requirements include but not limited to author's identity, version number and change history. |
ASSESSMENT CRITERION 3 |
Properties are set in order to protect the integrity of the file. |
ASSESSMENT CRITERION RANGE |
Properties include but not limited to read only, track changes. |
ASSESSMENT CRITERION 4 |
Conventions used are set out in a given scenario. |
ASSESSMENT CRITERION RANGE |
Conventions include but not limited to calculation methods, functions, styles and formatting (formatting to include dates, numbers, and codes). |
ASSESSMENT CRITERION 5 |
A summary or index worksheet is created to help users navigate and understand the organisation of multiple spreadsheet. |
ASSESSMENT CRITERION 6 |
A basic understanding of the legal requirements affecting spreadsheet use is demonstrated through evaluating the impact of legal controls and access to information. |
SPECIFIC OUTCOME 2 |
Apply security. |
ASSESSMENT CRITERIA |
ASSESSMENT CRITERION 1 |
Security measures are applied to ensure the integrity of the file. |
ASSESSMENT CRITERION RANGE |
Security measures include but not limited to distinct spreadsheet versions are saved, backed-up and verified, strong password protection, all of mixed case, non-alphanumeric characters and length, different macro security levels. |
ASSESSMENT CRITERION 2 |
Work is protected by including a password in order to control access. |
ASSESSMENT CRITERION RANGE |
Work include but not limited to workbooks, spreadsheet, rows, columns, cells, images.
Protected include but not limited to open, modify spreadsheet, modify worksheet hide, unhide. |
ASSESSMENT CRITERION 3 |
Changes are tracked in order to facilitate the sharing of files. |
ASSESSMENT CRITERION 4 |
Security settings are changed and removed in accordance with user requirements. |
SPECIFIC OUTCOME 3 |
Check input data. |
ASSESSMENT CRITERIA |
ASSESSMENT CRITERION 1 |
Single instances of given constants are placed in separate cells to simplify calculations. |
ASSESSMENT CRITERION RANGE |
Constants include but not limited to conversion rates and tax rates. |
ASSESSMENT CRITERION 2 |
Complex formulas are broken down into smaller components to enhance readability, comprehension and ease of updating. |
ASSESSMENT CRITERION 3 |
Named ranges are applied to make formulas more manageable. |
ASSESSMENT CRITERION 4 |
Manual and automatic calculation modes are used in accordance with a given scenario. |
ASSESSMENT CRITERION 5 |
Units of measurement are made explicit to avoid calculation errors. |
ASSESSMENT CRITERION 6 |
The value of precision display settings are examined to reflect their impact on readability. |
ASSESSMENT CRITERION 7 |
Text files are imported into a spreadsheet and validated for correctness of data type. |
ASSESSMENT CRITERION RANGE |
Text files include but are not limited to fixed length and delaminated. |
ASSESSMENT CRITERION 8 |
The integrity of data is reconciled as complete, consistent and correct in accordance with external data sources. |
SPECIFIC OUTCOME 4 |
Check formulas and totals. |
ASSESSMENT CRITERIA |
ASSESSMENT CRITERION 1 |
The order of precedence in mathematical operations is checked and corrected to avoid miscalculations. |
ASSESSMENT CRITERION 2 |
Cell referencing errors in functions is identified and corrected to ensure the reliability of the spreadsheet. |
ASSESSMENT CRITERION RANGE |
Cell referencing errors include circular references, missing input values, missing precedent cells. |
ASSESSMENT CRITERION 3 |
Formulas are substituted with array formulae to facilitate auditing activities. |
ASSESSMENT CRITERION 4 |
Error functions are applied and error values are corrected in order to enhance the reliability of the data. |
ASSESSMENT CRITERION RANGE |
Error functions include but not limited to ISERROR and ISNA.
Error values include but not limited to #DIV/0!, ####, #VALUE!, #NAME, #REF!, #NUM!. |
ASSESSMENT CRITERION 5 |
Cross-totals are created as a way to validate calculations and increase reliability. |
ASSESSMENT CRITERION 6 |
Formulas are audited to ensure reliability of spreadsheet. |
SPECIFIC OUTCOME 5 |
Check output data. |
ASSESSMENT CRITERIA |
ASSESSMENT CRITERION 1 |
Hidden information is revealed by changing certain formats in order to determine reliability. |
ASSESSMENT CRITERION RANGE |
Hidden information could include but not limited to hidden zero values.
Formats include but not limited to font and background colour. |
ASSESSMENT CRITERION 2 |
An understanding of formatting decimals and rounding off is demonstrated by reflecting their differences. |
ASSESSMENT CRITERION 3 |
Data is validated in order to ensure that the correct information was exported. |
ASSESSMENT CRITERION 4 |
Data is presented meaningfully by choosing an appropriate chart type. |
ASSESSMENT CRITERION 5 |
Charts are checked and corrected for orientation and data series visibility. |
ASSESSMENT CRITERION 6 |
Chart features are used to enhance chart meaning. |
ASSESSMENT CRITERION RANGE |
Chart features include but not limited to axes, orientation, scales, titles, annotation. |
SPECIFIC OUTCOME 6 |
Audit spreadsheets. |
ASSESSMENT CRITERIA |
ASSESSMENT CRITERION 1 |
Spreadsheets are analysed for criticality, risk and potential business impact and to determine the review and control requirements. |
ASSESSMENT CRITERION 2 |
Spreadsheets are analysed to reflect the reasons why they should be submitted for independent review and approval before circulation. |
ASSESSMENT CRITERION 3 |
Periodic review is discussed to reflect its need, purpose and impact. |
ASSESSMENT CRITERION 4 |
The use of advanced features is assessed to ensure that the spreadsheet is constructed for ease of use. |
ASSESSMENT CRITERION RANGE |
Advanced features include but not limited to macros, pop-ups, comments. |
ASSESSMENT CRITERION 5 |
The spreadsheet is reviewed for data-type mis-entry. |
ASSESSMENT CRITERION RANGE |
Data includes but not limited to text, numeric, dates. |
ASSESSMENT CRITERION 6 |
Conditional formatting is applied to highlight errors. |
SPECIFIC OUTCOME 7 |
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 |
Data sort is performed in order to organise information in order to provide breakdown summaries for ease of access. |
ASSESSMENT CRITERION RANGE |
Sorting includes but is not limited to ascending order, descending order, columns, months and weekdays. |
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. | NCM Computer and Business Academy |
126. | Ndulita Solutions |
127. | New Link Computer Skills |
128. | Ntamunde Investment |
129. | Ntandokazi Holdings Pty Ltd |
130. | NW Avuxeni Computer Academy |
131. | Nyankwavi Inverstment |
132. | Nyathela Business College |
133. | Nyelati Trading Enterprise |
134. | Olrich Home of Technology |
135. | On the Ball College Pty ltd |
136. | OPELONG BUSINESS INSTITUTE (PT |
137. | Paramixed Pty Ltd |
138. | Parkton College of Catering & Tourism Studies |
139. | Peo Entle HIV Wellness Management and Youth Skills Development NPO |
140. | Pioneer Business Consulting |
141. | Polokwane Technology Institute (Pty) Ltd |
142. | Pretoria Technical College |
143. | Priha Projects Pty Ltd |
144. | Progressive School of Business |
145. | Prophesy Training College (Pty) Ltd |
146. | PRX SCHOOL TEST |
147. | QUARPHIX (PTY) LTD |
148. | Ramotec Business College |
149. | Rand Training College |
150. | Redefine Human Capital (PTY) L |
151. | Richfield Graduate Institute of Technology Pty Ltd |
152. | Rostec Technical FET College (Pty) Ltd |
153. | Sabile Human Resources Consult |
154. | SANDM IT TRAINING (PTY) LTD |
155. | SED Computer Academy |
156. | Sesk Facilitation Development (PTY) LTD |
157. | Silulo Ulutho Technologies |
158. | Sisekelo Sustainability Institute |
159. | Sivile Housing Association RSA |
160. | SIYAFUNDA COMMUNITY TECHNOLOGY CENTRE NPC |
161. | SOUTH AFRICAN CORPORATE TRAINING ASSOCIATION (PTY) LTD |
162. | Spears Business and Life Couch Consulting (Pty) Ltd |
163. | SPLS Consultants (Pty) Ltd |
164. | SUCCESS BUILDERS INTERNATIONAL CC |
165. | Success Christian Training Cen |
166. | Succinct Investments (Pty) Ltd |
167. | SUPREME ICT CONSULTANTS |
168. | Synergistic Covenant Network NPO |
169. | Tech-Com Solutions cc |
170. | Techtisa (pty) Ltd |
171. | Terrawood |
172. | Terry Computer Services cc |
173. | Thalita Koume Directions (Pty) Ltd |
174. | The Finishing College (Pty) Lt |
175. | THE SKILLS DEVELOPMENT CORPORA |
176. | Think Tank T2 (Pty) Ltd |
177. | Tinotel Communications |
178. | Titan Trade Technologies |
179. | Tlou Foundation College |
180. | TORQUE TECHNICAL COMPUTER TRAINING PTY LTD |
181. | Tshwane College of Commerce an |
182. | Tsima Consulting Development S |
183. | TSP COLLEGE |
184. | TURFLOOP TRAINING SERVICES CC |
185. | Ubuhlanti Sances Trading (Pty) Ltd |
186. | Ukwazi Academy and Corporate S |
187. | Umbrella Training and Development |
188. | Umbusi Consulting Services |
189. | UTHINGO BRITE SERVICES |
190. | Varsity Institute of Science & Technology (Pty)Ltd |
191. | Visionary Skill Academy |
192. | Vukani Solutions |
193. | VUTHLARI MARKETING CONSULTING |
194. | Waterberg TVET College |
195. | Wellinkwise Pty Ltd |
196. | Whitestone College |
197. | WORK SKILLS RESOURCES CC |
198. | Working Solution International |
199. | Xylo Trading 12 (Pty) Ltd |
200. | YITRO INNOVATIONS |
201. | Yonet Training Academy |
202. | Youth Media Movement |
203. | ZA WIT (PTY) LTD |
204. | Zealot Business College |
205. | Zikode Development Trust |
206. | 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. |