![]() |
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 database application to work with simple databases |
SAQA US ID | UNIT STANDARD TITLE | |||
116936 | Use a Graphical User Interface (GUI)-based database application to work with simple databases | |||
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 | 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 replaces: |
US ID | Unit Standard Title | Pre-2009 NQF Level | NQF Level | Credits | Replacement Status |
7569 | Demonstrate understanding of the basic concepts of databases and the ability to plan and create a simple database | Level 2 | NQF Level 02 | 3 |
PURPOSE OF THE UNIT STANDARD |
This unit standard is intended for people who need to create and edit simple databases using a Graphical User Interface (GUI)-based database 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 |
Understand the principles of databases. |
ASSESSMENT CRITERIA |
ASSESSMENT CRITERION 1 |
A database management system is defined in terms of its purpose and use. |
ASSESSMENT CRITERION 2 |
Examples of uses of databases are provided. |
ASSESSMENT CRITERION RANGE |
At least three examples. |
ASSESSMENT CRITERION 3 |
Properties of databases are described in terms of their purpose and relation to the database as a whole. |
ASSESSMENT CRITERION RANGE |
Field, Record, Table, Index, Field Property, Data type. |
SPECIFIC OUTCOME 2 |
Open and save a simple existing databases. |
ASSESSMENT CRITERIA |
ASSESSMENT CRITERION 1 |
The database application is opened or started. |
ASSESSMENT CRITERION 2 |
The parts of the database application window are described in terms of their features and use. |
ASSESSMENT CRITERION RANGE |
All of: Menu Bar, Toolbar, Status Bar, scroll bar, Object Bar. |
ASSESSMENT CRITERION 3 |
An existing database is opened. |
ASSESSMENT CRITERION 4 |
Data is entered into an existing database table. |
ASSESSMENT CRITERION RANGE |
At least 5 records are entered. |
ASSESSMENT CRITERION 5 |
Saving a database giving it a descriptive name related to its purpose and use. |
ASSESSMENT CRITERION 6 |
The database is closed. |
ASSESSMENT CRITERION 7 |
The database application program is closed. |
SPECIFIC OUTCOME 3 |
Produce and edit a simple database table from given specifications. |
OUTCOME RANGE |
At least 5 fields. |
ASSESSMENT CRITERIA |
ASSESSMENT CRITERION 1 |
A database table is created with the required format bases on a given specification. |
ASSESSMENT CRITERION RANGE |
Data types to include at least: text, numeric, date, currency. |
ASSESSMENT CRITERION 2 |
The database table is saved with a descriptive name, as per the given specification. |
ASSESSMENT CRITERION RANGE |
The name of the new database table and database must allow the database table and database to be easily identified in terms of its purpose and content. |
ASSESSMENT CRITERION 3 |
A column is moved within the database table. |
ASSESSMENT CRITERION 4 |
Column widths of columns in the database table are changed. |
ASSESSMENT CRITERION RANGE |
At least 2 columns. |
ASSESSMENT CRITERION 5 |
A database table is deleted. |
ASSESSMENT CRITERION 6 |
The database table is saved and closed. |
SPECIFIC OUTCOME 4 |
Data is entered into a simple database table from given specifications. |
OUTCOME RANGE |
At least 5 fields. |
ASSESSMENT CRITERIA |
ASSESSMENT CRITERION 1 |
A new record is added to the database table. |
ASSESSMENT CRITERION RANGE |
At least 2 records are added. |
ASSESSMENT CRITERION 2 |
Data in the database table is modified. |
ASSESSMENT CRITERION RANGE |
At least 3 records are modified. |
ASSESSMENT CRITERION 3 |
Data in the database table is deleted. |
ASSESSMENT CRITERION 4 |
A record is deleted from the database table. |
SPECIFIC OUTCOME 5 |
Modify the design of a database table. |
ASSESSMENT CRITERIA |
ASSESSMENT CRITERION 1 |
An existing database table is opened in design view. |
ASSESSMENT CRITERION 2 |
The consequences of changing a field size are discussed. |
ASSESSMENT CRITERION 3 |
Field formats are modified. |
ASSESSMENT CRITERION RANGE |
Field size, Number field, Date field. |
ASSESSMENT CRITERION 4 |
A field is moved in the database table. |
ASSESSMENT CRITERION 5 |
A new field is added to the database table. |
ASSESSMENT CRITERION 6 |
A field is deleted from the database table. |
ASSESSMENT CRITERION 7 |
The consequences of the changes made are explained and corrected if necessary. |
ASSESSMENT CRITERION RANGE |
Type conversions. |
SPECIFIC OUTCOME 6 |
Sort and search for records in a database table. |
ASSESSMENT CRITERIA |
ASSESSMENT CRITERION 1 |
A record in a database table is sorted according to one field. |
ASSESSMENT CRITERION RANGE |
Ascending, descending. |
ASSESSMENT CRITERION 2 |
A record is located in a database table, by searching for specific data within the table. |
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 database application to address a given business problem. |
UNIT STANDARD CCFO ORGANISING |
Organise and manage oneself and one`s activities responsibly and effectively by using a database application to organize information into tables, rows and columns for a specific purpose. |
UNIT STANDARD CCFO COLLECTING |
Collect, analyse, organise, and critically evaluate information by using a database application to organize and capture information. |
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 database application to organize information into tables, rows and columns for a specific purpose. |
UNIT STANDARD CCFO SCIENCE |
Use science and technology effectively and critically, showing responsibility towards the environment and health of others by using a database 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 has replaced 7569, which was "Demonstrate understanding of the basic concepts of databases and the ability to plan and create a simple database", Level 2, 3 Credits.
Supplementary Information: Definitions: Assessor Notes: a. Specifications for specific outcome 3 to 5 should be given to the candidate, and should have at least 5 fields and 5 records. b. 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. c. 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 | 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 | 49602 | National Certificate: Construction: Geotechnical | Level 3 | NQF Level 03 | Passed the End Date - Status was "Reregistered" |
2023-06-30 | CETA |
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 | 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 | 50329 | Further Education and Training Certificate: Radiation Protection | Level 4 | NQF Level 04 | 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. | METSKILL PTY LTD |
99. | MMELA VILLAGE TECHNOLOGIES (PT |
100. | MND Training and Projects |
101. | Mogapi Education Group (Pty) Ltd |
102. | Motlhamme Executive Management |
103. | Moving Ahead Development Agenc |
104. | MP Avuxeni Computer Academy |
105. | Mpande Technologies cc |
106. | Mufuka Business and Technical |
107. | Musengavhadzimu Media |
108. | Natfin Holdings Pty Ltd |
109. | NBC Technologies |
110. | NCC - Vereeniging |
111. | NCM Computer and Business Academy |
112. | Ndulita Solutions |
113. | New Era Computer Training Centre (Hidobyte CC) |
114. | New Link Computer Skills |
115. | Nolwazi Stem Education for The |
116. | Ntamunde Investment |
117. | Ntandokazi Holdings Pty Ltd |
118. | NW Avuxeni Computer Academy |
119. | Nyankwavi Inverstment |
120. | Nyathela Business College |
121. | Olrich Home of Technology |
122. | On the Ball College Pty ltd |
123. | OPELONG BUSINESS INSTITUTE (PT |
124. | Paramixed Pty Ltd |
125. | Parkton College of Catering & Tourism Studies |
126. | Peo Entle HIV Wellness Management and Youth Skills Development NPO |
127. | Pioneer Business Consulting |
128. | Polokwane Technology Institute (Pty) Ltd |
129. | Pretoria Technical College |
130. | Priha Projects Pty Ltd |
131. | Progressive School of Business |
132. | Prophesy Training College (Pty) Ltd |
133. | PRX SCHOOL TEST |
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. | VEB CELE & ASSOCIATES PTY LTD |
176. | Visionary Skill Academy |
177. | Vukani Solutions |
178. | VUTHLARI MARKETING CONSULTING |
179. | Waterberg TVET College |
180. | Wellinkwise Pty Ltd |
181. | Whitestone College |
182. | WORK SKILLS RESOURCES CC |
183. | Working Solution International |
184. | Xylo Trading 12 (Pty) Ltd |
185. | YITRO INNOVATIONS |
186. | Yonet Training Academy |
187. | ZA WIT (PTY) LTD |
188. | Zealot Business College |
189. | 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. |