This unit describes the skills and knowledge required to develop spreadsheets through the use of both cloud-based and non-cloud based spreadsheet applications.
.
It 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.
What will you learn in this course?
- Follow correct ergonomic, conservation requirements and relevant organisational and statutory requirements
- Design spreadsheets that address a range of data and organisational requirements
- documents that align to document purpose and appropriate to target audience
- use software functions, graphics and support materials to create spreadsheets that adhere to organisational requirements relating to style and presentation
- Key elements of formatting of spreadsheets appropriate to workplace documents, including the ability to calculate:
- sum totals
- averages
- counts of values
- formulas and functions with:
- addition, subtraction, division, multiplication
- brackets
- create and modify intermediate-level charts that analyse the dataset.
On successful completion of this course, students will receive a statement of attainment for the following nationally accredited unit BSBTEC302 Design and produce spreadsheets.