Unit of competency
Modification History
Release |
Comments |
Release 1 |
This version first released with ICT Information and Communications Technology Training Package Version 1.0. |
Application
This unit describes the skills and knowledge required to use spreadsheet applications, including creating spreadsheets, formatting data, incorporating charts and objects, and printing spreadsheets.
It applies to individuals who perform a range of routine tasks in the workplace using a fundamental knowledge of spreadsheets under direct supervision or with limited responsibility.
No licensing, legislative or certification requirements apply to this unit at the time of publication.
Unit Sector
General ICT
Elements and Performance Criteria
ELEMENT |
PERFORMANCE CRITERIA |
Elements describe the essential outcomes. |
Performance criteria describe the performance needed to demonstrate achievement of the element. |
1. Create spreadsheets |
1.1 Open the spreadsheet application, create spreadsheet files and enter numbers, text and symbols into cells according to information requirements 1.2 Enter simple formulas and functions using cell referencing when required 1.3 Correct formulas when error messages occur 1.4 Use a range of common tools during spreadsheet development 1.5 Edit columns and rows within the spreadsheet 1.6 Use the auto-fill function to increment data where required 1.7 Save the spreadsheet to a folder on a storage device |
2. Customise basic settings |
2.1 Adjust page layout to meet user requirements or special needs 2.2 Open and view different toolbars 2.3 Change font settings so they are appropriate for the document purpose 2.4 Change alignment options and line spacing according to spreadsheet formatting features 2.5 Format cell to display different styles as required 2.6 Modify margin sizes to suit the purpose of the spreadsheets 2.7 View multiple spreadsheets concurrently |
3. Format spreadsheet |
3.1 Use formatting features as required 3.2 Copy selected formatting features from another cell in the spreadsheet or from another active spreadsheet 3.3 Use formatting tools as required within the spreadsheet 3.4 Align information in a selected cell as required 3.5 Insert headers and footers using formatting features 3.6 Save spreadsheet as another file type 3.7 Save to storage device and close spreadsheet |
4. Incorporate object and chart in spreadsheet |
4.1 Import an object into an active spreadsheet 4.2 Manipulate imported object by using formatting features 4.3 Create a chart using selected data in the spreadsheet 4.4 Display selected data in a different chart 4.5 Modify chart using formatting features |
5. Print spreadsheet |
5.1 Preview spreadsheet in print preview mode 5.2 Select basic printer options 5.3 Print spreadsheet or selected part of spreadsheet 5.4 Submit the spreadsheet to appropriate person for approval or feedback |
Foundation Skills
This section describes language, literacy, numeracy and employment skills incorporated in the performance criteria that are required for competent performance.
Skill |
Performance Criteria |
Description |
Reading |
1.1, 2.1 |
|
Writing |
1.1, 1.2, 1.5, 3.5, 4.5 |
|
Oral Communication |
1.1, 2.1, 5.4 |
|
Numeracy |
1.2, 4.3, 4.4 |
|
Interact with others |
5.4 |
|
Get the work done |
1.1-1.7, 2.1-2.7, 3.1-3.7, 4.1-4.5, 5.1-5.3 |
|
Unit Mapping Information
Code and title current version |
Code and title previous version |
Comments |
Equivalence status |
ICTICT105 Operate spreadsheet applications |
ICAICT105A Operate spreadsheet applications |
Updated to meet Standards for Training Packages. Minor edits to clarify intent of performance criteria. |
Equivalent unit |
Links
Companion Volume implementation guides are found in VETNet - https://vetnet.gov.au/Pages/TrainingDocs.aspx?q=a53af4e4-b400-484e-b778-71c9e9d6aff2