Google Links

Follow the links below to find material targeted to the unit's elements, performance criteria, required skills and knowledge

Elements and Performance Criteria

1. Select and prepare resources
   • Adhere to ergonomic, work organisation and occupational health and safety requirements
   • Use energy and resource conservation techniques to minimise wastage
   • Identify spreadsheet task requirements in relation to data entry, storage, output and presentation
2. Plan spreadsheet design
   • Ensure spreadsheet design suits purpose, audience and information requirements of task
   • Ensure spreadsheet design enhances readability and appearance, and meets organisational and task requirements for style and layout
   • Use style sheets and automatic functions to ensure consistency of design and layout
3. Create spreadsheet
   • Ensure data is entered, checked and amended to maintain consistency of design and layout, in accordance with organisational and task requirements
   • Format spreadsheet using software functions to adjust page and cell layout to meet information requirements, in accordance with organisational style and presentation requirements
   • Ensure formulae are tested and used to confirm output meets task requirements, in consultation with appropriate personnel as required
   • Use manuals, user documentation and online help to overcome problems with spreadsheet design and production
4. Produce simple charts
   • Select chart type and design that enables valid representation of numerical data, and meets organisational and task requirements
   • Create charts using appropriate data range in spreadsheet
   • Modify chart type and layout using formatting features
5. Finalise spreadsheets
   • Preview, adjust and print spreadsheet and any accompanying charts, in accordance with task requirements
   • Ensure data input meets designated timelines and organisational requirements for speed and accuracy
   • Name and store spreadsheet in accordance with organisational requirements and exit application without data loss/damage