SAQA 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 spreadsheet package to produce and manage business documents 
SAQA US ID UNIT STANDARD TITLE
114977  Use a spreadsheet package to produce and manage business documents 
ORIGINATOR
SGB Insurance and Investment 
PRIMARY OR DELEGATED QUALITY ASSURANCE FUNCTIONARY
-  
FIELD SUBFIELD
Field 03 - Business, Commerce and Management Studies Finance, Economics and Accounting 
ABET BAND UNIT STANDARD TYPE PRE-2009 NQF LEVEL NQF LEVEL CREDITS
Undefined  Regular  Level 3  NQF Level 03 
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 for learners who use a computer in a business environment. It is an introduction to basic computer literacy.

The qualifying learner is capable of:
  • Demonstrating the basic functions of a spreadsheet package.
  • Managing files in a spreadsheet package.
  • Formatting and editing data in an existing spreadsheet.
  • Constructing formulae and manipulating data.
  • Present data in different formats. 

  • LEARNING ASSUMED TO BE IN PLACE AND RECOGNITION OF PRIOR LEARNING 
    Learners should:
  • Hold a GETC or equivalent qualification; or
  • Be competent in Communication and Mathematical Literacy at NQF level 2. 

  • UNIT STANDARD RANGE 
    The typical scope of this Unit Standard is:
  • Basic concepts include, but are not limited to, formulas, functions, text, numbers, number of sheets and number of columns and rows.
  • Information on the screen includes, but is not limited to, menus, toolbar, status bar, shortcut keys, formula bar, cells, rows, columns and scroll bar.
  • Use of keyboard and mouse includes, but is not limited to, moving from sheet to sheet, moving from cell to cell, jumping to a cell using the go to option and using scroll bars.
  • Text and numeric data includes, but is not limited to labels, currency, date, and decimal format.
  • Use of the filing system includes, but is not limited to, open, move, copy, rename and delete a specific file or folder.
  • Formatting includes, but is not limited to, fonts, alignment, numbers, borders, shading, patterns, cells, rows, columns, size and cell protection.
  • Manipulation of data includes, but is not limited to, cut, paste, move, copy, delete, insert, hide and sort.
  • Use of formulae includes, but is not limited to, the structure of a formula, use of the relevant formula for a specific purpose, absolute/relative cell reference.
  • Application of formulae includes, but is not limited to the use of the toolbar and menu bar and in cell editing.
  • The spell check function includes, but is not limited to, checking a single word, checking a document and adding words for future reference.
  • Printing includes, but is not limited to, printing a single page, printing the entire workbook, set and clear a print area.
  • Sending e-mail includes sending a file from within a spreadsheet or sending it as an attachment.
  • Presentation formats include tables, pie charts, bar graphs, line graphs and schedules.
  • Reports may be printed and emailed.
  • Checking for suitability includes, but is not limited to, headers, footers, page divisions, page numbers, page orientation, margins, paper size, repeated rows and/or column headings. 

  • Specific Outcomes and Assessment Criteria: 

    SPECIFIC OUTCOME 1 
    Demonstrate the basic functions of a spreadsheet package. 

    ASSESSMENT CRITERIA
     

    ASSESSMENT CRITERION 1 
    The basic concept of a spreadsheet is explained with examples. 

    ASSESSMENT CRITERION 2 
    A spreadsheet is accessed and an indication is given of the information contained on the screen. 

    ASSESSMENT CRITERION 3 
    The default options are changed to suit own preferences. 

    ASSESSMENT CRITERION 4 
    The keyboard and mouse are used to navigate a spreadsheet package. 

    ASSESSMENT CRITERION 5 
    Text and numeric data is entered in a spreadsheet to create a new document. 

    ASSESSMENT CRITERION 6 
    The help function is demonstrated for a specific task. 

    SPECIFIC OUTCOME 2 
    Manage files in a spreadsheet package. 

    ASSESSMENT CRITERIA
     

    ASSESSMENT CRITERION 1 
    The basic computer filing system within a spreadsheet package is navigated to open, move, copy, rename and delete a specific file or folder. 

    ASSESSMENT CRITERION 2 
    A file is saved with reference to type, format and version. 

    ASSESSMENT CRITERION 3 
    The difference between Save and Save As is explained with examples. 

    SPECIFIC OUTCOME 3 
    Format and edit data in an existing spreadsheet. 

    ASSESSMENT CRITERIA
     

    ASSESSMENT CRITERION 1 
    The data in the spreadsheet is formatted for a specific purpose and design. 

    ASSESSMENT CRITERION 2 
    Data in a spreadsheet is manipulated to change the appearance of the document to match the purpose. 

    ASSESSMENT CRITERION 3 
    The layout and format of the spreadsheet are checked for suitability. 

    SPECIFIC OUTCOME 4 
    Construct formulae and manipulate data. 

    ASSESSMENT CRITERIA
     

    ASSESSMENT CRITERION 1 
    The use of formulae in a spreadsheet package is explained with examples. 

    ASSESSMENT CRITERION 2 
    The application of formulae in a spreadsheet package is demonstrated with reference to the entering of formulae. 

    ASSESSMENT CRITERION 3 
    Verification of data in a spreadsheet is demonstrated in order to check accuracy of the calculations. 

    ASSESSMENT CRITERION 4 
    A formula is edited and/or verified to accommodate changes in data. 

    SPECIFIC OUTCOME 5 
    Present data in different formats. 

    ASSESSMENT CRITERIA
     

    ASSESSMENT CRITERION 1 
    The presentation formats available in a spreadsheet package are identified and an indication is given of when it is appropriate to use each. 

    ASSESSMENT CRITERION 2 
    Data is prepared for presentation in different formats and layout according to a defined purpose. 

    ASSESSMENT CRITERION 3 
    The spell check function is applied and a document is produced for a specific audience. 


    UNIT STANDARD ACCREDITATION AND MODERATION OPTIONS 
    This Unit Standard will be internally assessed by the provider and moderated by a moderator registered by a relevant accredited ETQA or an ETQA that has a Memorandum of Understanding with the relevant accredited ETQA. 

    UNIT STANDARD DEVELOPMENTAL OUTCOME 
    N/A 

    UNIT STANDARD LINKAGES 
    N/A 


    Critical Cross-field Outcomes (CCFO): 

    UNIT STANDARD CCFO ORGANISING 
    The learner can organise him/herself and his/her activities when producing business documents. 

    UNIT STANDARD CCFO SCIENCE 
    The learner can use technology effectively by using a spreadsheet package in a business environment. 

    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
    Core  59057   Further Education and Training Certificate: Telecommunication Network Operations  Level 4  NQF Level 04  Passed the End Date -
    Status was "Reregistered" 
    2023-06-30  MICTS 
    Elective  48783   National Certificate: Financial Services  Level 2  NQF Level 02  Passed the End Date -
    Status was "Reregistered" 
    2023-06-30  INSETA 
    Elective  49772   National Certificate: Archaeology  Level 3  NQF Level 03  Passed the End Date -
    Status was "Reregistered" 
    2012-06-30  CATHSSETA 
    Elective  64589   National Certificate: Community Water, Health and Sanitation Monitoring  Level 3  NQF Level 03  Passed the End Date -
    Status was "Reregistered" 
    2023-06-30  EWSETA 
    Elective  61669   Further Education and Training Certificate: Community Water, Health and Sanitation Facilitation  Level 4  NQF Level 04  Passed the End Date -
    Status was "Reregistered" 
    2023-06-30  EWSETA 
    Elective  49256   Further Education and Training Certificate: Counselling  Level 4  NQF Level 04  Passed the End Date -
    Status was "Reregistered" 
    2023-06-30  HW SETA 
    Elective  49649   Further Education and Training Certificate: Long-term Insurance  Level 4  NQF Level 04  Passed the End Date -
    Status was "Reregistered" 
    2023-06-30  INSETA 
    Elective  66609   Further Education and Training Certificate: Retail Insurance  Level 4  NQF Level 04  Passed the End Date -
    Status was "Reregistered" 
    2023-06-30  As per Learning Programmes recorded against this Qual 
    Elective  66610   Further Education and Training Certificate: Short Term Insurance  Level 4  NQF Level 04  Passed the End Date -
    Status was "Reregistered" 
    2023-07-30  As per Learning Programmes recorded against this Qual 
    Elective  66809   Further Education and Training Certificate: Sport Technical Officiating  Level 4  NQF Level 04  Passed the End Date -
    Status was "Reregistered" 
    2023-06-30  CATHSSETA 
    Elective  65949   Further Education and Training Certificate: Supervision of Construction Processes  Level 4  NQF Level 04  Passed the End Date -
    Status was "Reregistered" 
    2023-06-30  CETA 


    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 for Construction Skills (Pty) Ltd (ACS) 
    2. Africa Learn (Pty) Ltd 
    3. ALL CONNECTIONS TRAINING AND CONSTRUCTION (PTY) LTD 
    4. Amadi Institute of Management And Technology (Pty) Ltd 
    5. ATTI (Advanced Technonogy Training Institute) 
    6. BEE Clinic Pty Ltd 
    7. BRC Solutions (Pty) Ltd 
    8. CHILUTSI TRADING ENTERPRISE 
    9. CKP Development Agency (Pty) Ltd 
    10. CTU Training Solutions 
    11. De Vries Management & Training Services cc 
    12. DINALEDI MANAGEMENT AND SERVICES 
    13. ERGO MAPHELONG INSTITUTE (PTY) LTD 
    14. ESKOM GENERATION - PALMIET PUMP STORAGE GRABOUW 
    15. Faisit (Pty) Ltd 
    16. HAZYVIEW WATER SKILLS ACADEMY 
    17. HUAWEI Technologies Africa (PTY) LTD 
    18. INDUSTRIES EDUCATION & TRAINING INSTITUTE - PE TTC 
    19. MOTHEO SKILLS ENTITY ( PTY) LLTD 
    20. Mpande Technologies cc 
    21. Mufuka Business and Technical 
    22. Nolwazi Stem Education for The 
    23. OPELONG BUSINESS INSTITUTE (PT 
    24. POWER SYSTEMS TRAINING, CAPE TOWN 
    25. Progressive School of Business 
    26. PROGRESSIVE SCHOOL OF BUSINESS AND ENGINEERING (PTY) LTD 
    27. QUARPHIX (PTY) LTD 
    28. Ripple Effect 4 (Pty) Ltd 
    29. SEANEGO INTERGRATED NATURAL RESOURCES MANAGEMENT 
    30. SOUTHERN AFRICAN YOUTH MOVEMENT 
    31. SUCCESS BUILDERS INTERNATIONAL CC 
    32. SUPREME ICT CONSULTANTS 
    33. TECHNICAL INTEGRATED SOLUTIONS (PTY) LTD 
    34. TELKOM SA SOC LIMITED 
    35. The Graduate Institute of Financial Sciences (Pty) Ltd 
    36. THOBOLOGO TRAINING & EDUCATION GROUP 
    37. Ukwazi Academy and Corporate S 
    38. Varsity Institute of Science & Technology (Pty)Ltd 
    39. Victor Optic Fibre Solutions 
    40. Wellinkwise 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.