Part B: Course Detail
Teaching Period: Term1 2025
Course Code: GEOM5180C
Course Title: Develop spreadsheets for spatial data
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
Thierry Demathieu | Trainer and Assessor - Building, Surveying and Land Management
College of Vocational Education
RMIT University
+61 39925 8359
thierry.demathieu@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. |
Element: |
2. Set up spreadsheets |
Performance Criteria: |
2.1 Develop linked spreadsheet solution using software features and formulas to meet task requirements. |
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. |
Element: |
4. Finalise spreadsheets |
Performance Criteria: |
4.1 Protect completed spreadsheets to prevent accidental corruption and archive 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.
Syllabus | ||
Session: |
Brief: |
Assessment Details |
|
Date: 10-16 February
Session: 1
|
Lesson Title: Introduction to Course content and Assessments
Description: In this session you will be introduced to the concepts used for the course, along with an outline of the assessment requirements.
You will also learn about the tools you will be using to solve computation problems.
|
Assessment 1: Released Assessment 2: Released Activity: Install HP Prime Apps. Activity: Install/Renew LISCAD software Activity: Install HP Prime emulator
Activity: Compute trigonometric heights. |
|
Date: 17-23 February
Session: 2 |
Lesson Title: Introductions to computations
Learning outcome: In this session, you will become familiar with the HP Prime apps to compute survey information
You will also be introduced of spreadsheets and how they can help solve computational problems. |
Activity: Testing HP Prime Traverse Close Area App using an industry plan of subdivision with missing elements.
Activity: Online learning of Spreadsheet
|
|
Date: 24 February-2 March
Session: 3 |
Lesson Title: Polar/rectangular conversions & Adjustments
Description: In this session, you will use the Polar /Rectangular conversion to adjust a closed boundary.
You will also use the conversion to compute and adjust an open traverse.
Both activities will use LANDATA ® free web mapping application to search and download published survey information.
|
Activity: Open traverse shown on Plan of Subdivision in Carlton.
Activity: Closed boundary on a Plan of Subdivision in Carlton. |
|
Date: 3-9 March
Session: 4 |
Lesson Title: Closed traverse and Bowditch adjustment
Description: This week, we will work on a closed traverse in preparation for Assessment 1 using the HP Prime and a spreadsheet.
|
Activity - Compute coordinates (unadjusted and adjusted) using the HP Prime and a spreadsheet software.
|
|
Date: 10-16 March Session: 5 |
Lesson Title: Assessment 1 – Task 1: Meet and Analyse project specifications
Description: In this session, you are required to meet and consult with the client (teacher) to analyse project specifications in determining project requirements.
We will also convert angles to bearings and slope distances to horizontal distances.
|
Activity: Project workshop
Activity: angles and distances reduction.
|
|
Date: 17-23 March
Session: 6 |
Lesson Title: Assessment 1 - Task 2: Closed Loop traverse - Part 1
Description: In this session, you are required to determine the misclose and form a closed geometric figure by employing calculations to adjust coordinates for each location utilising the scientific or programmable calculator.
|
Activity: Printed table provided and completed by hand. |
|
Date:
Session: 7 |
Lesson Title: Assessment 1 - Task 3: Closed Loop traverse - Part 2
Description: In this session, you are required to determine the misclose and form a closed geometric figure by employing calculations to adjust coordinates for each location utilising the provided spreadsheet template to complete your computations.
|
Activity: Values and formulas are entered in a spreadsheet.
Activity: Spreadsheet values are displayed graphically.
|
|
Date: 31 March –6 April
Session: 8 |
Lesson Title: Assessment 1 - Task 4: Resolve missing traverse elements
Description: In this session, you are required to resolve missing traverse elements by calculating missing bearings, interior angles and determine areas.
|
Assessment 1 due: Sunday 6 April 2025 |
|
Date: 7-13 April
Session: 9
|
Lesson Title: Statistics in surveying
Description: In this session, we will analyse sets of data and analyse them statistically.
|
Activity: Case study: Relevance of computing the Standard Deviation
|
|
Date: 14-20 April
Session: 10
|
Lesson Title: Assessment 2: Meet and Analyse project specifications
Description: In this session, you are required to meet and consult with the client (teacher) to analyse project specifications in determining project requirements.
|
Activity: Project workshop
Activity: angles and distances reduction.
|
Date: 18-25 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. |
|
|
Date: 28 April – 4 May
Session: 11
|
Lesson Title: Assessment 2: Trigonometry Height - Part 1
Description: In this session, you are required to determine heights through the measurement of angles and distances within a triangle. This triangle is formed by the instrument, a known reference point with a known elevation, and the location for which the height is yet to be determined.
You will also use the provided scientific or programmable calculator for these calculations.
|
Activity: Printed table provided and completed by hand. |
|
Date: 5-11 May
Session: 12
|
Lesson Title: Assessment 2: Trigonometry Height - Part 2
Description: In this session, you are required to determine heights through the measurement of angles and distances within a triangle. This triangle is formed by the instrument, a known reference point with a known elevation, and the location for which the height is yet to be determined.
You will also use spreadsheet template provided to complete your computations.
|
Activity: Values and formulas are entered in a spreadsheet.
Activity: Spreadsheet values are displayed graphically.
|
|
Date: 12-18 May
Session: 13
|
Lesson Title: Assessment 2: Complex Reverse Curve
Description: In this session, you are required to compute the lengths, chainages, angles, bearings, and distances for a complex circular and reverse curve for a road alignment using information captured in the field using the scientific or programmable calculator provided.
|
Activity: Printed table provided and completed by hand.
|
|
Date: 19-25 May
Session: 14
|
Lesson Title: Assessment 2: Complex Reverse Curve
Description: In this session, you are required to use an independent check of the table completed.
You will also learn how to enter the Reverse Curve information into a surveying software like LISCAD.
|
Activity: Use LISCAD and produce point and line reports to check previous week table.
|
|
Date: 26 May-1 June
Session: 15
|
Lesson Title: Assessment 2: Knowledge Questions
Description: In this session you will access resources to be able to complete the knowledge questions prior to the due date.
|
Activity: Use resources available to answer the questions
|
|
Date: 2-8 June
Session: 16
|
Lesson Title: Assessment 2: Finalisation of the project
Description: In this session you will finalise the project.
|
Assessment 2 due: Sunday 8 June 2025 |
|
Date: 9-15 June
Session: 17 |
Lesson Title: Consultation
Description: This session will be dedicated to students who have not yet met the assessment requirements for assessment 2.
|
|
|
Date: 16-22 June
Session: 18 |
Lesson Title: Consultation
Description: This session will be dedicated to students who have not yet met the assessment requirements for assessment 2.
|
|
Learning Resources
Prescribed Texts
References
Other Resources
Check the Library Subject Guides: http://rmit.libguides.com/geospatial
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 Name |
Description |
Release Date |
Due Date |
|
Traverse Computation |
In this assessment you will take on the role of a surveyor and will be responsible for the collection and reduction of field observations, and present results for the company. Your manager has given you two different traverse observations (Part 2 and 3) for you to compute the required traverse information. |
10th of February 2025 |
Sunday 10th of April 2025 |
Traverse & Horizontal |
In this assessment you will take on the role of a surveyor and will be responsible for the collection and reduction of field observations, and present results for the company. Your manager has given you three different survey observations: missing traverse elements, trig heighting and curve set out for you to compute various traverse components, including, adjustments, misclosures and missing traverse data. |
10th of February 2025 |
Sunday 8 June 2025 |
Assessment Matrix
Mapping Assessments to the Unit of Competency – Instructions
Element and Performance criteria | |||
Performance criteria describe what needs to be done to demonstrate achievement of the element. |
AT1: Survey Calculations Part 1 |
AT2: Survey Calculations Part 2 |
|
|
|
3A |
3A |
|
3A |
3A |
|
|
1A |
1A |
|
|
|
3C |
3C |
|
3C |
3C |
|
|
3E |
3F |
|
|
|
3B |
3B |
|
3B |
3B |
|
|
3C |
3C |
|
|
3B, 3C, 3F |
3B, 3C, 3D |
|
|
|
3D |
3G |
|
3C |
3D |
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 elements and performance criteria of this unit by developing three types of multi-worksheet spreadsheets for different spatial data. Spreadsheets must include: |
AT1: Survey Calculations Part 1 |
AT2: Survey Calculations Part 2 |
| ||
|
3C |
3C |
|
3C |
3C |
|
3F |
3F |
|
3C |
3C |
|
3C |
3C |
|
3C |
3C |
|
3F |
3D |
|
3C |
3C |
|
3E |
3G |
|
3C |
3C |
| ||
|
3C |
3C |
|
3C |
3C |
|
3C |
3C |
|
3C |
3C |
|
3C |
3C |
Knowledge Evidence | ||
A person demonstrating competency in this unit must demonstrate knowledge of: |
AT1: Survey Calculations Part 1 |
AT2: Survey Calculations Part 2 |
| ||
|
3G |
|
|
3H |
|
| ||
|
3I |
|
|
3J |
|
|
3K |
|
|
3L |
|
|
3K |
|
|
3M |
|
|
3N |
|
| ||
|
3O |
|
|
3P |
|
Assessment conditions |
Describe how assessments meet the assessment conditions |
Assessors must satisfy 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. Work is carried out in a simulated office environment, the students are carrying out a task that is similar to work that would be carried out in the workplace, with students discussing with the manger/ Teacher. |
Candidates must have access to: | |
|
All labs will have the appropriate computers and software installed. Software that students required include: Microsoft Office including EXCEL available through Office 365 |
|
Students will be provided documentation on Canvas relating and information privacy and/or licensing as part of the training |
Other Information
Attendance Requirement - 85% for all students.
Resubmission Policy: To pass this course, students must achieve a Satisfactory (S) result for all their Assessments (and parts of those assessments).
Students who do not achieve a Satisfactory (S) result for their entire original submission for an Assessment will be provided with 1 (one) more submission opportunity (e.g. the resubmission) with a specific due date by their assessor. Students must achieve a Satisfactory (S) result on their resubmission for that Assessment, by the due date given to them by their Assessor.
Students who fail to submit their assessment by the due date will be issued a DNS (Did Not Submit) result which will not be overturned by teaching or managing staff. A DNS result will be overturned based on an approved Extension of Time or approved Special Consideration.
To be deemed Competency Achieved, students must achieve a satisfactory result in all assessment tasks. Students who fail to receive a Satisfactory result on all assessment tasks and have exhausted their resubmissions, extension of time applications, special consideration applications or Equitable Learning Plan provisions will be deemed as Not Yet Competent.
Credit Transfer and/or Recognition of Prior Learning (RPL):
You may be eligible for credit towards courses in your program if you have already met the learning/competency outcomes through previous learning and/or industry experience. To be eligible for credit towards a course, you must demonstrate that you have already completed learning and/or gained industry experience that is:
Relevant
Current
Satisfies the learning/competency outcomes of the course
Please refer to http://www.rmit.edu.au/students/enrolment/credit to find more information about credit transfer and RPL.
Study and learning Support:
Study and Learning Centre (SLC) provides free learning and academic development advice to you.
Services offered by SLC to support your numeracy and literacy skills are:
- Assignment writing, thesis writing and study skills advice
- Maths and science developmental support and advice
- English language development
Please Refer http://www.rmit.edu.au/study andlearningcentre to find more information about Study and learning Support
Equitable Learning Services (ELS):
If you are suffering from long-term medical condition or disability, you should contact Equitable Learning Services (ELS) to seek advice and support to complete your studies. Please refer to https://www.rmit.edu.au/students/support-and-facilities/student-support/equitable-learning-services to find more information about services offered by Equitable Learning Services (ELS).
Late submission:
If you require an Extension of Submittable Work (assignments, reports or project work etc.) for 7 calendar days or less (from the original due date) and have valid reasons, you must complete and lodge an Application for Extension of Submittable Work (7 Calendar Days or less) form and lodge it with the Senior Educator/ Program Manager.
The application must be lodged no later than one working day before the official due date. You will be notified within no more than 2 working days of the date of lodgment as to whether the extension has been granted.
If you seek an Extension of Submittable Work for more than 7 calendar days (from the original due date) must lodge an Application for Special Consideration form under the provisions of the Special Consideration Policy, preferably prior to, but no later than 2 working days after the official due date.
Submittable Work (assignments, reports or project work etc.) submitted late without approval of an extension will not be accepted or marked.
Special consideration:
Please Refer http://www.rmit.edu.au/students/specialconsideration to find more information about special consideration
Plagiarism:
Plagiarism is a form of cheating and it is very serious academic offence that may lead to expulsion from the University.
Please Refer: www.rmit.edu.au/academicintegrity to find more information about plagiarism.
Other Information:
All email communications will be sent to your RMIT email address and you must regularly check your RMIT emails.
Course Overview: Access Course Overview