Complex Documents and Spreadsheets

Complex Documents and Spreadsheets


Price:

$460.00

To enrol, select payment option below:



Complex Documents and Spreadsheets

$460.00

Quantity
TOTAL: $510.00 over 2 months
Initial Payment: $200.00
Succeeding Payments: $77.50 X 4 fortnightly payments

Units of Competency

2

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

The New Leadership and Management Qualifications have arrived!

GET READY TO LAUNCH YOUR CAREER WITH TOP SKILLS

CHOOSE YOUR COURSE

A large part of effective written communication is the use of software applications to communicate information faster, easier and cheaper, and connect with people from all over the world.

Working in the business services sector will require you to develop your competencies in designing and producing quality complex documents and spreadsheets to support your organisation’s information and communication requirements.

With this short course, you will learn the skills and knowledge required to prepare to produce word processed documents and spreadsheets, work with complex tables and other data, develop linked spreadsheet solutions, automate and standardise spreadsheet operations and represent numerical data in graphic form.

View the units below to understand what each unit within this course offers and how each delivers specific skills and knowledge in a practical sense which you can relate to in the workplace.

This short course will earn you a Statement of Attainment in partial completion of the BSB40215 Certificate IV in Business.

Career Opportunities

  • Office administrator
  • Office manager
  • Project assistant
  • Supervisor/manager

You may use one or more of the units in this course to credit transfer towards the below qualifications at AOT:

  • BSB40215 Certificate IV in Business
  • BSB40515 Certificate IV in Business Administration
  • BSB41015 Certificate IV in Human Resources

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

BSBITU401 Design and develop complex text documents

This unit describes the skills and knowledge required to design and develop business documents using complex technical features of word processing software.

It applies to individuals who work in a range of business environments and have skills which may be applied in the provision of administrative support within an enterprise, or by technical/knowledge experts responsible for producing their own word processed documents.

Topics:
  1. Prepare to produce word processed documents
  2. Design complex documents
  3. Add complex tables and other data
  4. Produce documents
Upon successful completion of this unit, you will:
  • follow organisational and safe work practices including:
    • ergonomic requirements
    • energy and resource conservation techniques
  • adhere to organisational requirements for:
    • producing documents within designated timelines
    • naming and storing documents
  • adhere to task requirements when producing complex documents including:
    • using appropriate styles and layout consistently throughout the document
    • using correct formatting and document structure
  • resolve issues by referring to user documentation and online help
  • use appropriate data storage options
  • apply knowledge of complex operation and functions of industry software applications
  • communicate with relevant personal
Demonstrate knowledge of:
  • various formatting styles and their effect on formatting, readability and appearance of documents
  • organisational requirements for ergonomics, work periods and breaks, and conservation techniques
  • the purpose and contents of an organisational style guide
Nominal hours = 100 hours

BSBITU402 Develop and use complex spreadsheets

This unit describes the skills and knowledge required to use spreadsheet software to complete business tasks and produce complex documents.

It applies to individuals employed in a range of work environments who require skills in creation of complex spreadsheets to store and retrieve data. They may work as individuals providing administrative support within an enterprise, or may be independently responsible for designing and working with spreadsheets relevant to their own work roles.

Topics:
  1. Prepare to develop spreadsheet
  2. Develop a linked spreadsheet solution
  3. Automate and standardise spreadsheet operation
  4. Use spreadsheets
  5. Represent numerical data in graphic form
Upon successful completion of this unit, you will:
  • follow organisational and safe work practices including:
    • ergonomic requirements
    • energy and resource conservation techniques
  • adhere to organisational requirements for:
    • ensuring consistency of style, design and layout
    • saving and printing documents within designated timelines
    • naming and storing documents
  • adhere to identified or task requirements when producing documents including:
    • editing macros and automating some tasks
    • using appropriate templates
    • creating graphs to represent data
    • resolve issues by referring to user documentation and online help
    • use appropriate data storage options
    • evaluate tasks to improve efficiency
    • apply knowledge of functions and features of contemporary computer applications
    • communicate with relevant personnel
Demonstrate knowledge of:
  • advanced functions of spreadsheet software applications
  • the impact of formatting and design on presentation and readability of data
  • organisational requirements for ergonomics, work periods and breaks, and conservation techniques
Nominal hours = 50 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
BSBITU401 Design and develop complex text documentsVirtual ClassroomScenario/Case Study
BSBITU402 Develop and use complex spreadsheetsWritten ActivitiesVirtual ClassroomScenario/Case Study

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.

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 answer 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