BSBTEC302

This unit describes the skills and knowledge required to develop spreadsheets through the use of spreadsheet applications.

The unit applies to individuals employed in a range of environments who tend to be personally responsible for designing and working with spreadsheets under minimal supervision. These individuals are generally required to have intermediate knowledge and understanding of a number of spreadsheet applications.

Topics:

  1. Select and prepare resources
  2. Plan spreadsheet design
  3. Create spreadsheet
  4. Produce charts
  5. Finalise and present spreadsheets

Upon successful completion of this unit, you will:

  • Plan, design, produce and finalise a spreadsheet on at least four occasions.

In the course of the above, the candidate must:

  • Produce spreadsheet documents that align to document purpose and appropriate to target audience
  • Design spreadsheets using formulas and functions with:
    • Addition, subtraction, division, multiplication
    • Brackets
  • Design spreadsheets that address a range of data and organisational requirements
  • Use software functions to create spreadsheets that adhere to organisational requirements relating to style and presentation
  • Use relevant help functions to rectify document issues
  • Produce spreadsheet document in appropriate format for review, including ability to create and modify intermediate-level charts that analyse the dataset.

Nominal hours = 35