BSBITU314 Design and produce spreadsheets

Price:

$140.00

To enrol, select payment option below:

Prepaid Fee
Payment Plan

BSBITU314 Design and produce spreadsheets

$140.00

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

Payment Plan

Units of Competency

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

Description

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.

Units

BSBITU314

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.

Topics:

Select and prepare resources
Plan spreadsheet design
Create spreadsheet
Produce intermediate-level charts
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

Course Assessment

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

Course Duration

We provide you with three (3) months to complete this short 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 much less than this. To begin planning your studies we recommend planning for 20-25 hours of study per unit and then adjusting as you go. You may book a mentoring session for assistance setting up a study plan once you have enrolled.

Course Requirements

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

Learner Support

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

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 answer to your questions quickly and easily using the FAQs.

You are not alone in your study with AOT!

BSBITU314 Design and produce spreadsheets

BSBITU314 Design and produce spreadsheets