![]() |
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. | Action for Blind and Disabled |
3. | Aspirations Communication Training CC |
4. | Atvance Institute (Pty) Ltd |
5. | Balefile Trading and Services |
6. | Bokamoso Skills and Economic Development Centre |
7. | College Africa Group (Pty) Ltd |
8. | CSL Accountants |
9. | Eagle Computer Training |
10. | Ekasi IT Solutions Centre |
11. | Ekurhuleni Artisans and Skills Training Centre Pty Ltd |
12. | Elangeni Training Institute |
13. | Elchees Software Solutions |
14. | Eshybrand Pty Ltd |
15. | EYETHU NATIONAL COMPUTER COLLEGE PTY LTD |
16. | Finweb Business Consultancy |
17. | Foster-Melliar (Pty) Ltd |
18. | Fourways Private College |
19. | Global Institute for Capacity |
20. | HAVOHEJ CONSULTANCY |
21. | Hazyview Computer College |
22. | HILLCROSS BUSINESS SCHOOL (PTY |
23. | Hlanganani ICT (Pty) Ltd |
24. | Ikusasalethu Youth Development Project NPC |
25. | Inqubeko Institute (Pty) Ltd |
26. | IT Academy |
27. | Jeppe College of Commerce and |
28. | K Boneng Consulting Services P |
29. | K Centre Business Enterprise (PTY) LTD |
30. | Loomee Group |
31. | Masakhane Training and Consult |
32. | METSKILL PTY LTD |
33. | Mogapi Education Group (Pty) Ltd |
34. | Moving Ahead Development Agenc |
35. | Musengavhadzimu Media |
36. | Natfin Holdings Pty Ltd |
37. | Ndulita Solutions |
38. | Polokwane Technology Institute (Pty) Ltd |
39. | Progressive School of Business |
40. | PRX SCHOOL TEST |
41. | QUARPHIX (PTY) LTD |
42. | Redefine Human Capital (PTY) L |
43. | Richfield Graduate Institute of Technology Pty Ltd |
44. | Rostec Technical FET College (Pty) Ltd |
45. | Sabile Human Resources Consult |
46. | SANDM IT TRAINING (PTY) LTD |
47. | Silulo Ulutho Technologies |
48. | Synergistic Covenant Network NPO |
49. | Techtisa (pty) Ltd |
50. | The Finishing College (Pty) Lt |
51. | Titan Trade Technologies |
52. | TORQUE TECHNICAL COMPUTER TRAINING PTY LTD |
53. | Varsity Institute of Science & Technology (Pty)Ltd |
54. | VEB CELE & ASSOCIATES PTY LTD |
55. | Wellinkwise Pty Ltd |
56. | Whitestone College |
57. | ZA WIT (PTY) LTD |
58. | Zealot Business College |
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. |