Microsoft Excel
Microsoft Excel
Embedded Files
UNIT STANDARD
UNIT STANDARD
SAQA ID 116937:
Use a Graphical User Interface (GUI)-based spreadsheet application to create and edit spreadsheets
(NQF Level 2, 4 Credits)
PURPOSE OF THE UNIT STANDARD
This unit standard is intended for people who need to create and edit spreadsheets using a Graphical User Interface (GUI)-based spreadsheet application either as a user of computers or as basic knowledge for a career needing this competency, like the ICT industry
People credited with this unit standard are able to:
Demonstrate an understanding of the principles of spreadsheets.
Create, open and save spreadsheets.
Produce a spreadsheet from a given specification.
Edit a spreadsheet.
Format a spreadsheet.
Check spelling in a spreadsheet.
Print a spreadsheet using features specific to spreadsheets.
The performance of all elements is to provide a standard that allows for further learning in this area.
SAQA ID 258879:
Change the appearance of a spreadsheet
(NQF Level 3, 3 Credits)
PURPOSE OF THE UNIT STANDARD
This Unit Standard is intended for people who need to have to present sophisticated spreadsheets in a variety of industry and economic sectors
People credited with this unit standard are capable of:
Outlining data in a spreadsheet.
Modifying the display of spreadsheet data.
Applying conditional formatting to data.
Creating and use templates.
Working with comments.
UNIT STANDARD
UNIT STANDARD
SAQA ID 116940:
Use a Graphical User Interface (GUI)-based spreadsheet application to solve a given problem
(NQF Level 3, 6 Credits)
PURPOSE OF THE UNIT STANDARD
This unit standard is intended for people who need to plan, produce, use and spreadsheets to solve problems using a Graphical User Interface (GUI)-based spreadsheet application either as a user of computers or as basic knowledge for a career needing this competency, like the ICT industry
People credited with this unit standard are able to:
Prepare and produce a spreadsheet to provide a solution to a given problem.
Adjust settings to customise the view and preferences of the spreadsheet application.
Work with multiple worksheets.
Apply formulae to worksheets to provide alternative solutions to a problem.
Apply simple built-in functions of the spreadsheet application to the given problem.
Apply formatting to a spreadsheet applicable to the given problem.
Use special effects to improve the presentation of the spreadsheet.
Evaluate a spreadsheet.
The performance of all elements is to a standard that allows for further learning in this area.
UNIT STANDARD
UNIT STANDARD
SAQA ID 116943:
Use a Graphical User Interface (GUI)-based spreadsheet application, enhance the functionality and apply graph / charts to a spreadsheet
(NQF Level 4, 3 Credits)
PURPOSE OF THE UNIT STANDARD
This unit standard is intended for people who need to enhance spreadsheet appearance using a Graphical User Interface (GUI)-based spreadsheet application either as a user of computers or as basic knowledge for a career needing this competency, like the ICT industry
People credited with this unit standard are able to:
Create and edit a graph/chart.
Load data from an external data source to produce a given spreadsheet result.
Insert and edit objects in a spreadsheet.
The performance of all elements is to a standard that allows for further learning in this area.
SAQA ID 258878:
Ensure spreadsheet integrity to enhance reliability
(NQF Level 4, 3 Credits)
PURPOSE OF THE UNIT STANDARD
This Unit Standard is intended for people who work with spreadsheets and for whom the reliability of the data produced is critical
People credited with this unit standard are capable of:
Setting up a spreadsheet.
Applying security.
Checking input data.
Checking formulas and totals.
Checking output data.
Auditing spreadsheets.
Validating and sorting data in a spreadsheet.
Google Sites
Report abuse