BSBTEC302 Design and produce spreadsheets

BSBTEC302 Design and produce spreadsheets


Price:

$180.00

To enrol, select payment option below:


BSBTEC302 Design and produce spreadsheets

$180.00

Quantity

Units of Competency

1

Course Access

3 months access to online course

Support Hours

7am - 9pm AEST (Mon - Fri)

Why Study with AOT?

  • Over 15 years of delivering qualifications online
  • Dedicated eLearning and LMS development team
  • Courses developed in-house by industry experts
  • Courses written specifically for online delivery
  • Professional and industry skilled trainers
  • Rated ‘Excellent’ on independent review platform TrustPilot

Simulated Workplace

Full access to our unique virtual company that brings your course material to life.

Delivery Mode

100% online, available 24/7
No classroom attendance or work placement

Trainer Support

One-on-one unlimited

MAY MADNESS

Extended due to popular demand.
We must be mad!

VIEW COURSE

Terms and conditions apply. See T&Cs for more details.

This single unit course 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. 

Successful completion of this short course will earn you a Statement of Attainment in partial completion of the BSB30120 Certificate III in Business. 

You may use the unit of this course to credit transfer towards the below qualifications: 

  • BSB30120 Certificate III in Business 
  • BSB40320 Certificate IV in Entrepreneurship and New Business  

Talk to our course advisor for more information on credit transfer rules and the qualification that will best suit your needs. 

BSBTEC302 Design and produce spreadsheets

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

You will be assessed for these units of competency using a variety of tasks to assess your understanding and skills. A virtual session means you will be one on one with your assessor either answering questions or taking part in a role play, just as you would do in any classroom, only we do it online.

All of our assessments are marked by your assessor within ten (10) working days following the day you submitted your work. You have three (3) attempts for each assessment task to achieve a satisfactory outcome (100% pass mark), with your assessor giving you detailed feedback following each submission.

Unit Written
Activities
Virtual Classroom/Roleplay Scenario/
Case study
Project/
Report
BSBTEC302 Design and produce spreadsheetsWritten ActivitiesVirtual ClassroomScenario/Case Study

We provide you with up to three (3) months to complete this course. How long it actually takes you to complete each unit will be reflective of the time you are able to dedicate to your studies.

In the units list, you will see the government’s nominal hours for each unit, which are their anticipated number of study hours. Our students usually find that their actual study hours are less than this.

Requirements

There are no formal requirements. However, learners will need:
  • Sufficient language, literacy and numeracy skills to complete the course
  • Basic computer skills
    • Knowledge of common computing terms and word processing
    • Proficiency with web browser software and sending/receiving e-mail including e-mail with attachment
    • Familiarity with navigating the Internet
  • Meet technology requirements
  • Be at least 18 years old or have completed Year 12 if enrolling in a Diploma

Technology requirements

  • Operating System: Windows 7 or higher (recommended); MAC OS X 10.6 (Snow Leopard) or higher (recommended)
  • CPU: Min. of 2 GB of RAM, Min. of 2 GB of spare disk space is recommended
  • Processor: 2.0 GHz processor or higher (32-bit or 64-bit)
  • Monitor with at least 1024x768 screen resolution
  • Internet access: Minimum ADSL1 with a speed of at least 3 Mbps
  • An email address that is unique to you and that you will maintain throughout your enrolment
  • Headset (or speakers and microphone) and webcam
  • Microsoft Office (Word, Excel, PowerPoint, Publisher) or similar software
  • Up-to-date web browser version

Support you can expect from AOT

Our focus is to provide the real-world skills and knowledge that you need to advance your career, fulfil your goals and achieve success in the workplace. No matter what course you choose, here at AOT you will receive the assistance and support that will help make your study time convenient, manageable and worthwhile. The benefit of studying with us is that you don't have to schedule your time to attend face-to-face classroom sessions. You can study at times convenient to you in your own home or anywhere that suits your learning style. To support you in your study we provide:

Live chat

Trainer support available whilst you are studying 7am – 9pm AEST (Mon to Fri).

Contact us form

Contact us at any time using the Contact us form found within your course to create support tickets.

Mentoring sessions

You can book unlimited appointments with a trainer to discuss the learning material, assessment expectations, or assessment feedback.

Virtual classroom sessions

This can be booked with your trainer for specific assessments.

Course induction

You are provided with a course induction tutorial and you may also request for a Learner Support Officer to personally take you through the sauceLMS and your course.

Help and Support

A section on your sauceLMS dashboard with useful links.

Student Frequently Asked Questions

Find answers to your questions quickly and easily using the FAQs.
You are not alone in your study with AOT!

Want to know more?

TRY FREE DEMO DOWNLOAD INFO PACK
X