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
- 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
What will you need to know before the course?
Students should have some experience using spreadsheets to enter data, perform basic tasks e.g. help functions, simple formatting and create simple charts.
If you have language, numeracy or literacy concerns, please discuss them with us before the course starts.
Study options and next steps
Click on your preferred study mode below to get started with your application or enrolment.
Available Semester 1 & Semester 2
Esperance - On Campus - Express your interest
| When | Available Semester 1 & Semester 2 | ||||||||||||
| Where | Esperance | ||||||||||||
| How | Classroom | ||||||||||||
| Course fee |
|
* Indicative Fee Disclaimers
Fees and charges published on our website are indicative only, and are for the entire course for students enrolling on a full-time basis in 2023.
- Fees may differ between courses delivered at different campuses due to the elective units included in the course study plan or adapting courses to meet local industry needs.
- Fees may also differ for each individual student depending on the units of study selected, prior qualifications and recognition of prior learning.
- Fees are payable at time of enrolment.
- Proof of concession must be presented to access concession rates if eligible.
- For secondary school aged persons not enrolled at school (in 2023, students born on or after 1 July 2005 who are at least 15 years old) the maximum course fee chargeable in 2023 is $420 plus the resource fees and discretionary fees.
- Concessions and Secondary School Age cap do not apply to commercial courses (such as short courses), or Foundation Programs (ESL, General Education, etc.).
- Prices quoted include resource fees, but do not include material fees such as the cost of books, uniforms, and students personal equipment.
- The course fee cap applicable to Diplomas and Advanced Diplomas only applies during the current calendar year, so fees might differ for students enrolling in semester 2.
- VET Student Loans Eligible Courses and Caps may be subject to changes implemented by the Australian Government.
- Course information and fees are subject to change without notice.
- Depending on your circumstances, payment options may include paying fees via instalments or applying for assistance because of financial hardship.
- Visit the Fees and Payment Options page for further information.