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: 

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
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  Reregistered  2023-06-30  MICTS 
    Elective  48783   National Certificate: Financial Services  Level 2  NQF Level 02  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  Reregistered  2023-06-30  EWSETA 
    Elective  61669   Further Education and Training Certificate: Community Water, Health and Sanitation Facilitation  Level 4  NQF Level 04  Reregistered  2023-06-30  EWSETA 
    Elective  49256   Further Education and Training Certificate: Counselling  Level 4  NQF Level 04  Reregistered  2023-06-30  HW SETA 
    Elective  49649   Further Education and Training Certificate: Long-term Insurance  Level 4  NQF Level 04  Reregistered  2023-06-30  INSETA 
    Elective  66609   Further Education and Training Certificate: Retail Insurance  Level 4  NQF Level 04  Reregistered  2021-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  Reregistered  2021-06-30  As per Learning Programmes recorded against this Qual 
    Elective  66809   Further Education and Training Certificate: Sport Technical Officiating  Level 4  NQF Level 04  Reregistered  2023-06-30  CATHSSETA 
    Elective  65949   Further Education and Training Certificate: Supervision of Construction Processes  Level 4  NQF Level 04  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. Alcari Learning Centre (Pty) Ltd 
    2. ALSTOM JOHN THOMPSON (PTY) LTD CAPE TOWN 
    3. AMBROSER SOLUTIONS (PTY) LTD 
    4. ARBINET TRAINING & DEVELOPMENT 
    5. AZIFANI PROJECTS AND TRANSPORT (PTY) LTD 
    6. BALOMAT SKILLS TRAINING ACADEMY 
    7. BRC Solutions (Pty) Ltd 
    8. Candy Nxusani Trading 
    9. CKP Development Agency (Pty) Ltd. 
    10. CTU Training Solutions 
    11. De Vries Management & Training Services cc 
    12. EARTH CHILD CONSULTING (PTY) LTD 
    13. EECTRICAL CONTRACTORS ASSOCIATION - ECA 
    14. EJW Financial Services (Pty) Ltd 
    15. EMINENCE BUSINESS SOLUTIONS (PTY) LTD 
    16. ESKOM DISTRIBUTION NORTH WESTERN REGION, BLOEMFONTEIN 
    17. Executive People Development Solutions (Pty) Ltd 
    18. Faisit (Pty) Ltd 
    19. Glicam Trading Enterprise 
    20. Greenfield Management Solutions 
    21. IMPILONHLE TRADING & PROJECTS 8 
    22. Indalo Health And Wellness (PTY) Ltd 
    23. INFRASTRUCTURE CONSULTING ENGINEERS CC 
    24. INGEN ENGINEERING PROJECTS 
    25. Intec College 
    26. Intelligo Solutions Pty (Ltd) 
    27. Invuya Institute of Learning (Pty) Ltd 
    28. IYANDA HOLDINGS (PTY) LTD 
    29. JOSMAP TRAINING INSTIUTE 
    30. KAREUBO MANAGEMENT SYSTEMS 
    31. Learn A Trade 
    32. Lesedi Hospice 
    33. License to Skill cc 
    34. MACT BUSINESS HUB 
    35. Masifunde Training Centre (Pty) Ltd 
    36. Milnex - Brakpan 
    37. MMESELANE CONSTRUCTION 
    38. MOVING AHEAD DEVELOPMENT AGENCY 
    39. MUNICIPAL TRAINING & DEVELOPMENT INSTITUTE 
    40. NEW HOPE REVIVAL ORGANISATION 
    41. NKANYEZI FOUNDATION 
    42. Ntongenhle Construction Force 
    43. Octomate (Pty) Ltd 
    44. Outsurance Insurance Company Ltd 
    45. PERSEVCON CONSTRUCTION PTY LTD 
    46. Phathutshedzo Connsulting Training Provider 
    47. PRAXIS TRAINING AND CONSULTANCY (PTY) LTD 
    48. Richfield Graduate Institute of Technology Pty Ltd 
    49. Ripple Effect 4 (Pty) Ltd 
    50. RJM Educational Consulting PTY LTD 
    51. ROCKWELL AUTOMATION 
    52. RONNELS CONSTRUCTION PTY LTD 
    53. Sinethemba Visiwe PTY LTD 
    54. Sodic Training and Development 
    55. SOUTH AFRICA ADVANCED SKILLS INSTITUTE 
    56. SOUTHERN AFRICAN YOUTH MOVEMENT 
    57. TELKOM SA SOC LTD 
    58. Tira Telecoms 
    59. Triple Play Fibre Optic Solutions 
    60. Yetfu Trading 



    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.