Course Title: Develop spreadsheets for spatial data
Part B: Course Detail
Teaching Period: Term1 2023
Course Code: GEOM5180C
Course Title: Develop spreadsheets for spatial data
Important Information:
Please note that this course may have compulsory in-person attendance requirements for some teaching activities.
To participate in any RMIT course in-person activities or assessment, you will need to comply with RMIT vaccination requirements which are applicable during the duration of the course. This RMIT requirement includes being vaccinated against COVID-19 or holding a valid medical exemption.
Please read this RMIT Enrolment Procedure as it has important information regarding COVID vaccination and your study at RMIT: https://policies.rmit.edu.au/document/view.php?id=209.
Please read the Student website for additional requirements of in-person attendance: https://www.rmit.edu.au/covid/coming-to-campus
Please check your Canvas course shell closer to when the course starts to see if this course requires mandatory in-person attendance. The delivery method of the course might have to change quickly in response to changes in the local state/national directive regarding in-person course attendance.
School: 530T Built Environment and Sustainability
Campus: City Campus
Program: C5416 - Diploma of Surveying
Course Contact: Matthew Sweeney
Course Contact Phone: +61 3 9925 4105
Course Contact Email: matthew.sweeney@rmit.edu.au
Name and Contact Details of All Other Relevant Staff
Greg Patterson
Spatial Scientist and Surveying Teacher
School of Vocational Engineering, Health & Sciences
RMIT University
Building 56
Carlton, Vic, 3053, Australia
Phone: +61 400 231 518
Email: gregory.patterson@rmit.edu.au
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.
Pre-requisites and Co-requisites
None
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.
National Codes, Titles, Elements and Performance Criteria
National Element Code & Title: |
CPPSSI5060 Develop spreadsheets for spatial data |
Element: |
1. Prepare for spreadsheet tasks |
Performance Criteria: |
1.1 Determine specifications for spreadsheets and identify the task requirements for spatial data entry, storage, output, reporting and presentation. 1.2 Evaluate tasks to identify design parameters, required features and functions and areas where automation would increase efficiency. 1.3 Set up and check software for functionality and capacity to meet task requirements. |
Element: |
2. Set up spreadsheets |
Performance Criteria: |
2.1 Develop linked spreadsheet solution using software features and formulas to meet task requirements. 2.2 Test formulas and functions and resolve errors to confirm that output meets task requirements. 2.3 Format spreadsheets and use titles, colours, headings, labels and data to enhance meaning and presentation of data. |
Element: |
3. Use functions and features of spreadsheet software |
Performance Criteria: |
3.1 Enter, check and edit spatial data according to task and organisational requirements. 3.2 Import and export spatial data between compatible software applications and adjust host documents according to task requirements. 3.3 Use software documentation and online help to overcome errors and problems with spreadsheet design and production as required. 3.4 Develop and edit spreadsheet templates to standardise spreadsheet operation and ensure quality and consistency in format and design. |
Element: |
4. Finalise spreadsheets |
Performance Criteria: |
4.1 Protect completed spreadsheets to prevent accidental corruption and archive according to organisational requirements. 4.2 Complete documentation and inform appropriate persons of results according to organisational requirements. |
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.
Details of Learning Activities
You will learn to:
- Prepare for spreadsheet tasks by determining and identifying task specifications and requirements.
- Setup and check software functionalities that would increase the efficiency of task requirements.
- Develop spreadsheets to solve task requirements with appropriate quality assurance (QA) checks and apply formats to enhance the presentation.
- Use complex functions and command features of spreadsheet software to develop a comprehensive end product and deliverable to a client to finalise the spreadsheet projects.
The total number of scheduled hours of teaching, learning and assessment involved in this course includes all planned activities (face to face classes, lectures, workshops and seminars; workplace visits, online learning and other forms of structured teaching and learning). It also covers the amount of effort necessary to undertake, evaluate and complete all assessment requirements, observation of work performance, discussions with supervisors and others providing third party evidence and one on one and group assessment sessions with students.
Teaching Schedule
Syllabus
The following syllabus provides you with this course's Training and Assessment schedule. Refer to this page to find out what themes will be discussed each week and when assessments are due. You will also find important information on census dates, excursions and practices. While we endeavour to deliver and assess in line with this syllabus, we reserve the right to make changes to accommodate unexpected circumstances.
Session/Date |
Theme |
Assessments |
|
6 - 10 February |
Welcome and course overview In this session you will be introduced to the assessment 1 requirements spreadsheets including some basic and complex features and functions within the software. |
Activity: Introduced to the subject including assessments and complete some training using features within spreadsheets |
|
13-19 February |
Spreadsheet features and functions In this session you will be work with spreadsheets and complete a series of activities. This will include: identification of cell, cell references, data attributes, named ranges, cell protection, embedding cell references in formulas, conditional formats, data validation tools and processes, graph creation, simple macros, headings and labels, and pivot tables |
Activity: Training using features and functions within spreadsheets |
|
20 - 26 February |
Spreadsheet functions to create formulas In this session you will be work with spreadsheets and complete a series of activities using features and functions within spreadsheets. This will include: adding text, adding mathematical equations, using lookup tables, determine statistical information, logical functions such as FALSE function and IF function. |
Activity: Training using features and functions within spreadsheets |
|
27 February - 5 March |
Link spreadsheets In this session you will link different spreadsheets using software features and formulas |
Activity: Linking spreadsheets |
|
6-12 March |
Spreadsheets formulas In this session you will be introduced to advanced mathematical formulas where you will convert imperial measurements to metric measurements, compute rise and fall, compute the adjusted RL, validate the output and lock / protect the cell so that the cells cannot be edited |
Activity: Rise and fall |
|
13-19 March
|
Spreadsheets formulas (Continued) In this session you will be introduced to advanced mathematical formulas where you will convert imperial measurements to metric measurements, compute rise and fall, compute the adjusted RL, validate the output and lock lock / protect the cell so that the cells cannot be edited Note: 13 Feb - Labour Day public holiday |
Activity: Rise and fall |
|
20-26 March |
Create graphs using spreadsheets In this session you will be work with spreadsheets and create a series of graphs using named ranges. This will include: formatting the spreadsheets and include titles, colours, headings, labels and data to enhance meaning and presentation of data. |
Activity: Create graphs using spreadsheets |
|
Census DateLinks to an external site. 31 March 2023 |
The Census Date is the last day you can withdraw from this course without financial penalty. If you need to withdraw from this course, you must do so before this date to avoid additional student fees. |
|
|
27 March - 2 April |
Assessment 1: Computation of clearance height of the bridge - Part 1 - Computation of clearance height of the bridge There are two parts to this assessment. In this session you will complete part 1 of the assessment consisting of 5 tasks. This will include: prepare spreadsheet for task requirements, set up the leveling computation spreadsheet template, use functions and features of spreadsheet software, validate data integrity and finalise spreadsheets, and complete documentation and report to the client. |
Assessment 1: Part 1 - Computation of clearance height of the bridge |
|
3-9 April |
Assessment 1: Montague Street bridge Project - Part 2 - Reduction of Leveling observation using Macros There are two parts to this assessment. In this session you will complete part 2 of the assessment consisting of 5 tasks. This will include: prepare spreadsheet for task requirements, set up the leveling computation spreadsheet template, use functions and features of spreadsheet software, validate data integrity and finalise spreadsheets, and complete documentation upload onto canvas
Note: 07 April (Friday) - Good Friday public holiday |
Assessment 1: Part 2 - Reduction of Leveling observation using Macros |
|
Mid-semester break 10-16 April |
The Mid-semester break is a scheduled break in the semester. No teaching or assessment will occur during this time. Also, your Trainer/Assessor won't be available during this time. If you need to contact them, please email them via your student email account, and they will respond once they return from the break.
Notes: 10 April - Easter Monday public holiday 11 April - Easter Tuesday RMIT holiday |
|
|
17-23 April |
Spreadsheet features and functions In this session you will be introduced to the assessment requirements. You will also work with spreadsheets and complete a series of activities. This will include: Using the following software features and functions - VLOOKUP, SUM, AVERAGE, TEXT, MIN and MAX and calculating statistical information. |
Activity: Introduced to assessment 2 and training using software features and functions |
|
24-30 April |
Spreadsheet features and functions In this session you will determine software functions and features that can be used to resolve data quality and numerical issues, and topological errors |
Activity: Software features and functions to resolve problems |
|
ANZAC Day Public holiday 25 April 2023 |
No teaching or assessment will occur on ANZAC Day. Additionally, RMIT staff will not be available during this time. If you need to contact them, please email them via your student email account, and they will respond once they return from the break. | |
|
1-7 May |
Create spatial data using geographic information system In this session you will create spatial data using geographic information system (GIS) application tools |
Activity: Create spatial data using GIS |
|
8-14 May |
Spreadsheet features and functions In this session you will complete a series of activities. This will include the use of Macros within the spreadsheet |
Activity: Training using features and functions within spreadsheets |
|
15-21 May |
Spreadsheet features and functions In this session you will complete a series of activities. This will include Bowditch adjustment and determining decimal degrees from degrees minutes and seconds |
Activity: Training using features and functions within spreadsheets |
|
22-28 May |
Assessment 2: Analyse spatial data - Part 1 - Reduction of Leveling observation using Macros There are two parts to this assessment. In this session you will complete part 1 of the assessment. This will include: determine and document task requirements and specifications, prepare spatial data in spreadsheets for the task, use software functions and features to resolve the problem and complete documentation. |
Assessment 2: Part 1 - Analyse spatial data |
|
29 May - 4 June |
Assessment 2: Analyse spatial data - Part 2 - Reduction of Leveling observation using Macros In this assessment task, You will complete part 2 of the assessment. This will include answering all knowledge questions. |
Assessment 2: Part 1 - Knowledge Questions |
|
5-11 June |
Revision and feedback on work completed | |
|
Session Eighteen 12-18 June |
Assessment marking and finalising results | |
|
Queens Birthday Public Holiday 12 June 2023 |
No teaching or assessing will occur on the Queen's Birthday. Additionally, RMIT staff will not be available during this time. If you need to contact them, please email them via your student email account, and they will respond once they return from the break. | |
|
29 June 2023 |
Important: It is your responsibility to check your results on this date. Your official results for this course will be released on this date. Your teacher will not inform you of your final result. It will only be available via My Student Record on RMIT's website. It is not your Trainer/Assessors responsibility to let you know your final result. Your teacher will not be available to comment on your assessment or final results from 18-29 June 2022. After this date, you can contact them to talk about your final result if you need it. |
Learning Resources
Prescribed Texts
References
Other Resources
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.
Assessment Tasks
Assessment 1 - Montague Street bridge Project
Assessment 2 - Analyse spatial data
Assessment Matrix
Mapping Assessments to the Unit of Competency – Instructions
Foundation Skills |
Foundation skills essential to performance are explicit in the performance criteria of this unit of competency |
Performance Evidence | ||
To demonstrate competency a candidate must meet the performance criteria of this unit by using a geographic information system (GIS) or computer-aided design (CAD) environment to develop two-dimensional (2-D) and three-dimensional (3-D) terrain visualisations that meet specifications for two different projects. |
Assessment Task 1: Terrain Visualisation Part 1 |
Assessment Task 2: Terrain Visualisation Part 2 |
For each project, the candidate must prepare drawings and models that meet specifications for accuracy, completeness, coverage, density and logical consistency. |
1H |
1A |
For the 3-D terrain visualisations, the candidate must: | ||
Develop contour, slope and shaded relief maps of an area by creating and manipulating entities in 3-D space |
1H, 1G, 1I |
1A |
Create a digital elevation model in 3-D using mathematically defined surfaces and point or line data. |
1I |
1A |
Knowledge Evidence | ||
To be competent in this unit a candidate must demonstrate knowledge of: |
Assessment Task 1: Terrain Visualisation Part 1 |
Assessment Task 2: Terrain Visualisation Part 2 |
|
Interpretation of:
|
1 – 1C 2 – 1H 3 – 1A
|
4 – 1B |
Interpolation techniques to convert from point to raster data |
1G |
1B |
|
Computer platforms and software for GIS, CAD and digital elevation models (DEM) |
1B |
1A |
Legislative requirements for data, copyright and licensing |
1E |
1C |
Data formats and precision and accuracy requirements for preparing terrain visualisations in 2-D drawings and 3-D models |
1H |
1A |
Techniques for processing and displaying digital images |
1H |
1A |
Sources for existing spatial datasets |
1E |
1C |
Methods for capture of raw elevation data |
1D |
|
GIS and CAD principles, capabilities and uses in relation to creating terrain visualisations |
1E |
1A |
Methods for validating spatial data sources |
1D |
1A |
Types of data set constraints |
1A |
3C |
Key features of spatial referencing systems |
1C |
1A |
Techniques for modifying existing 2-D and 3-D models |
1H |
|
Types of products that can be derived from a DEM. |
1D |
|
Assessment conditions |
Describe how assessments meet the assessment conditions |
Assessors must meet the requirements for assessors contained in the Standards for Registered Training Organisations. |
RMIT employment requires all trainers and assessors to comply with the Standards for RTOs in respect to holding the TAE40116, or higher VE qualification including any necessary updated units. All employees must show currency within their vocational specialty along with their professional employment. |
Competency is to be assessed in the workplace or a simulated environment that accurately reflects performance in a real workplace setting where these skills and knowledge would be performed. |
Assessments reflect the workspace environment. Assessors to have appropriate industry experience and knowledge. Students have access to computers with the latest GIS software packages during scheduled class times that comply with current industry practices. |
|
Candidates must have access to:
|
All labs will have the appropriate computers and software installed. Software that students required include:
Students will have access to additional software through Office 365. The students can sign in with your RMIT email address and password. |
Other Information
Interim Results
After you have submitted an assessment, you will receive an interim result. This is displayed in the Grades section of this Canvas shell. These will be as follows:
Results |
|
|
Satisfactory (S) |
|
|
Not Yet Satisfactory (NYS) |
|
|
Did Not Submit (DNS) |
You will receive this result when you have not submitted your assessment by the due date or time. Your Trainer/Assessor, the Program Coordinator or the Program Manager cannot overturn this interim result. An approved Special Consideration is required to allow further opportunities to complete the assessment. Additionally, moderation panels cannot overturn this result either. |
Note: You must achieve a Satisfactory (S) result for every assessment in this course in order to pass.
Interim results will inform the moderation panel of their decision as to whether or not you are deemed competent and can pass the course. Your final and official result will be published via My Results on RMIT's website. It is your responsibility to check your final results. Your Trainer/Assessor, the Program Coordinator or the Program Manager will not inform you of your final result.
Resubmission Policy:
After you submit your assessment, your Trainer/Assessor will review your submission. If you have met all the requirements of the assessment task, you will receive an S result in your Grades section of this course.
If the Trainer/Assessor determines that you have not met the assessment requirements, you will receive an NYS result in the Grades section. In this case, your Trainer/Assessor will provide you with the following opportunities to resubmit:
- Project/Practical-Based Assessment Task: One Resubmission per assessment.
- Knowledge-Based Assessment Task (Tests): Two Resubmissions per assessment
Important: If you do not submit an assessment by its due date or time, you are not entitled to a resubmission. You will only receive an opportunity to submit an assessment that you have failed to submit on time if you provide an approved Special Consideration. Your Trainer/Assessor, Program Coordinator & Program Manager or the Moderation panel cannot overturn a DNS result without approved Special Consideration.
*Resubmissions cannot be accepted via email or as attachments to the comments of another assessment. Any work submitted in this manner will not be accepted or recognised, regardless of the circumstances. All resubmissions must be uploaded via the original submission folder and by the due date and time set by the Trainer/Assessor.
**Your Trainer/Assessor, Program Coordinator or Program Manager cannot issue further resubmission opportunities beyond those stated here. You will only be provided with further opportunities based on the successful application for Special Consideration or upon the course moderation panel's review and decision at the course's end.
Attendance:
You are required to attend a minimum of 85% of your classes. If you miss classes, you will need to provide a medical certificate to your Trainer/Assessor for classes that result in you not meeting the 85% requirement.
If you fail to attend the minimum required classes and engage in each class, your trainer/assessor will not accept your assessment submissions. You will be required to attend an in-person interview with your trainer/assessor at a time determined by them. Failure to attend this interview will result in your assessment being rejected. Additionally, the trainer/assessor reserves the right to reject your assessment based on the interview's outcome. This is required to ensure RMIT meets the Standards set for RTOs to ensure the validity of your work.
Course Overview: Access Course Overview