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.
This unit standard is intended for people who need to enhance document appearance using a GUI-based word processor 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 table. • Format a table according to given requirements. • Create and edit columns in a document. • Format columns in a document.
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.
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.
This Unit Standard is intended for people who need to have to present sophisticated spreadsheets in a variety of industry and economic sectors. A person credited with this unit standard is 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.
Develop the skills to create, open, save, and edit spreadsheets using a GUI-based application. Gain confidence in formatting, checking spelling, and printing spreadsheets effectively.
Learn to create, format, and edit tables and columns within a document. This unit enhances document appearance using GUI-based word processor tools.
Explore ways to improve spreadsheet utility by applying advanced formatting and incorporating graphs or charts for better data presentation.
Use spreadsheet software to address specific problems through structured data analysis and presentation, supporting informed decision-making.
Master the techniques to customize spreadsheet aesthetics, from layout modifications to cell styling, making your data more readable and professional.
This foundational requirement ensures learners can read, write and communicate clearly in English. Strong literacy supports learning, helps with understanding technical content, and ensures effective participation in training.