|
|
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: |
| Demonstrate knowledge of and produce computer spreadsheets using basic functions |
| SAQA US ID | UNIT STANDARD TITLE | |||
| 7572 | Demonstrate knowledge of and produce computer spreadsheets using basic functions | |||
| ORIGINATOR | ||||
| SGB Information Systems and Technology | ||||
| 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 2 | NQF Level 02 | 3 |
| REGISTRATION STATUS | REGISTRATION START DATE | REGISTRATION END DATE | SAQA DECISION NUMBER | |
|
Passed the End Date - Status was "Reregistered" |
2003-12-03 | 2004-12-02 | SAQA 1351/03 | |
| LAST DATE FOR ENROLMENT | LAST DATE FOR ACHIEVEMENT | |||
| 2005-12-02 | 2008-12-02 | |||
| 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 is replaced by: |
| US ID | Unit Standard Title | Pre-2009 NQF Level | NQF Level | Credits | Replacement Status |
| 116937 | Use a Graphical User Interface (GUI)-based spreadsheet application to create and edit spreadsheets | Level 2 | NQF Level 02 | 4 |
| PURPOSE OF THE UNIT STANDARD |
| People credited with this unit standard are able to
demonstrate knowledge of the uses and features of computer spreadsheets? produce a computer spreadsheet file? use computer spreadsheet application basic functions |
| LEARNING ASSUMED TO BE IN PLACE AND RECOGNITION OF PRIOR LEARNING |
| Open.
The credit value of this unit is based on a person having the prior knowledge and skills to operate a personal computer. |
| Specific Outcomes and Assessment Criteria: |
| SPECIFIC OUTCOME 1 |
| Demonstrate knowledge of the uses and features of computer spreadsheets. |
| OUTCOME NOTES |
| 1.1 Uses of spreadsheets are identified in terms of their advantages.
1.2 Methods of moving the cell cursor are demonstrated in order to move about the spreadsheet. 1.3 Examples of spreadsheet programs are named. |
ASSESSMENT CRITERIA |
| ASSESSMENT CRITERION 1 |
| Demonstrate knowledge of the uses and features of computer spreadsheets |
| ASSESSMENT CRITERION NOTES |
| 1.1 Uses of spreadsheets are identified in terms of their advantages.
1.2 Methods of moving the cell cursor are demonstrated in order to move about the spreadsheet .1.3 Examples of spreadsheet programs are named. |
| SPECIFIC OUTCOME 2 |
| Produce a computer spreadsheet file. |
| OUTCOME NOTES |
| 1 Data is entered into the spreadsheet using labels and values.
2.2 Data is formatted to produce the required spreadsheet in terms of cell width, alignment, text, number .2.3 Spreadsheet formulae are applied in order to add, subtract, multiply, divide, and 2.4 Data integrity practices are demonstrated in terms of comparison with original information sources, audited formulae, and check-totals .2.5 Cell ranges within the spreadsheet are charted to produce charts that are relative to the requirement. |
ASSESSMENT CRITERIA |
| ASSESSMENT CRITERION 1 |
| Produce a computer spreadsheet file |
| ASSESSMENT CRITERION NOTES |
| 1 Data is entered into the spreadsheet using labels and values
.2.2 Data is formatted to produce the required spreadsheet in terms of cell width, alignment, text, number formats. 2.3 Spreadsheet formulae are applied in order to add, subtract, multiply, divide, and sum .2.4 Data integrity practices are demonstrated in terms of comparison with original information sources, audited formulae, and check-totals. 2.5 Cell ranges within the spreadsheet are charted to produce charts that are relative to the requirement. |
| SPECIFIC OUTCOME 3 |
| Use computer spreadsheet application, basic functions |
| OUTCOME NOTES |
| 3.1 A facility is used to find spreadsheet application information.
3.2 File management techniques are demonstrated in relationship to the spreadsheet program in use. Range: create, name, save, copy, rename, abandon changes, locate folder, display folder contents, locate file. 3.3 Basic cell formatting and editing techniques are Range: Column width, text font, style, size 3.4 The spreadsheet document is previewed and printed using page orientation in keeping with the layout required. |
ASSESSMENT CRITERIA |
| ASSESSMENT CRITERION 1 |
| Use computer spreadsheet application, basic functions. |
| ASSESSMENT CRITERION NOTES |
| 3.1 A facility is used to find spreadsheet application information
.3.2 File management techniques are demonstrated in relationship to the spreadsheet program in use. Range: create, name, save, copy, rename, abandon changes, locate folder, display folder contents, locate file .3.3 Basic cell formatting and editing techniques are demonstrated Range: Column width, text font, style, size 3.4 The spreadsheet document is previewed and printed using page orientation in keeping with the layout required. |
| Critical Cross-field Outcomes (CCFO): |
| UNIT STANDARD CCFO IDENTIFYING |
| Identify and solve problems. |
| UNIT STANDARD CCFO WORKING |
| Work effectively with others as a member of a team, group, organisation. |
| UNIT STANDARD CCFO ORGANISING |
| Organise and manage oneself and one`s activities responsibly and effectively. |
| UNIT STANDARD CCFO COLLECTING |
| Collect, organise and critically evaluate. |
| UNIT STANDARD CCFO COMMUNICATING |
| Communicate effectively using visual, mathematical, and language skills in modes of oral and written. |
| UNIT STANDARD CCFO SCIENCE |
| Use science and technology effectively and critically (showing responsibility towards the environment and health. |
| UNIT STANDARD CCFO DEMONSTRATING |
| Demonstrate an understanding of the world as a set of related systems. |
| UNIT STANDARD CCFO CONTRIBUTING |
| Contribute to the full personal development of each learner and the social and economic development of society at large, by making it the underlying intention of any programme of learning to make an individual aware of the importance of:-
reflecting on exploring a variety of strategies to learn more effectively- participating as responsible citizens in the life of local, national and global communities- being culturally and aesthetically sensitive across a range of social contexts- exploring education and career opportunities and- developing entrepreneurial opportunities. |
| UNIT STANDARD NOTES |
| This unit standard has been replaced by 116937, which is "Use a Graphical User Interface (GUI)-based spreadsheet application to create and edit spreadsheets", Level 2, 4 Credits. |
| QUALIFICATIONS UTILISING THIS UNIT STANDARD: |
| ID | QUALIFICATION TITLE | PRE-2009 NQF LEVEL | NQF LEVEL | STATUS | END DATE | PRIMARY OR DELEGATED QA FUNCTIONARY | |
| Fundamental | 48473 | National Certificate: Electrical Engineering | Level 2 | NQF Level 02 | Passed the End Date - Status was "Reregistered" |
2009-02-18 | Was EWSETA until Last Date for Achievement |
| Fundamental | 20419 | National Certificate: Electrical Engineering | Level 3 | NQF Level 03 | Passed the End Date - Status was "Registered" |
2004-02-10 | Was EWSETA until Last Date for Achievement |
| Fundamental | 23274 | National Certificate: Mechanical Engineering: Fitting | Level 3 | NQF Level 03 | Passed the End Date - Status was "Reregistered" |
2008-06-25 | MERSETA |
| Fundamental | 48650 | National Certificate: Seed Research and Development Operations | Level 3 | NQF Level 03 | Passed the End Date - Status was "Reregistered" |
2023-06-30 | AgriSETA |
| Fundamental | 48906 | Further Education and Training Certificate: Supervision of Wastewater Reticulation Operations | Level 4 | NQF Level 04 | Passed the End Date - Status was "Reregistered" |
2008-02-19 | Was EWSETA until Last Date for Achievement |
| Fundamental | 48910 | Further Education and Training Certificate: Water Purification Processes | Level 4 | NQF Level 04 | Passed the End Date - Status was "Reregistered" |
2023-06-30 | EWSETA |
| Fundamental | 23895 | National Certificate: Supervision of Building Construction Processes | Level 4 | NQF Level 04 | Passed the End Date - Status was "Registered" |
2004-06-09 | Was CETA until Last Date for Achievement |
| Fundamental | 23682 | National Certificate: Supervision of Civil Engineering Construction Processes: Labour Intensive Construction | Level 4 | NQF Level 04 | Passed the End Date - Status was "Registered" |
2004-06-09 | Was CETA until Last Date for Achievement |
| Fundamental | 23674 | National Certificate: Supervision of Civil Engineering Construction Processes: Road Works | Level 4 | NQF Level 04 | Passed the End Date - Status was "Registered" |
2004-06-09 | Was CETA until Last Date for Achievement |
| Fundamental | 23673 | National Certificate: Supervision of Civil Engineering Construction Processes: Water and Waste Water | Level 4 | NQF Level 04 | Passed the End Date - Status was "Registered" |
2004-06-09 | Was CETA until Last Date for Achievement |
| Fundamental | 49053 | National Certificate: Supervision of Construction Processes | Level 4 | Level TBA: Pre-2009 was L4 | Passed the End Date - Status was "Reregistered" |
2018-06-30 | Was CETA until Last Date for Achievement |
| Elective | 49058 | National Certificate: Construction Materials Testing | Level 2 | NQF Level 02 | Passed the End Date - Status was "Reregistered" |
2023-06-30 | CETA |
| Elective | 48806 | National Certificate: Craft Production | Level 2 | NQF Level 02 | Passed the End Date - Status was "Reregistered" |
2023-06-30 | CATHSSETA |
| Elective | 48725 | National Certificate: Explosives Operations | Level 2 | NQF Level 02 | Passed the End Date - Status was "Registered" |
2007-04-07 | Was CHIETA until Last Date for Achievement |
| Elective | 77163 | National Certificate: Industrial Water Treatment Support System Operations | Level 2 | NQF Level 02 | Passed the End Date - Status was "Reregistered" |
2023-06-30 | EWSETA |
| Elective | 14657 | National Certificate: Insurance Administration | Level 2 | NQF Level 02 | Passed the End Date - Status was "Registered" |
2004-04-18 | INSETA |
| Elective | 49068 | National Certificate: Railway Signalling: Assembly and Wiring of Equipment | Level 2 | NQF Level 02 | Passed the End Date - Status was "Reregistered" |
2023-06-30 | TETA |
| Elective | 58497 | National Certificate: Automotive Repair and Maintenance | Level 3 | NQF Level 03 | Passed the End Date - Status was "Registered" |
2009-02-18 | Was MERSETA until Last Date for Achievement |
| Elective | 22859 | National Certificate: Autotronics | Level 3 | NQF Level 03 | Passed the End Date - Status was "Reregistered" |
2009-11-07 | Was MERSETA until Last Date for Achievement |
| Elective | 49017 | National Certificate: Construction Materials Testing | Level 3 | NQF Level 03 | Passed the End Date - Status was "Reregistered" |
2023-06-30 | CETA |
| Elective | 24456 | National Certificate: Maintaining Vehicles | Level 3 | NQF Level 03 | Passed the End Date - Status was "Reregistered" |
2008-02-06 | Was MERSETA until Last Date for Achievement |
| Elective | 49216 | National Certificate: Pipeline Operations | Level 3 | NQF Level 03 | Passed the End Date - Status was "Reregistered" |
2023-06-30 | TETA |
| Elective | 48905 | National Certificate: Wastewater Reticulation Services | Level 3 | NQF Level 03 | Passed the End Date - Status was "Reregistered" |
2008-02-19 | Was EWSETA until Last Date for Achievement |
| Elective | 23708 | National Certificate: Community Water, Sanitation and Health Facilitation | Level 4 | NQF Level 04 | Passed the End Date - Status was "Reregistered" |
2008-06-11 | Was EWSETA until Last Date for Achievement |
| Elective | 24194 | National Certificate: Construction Material Manufacturing | Level 4 | Level TBA: Pre-2009 was L4 | Passed the End Date - Status was "Reregistered" |
2023-06-30 | CETA |
| Elective | 23975 | National Certificate: Construction Material Testing: Bituminous Materials | Level 4 | NQF Level 04 | Passed the End Date - Status was "Registered" |
2004-02-11 | Was CETA until Last Date for Achievement |
| Elective | 23974 | National Certificate: Construction Material Testing: Soils and Aggregates | Level 4 | NQF Level 04 | Passed the End Date - Status was "Registered" |
2004-02-11 | Was CETA until Last Date for Achievement |
| Elective | 23678 | National Certificate: Fossil Power Plant Operation | Level 4 | Level TBA: Pre-2009 was L4 | Passed the End Date - Status was "Reregistered" |
2023-06-30 | EWSETA |
| Elective | 23735 | National Certificate: Hydro Power Plant Operation | Level 4 | Level TBA: Pre-2009 was L4 | Passed the End Date - Status was "Reregistered" |
2009-02-18 | Was EWSETA until Last Date for Achievement |
| Elective | 23733 | National Certificate: Nuclear Power Plant Operation | Level 4 | Level TBA: Pre-2009 was L4 | Passed the End Date - Status was "Reregistered" |
2023-06-30 | EWSETA |
| Elective | 23476 | National Certificate: Supervision of Water Reticulation Operations | Level 4 | NQF Level 04 | Passed the End Date - Status was "Reregistered" |
2008-02-09 | Was EWSETA until Last Date for Achievement |
| Elective | 23736 | National Diploma: Hydro Power Plant Process Control | Level 5 | Level TBA: Pre-2009 was L5 | Passed the End Date - Status was "Reregistered" |
2009-02-18 | Was EWSETA until Last Date for Achievement |
| 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. | AVUXENI COMPUTER ACADEMY KZN |
| 2. | Buhlebetfu Investments Pty Ltd |
| 3. | Capricorn FET College - Central Office |
| 4. | CLEAN HEAT ENERGY SAVING SOLUTIONS (PTY) LTD |
| 5. | Construction Resource Development College |
| 6. | CTU Training Solutions |
| 7. | Eastcape Training Centre |
| 8. | EDUCATORY ELECTRO SERVICES |
| 9. | Elite Operator and Skills Training |
| 10. | ERGO MAPHELONG INSTITUTE (PTY) LTD |
| 11. | Judy Atipa Investment Pty Ltd |
| 12. | K2011145379(South Africa) (Pty) Ltd |
| 13. | Leps Training Consultants |
| 14. | Microzone Training CC |
| 15. | Mpontshe Training |
| 16. | Novi General Services |
| 17. | Othandweni Training Centre |
| 18. | Raubex Construction Pty (Ltd) |
| 19. | SEDA Construction Incubator Trust |
| 20. | Sinovuyolethu Trading Pty Ltd |
| 21. | Sonani Training and Communications |
| 22. | South African Value Education (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. |