Course Title: Develop spreadsheets for spatial data

Part A: Course Overview

Program: C5368 Diploma of Surveying

Course Title: Develop spreadsheets for spatial data

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.

Terms

Course Code

Campus

Career

School

Learning Mode

Teaching Period(s)

COSC6209C

City Campus

TAFE

174T School of VE Engineering, Health & Science

Face-to-Face

Term1 2017,
Term2 2017

Course Contact: Thierry Demathieu

Course Contact Phone: +61 3 9925 8359

Course Contact Email: thierry.demathieu@rmit.edu.au



Course Description

This unit of competency specifies the outcomes required to design and develop spreadsheets to enter, edit and format spatial data. The unit covers using functions and features of spreadsheet software, including linked spreadsheets, multiple documents and advanced mathematical formulas based on trigonometrical functions. The unit also covers work preparation activities, including evaluating tasks to identify design parameters and setting up software and spreadsheet templates to ensure quality and consistency in format and design. The unit requires the ability to use technology to apply advanced mathematical concepts to spatial data, including identifying and resolving errors relating to formulas and other spreadsheet functions.

The unit supports those who work in a lead role in a surveying or spatial information services team.

Pre-requisite Courses and Assumed Knowledge and Capabilities

NIL



National Competency Codes and Titles

National Element Code & Title:

CPPSIS5060 Develop spreadsheets for spatial data

Elements:

1. Prepare for spreadsheet tasks.

2. Set up spreadsheets.

3. Use functions and features of spreadsheet software.

4. Finalise spreadsheets.


Learning Outcomes

 On completion of this course, you should be able to:

1. Prepare for spreadsheet tasks.

1.1.  Spreadsheet requirements for spatial data entry, storage, output, reporting and presentation are identified to determine task requirements in consultation with appropriate persons .

1.2.  Tasks are evaluated to identify design parameters, required mathematical formulas and areas where automation would increase efficiency according to task requirements.

1.3.  Software is set up and checked to ensure functionality and capacity to meet task and organisational requirements.

 

2. Set up spreadsheets.

2.1.  Spreadsheet templates are developed and edited to standardise spreadsheet operation and ensure quality and consistency in format and design.

2.2.  Linked worksheet solution is developed using software functions and formulas to meet task requirements.

2.3.  Worksheets are formatted to incorporate cell and data attributes, formulas and graphs with labels and titles.

2.4.  Formulas are tested to confirm that output meets task requirements and errors are identified and resolved or contingencies managed.

 

3. Use functions and features of spreadsheet software.

3.1. Spatial data is entered, checked and edited according to task and organisational requirements.

3.2. Spatial data is imported and exported between compatible spreadsheets, and host documents are adjusted according to task requirements.

3.3. Software documentation and online help are used to overcome problems with spreadsheet design and production.

3.4. Spreadsheets, including graphs, are produced and stored according to organisational requirements.

 

4.  Finalise spreadsheets.

4.1. Completed spreadsheets are protected to prevent accidental corruption and are archived according to organisational requirements.

4.2. Documentation is completed and appropriate persons are informed of results according to organisational requirements. 

 


Overview of Assessment

Assessment Tasks

Students must pass each of the following assessment tasks to demonstrate competent. 

Assessment

Weight%

Task 1

Assignment

25%

Task 2

Test

35%

Task 3

Portfolio

40%

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

Assessment Mapping Matrix  

Elements/

Performance Criteria Covered

Task 1

Task 2

Task 3

1.1

X

 

X

1.2

X

X

 

1.3

X

X

 

2.1

X

 

X

2.2

X

X

 

2.3

X

X

 

2.4

X

X

 

3.1

X

X

 

3.2

X

X

 

3.3

X

 

X

3.4

X

X

X

4.1

 

X

X

4.2

 

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.