![]() |
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: |
Design forms and reports using a Graphic User Interface (GUI) based database |
SAQA US ID | UNIT STANDARD TITLE | |||
258875 | Design forms and reports using a Graphic User Interface (GUI) based database | |||
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 | 4 |
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 need to create and use forms, reports and graphs in small scale GUI database applications.
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 is competent in the following:
|
UNIT STANDARD RANGE |
Specific Outcomes and Assessment Criteria: |
SPECIFIC OUTCOME 1 |
Analyse the use of advanced forms and reports. |
ASSESSMENT CRITERIA |
ASSESSMENT CRITERION 1 |
The needs of users are identified and analysed to determine the structure of the form. |
ASSESSMENT CRITERION 2 |
The content and layout of the form is planned to facilitate the gathering of the data required. |
ASSESSMENT CRITERION 3 |
The use of forms is discussed with regard to their impact on the End Users. |
ASSESSMENT CRITERION 4 |
The needs of users are identified and analysed to determine the structure of the report. |
ASSESSMENT CRITERION 5 |
The content and layout of the report is designed to meet reporting requirements. |
ASSESSMENT CRITERION 6 |
The use of reports is discussed in terms of structure and appearance. |
SPECIFIC OUTCOME 2 |
Design a form with all the necessary controls for ease of use in an end user environment. |
OUTCOME RANGE |
Controls include but are not limited to text box, label, combo boxes, and image controls, difference between bound control and other, using queries and tables as the basis for input, types of bound controls. |
ASSESSMENT CRITERIA |
ASSESSMENT CRITERION 1 |
A header and footer are added to a form to accommodate information that will remain on the form as the user scrolls through records. |
ASSESSMENT CRITERION 2 |
Bound controls are placed on a form for data entry. |
ASSESSMENT CRITERION 3 |
Calculated controls are created to show the result of calculations on the underlying fields/field of a query or table. |
ASSESSMENT CRITERION RANGE |
Creation of calculated controls include the use of functions and expression builder. |
ASSESSMENT CRITERION 4 |
Linked forms and subforms are created to enhance ease of use. |
ASSESSMENT CRITERION RANGE |
Creating processes include creating queries and use of join types and subform types. |
ASSESSMENT CRITERION 5 |
A multi page form is created to enhance ease of use. |
ASSESSMENT CRITERION RANGE |
Creating processes include inserting a page break control, adding a tab control. |
SPECIFIC OUTCOME 3 |
Create a report for meaningful interpretation of data. |
ASSESSMENT CRITERIA |
ASSESSMENT CRITERION 1 |
A report is created by attaching controls. |
ASSESSMENT CRITERION RANGE |
Creating processes include but are not limited to header and footer, detail sections, assigning controls. |
ASSESSMENT CRITERION 2 |
Controlling page breaks and the printing of headers and footers are inserted to achieve a specified layout. |
ASSESSMENT CRITERION RANGE |
Controlling page breaks and the printing of headers and footers include options such as force new page, keep together. |
ASSESSMENT CRITERION 3 |
Report data are grouped and sorted to illustrate trends and draw conclusions. |
ASSESSMENT CRITERION 4 |
Summaries and running totals are included in a report to provide different perspectives of the underlying data. |
ASSESSMENT CRITERION 5 |
An alphabetic index is created to find records faster. |
ASSESSMENT CRITERION 6 |
A main report utilising sub-reports is produced, hiding duplicates. |
ASSESSMENT CRITERION 7 |
A chart is created from a report to visually enhance data. |
ASSESSMENT CRITERION 8 |
A graph is edited with tools provided as to achieve different formatting. |
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. | 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. | Mogapi Education Group (Pty) Ltd |
33. | Moving Ahead Development Agenc |
34. | Musengavhadzimu Media |
35. | Natfin Holdings Pty Ltd |
36. | Ndulita Solutions |
37. | Polokwane Technology Institute (Pty) Ltd |
38. | Progressive School of Business |
39. | PRX SCHOOL TEST |
40. | QUARPHIX (PTY) LTD |
41. | Redefine Human Capital (PTY) L |
42. | Richfield Graduate Institute of Technology Pty Ltd |
43. | Rostec Technical FET College (Pty) Ltd |
44. | Sabile Human Resources Consult |
45. | SANDM IT TRAINING (PTY) LTD |
46. | Silulo Ulutho Technologies |
47. | Synergistic Covenant Network NPO |
48. | Techtisa (pty) Ltd |
49. | The Finishing College (Pty) Lt |
50. | Titan Trade Technologies |
51. | TORQUE TECHNICAL COMPUTER TRAINING PTY LTD |
52. | Varsity Institute of Science & Technology (Pty)Ltd |
53. | Wellinkwise Pty Ltd |
54. | Whitestone College |
55. | ZA WIT (PTY) LTD |
56. | 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. |