This Learner Guide explains how to select the most appropriate application to produce a required spreadsheet and then how to plan the design according to organisational requirements. It then describes the process of creating and formatting the spreadsheet, including consulting with relevant stakeholders to confirm it meets task requirements. It also explains how to produce charts. Finally, it covers reviewing the spreadsheet and presenting it to stakeholders before naming and storing it.

Resources available

Learner Guide
• Mapped to Units of Competency
• Workplace Examples
• Practice Tasks
• Topic Summaries
• Learning Checkpoints

Assessment Support Pack
For the student:
• Practice Assessment Workbook
• Final Assessment Workbook
• Supporting documents
For the assessor:
• Introduction Manual
• Practice Assessments and Marking Guide
• Final Assessment and Marking Guide
• Talk with Others discussion topics
• Observation*
• Third Party Report*
• Competency Mapping
• PowerPoint Slides
• Delivery Plans

PowerPoint Slides are also available separately per unit of competency. Contact your Account Manager for more information.

*where the Unit of Competency requires an Observation be undertaken

Learner guides

• Product Code: BBTEC302
• ISBN: 978-1-76075-828-8

Support resources

• Product Code: BBTEC302SP
• ISBN: 978-1-76075-830-1