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 solve a given problem |
SAQA US ID | UNIT STANDARD TITLE | |||
117927 | Use a Graphical User Interface (GUI)-based database 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 4 | NQF Level 04 | 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 |
7576 | Demonstrate the ability to use a database for business purposes | 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 databases to solve problems 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 |
Any database application that operates in a Graphical User Interface (GUI)-based environment.
The database being worked with in this standard is to include, but is not limited to: |
Specific Outcomes and Assessment Criteria: |
SPECIFIC OUTCOME 1 |
Prepare a database to provide a solution to a given problem. |
ASSESSMENT CRITERIA |
ASSESSMENT CRITERION 1 |
A working plan is developed to meet the requirements of a supplied brief. |
ASSESSMENT CRITERION 2 |
The plan identifies the purpose of the database. |
ASSESSMENT CRITERION 3 |
The plan includes a basic outline of the database specifications and/or features required to provide a solution, with reasons for choices made. |
SPECIFIC OUTCOME 2 |
Create database tables and data entry forms to solve the given problem. |
ASSESSMENT CRITERIA |
ASSESSMENT CRITERION 1 |
One or more database tables are created to solve the given problem. |
ASSESSMENT CRITERION RANGE |
At least 5 fields are included in one of the database tables created. The table definition data types needs to include at least the following: text, numeric, date, currency. |
ASSESSMENT CRITERION 2 |
A form is created for each database table. |
ASSESSMENT CRITERION 3 |
Formats of form fields are modified. |
ASSESSMENT CRITERION RANGE |
Font style, size and colour, background colour. |
ASSESSMENT CRITERION 4 |
A header is added to a form. |
ASSESSMENT CRITERION 5 |
A footer is added to a form. |
ASSESSMENT CRITERION 6 |
Fields of the form are re-arranged. |
ASSESSMENT CRITERION 7 |
A data entry form is saved and closed. |
ASSESSMENT CRITERION 8 |
Data is entered into a database table using the form. |
ASSESSMENT CRITERION 9 |
A data entry form is deleted. |
SPECIFIC OUTCOME 3 |
Retrieve information from a database by applying a filter. |
OUTCOME RANGE |
Filter, Query. |
ASSESSMENT CRITERIA |
ASSESSMENT CRITERION 1 |
A filter is applied to the database table to filter out specific records. |
ASSESSMENT CRITERION RANGE |
Filter by selection, excluding selection, input, form, form window. |
ASSESSMENT CRITERION 2 |
Remove a filter. |
ASSESSMENT CRITERION 3 |
Create queries to select specific records to be extracted from a database table. |
ASSESSMENT CRITERION RANGE |
Single-field query, multi-field query, using the toolbar, using a wizard. |
ASSESSMENT CRITERION 4 |
Retrieve information by running a query. |
ASSESSMENT CRITERION 5 |
A query is saved. |
ASSESSMENT CRITERION 6 |
Modify an existing query. |
ASSESSMENT CRITERION 7 |
A field is added to a query. |
ASSESSMENT CRITERION 8 |
A field is removed from a query. |
ASSESSMENT CRITERION 9 |
Fields in a query are hidden. |
SPECIFIC OUTCOME 4 |
Sort data in a database query. |
OUTCOME RANGE |
Ascending, descending. |
ASSESSMENT CRITERIA |
ASSESSMENT CRITERION 1 |
Query data is sorted. |
SPECIFIC OUTCOME 5 |
Create a report for a database table. |
ASSESSMENT CRITERIA |
ASSESSMENT CRITERION 1 |
A report is designed to address the requirement of the given problem. |
ASSESSMENT CRITERION 2 |
A report is created that meets the design. |
ASSESSMENT CRITERION 3 |
A report is modified. |
ASSESSMENT CRITERION RANGE |
Header, Footer, font (size, type, colour). |
ASSESSMENT CRITERION 4 |
Data is grouped in a report. |
ASSESSMENT CRITERION 5 |
A selection is resized in a report. |
ASSESSMENT CRITERION 6 |
A report is saved. |
ASSESSMENT CRITERION 7 |
A report is deleted. |
SPECIFIC OUTCOME 6 |
Perform advanced print options for a database. |
ASSESSMENT CRITERIA |
ASSESSMENT CRITERION 1 |
A database form is printed. |
ASSESSMENT CRITERION 2 |
A query result is printed. |
ASSESSMENT CRITERION 3 |
A database report is previewed to check that the presentation is in accordance with the given specification. |
ASSESSMENT CRITERION 4 |
A database report is printed. |
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 7576, which was "Demonstrate the ability to use a database for business purposes", Level 3, 5 Credits.
Supplementary Information: Definitions: Assessor Notes: a. Learners are required to plan, produce, use and evaluate a database to provide a solution to a given problem. The problem may be either part of the learner`s employment tasks (in the case of workplace assessment) or be a set exercise. b. The simple user document must be provided to the candidate being assessed, with a clear description of both the desirable outcomes sought and the constraints to be met by the solution. It contains detailed specifications against which the success or otherwise of the database can be evaluated. For the purpose of this unit standard the simple user document can be either created as part of the candidates employment (in the case of workplace assessment) or in response to a set task. c. The supplied brief must incorporate requirements to ensure that all assessment criteria are met. d. 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. e. 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 | 49627 | Further Education and Training Certificate: e Records Management | Level 4 | NQF Level 04 | Passed the End Date - Status was "Reregistered" |
2012-06-30 | |
Elective | 58375 | National Certificate: Bookkeeping | Level 3 | NQF Level 03 | Passed the End Date - Status was "Reregistered" |
2023-06-30 | FASSET |
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 |
Elective | 57879 | National Certificate: Manufacturing of Surface Coatings | Level 3 | NQF Level 03 | Passed the End Date - Status was "Reregistered" |
2023-06-30 | CHIETA |
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 | 58376 | Further Education and Training Certificate: Bookkeeping | Level 4 | NQF Level 04 | Passed the End Date - Status was "Reregistered" |
2023-06-30 | FASSET |
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 | 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 | 73298 | Further Education and Training Certificate: Photography | 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 | 58337 | Further Education and Training Certificate: Trade Union Practice | Level 4 | NQF Level 04 | Passed the End Date - Status was "Reregistered" |
2023-06-30 | ETDP SETA |
Elective | 61349 | National Certificate: Heritage Resource Management | Level 5 | Level TBA: Pre-2009 was L5 | Passed the End Date - Status was "Reregistered" |
2023-06-30 | CATHSSETA |
Elective | 59387 | National Certificate: Intellectual Property Administration | Level 5 | Level TBA: Pre-2009 was L5 | Passed the End Date - Status was "Reregistered" |
2012-06-30 | CATHSSETA |
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. | Aldabri 106 Institute for Quality (Pty) Ltd |
10. | All Nation Group Five Trading and Projects |
11. | Amadi Institute of Management And Technology (Pty) Ltd |
12. | Amilak Training Center |
13. | Angie Technologies |
14. | Answer The Call Skills and Entrepreneurship |
15. | ASMO INSTITUTE OF BUSINESS AN |
16. | Aspirations Communication Training CC |
17. | ATTI IT SOLUTIONS (Bloemfontei |
18. | ATTI Nelspruit Pty Ltd |
19. | Atvance Institute (Pty) Ltd |
20. | Balefile Trading and Services |
21. | Basadipele Skills Development and Training |
22. | BEE Clinic Pty Ltd |
23. | Bells Technical College |
24. | BLC Entertainment |
25. | Bokamoso Skills and Economic Development Centre |
26. | Brainwave Projects 1430 cc |
27. | Breakeven 59(PTY) Ltd |
28. | Business Optimization Training Institute (Pty) Ltd |
29. | Careers IT |
30. | CENTRE FOR EXCELLENCE & PROFESSIONAL TRAINING |
31. | CHILI PEPPER INFORMATION TECHNOLOGY SOLUTIONS |
32. | Clean Heat Academy |
33. | College Africa Group (Pty) Ltd |
34. | Columbus Consulting Pty Ltd |
35. | Common Vision Young Specialist Trading cc |
36. | COMPUSTEPS COLLEGE (PTY) LTD |
37. | CSL Accountants |
38. | CTU Training Solutions |
39. | CYBAX SYSTEMS |
40. | Dabulamanzi & Njabulo Ndaba Consulting cc |
41. | DC Academy (PTY)LTD |
42. | Decade Pulse (Pty) Ltd |
43. | Dee's Training (Pty) Ltd |
44. | Delight Computer Training |
45. | DITSELA WORKERS EDUCATION INSTITUTION |
46. | Eagle Computer Training |
47. | Eagle High IT Training |
48. | EAST LONDON MANAGEMENT INSTITUTE |
49. | ED-U Options Academy |
50. | Ekasi IT Solutions Centre |
51. | Ekurhuleni Artisans and Skills Training Centre Pty Ltd |
52. | Elangeni Training Institute |
53. | Elchees Software Solutions |
54. | ELIJAH BARAYI MEMORIAL TRAINING CENTRE |
55. | Emalahleni Institute of Techno |
56. | Epitome Villa (Pty)Ltd |
57. | Eshybrand Pty Ltd |
58. | EYETHU NATIONAL COMPUTER COLLEGE PTY LTD |
59. | FILM Mentorship & Training SA |
60. | Finweb Business Consultancy |
61. | Foster-Melliar (Pty) Ltd |
62. | Fourways Private College |
63. | Futurekids SA (Fochville) |
64. | Genii Institute PTY LTD |
65. | Gigimo Tourism Academy |
66. | Global Institute for Capacity |
67. | Greater Tzaneen Community Foundation |
68. | Gurandbuilt Management Development |
69. | HAVOHEJ CONSULTANCY |
70. | Hazyview Computer College |
71. | Hectic Productions cc |
72. | HILLCROSS BUSINESS SCHOOL (PTY |
73. | Hlanganani ICT (Pty) Ltd |
74. | Home of Compassion/Grace Ministries |
75. | HUAWEI Technologies Africa (PTY) LTD |
76. | Ikusasa Technology Solutions |
77. | Ikusasalethu Youth Development Project NPC |
78. | iLearn Corporate Services PTY LTD |
79. | Information Technology Resource Centre |
80. | Inqubeko Institute (Pty) Ltd |
81. | IT Academy |
82. | IT-HI-Q Training (PTY) Ltd |
83. | Iyam Training Services |
84. | Jeppe College of Commerce and |
85. | K Boneng Consulting Services P |
86. | K Centre Business Enterprise (PTY) LTD |
87. | Keybase Training Solutions Cc |
88. | KN Training Specialist |
89. | KT Mobile Services |
90. | Kundani Trading |
91. | L and P Computer Academy Pty Ltd |
92. | LETAGO DEVELOPMENT CONSULTING |
93. | LIMPOPO COMPUTER COLLEGE BK |
94. | LINDAMAHLE MANAGEMENT SYSTEMS (PTY) LTD |
95. | Loomee Group |
96. | LYFE COMPUTER TECHNOLOGIES (PTY) LTD |
97. | Makhophila Training |
98. | Malope It Solutions (Pty) Ltd |
99. | Masakhane Training and Consult |
100. | Mash Computer Training |
101. | MBOWA COLLEGE PTY LTD |
102. | Metanoia Ratings PTY LTD |
103. | MMELA VILLAGE TECHNOLOGIES (PT |
104. | MND Training and Projects |
105. | Mogapi Education Group (Pty) Ltd |
106. | Motheo Training Institute Trust |
107. | Motlhamme Executive Management |
108. | Moving Ahead Development Agenc |
109. | MP AVUXENI COMPUTER ACADEMY |
110. | Mpande Technologies cc |
111. | Mufuka Business and Technical |
112. | Musengavhadzimu Media |
113. | Natfin Holdings Pty Ltd |
114. | NBC Technologies |
115. | NCC - Vereeniging |
116. | NCM Computer and Business Academy |
117. | Ndulita Solutions |
118. | New Era Computer Training Centre (Hidobyte CC) |
119. | New Link Computer Skills |
120. | Nolwazi Stem Education for The |
121. | Ntamunde Investment |
122. | Ntandokazi Holdings Pty Ltd |
123. | NW Avuxeni Computer Academy |
124. | Nyankwavi Inverstment |
125. | Nyathela Business College |
126. | OL Afrika Media |
127. | Olrich Home of Technology |
128. | On the Ball College Pty ltd |
129. | OPELONG BUSINESS INSTITUTE (PT |
130. | Paramixed Pty Ltd |
131. | Parkton College of Catering & Tourism Studies |
132. | Peo Entle HIV Wellness Management and Youth Skills Development NPO |
133. | Pioneer Business Consulting |
134. | Polokwane Technology Institute (Pty) Ltd |
135. | Posh Multimedia |
136. | Pretoria Technical College |
137. | Priha Projects Pty Ltd |
138. | Progressive School of Business |
139. | Prophesy Training College (Pty) Ltd |
140. | PRX SCHOOL TEST |
141. | QUALITATIVE INNOVATIVE SOLUTIONS |
142. | QUARPHIX (PTY) LTD |
143. | Ramotec Business College |
144. | Rand Training College |
145. | Redefine Human Capital (PTY) L |
146. | Richfield Graduate Institute of Technology Pty Ltd |
147. | Rostec Technical FET College (Pty) Ltd |
148. | Sabile Human Resources Consult |
149. | SANDM IT TRAINING (PTY) LTD |
150. | Sebenzisanane Human Capital |
151. | SED Computer Academy |
152. | Sesk Facilitation Development (PTY) LTD |
153. | Silulo Ulutho Technologies |
154. | Sisekelo Sustainability Institute |
155. | SIYAFUNDA COMMUNITY TECHNOLOGY CENTRE NPC |
156. | SOUTH AFRICAN CORPORATE TRAINING ASSOCIATION (PTY) LTD |
157. | Spears Business and Life Couch Consulting (Pty) Ltd |
158. | SPLS Consultants (Pty) Ltd |
159. | SUCCESS BUILDERS INTERNATIONAL CC |
160. | Success Christian Training Cen |
161. | SUPREME ICT CONSULTANTS |
162. | Synergistic Covenant Network NPO |
163. | T Mabuya & Associates (Pty) Ltd |
164. | Tech-Com Solutions cc |
165. | Techtisa (pty) Ltd |
166. | Terrawood |
167. | Terry Computer Services cc |
168. | Thalita Koume Directions (Pty) Ltd |
169. | The Finishing College (Pty) Lt |
170. | Think Tank T2 (Pty) Ltd |
171. | Titan Trade Technologies |
172. | Tlou Foundation College |
173. | TORQUE TECHNICAL COMPUTER TRAINING PTY LTD |
174. | TSP COLLEGE |
175. | TURFLOOP TRAINING SERVICES CC |
176. | Ubuhlanti Sances Trading (Pty) Ltd |
177. | Ukwazi Academy and Corporate S |
178. | Umbrella Training and Development |
179. | Umbusi Consulting Services |
180. | UTHINGO BRITE SERVICES |
181. | Varsity Institute of Science & Technology (Pty)Ltd |
182. | Visionary Skill Academy |
183. | VSS College (Pty) LTD |
184. | Vukani Solutions |
185. | VUTHLARI MARKETING CONSULTING |
186. | Waterberg TVET College |
187. | Wellinkwise Pty Ltd |
188. | Whitestone College |
189. | WORK SKILLS RESOURCES CC |
190. | Working Solution International |
191. | Xylo Trading 12 (Pty) Ltd |
192. | YITRO INNOVATIONS |
193. | Yonet Training Academy |
194. | ZA WIT (PTY) LTD |
195. | Zealot Business College |
196. | 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. |