BSBITU402A - Develop and Use Complex Spreadsheets 2013

BSBT072A

Get your questions answered

  • Is online study right for me?
  • Why OUA?
  • What should I study?
  • How does it work?
  • How do I enrol?

Discover what's involved in studying through OUA.

Find out more

Overview

To enrol in this unit, you must be accepted into a course from the provider.
Read before you start

Level of study: What does Vocational Education, Training mean?

Vocational Education, Training

EFTSL: What does EFTSL mean?

0.03125

Delivery Method: What does delivery method mean?

Fully Online

Availability: What is a Study period?

2013:

Duration:

13 weeks

Government loans available:

VET FEE-HELP VET FEE-HELP

Domestic student fee:

$600.00 (AUD)

International student fee:

$850.00 (AUD)

Description

This unit describes the performance outcomes, skills and knowledge required to use spreadsheet software to complete business tasks and to produce complex documents. The software used is Microsoft Excel 2010.

Enrolment Restriction

In order to enrol in this unit, you must be accepted into one of the following courses:

Please visit the course details page and read the Requirements tab for more information about eligibility.

Prerequisites

Equivalent units

You cannot enrol in this unit if you have successfully completed any of the following unit(s) because they are considered academically equivalent:

  • BSBT065A — BSBITU402A - Develop and Use Complex Spreadsheets

Special Requirements

  • Additional materials
  • Broadband access

Assessment

  • Assignment 1 (40%)
  • Assignment 2 (50%)
  • Quiz 1 (5%)
  • Quiz 2 (5%)

Learning Outcomes

At the completion of this unit students will be able to:

  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.

Topics

This unit addresses the following topics.

NumberTopic
1Organise personal work environment in accordance with ergonomic requirements
2Test formulae to confirm output meets task requirements
3Format cells and use data attributes assigned with relative and/or absolute cell references, in accordance with the task specifications
4Link spreadsheets in accordance with software procedures
5Utilise spreadsheet design software functions and formulae to meet identified requirements
6Apply work organisation strategies and energy and resource conservation techniques to plan work activities
7Identify organisational and task requirements in relation to data entry, storage, output, reporting and presentation requirements
8Analyse task and determine specifications for spreadsheets
9Evaluate tasks to identify those where automation would increase efficiency
10Create, use and edit macros to fulfil the requirements of the task and automate spreadsheet operation
11Develop, edit and use templates to ensure consistency of design and layout for forms and reports, in accordance with organisational requirements
12Enter, check and amend data in accordance with organisational and task requirements
13Import and export data between compatible spreadsheets and adjust host documents, in accordance with software and system procedures
14Use manuals, user documentation and online help to overcome problems with spreadsheet design and production
15Preview, adjust and print spreadsheet in accordance with organisational and task requirements
16Name and store spreadsheet in accordance with organisational requirements and exit the application without data loss or damage
17Determine style of graph to meet specified requirements and manipulate spreadsheet data if necessary to suit graph requirements
18Create graphs with labels and titles from numerical data contained in a spreadsheet file
19Save, view and print graph within designated time lines

Study Resources

This unit is delivered using the following methods and materials:

Instructional Methods

  • Discussion Forum/Discussion Board
  • Embedded Multimedia
  • Online Quizzes/Tests
  • Online assignment submission
  • Standard Media
  • Web links

Textbook information for this unit is currently being updated and will be available soon. Please check back regularly for updates. Alternatively, visit the Unibooks website and enter the unit details to search for available textbooks.

Relevant Courses

This unit is an approved elective in the following courses:

This unit may be eligible for credit towards other courses:

  1. Many undergraduate courses on offer through OUA include 'open elective' where any OUA unit can be credited to the course. You need to check the Award Requirements on the course page for the number of allowed open electives and any level limitations.
  2. In other cases, the content of this unit might be relevant to a course on offer through OUA or elsewhere. In order to receive credit for this unit in the course you will need to supply the provider institution with a copy of the Unit Profile in the approved format, which you can download here. Note that the Unit Profile is set at the start of the year, and if textbooks change this may not match the Unibooks textbook list.
If you would like to study this unit and enrol today, add it to your Study Cart. Alternatively if you are still exploring your options, you can save this unit to review later by clicking Save to Wishlist.

Currently studying this unit?

Need support? We're here to help.

Send an enquiry

Let's talk

Have a question? Give us a call.

November Extended Hours
Monday 3rd - Friday 7th: 8am - 8pm
Saturday 8th: 9am - 5pm
Sunday 9th: CLOSED
Monday 10th - Friday 14th: 8am - 8pm
Saturday 15th: 9am - 5pm
Sunday 16th: 10am - 10pm
Monday 17th - Wednesday 19th: 8am - 10pm
Thursday 20th - Friday 21st: 8am - late

Standard Hours
Monday to Friday: 8am - 8pm
Saturday and Sunday: CLOSED

All times in Australian Eastern Standard or Daylight Time