![]() |
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: |
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 | |
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 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 | Reregistered | 2021-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 | 78528 | National Certificate: Chemical Operations | Level 3 | NQF Level 03 | Reregistered | 2021-06-30 | As per Learning Programmes recorded against this Qual |
Elective | 49602 | National Certificate: Construction: Geotechnical | Level 3 | NQF Level 03 | Reregistered | 2023-06-30 | CETA |
Elective | 61971 | National Certificate: Pulp and Paper Operations | Level 3 | NQF Level 03 | Reregistered | 2023-06-30 | FPMSETA |
Elective | 67461 | Further Education and Training Certificate: Event Support | Level 4 | NQF Level 04 | Reregistered | 2021-06-30 | As per Learning Programmes recorded against this Qual |
Elective | 50329 | Further Education and Training Certificate: Radiation Protection | Level 4 | NQF Level 04 | 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. | Abetech |
2. | Abinet (PTY)LTD |
3. | Academy of Training and Development |
4. | AccTech Systems (PTY)LTD |
5. | Acol Computer Training PTY LTD |
6. | Act of Grace 97 |
7. | Added Advantage Academy (Durban) |
8. | Afedile M Learning Centre (Pty) Ltd |
9. | Affirmations Training |
10. | All Connections cc |
11. | Amitek Business College |
12. | Anderson College (Pty) Ltd |
13. | Ankalite (Pty) Limited |
14. | Arise Business Centre |
15. | Artshub Institute (Pty) Ltd |
16. | Aspirations Communication Training CC |
17. | ATTI Nelspruit Pty Ltd |
18. | AUM IT Solutions |
19. | Bantsho Marketing & Management Strategies |
20. | Best Information Solutions |
21. | Beth Horner & Associates |
22. | Birnam Business College (Pty) Limited |
23. | Bonalesedi Computer Training |
24. | Bophelo Tota ICT Driving Academy (Pty) Ltd |
25. | Broadband College of Technology |
26. | BTC Campus (Pty) Ltd |
27. | Bytes People Solutions A Division of Altron TMT (Pty) Ltd |
28. | Calandra Trading 523(PTY) |
29. | Cape Innovation Technology Initiative |
30. | Cape Town Society for the Blind |
31. | Certified Workforce Trainers cc. |
32. | Claas Illustration |
33. | College Africa Group (Pty) Ltd |
34. | Columbus Consulting Pty Ltd |
35. | CompEd IT Training |
36. | Competence computer and business management |
37. | Creative Minds - UPINGTON |
38. | Creative Minds Worcester |
39. | CTU Training Solutions |
40. | CYBER MINDS (PTY) LIMITED |
41. | Daily Training Cc |
42. | DC Dynamic College of Commerce & Further Training (Pty) Ltd |
43. | Ditlotlo Trading Enterprise Cc |
44. | DVG Property (Pty)Ltd |
45. | Eagle Computer Training |
46. | Eastern Cape Academy of Technology |
47. | Egsibit Training and Development |
48. | Ekasi IT Solutions CC |
49. | Ekurhuleni Computer College |
50. | Elangeni Training Institute |
51. | Eskilz College (Pty) Ltd |
52. | EUSA COMPUTER ACCOUNTING (PTY) LTD |
53. | EZI BOOKINGS |
54. | Fakazani Management Services |
55. | Falcon Business Institute (Pty) Ltd |
56. | Far-Ahead Computer Training Centre Cc |
57. | Forek Institute of Technology (Pty) Ltd |
58. | Fort Hare Solutions (PTY) LTD |
59. | Gabasega Consulting and Training Centre |
60. | Gauteng College of Engineering and Technology (PTY) LTD |
61. | GDE Science Education Centre |
62. | Gegana Computer Academy and Business Solutions cc |
63. | Golden Step Campus (Pty) Ltd. |
64. | Goldfields TVET College |
65. | Goodwill Institute Of Technology |
66. | Gurandbuilt Management Development |
67. | Hazyview Computer College |
68. | Hectic Productions cc |
69. | iLearn Corporate Services PTY LTD |
70. | Indonsa Consulting and Training cc |
71. | Information Technology Resource Centre |
72. | Institute of Training and Education for Capacity Building |
73. | ISAMON VOCATIONAL COLLEGE OF EXCELLENCE |
74. | iSolve Business Solutions (Pty) Ltd |
75. | Jeppe College of Commerce and Computer Studies |
76. | JHJ Training |
77. | Johannesburg Institute of Engineering & Technology |
78. | John Taolo Gaetsewe Developmental Trust |
79. | Keybase Training Solutions Cc |
80. | Kezla Investments |
81. | King Sabata Dalindyebo TVET College |
82. | Kondi Computer Training |
83. | KROONDAL OPERATIONS (PTY) LTD |
84. | Kumani Computer College |
85. | KWAZULU NATAL AVUXENI COMPUTER AND TRAINING CENTRE (PTY) LTD |
86. | Leading Edge Business Solutions (Pty) Ltd |
87. | Lephalale Core Skills Academy (Pty) Ltd |
88. | Lesedi Consulting |
89. | Leseding Computer Systems (Pty) Ltd |
90. | LGIT Smart Solutions |
91. | Limco Consulting and management (Pty) Ltd |
92. | Loja Trading cc |
93. | Mackeys Computing (Pty) Ltd |
94. | Malope IT Solutions |
95. | Masana Brainstorm Conferencing cc |
96. | Mash Computer Training |
97. | Mass Computer Training And Printers |
98. | MasterGrade IT |
99. | METSKILL PTY LTD |
100. | Mokk Consultants Cc |
101. | Mosadikago Trading Cc |
102. | Mourema Computer Training Centre |
103. | MP Avuxeni Computer Academy |
104. | Mpisholo Training Solutions |
105. | Mthonyama Technologies cc |
106. | National Computer College Carletonville |
107. | NCM Computer and Business Academy |
108. | Ndabezitha Life Skills Training Institute |
109. | NetCampus (Pty) Ltd. |
110. | New Era Computer Training Centre (Hidobyte CC) |
111. | New Link Computer Skills |
112. | Ngubeni Corporation |
113. | Ntamunde Investment |
114. | NW Avuxeni Computer academy |
115. | Ocule IT cc |
116. | On the Ball College Pty ltd |
117. | Options In Training (Pty) Ltd |
118. | Overcomers Training College (Pty) Ltd |
119. | Pillays Computer and Careers |
120. | Presentation Software Training |
121. | Prophesy Training College (Pty) Ltd |
122. | PROSERV SA (PTY) LTD |
123. | Protech Business and Computer College Pty Ltd. |
124. | Qhakaza Management Services |
125. | Rainbow Moon Trading 193 CC |
126. | Rand Training College |
127. | Reaithuta Computer Academy |
128. | Regent-Comp |
129. | Richfield Graduate Institute of Technology Pty Ltd |
130. | Ron and Becky Trading |
131. | Rorisang Computer (Pty) Ltd |
132. | Sankin Computer Training Pty Ltd |
133. | Sas Institute Pty Ltd |
134. | Sebata Municipal Solutions (Pty) Limited |
135. | SEDIBENG |
136. | Setlagole Telecentre |
137. | Sivile Housing Association RSA |
138. | Siyabonga Multi - Purpose Centre |
139. | Siyafunda Community Technology Centre |
140. | South Africa Advanced Skills Institute (Pty) Ltd |
141. | Southern Africa Youth Project NPC |
142. | Sovereign Skills Development Institute (Pty) |
143. | Springfield Training (Pty) Ltd |
144. | Star Light Consulting |
145. | Success Christian Training Centre |
146. | Taal-Net Training Institute |
147. | Terry Computer Services cc |
148. | The Graduate Institute of South Africa |
149. | Tira Telecoms |
150. | Titan Trade Technologies (Pty) Ltd |
151. | Torque Technical Computer Training (Pty) Ltd |
152. | Tshwane College of Commerce and Computer |
153. | Tumelo Education and Training |
154. | Turnstone Trading 183 (Pty) Ltd |
155. | Umbuso Training Services (Pty) Ltd. |
156. | VEB CELE & Associates (Pty) Ltd |
157. | Vukani Solutions |
158. | Vuthlari Marketing Consulting (PTY)LTD |
159. | Waterberg TVET College |
160. | Whitestone College |
161. | WW.IT-IQ Training & Solutions |
162. | Y2K COLLEGE |
163. | Zealot Business College cc |
164. | ZJ Africa Learn (Pty) Ltd |
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. |