Design and Produce Spreadsheets (921)

Course duration: 85 hours

Potential Career Outcomes:
Graduates are working toward roles such as:

• General Clerk
• Data Entry Officer
• Administrative Assistant
• Customer Service Representative
• Clerical and Administration Worker
• Customer Service Officer
• Program Administrator

What you’ll learn:
BSBTEC302 – Design and produce spreadsheets

• Design and set up spreadsheets for business use
• Enter, format, and organise data effectively
• Use formulas and functions for calculations
• Create charts and graphs to visualise data
• Validate and protect spreadsheet data
• Analyse and interpret spreadsheet information

This course is perfect for those who have no experience but would like to launch a career in business and administration.

The unit is also an ideal way to formalise current work experience for those who are already in the industry but need a qualification to get ahead.

Recommended Local Entry Requirements:

• Students are 15 years old  (Note: Students under 18 will need permission from a parent or guardian to enrol)
• Have language, literacy and numeracy skills that ensure the ability to work independently with assistance from a support person where required, extract information from simple text, and communicate with trainers via email 
• Pass a short Language, Literacy, Numeracy and Digital (LLND) assessment
• Students must have a Unique Student Identifier (USI)

Resource Requirements:

• Regular access to a computer, tablet or smartphone with high-speed internet (note: there may be activities in the course that need to be completed using a desktop computer rather than a tablet or smartphone)
• Basic to intermediate computer or digital device skills, including the ability to make a short video
• An email address and regular access to a reliable internet connection
• Access to Microsoft Office or equivalent
• PDF reader software (e.g., Adobe Acrobat) installed on a computer or the digital device being used to access the course

Additional Requirements:

• The ability and willingness to study online lesson material and complete all assessment requirements for each unit of competency
• The ability to communicate directly with Alffie in English
• The ability to understand and follow detailed instructions in English given verbally or in writing