|
The range statement relates to the unit of competency as a whole. It allows for different work environments and situations that may affect performance. Bold italicised wording, if used in the performance criteria, is detailed below. Essential operating conditions that may be present with training and assessment (depending on the work situation, needs of the candidate, accessibility of the item, and local industry and regional contexts) may also be included. |
Ergonomic requirements may include: | avoiding radiation from computer screenschair height, seat and back adjustmentdocument holderfootrestkeyboard and mouse positionlightingnoise minimisationposturescreen positionworkstation height and layout |
Work organisation requirements may include: | exercise breaksmix of repetitive and other activitiesrest periods |
Conservation techniques may include: | double-sided paper userecycling used and shredded paperre-using paper for rough drafts (observing confidentiality requirements)utilising power-save options for equipment |
Spreadsheet task requirements may include: | data entryoutputpresentationstorage |
Data may include: | numberstext |
Checking may include: | accuracy of dataaccuracy of formulae with calculatorensuring instructions with regard to content and format have been followedproofreadingspelling, electronically and manually |
Formatting may include: | alignment on pageefficiency of formulaeenhancements to format - borders, patterns and coloursenhancements to textheaders/footersuse of absolute and relative cell addressesuse of cell addresses in formulae |
Software functions may include: | adding/deleting columns/rowsformatting cellsformatting textheaders/footerssizing columns/rows |
Formulae may include: | absolute cell referencing and/or mixed referencesaveragedivisionmaximumminimummultiplicationsubtractionsumcombinations of above |
Chart types may include: | areabarcolumnexploded pielinepie and 3-D piescatter/bubblestacked/multiple barstacked, 3-D column |
Features may include: | axesaxis titleborderschart titlecoloursdata labelsdata tablesfillsgridlineslegendlinespatterns |
Printing may include: | fit on one pagefit specific number of pageswith formulaewith values |
Designated time lines may include: | organisational time line e.g. financial requirementstime line agreed with internal/external clienttime line agreed with supervisor/person requiring spreadsheet |
Storing data may include: | authorised accessfiling locationsorganisational policy for backing up filesorganisational policy for filing hard copies of spreadsheetssecuritystorage in electronic folders/sub-foldersstorage on CD-ROM, zip drives, USB memory |