BSBITU314 Design and produce spreadsheets

Try Free Course Demo Download Info Pack

BSBITU314 Design and produce spreadsheets

Price:

$140.00

To enrol, select payment option below:



BSBITU314 Design and produce spreadsheets

$140.00

Quantity
TOTAL: $190.00 over 1 month
Initial Payment: $100.00
Succeeding Payments: $45.00 X 2 fortnightly payments

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

UNLOCK YOUR POWER SKILLS FOR
THE NEW YEAR CHALLENGES

Over 70 courses to explore endless possibilities for your career

VIEW COURSES

Course Overview

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

Successful completion of the unit of competency outlined below will earn you a Statement of Attainment in partial completion of the BSB30415 Certificate III in Business Administration.

Study Pathways

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

  • BSB30415 Certificate III in Business Administration

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

BSBITU314 Design and produce spreadsheets

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.

Topics:
  1. Select and prepare resources
  2. Plan spreadsheet design
  3. Create spreadsheet
  4. Produce intermediate-level charts
  5. Finalise and present spreadsheets
Upon successful completion of this unit, you will:
  • design spreadsheets that address a range of data and organisational requirements
  • use software functions, graphics and support materials to create spreadsheets
  • apply knowledge of formatting requirements for workplace documents.
Demonstrate knowledge of:
  • formatting requirements of workplace documents
  • organisational guidelines on spreadsheet design and use
  • organisational requirements for ergonomic standards, work periods and breaks, and conservation techniques.
Nominal hours = 35 hours

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
BSBITU314 Design and produce spreadsheets✔Written Activities✔Virtual Classroom

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

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!
Trustpilot

Want to know more?

TRY FREE DEMO DOWNLOAD INFO PACK
1300 72 66 34
X