Course Title: Use complex spreadsheets for spatial information

Part A: Course Overview

Program: C5320 Diploma of Surveying

Course Title: Use complex spreadsheets for spatial information

Portfolio: SEH Portfolio Office

Nominal Hours: 40

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.

Course Code	Campus	Career	School	Learning Mode	Teaching Period(s)
COSC7351C	City Campus	TAFE	130T Vocational Engineering	Face-to-Face or Internet	Term1 2014, Term1 2015, Term1 2016

Course Contact: Program Manager

Course Contact Phone: +61 3 9925 4468

Course Contact Email: vocengineering@rmit.edu.au

Course Description

This unit of competency specifies the outcomes required to use spreadsheet software to complete spatial tasks using complex spatial data. The skills and knowledge required in this unit focus on creating complex spreadsheets to store and retrieve spatial data.

Pre-requisite Courses and Assumed Knowledge and Capabilities

Nil

National Competency Codes and Titles

National Element Code & Title:	CPPSIS5060A Use complex spreadsheets for spatial information
Elements:	1. Prepare the task. 2. Evaluate and standardise spreadsheet operation. 3. Develop a linked worksheet solution. 4. Use spreadsheets. 5. Finalise the task.

Learning Outcomes

Refer to elements

Overview of Assessment

The assessment is conducted in both theoretical and practical aspects of the course according to the performance criteria set in the National Training Package. Assessment may incorporate a variety of methods including written/oral activities and demonstration of practical skills to the relevant industry standards. Participants are advised that they are likely to be asked to personally demonstrate their assessment activities to their teacher/assessor. Feedback will be provided throughout the course. To successfully complete this course you will be required to demonstrate competency in each assessment task detailed under Assessment Tasks:

Students must pass each of the following assessment tasks to demonstrate competence

Assessment Tasks

Assessment	Weight %
Assessment 1	Written Assessment	25
Assessment 2	Test	35
Assessment 3	Portfolio	40

These tasks assess the following Course Learning Outcomes (CLOs):

Assessment Mapping Matrix

Elements/ Performance Criteria Covered	Assessment 1	Assessment 2	Assessment 3
1.1	X		X
1.2	X		X
1.3	X		X
1.4	X		X
2.1	X		X
2.2	X		X
3.1	X		X
3.2	X		X
3.3	X		X
3.4	X		X
4.1	X	X
4.2	X	X
4.3	X	X
4.4	X	X
4.5	X	X
4.6	X	X
4.7	X	X
5.1		X	X
5.2		X	X
5.3		X	X

To be deemed competent you must demonstrate an understanding of all aspects required of the competency. Assessment methods have been designed to measure your achievement of each competency in a flexible manner over multiple tasks.