< All Topics
Print

National Certificate – Produce word processing documents for business – Level 3 – 7570

Purpose Of The Unit Standard 

People credited with this unit standard are able to:

  • demonstrate knowledge of the uses and advanced features of a word processing package on a personal computer (including use of spell-check and grammar checking tools) 
  • create and use bulleted and numbered lists and tables 
  • import and position pictures, images and objects into a word processing document 
  • use the mail merge feature 
  • Save the document in a format that it can be used in other applications 

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 produce and use word processing documents using basic functions. 

Unit Standard Outcome Header 

Change appearance of document 

Specific Outcomes and Assessment Criteria

Specific outcome 1 

Change appearance of document. 

Outcome range 

Page and section numbers, date author, file name, symbol 

Module 1

Plan and design computer spreadsheet documents to solve a business problem.

  • The problem is identified as being solvable by a spreadsheet.
  • The spreadsheet is designed and documented in keeping with the nature of the problem.

Module 2

Produce a computer spreadsheet file to solve a business problem.

  • Data is entered into the spreadsheet using labels and values.
  • Data is formatted to produce the required spreadsheet in terms of cell width, alignment, number and date and time formats.
  • Spreadsheet formulae are applied in order to produce the required spreadsheet in terms of statistical, time and date, financial and logical functions.
  • Absolute cell referencing is used in order to copy formulae across and down.
  • Template files are created, used and documented to meet the user requirements.
  • Data integrity practices are demonstrated in terms of comparison with original information sources, audited formulae, check-totals and sort.
  • The spreadsheet contains cells, which are sorted numerically and alphabetically.

Module 3

Use a computer spreadsheet file to solve a business problem.

  • Cell ranges within the spreadsheet are charted to meet user requirements.
  • Cell range within a spreadsheet is graphed to user requirements.
  • The problem is solved by the spreadsheet created.
  • “What if” exercises are applied to the spreadsheet in order to accommodate changes in requirements.
  • Where available, the use of the onscreen help facility is demonstrated.
  • File management techniques are demonstrated in terms of creating, naming, saving, copying, renaming, deleting, locating directory (folder), displaying directory contents printing and relocating.
  • The file is previewed and printed using page setup appropriate to the layout.

Module 4

Manipulate the data in a spreadsheet.

  • The appearance of spreadsheet is modified to user requirements using formatting facilities.
  • Selected cells within an existing spreadsheet file are sorted numerically and alphabetically.

Unit Standard Notes 

This unit standard has been replaced by:

  • 116938, which is “Use a Graphical User Interface (GUI)-based word processor to create and edit documents”, Level 1, 4 Credits; and
  • 117924, which is “Use a Graphical User Interface (GUI)-based word processor to format documents”, Level 2, 5 Credits; and
  • 119078, which is “Use a GUI-based word processor to enhance a document through the use of tables and columns”, Level 3, 5 Credits; and
  • 116942, which is “Use a GUI-based word processor to create merged documents”, Level 3, 3 Credits. 
IDQUALIFICATION TITLEPRE-2009 NQF LEVELNQF LEVELSTATUSEND DATEPRIMARY OR DELEGATED QA FUNCTIONARY
Core 67465 National Certificate: Business Administration Services Level 3 NQF Level 03 Reregistered 2018-06-30 As per Learning Programmes recorded against this Qual 
Core 60650 Professional Qualification: Business Administration Level 3 NQF Level 03 Reregistered 2018-06-30 As per Learning Programmes recorded against this Qual 
Core 48817 Further Education and Training Certification: Construction Materials Testing Level 4 NQF Level 04 Reregistered 2018-06-30 CETA 
Core 22672 National Certificate: Wastewater Process Control Level 4 NQF Level 04 Passed the End Date-
Status was “Reregistered” 
2008-06-11 Was EWSETA until Last Date for Achievement 
Fundamental 48902 National Certificate: Abattoir Supervision Level 3 NQF Level 03 Reregistered 2018-06-30 AgriSETA 
Fundamental 49128 National Certificate: Community Health Work Level 3 NQF Level 03 Passed the End Date –
Status was “Reregistered” 
2009-04-08 Was HW SETA until Last Date for Achievement 
Fundamental 22440 National Certificate: Customs Clearing Level 3 NQF Level 03 Passed the End Date- Status was “Reregistered” 2008-09-13 Was SETA until Last Date for Achievement 
Fundamental 22442 National Certificate: Freight Forwarding Level 3 NQF Level 03 Passed the End Date –
Status was “Reregistered” 
2008-09-13 SETA 
Fundamental 23453 National Certificate: Micro Finance Level 3 NQF Level 03 Reregistered 2018-06-30 BANKSETA 
Fundamental 48658 Further Education and Training Certificate: Seed Marketing Level 4 NQF Level 04 Reregistered 2018-06-30 AgriSETA 
Fundamental 48653 Further Education and Training Certificate: Seed Processing and Packaging Control Level 4 NQF Level 04 Reregistered 2018-06-30 AgriSETA 
Fundamental 48647 Further Education and Training Certificate: Seed Production Level 4 NQF Level 04 Reregistered 2018-06-30 AgriSETA 
Fundamental 48657 Further Education and Training Certificate: Seed Research and Development Level 4 NQF Level 04 Reregistered 2018-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 Reregistered 2018-06-30 EWSETA 
Fundamental 23675 National Certificate: Management of Building Construction Processes Level 5 Level TBA: Pre-2009 was L5 Reregistered 2018-06-30 CETA 
Fundamental 48671 National Certificate: Music Industry: Sound Technology Level 5 Level TBA: Pre-2009 was L5 Reregistered 2018-06-30 MICTS 
Fundamental 48908 National Certificate: Sanitation Project Co-ordination Level 5 Level TBA: Pre-2009 was L5 Reregistered 2018-06-30 EWSETA 
Fundamental 23683 National Diploma: Management of Civil Engineering Construction Processes Level 5 NQF Level 05 Reregistered 2018-06-30 CETA 
Elective 49058 National Certificate: Construction Materials Testing Level 2 NQF Level 02 Reregistered 2018-06-30 CETA 
Elective 48806 National Certificate: Craft Production Level 2 NQF Level 02 Reregistered 2018-06-30 CATHSSETA 
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 22867 National Certificate: Chemical Systems Operations Level 3 NQF Level 03 Passed the End Date –
Status was “Registered” 
2005-10-09 Was CHIETA until Last Date for Achievement 
Elective 49017 National Certificate: Construction Materials Testing Level 3 NQF Level 03 Reregistered 2018-06-30 CETA 
Elective 49600 National Certificate: Development Practice Level 3 NQF Level 03 Passed the End Date –
Status was “Reregistered” 
2009-05-13 Was ETDP SETA until Last Date for Achievement 
Elective 49056 National Certificate: Domestic Appliance Repair Level 3 NQF Level 03 Reregistered 2018-06-30 EWSETA 
Elective 48494 National Certificate: Financial Services Management Level 3 NQF Level 03 Passed the End Date –
Status was “Reregistered” 
2012-06-30 INSETA 
Elective 23138 National Certificate: Food and Beverage Laboratory Practices: Food and Beverage Laboratory Analysis Level3 NQF Level 03 Passed the End Date –
Status was “Registered” 
2005-12-04 Was FOODBEV until Last Date for Achievement 
Elective 20177 National Certificate: Insurance Level 3 NQF Level 03 Passed the End Date –
Status was “Registered” 
2004-10-10 Was INSETA until Last Date for Achievement 
Elective 83946 National Certificate: Management Level 3 NQF Level 03 Reregistered 2018-06-30 As per Learning Programmes recorded against this Qual 
Elective 48434 National Certificate: Molten Glass Production Level 3 NQF Level 03 Passed the End Date –
Status was “Reregistered” 
2008-09-17 Was CHIETA until Last Date for Achievement 
Elective 49216 National Certificate: Pipeline Operations Level 3 NQF Level 03 Reregistered 2018-06-30 TETA 
Elective 49449 National Certificate: Plastics Manufacturing Level 3 NQF Level 03 Reregistered 2018-06-30 MERSETA 
Elective 20889 National Certificate: Plastics Manufacturing Level 3 NQF Level 03 Passed the End Date –
Status was “Registered” 
2005-04-13 Was MERSETA until Last Date for Achievement 
Elective 36155 National Certificate: Polymer Composite Fabrication Level 3 NQF Level 03 Reregistered 2018-06-30 MERSETA 
Elective 35939 National Certificate: Pulp and Paper Woodyard Operations Level 3 NQF Level 03 Passed the End Date –
Status was “Registered” 
2007-02-01 Was FPMSETA until Last Date for Achievement 
Elective 49596 National Certificate: Radiation Monitoring Level 3 NQF Level 03 Reregistered 2018-06-30 EWSETA 
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 48818 Further Education and Training Certificate: Arts and Culture Administration Level 4 NQF Level 04 Reregistered 2018-06-30 CATHSSETA 
Elective 48643 Further Education and Training Certificate: Chemical Pulp Manufacturing Level 4 NQF Level 04 Passed the End Date –
Status was “Registered” 
2007-02-11 Was FPMSETA until Last Date for Achievement 
Elective 48978 Further Education and Training Certificate: Electrical Network Control Level 4 NQF Level 04 Reregistered 2018-06-30 EWSETA 
Elective 49120 Further Education and Training Certificate: Film, Television and Video Production Operations Level 4 NQF Level 04 Passed the End Date –
Status was “Registered” 
2007-12-02 Was MICTS until Last Date for Achievement 
Elective 48854 Further Education and Training Certificate: Fundraising Level 4 NQF Level 04 Reregistered 2018-06-30 SERVICES 
Elective 48664 Further Education and Training Certificate: Mail Supervision Level 4 NQF Le el 04 Reregistered 2018-06-30 SERVICES 
Elective 65110 Further Education and Training Certificate: Management Level 4 NQF Level 04 Passed the End Date –
Status was “Reregistered” 
2009-03-14 As per Learning Programmes recorded against this Qual 
Elective 48644 Further Education and Training Certificate: Paper, Board or Tissue Manufacturing Level 4 NQF Level 04 Passed the End Date –
Status was “Registered” 
2007-02-11 Was FPMSETA until Last Date for Achievement 
Elective 48732 Further Education and Training Certificate: Phlebotomy Techniques Level 4 NQF Level 04 Passed the End Date –
Status was “Registered” 
2007-08-11 Was HPCSA until Last Date for Achievement 
Elective 48666 Further Education and Training Certificate: Postal Frontline Service Level 4 NQF Level 04 Reregistered 2018-06-30 SERVICES 
Elective 48645 Further Education and Training Certificate: Pulp and Paper Chemical Recovery Level 4 NQF Level 04 Passed the End Date –
Status was “Registered” 
2007-02-11 Was FPMSETA until Last Date for Achievement 
Elective 48909 Further Education and Training Certificate: Sanitation Project Facilitation Level 4 NQF Level 04 Reregistered 2018-06-30 EWSETA 
Elective 20638 National Certificate: Collective Investment Schemes Level 4 NQF Level 04 Passed the End Date –
Status was “Registered” 
2004-12-05 INSETA 
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 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 20639 National Certificate: Healthcare Benefits Administration: Claims Assessing Level 4 NQF Level 04 Passed the End Date –
Status was “Registered” 
2004-12-05 INSETA 
Elective 20773 National Certificate: Long Term Insurance Level 4 NQF Level 04 Passed the End Date –
Status was “Registered” 
2004-12-05 INSETA 
Elective 48796 National Certificate: Quality Assurance of Tyre Manufacturing Processes Level 4 Level TBA: Pre-2009 was L4 Reregistered 2018-06-30 MERSETA 
Elective 24396 National Certificate: Risk Management Level 4 NQF Level 04 Passed the End Date –
Status was “Registered” 
2006-10-08 Was INSETA until Last Date for Achievement 
Elective 21796 National Certificate: Short Term Insurance Level 4 NQF Level 04 Passed the End Date –
Status was “Registered” 
2005-06-12 Was INSETA until Last Date for Achievement 
Elective 48736 National Certificate: Small Business Financial Management Level 4 NQF Level 04 Reregistered 2018-06-30 FASSET 
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 48799 National Certificate: Tyre and Tyre Component Manufacturing Level 4 Level TBA: Pre-2009 was L4 Reregistered 2018-06-30 MERSETA 
Elective 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 
This form is currently undergoing maintenance. Please try again later.
Previous National Certificate – ODETP – Level 5 – 50334
Next National Certificate – Production Technology – Level 2 – 58781
Table of Contents