Course Title: Develop spreadsheets for spatial data

Part A: Course Overview

Program: C5416 Diploma of Surveying

Course Title: Develop spreadsheets for spatial data

Portfolio: Vocational Education

Nominal Hours: 60

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)

GEOM5180C

City Campus

TAFE

530T Built Environment and Sustainability

Face-to-Face or Internet

Term1 2023

Course Contact: Matthew Sweeney

Course Contact Phone: +61 3 9925 4105

Course Contact Email: matthew.sweeney@rmit.edu.au



Course Description

In this course you will develop the skills and knowledge required to design, create and validate spreadsheets for spatial data and to translate spatial data into spreadsheet design and layout. This includes translating between spreadsheet and spatial software, and using functions and features of spreadsheet software, including linked spreadsheets, documents and advanced mathematical formulas.

The course also includes identifying design parameters and setting up software and spreadsheet templates to ensure quality and consistency in format and design, as well as using technology to apply advanced mathematical concepts to spatial data, including identifying and resolving errors relating to formulas and other spreadsheet functions.

 

Pre-requisite Courses and Assumed Knowledge and Capabilities

None



National Competency Codes and Titles

National Element Code & Title:

CPPSSI5060 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 successful completion of this course you will have developed and applied the skills and knowledge required to demonstrate competency in the above elements. 


Overview of Assessment

Assessment for this course is ongoing throughout the semester. Your knowledge and understanding of course content is assessed through participation in class exercises, oral presentations and through the application of learned skills and insights to your written tasks. Full assessment briefs will be provided and can be found on CANVAS.