Course Title: Develop spreadsheets for spatial data
Part A: Course Overview
Program: C5368 Diploma of Surveying
Course Title: Develop spreadsheets for spatial data
Portfolio: Vocational Education
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 or Internet |
Term1 2017, Term2 2017, Term1 2018, Term1 2019, Term1 2020, Term1 2021 |
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
None
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
See elements above
Overview of Assessment
Assessment Tasks
Students must pass each of the following assessment tasks to demonstrate competency
Assessment | |
Task 1 |
Assessment 1 |
Task 2 |
Assessment 2 |