Course Title: Develop and use complex spreadsheets

Part B: Course Detail

Teaching Period: Term1 2011

Course Code: COSC5956C

Course Title: Develop and use complex spreadsheets

School: 130T Engineering (TAFE)

Campus: City Campus

Program: C5236 - Diploma of Surveying

Course Contact : Thierry Demathieu

Course Contact Phone: +61 3 9925 8359

Course Contact

Name and Contact Details of All Other Relevant Staff

William Ntuwah

+61 3 99254445

Nominal Hours: 20

Regardless of the mode of delivery, represent a guide to the relative teaching time and student effort required to successfully achieve a particular competency/module. This may include not only scheduled classes or workplace visits but also the amount of effort required to undertake, evaluate and complete all assessment requirements, including any non-classroom activities.

Pre-requisites and Co-requisites


Course Description

This unit covers the use of spreadsheet software to complete business tasks and produce suitable complex documents. This unit is related to BSBCMN214A Create and use simple spreadsheets

National Codes, Titles, Elements and Performance Criteria

National Element Code & Title:

BSBADM404A Develop and use complex spreadsheets


1. Use safe work practices

Performance Criteria:

1.1 Workspace, furniture and equipment are adjusted to suit the ergonomic requirements of the user
1.2 Work organisation meets organisational and statutory requirements for computer operation
1.3 Energy and resource conservation techniques are used to minimise wastage in accordance with organisational and statutory requirements


2. Develop a linked spreadsheet solution

Performance Criteria:

2.1 Task is analysed and specifications for spreadsheets are determined
2.2 Organisational and task requirements in relation to data entry, storage, output, reporting and presentation requirements are identified
2.3 Spreadsheet design utilises software functions and formulae to meet identified requirements
2.4 Spreadsheets are linked in accordance with software procedures
2.5 Cells are formatted and data attributes assigned with relative and/or absolute cell references used in accordance with the task specifications


3. Automate and standardise spreadsheet operation

Performance Criteria:

3.1 Tasks are evaluated to identify those where automation would increase efficiency
3.2 Macros are created, used and edited to fulfil the requirements of the task and automate spreadsheet operation
3.3 Templates are developed, edited and used to ensure consistency of design and layout for forms and reports in accordance with organisational requirements


4. Use spreadsheets

Performance Criteria:

4.1 Data is entered, checked and amended in accordance with organisational and task requirements
4.2 Data is imported / exported between compatible spreadsheets and host documents adjusted in accordance with software and system procedures
4.3 Manuals, user documentation and on-line help are used to overcome problems with spreadsheet design and production
4.4 Spreadsheet is previewed, adjusted and printed in accordance with organisational and task requirements
4.5 Spreadsheet is named and stored , in accordance with organisational requirements and the application exited without data loss/damage


5. Represent numerical data in graphic form

Performance Criteria:

5.1 Style of graph is determined to meet specified requirements and spreadsheet data is manipulated if necessary to suit graph requirements
5.2 Graphs are created with labels and titles from numerical data contained in a spreadsheet file
5.3 Graph is saved, viewed and printed within designated timelines

Learning Outcomes

Refer to elements

Details of Learning Activities

Teacher led :

Classroom &/or tutorial instruction the use of spreadsheet software to complete tasks and produce suitable complex documents, as well as tasks associated with the elements above including the use of computers and relevant software/s, capabilities of survey methodologies and technologies in a simulated workplace environment.

Student managed:

Develop data management strategies to determine suitable sources of information for the creation of new spatial data sets to industry standards.
Participation in group activities based on simulated workplace exercises. Individual exercises carrying out research, computations, data compilation and appraisal.
Compilation of Portfolio of examples of work, client reports, management reports and data management records.

Teaching Schedule

This is an indicative teaching schedule, refer to the Blackboard for any changes or announcements


Week No

Topic Delivered

Assessment/ Task

 1 Creating Simple worksheet 
 2 Formulae 
 3 Workbook with multiple worksheet 
 4 Relative, Absolute and mixed cell addresses 
 5 Logical Functions 
 6 Assignment  Assignment 1
 7 Logical Functions  
 8 Logical Functions  
 9 Problem solving 
 10 Charts 
 11 Assignment  Assignment 2
 12 Application - Project 1 
 13 Application - Project 1 
 14 Application - Project 1 
 15 Application - Project 1 
 16 Application - Project 1 Assignment 3
 17 Application - Project 1 
 18 Evaluation 

Learning Resources

Prescribed Texts

Acts and Regulations Occupational Health and Safety Commission.
Surveying, A Bannister and S Raymond, Pitman
Elementary Surveying, Elfick Fryer Brinkner Wolf, Harper Collins
Advanced-Engineering-Surveying-problems-and-solutions, F A Shepard, Arnold.


Other Resources

Web Resources: - Online@RMIT – Program and Course information, documents, resources and links. - Land Channel (Victoria) - Survey Mark Enquiry Service, GPSnet, Maps & Images, Property Information, Land Management. - Institute of Surveyors, Australia - Mapping Sciences Institute, Australia - ANZLIC: Australian and New Zealand Spatial Information Council - Surveyors Board, Victoria – Survey Practice Handbook, Key Legislation for Surveyors. - Intergovernmental Committee on Surveying and Mapping - Standards and Practices for Control Surveys - Geoscience Australia – National Mapping Agency, Geocentric Datum of Australia, GPS

Overview of Assessment

A person who demonstrates competency in this unit must be able to demonstrate understanding of a broad knowledge base incorporating some theoretical concepts.
• Literacy skills to interpret and evaluate the purposes and uses of various features of spreadsheets; use a variety of strategies for planning and reviewing own work
• Proofreading and editing skills to check for accuracy and consistency of information by consulting additional resources
• Problem solving skills to use processes flexibly and interchangeably
• Numeracy skills to collate and present data; graphs and related references
• Communication skills to follow complex oral instructions when using technology; listen to and interpret complex sequenced instructions
• Keyboarding skills
• Ability to relate to people from a range of social, cultural and ethnic backgrounds and physical and mental abilities

Assessment Tasks

Assessment of this unit will involve completion of Assignments and the Evaluation of portfolio, using a checklist, of the performance of elements of competence as designated for this unit to the required standard including collection methods and techniques related to the project objectives.

Observation, using a skills checklist, of performance of elements of competence as designated for this unit to the required standard during practical fieldwork exercises within a simulated workplace project.

Assessment will require demonstration of:

• Consistence performance of each element of the unit across a representative range of applications, autonomously and to requirements
• Performance criteria for each element of competence
• Underpinning knowledge and skills specified.

Context of Assessment:

This unit is to be assessed in a simulated workplace and under the normal range of work conditions.

Assessment Matrix

Element 1Use safe work practices Assignment 1
Element 2Develop a linked spreadsheet solutionAssignment 1
Element 3Automate and standardise spreadsheet operationAssignment 2
Element 4Use spreadsheetsAssignment 3
Element 5Represent numerical data in graphic formAssignment 3

Note: Assignment due dates will be issued on commencement of the course

Course Overview: Access Course Overview