BSBITU402A - Develop and Use Complex Spreadsheets - 2013

To enrol in this unit, you must be accepted into a course from the provider. Read before you start
This page is for past year, View 2017 unit details.

Unit summary


  • Level of Study: Vocational Education, Training
  • Study load: 0.03125 EFTSL
  • Delivery method: Fully Online
  • Prerequisites: Yes
  • Duration: 13 weeks
  • Government loans available: VET FEE-HELP
  • Availability for 2013: SP2 , SP3 , SP4
  • Assessment: Assignment 1 (40%) , Assignment 2 (50%) - Learn more

Unit provided by

2013 Fees
Domestic 600.00
International 850.00

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.

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.
  • Assignment 1 (40%)
  • Assignment 2 (50%)
  • Quiz 1 (5%)
  • Quiz 2 (5%)

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:

  • Additional materials
  • Broadband access

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.

This unit addresses the following topics.

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

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

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 Co-Op textbook list.

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

Enquire online

Need to ask a question that's best put down in words?
Make an online enquiry.

Enquire now

Got a question?

Get an answer from one of our friendly Student Advisors.