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: 

Produce spreadsheets using accounting related information technology 
SAQA US ID UNIT STANDARD TITLE
12998  Produce spreadsheets using accounting related information technology 
ORIGINATOR
SGB HET Accountancy and Financial Management 
PRIMARY OR DELEGATED QUALITY ASSURANCE FUNCTIONARY
FASSET - Financial and Accounting Services SETA 
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 5  Level TBA: Pre-2009 was L5 
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 
People credited with this unit standard are generally found within the accounting technician intermediate stage. On successful completion of the unit standard, people will be able to use information technology as an essential tool when undertaking accounting activities. This involves the ability to obtain information from a computerised management information system, produce spreadsheets for the analysis of numerical information, and contribute to the quality of the aforesaid management information system within an accounting environment. 

LEARNING ASSUMED TO BE IN PLACE AND RECOGNITION OF PRIOR LEARNING 
  • Unit standards for Computer literacy at NQF level 4
  • Unit standard, Work with information technology in an accounting environment, NQF level 5 

  • UNIT STANDARD RANGE 
  • Information; obtained from own work and area of responsibility, obtained on request from others
  • Spreadsheets include those that require possible rounding errors, have conditions in some formulas, are used to produce graphs
  • MIS - computerised system 

  • Specific Outcomes and Assessment Criteria: 

    SPECIFIC OUTCOME 1 
    Obtain information from a computerised management information system. 
    OUTCOME RANGE 
    Information; obtained from own work and area of responsibility, obtained on request from others 

    ASSESSMENT CRITERIA
     

    ASSESSMENT CRITERION 1 
    1. The principles of general information technology are described in relation to MIS, other IT applications and spreadsheets. 

    ASSESSMENT CRITERION 2 
    2. The required information is correctly located within the MIS structure. 
    ASSESSMENT CRITERION RANGE 
    Information locations; database, unique reference codes
     

    ASSESSMENT CRITERION 3 
    3. Advice is sought from the appropriate person, where there are difficulties in obtaining the required information. 
    ASSESSMENT CRITERION RANGE 
    Costs incurred, Time taken
     

    ASSESSMENT CRITERION 4 
    4. Additional authorisation is obtained for sensitive or confidential information in accordance with the organisation's security regulations. 

    ASSESSMENT CRITERION 5 
    5. Information is checked for its accuracy and completeness. 

    ASSESSMENT CRITERION 6 
    6. Information is stored in a format that facilitates access and use by others. 

    ASSESSMENT CRITERION 7 
    7. Confidential information is kept secure and not disclosed to unauthorised people. 

    SPECIFIC OUTCOME 2 
    Produce spreadsheets for the analysis of numerical information. 
    OUTCOME RANGE 
    Spreadsheets include those that require possible rounding errors, have conditions in some formulas, are used to produce graphs 

    ASSESSMENT CRITERIA
     

    ASSESSMENT CRITERION 1 
    1. The spreadsheet is titled in a way that clearly defines its use and purpose. 

    ASSESSMENT CRITERION 2 
    2. The arrangement of the spreadsheet is consistent with organisational conventions. 
    ASSESSMENT CRITERION RANGE 
    Spreadsheet produced for own work and area of responsibility and/ or on request from others
     

    ASSESSMENT CRITERION 3 
    3. All rates and other numeric inputs and assumptions are stated to the correct number of decimal places. 
    ASSESSMENT CRITERION RANGE 
    Information may be numeric and/ or alphabetic
     

    ASSESSMENT CRITERION 4 
    4. Calculated values are checked for correctness when changes are made to input data. 

    ASSESSMENT CRITERION 5 
    5. The spreadsheet is used to carry out data modifications and for entry of related formulas. 
    ASSESSMENT CRITERION RANGE 
    Spreadsheet produced by modification and/ or creation
     

    ASSESSMENT CRITERION 6 
    6. Each cell is formatted clearly and accurately. 

    ASSESSMENT CRITERION 7 
    7. A method is selected to eliminate rounding errors which is suitable for the purpose of the spreadsheet. 

    ASSESSMENT CRITERION 8 
    8. Confidential information is kept secure and not disclosed to unauthorised people. 

    SPECIFIC OUTCOME 3 
    Contribute to the quality of the management information system. 
    OUTCOME RANGE 
    MIS - computerised system 

    ASSESSMENT CRITERIA
     

    ASSESSMENT CRITERION 1 
    1. Potential improvements to the MIS are identified and considered for their impact on the quality of the system and any interrelated systems. 

    ASSESSMENT CRITERION 2 
    2. Suggestions for changes are supported by a clear rationale as to how they could improve the quality of the system. 

    ASSESSMENT CRITERION 3 
    3. The reliability of assumptions and judgements made is assessed and clearly stated. 

    ASSESSMENT CRITERION 4 
    4. The benefits and costs of all changes are described accurately. 

    ASSESSMENT CRITERION 5 
    5. Suggestions are presented clearly and in a way that assists people to understand and act on them. 


    UNIT STANDARD ACCREDITATION AND MODERATION OPTIONS 
    Accreditation for this unit standard shall be obtained from the relevant Education and Training Quality Assurance Body, through summative assessment by a registered assessor.

    Moderation activity comments by SGB`s, organisations and individuals may be forwarded to NSB03. 

    UNIT STANDARD ESSENTIAL EMBEDDED KNOWLEDGE 
    A demonstrated understanding of:
  • General Information Technology
  • The organisation
  • MIS
  • Other IT applications
  • Spreadsheets
  • Organisation`s computer software, systems and networking
  • Cost benefit analysis techniques

    Legal Requirements:
  • Security and legal regulations;
  • Data Protection Act

    Terminology:
  • MIS - Management Information Systems
  • IT - Information Technology 


  • Critical Cross-field Outcomes (CCFO): 

    UNIT STANDARD CCFO IDENTIFYING 
    Identify and solve problems in which responses display that responsible decisions using critical and creative thinking have been made. 

    UNIT STANDARD CCFO WORKING 
    Work effectively with others as a member of a team, group, organisation and community. 

    UNIT STANDARD CCFO ORGANISING 
    Organise and manage oneself and one`s activities responsibly and effectively. 

    UNIT STANDARD CCFO COLLECTING 
    Collect, organise and critically evaluate information. 

    UNIT STANDARD CCFO COMMUNICATING 
    Communicate effectively using visual, mathematical and language skills in the modes of oral and written presentations. 

    UNIT STANDARD CCFO SCIENCE 
    Use science and technology effectively and critically (showing responsibility towards the environment and health of others). 

    UNIT STANDARD CCFO DEMONSTRATING 
    Demonstrate an understanding of the world as a set of related systems. 

    UNIT STANDARD CCFO CONTRIBUTING 
    Be culturally and aesthetically sensitive across a range of social contexts. 

    REREGISTRATION HISTORY 
    As per the SAQA Board decision/s at that time, this unit standard was Reregistered in 2012; 2015. 

    QUALIFICATIONS UTILISING THIS UNIT STANDARD: 
      ID QUALIFICATION TITLE PRE-2009 NQF LEVEL NQF LEVEL STATUS END DATE PRIMARY OR DELEGATED QA FUNCTIONARY
    Core  23734   National Diploma: Nuclear 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 
    Core  36213   National Diploma: Technical Financial Accounting  Level 5  NQF Level 05  Reregistered  2023-06-30  FASSET 
    Fundamental  35926   National Diploma: Payroll Administration Services  Level 5  Level TBA: Pre-2009 was L5  Passed the End Date -
    Status was "Reregistered" 
    2009-03-31  Was SERVICES until Last Date for Achievement 
    Fundamental  67229   National Diploma: Payroll Administration Services  Level 5  NQF Level 05  Reregistered  2023-06-30  SERVICES 
    Fundamental  23653   National Diploma: Financial Markets  Level 6  NQF Level 06  Reregistered  2023-06-30  FASSET 
    Elective  49021   Further Education and Training Certificate: Debt Recovery  Level 4  NQF Level 04  Reregistered  2023-06-30  FASSET 
    Elective  58394   National Certificate: Film and Television Production  Level 5  Level TBA: Pre-2009 was L5  Reregistered  2023-06-30  MICTS 
    Elective  23679   National Diploma: Fossil 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 
    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. Big Fish School of Digital Filmmaking (Pty) Ltd 
    2. Definitive Training Solutions CC 
    3. eMedia Investment 
    4. FILM Mentorship & Training 
    5. Footprint Media academy Pty ltd 
    6. Media Village Communication 
    7. South African Film Institute 
    8. The Media Workshop cc 
    9. Training for Results (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.