Excel: Design and produce spreadsheets

Assessments are made against units of competency.

Design and produce spreadsheets (BSBTEC302)

Excel : Design and produce spreadsheets - Sydney Course

In this short Computer Skills for Work and Study course, you will build on your basic to intermediate excel skills to become more proficient in designing and producing spreadsheets. You will develop highly sought after digital skills and knowledge that are required in most business operations.

This course will help you understand and use different business technology to develop official documentation in Microsoft Office excel application.

By the end of this course, you will have the confidence and ability to use excel.

This course is designed specifically for people who are at the intermediate level with using computers and digital technology. It is a great pathway to helping you gain employment or access to further vocational study.

Macquarie Community College operates from a range of venues across Northern and Western Sydney. We have campuses in Blacktown, Carlingford, Chatswood, Epping, Mt Druitt, Richmond, and Ryde. Enrol now!

Course Outline

In this course you will learn:

How to use and produce more advanced spreadsheets

Course Outcome

By the end of this course you will be able to:

Create electronic presentations

At the end of the course, you will be issued a certificate of attainment in BSBTEC302 - Design and produce spreadsheets where competency has been achieved.

What to Bring

All course material is provided and inclusive with course fees.

Please bring:

Notebook
Pen

Prerequisite: Essential

An appropriate level of language, literacy and numeracy (LLN) skills is required to enrol in this course. Macquarie Community College may conduct an LLN assessment as part of the pre enrolment process.

Fees and Government Subsidy Opportunities

Smart and Skilled is a reform of the NSW Vocational Education and Training (VET) system. It's helping people in NSW get the skills they need to find a job and advance their careers.

Smart and Skilled provides eligible students with:

An entitlement to government-subsidised training up to and including Certificate III.
Government funding for higher-level courses (Certificate IV and above) in targeted priority areas.

If you're a prospective student, please visit: https://www.macquarie.nsw.edu.au/smart-and-skilled-subsidised-training where you will find everything you need to know about the Smart and Skilled program before you enrol.

NSW FEE-FREE* courses now available, please visit: https://www.macquarie.nsw.edu.au/nsw-fee-free-training

*Eligibility criteria apply. This training is fully subsidised by the NSW and Australian Governments, and as a result your fee is determined through Training Services NSW formal eligibility criteria. Students will need to supply the required evidence in accord with the requirements of Smart and Skilled eligibility.

Payment Plans are available through Macquarie Community College for Smart and Skilled eligible qualifications. 10% deposit OR $40 (whichever is greater) required upon enrolment followed by Interest-free payment plan. Payment methods: EFTPOS, Direct Deposit, Direct Debit, Visa or MasterCard.

Study Load

This course will include both classroom based sessions and home study.

Credit Transfer and Recognition of Prior Learning

Credit transfer (CT) is defined in the AQF as follows:

Credit transfer is a process that provides students with agreed and consistent credit outcomes for components of a qualification based on identified equivalence in content and learning outcomes between matched qualifications.

Recognition of prior learning (RPL) is defined in the AQF as follows:

Recognition of prior learning is an assessment process that involves assessment of an individual’s relevant prior learning (including formal, informal and non-formal learning) to determine the credit outcomes of an individual application for credit.

This is underpinned by the AQF definition of credit as follows:

Credit is the value assigned for the recognition of equivalence in content and learning outcomes between different types of learning and/or qualifications.
Credit reduces the amount of learning required to achieve a qualification and may be through credit transfer, articulation, recognition of prior learning or advanced standing.

For further CT information visit: https://www.aqf.edu.au/sites/aqf/files/credit-transfer-explanation.pdf.

For further RPL information visit: https://www.aqf.edu.au/sites/aqf/files/rpl-explanation.pdf.

If you would like to apply for CT or RPL, please contact us.

Career Opportunities

This course is a pathway to employment or further vocational study and is suitable for any person wishing to safely perform computer-related tasks using software applications on a more advanced level.

Elective Unit Components (6)

BSBTEC302 - Design and produce spreadsheets

For more information, visit https://training.gov.au/Training/Details/ICT20120

How You Will Be Assessed

Assessment (including recognition of prior learning) must:

Meet the requirements of the relevant training package or accredited course, and
Be conducted in accordance with the principles of assessment and the rules of evidence, and
Meet workplace and, where relevant, regulatory requirements.

For this course assessment will entail the following:

Written and verbal questioning
Practical demonstrations

Assessments will be written and practical and may take place in the classroom environment.

What Can I Study Next?

At the completion of this course you can move on to a more advanced level courses in IT or business to gain more complex skills such as ICT20120 Applied Digital Technologies or BSB30120 Certificate III in Business.

Delivery Mode

We offer training in formats that suit you and your workplace in accordance with the training package.

This course is available in the following mode:

Classroom based: experienced and engaging trainers will take you through the course material face to face with an individual assessment for each unit of competency and a variety of delivery modes to ensure individual learning styles are catered for.

Please note: Government COVID-19 regulations and recommendations, including appropriate social distancing measures, hand washing and other hygiene protocols will be in place at all times and may result in course delivery changes.

Classroom learning for this course may include:

Text book references
White board notes and visuals
PowerPoint presentations
DVD’s
Class discussions and group tasks
Case studies and scenarios
Practical simulation and group role play

Workplace based training delivered in your workplace

Other areas of delivery assessed on request

Logistical Information

Government COVID-19 regulations and recommendations, including appropriate social distancing measures, hand washing, and other hygiene protocols will be in place at all times and may result in course delivery changes.