Course Title: Develop spreadsheets for spatial data

Part B: Course Detail

Teaching Period: Term1 2020

Course Code: COSC6209C

Course Title: Develop spreadsheets for spatial data

School: 174T School of VE Engineering, Health & Science

Campus: City Campus

Program: C5368 - Diploma of Surveying

Course Contact: Thierry Demathieu

Course Contact Phone: +61 3 9925 8359

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


Name and Contact Details of All Other Relevant Staff

Course Coordinator:

Dr Indira Wittamperuma 
Teacher - Surveying
Surveying Department, School of Vocational Engineering, RMIT
Building 57, Level 5, Room 37
115 Queensberry St
Carlton 3053, Australia
Tel. +61 3 9925 4176
Email: indira.wittamperuma@rmit.edu.au
www.rmit.edu.au

 

Simon Shachter

Teacher  Surveying Department School of Vocational Engineering, Health and Science (SVEHS)
RMIT University
Building 51, Level 6, Room 10
115 Queensberry St
Carlton 3053, Australia
Tel. +61 3 9925 8983
Email: simon.shachter@rmit.edu.au  

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.

Pre-requisites and Co-requisites

None

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.


National Codes, Titles, Elements and Performance Criteria

National Element Code & Title:

CPPSIS5060 Develop spreadsheets for spatial data

Element:

1. Prepare for spreadsheet tasks.

Performance Criteria:

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.

Element:

2. Set up spreadsheets.

Performance Criteria:

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.

Element:

3. Use functions and features of spreadsheet software.

Performance Criteria:

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.

Element:

4. Finalise spreadsheets.

Performance Criteria:

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.

Learning Outcomes


See elements above


Details of Learning Activities

You will learn to:

  • Use logical functions in survey data computations
  • Apply macros to automate spreadsheet operations
  • Solve problems related to survey operations

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.

Students will be able to access course information and learning materials through the Learning Hub and may be provided with additional materials in class. Lists of relevant reference books, resources in the library and accessible Internet sites will be provided where possible. You will also use equipment and software packages in the laboratory for the project work. During the course, you will be directed to websites to enhance your knowledge and understanding of difficult concepts.

 

 


Teaching Schedule

Week number

Topic

Assessment due date

1

Introduction

 

2

Getting started with Microsoft Excel

 

 

3

Relative and absolute cell reference

 

4

Advanced functions

 

5

Google Sheets / Excel Charts

 

6

Assessment 1

 

7

Assessment 1

 

8

Assessment 1

 

9

 Assessment 1

Assessment 1 due

10

 Trig heighting /Macros in Excel

 

11

Trigonometric function

 

12

Inverse Trigonometrical Functions

  

13

Bowditch rule/ Area calculation by coordinates & Finalise

 

14

Revision

  

15

Assessment 2

 Assessment 2 due

16

Assessment 2

Assessment 2 due

17

Feedback to students

 

18

Feedback to students

 

 


Learning Resources

Prescribed Texts


References


Other Resources

Students will be able to access course information and learning materials through myRMIT and may be provided with additional materials in class. Lists of relevant reference books, resources in the library and accessible Internet sites will be provided where possible. You will also use equipment and software packages in the laboratory for the project work. During the course, you will be directed to websites to enhance your knowledge and understanding of difficult concepts.

Check the Library Subject Guides:

http://rmit.libguides.com/geospatial


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

Task 3

Assessment 3

 


Assessment Tasks

 

No

Name of Assessment Task

Method of Assessment

1.

Assessment 1

Written Computations Assignment

2.

Assessment 2

 

Written Test


Assessment Matrix

 

Element

Performance criteria

 

 

 

 

Assessment

Task 1: Surveying computations

Assessment

Task 2: Open Book Test

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

ProjectA(1.1), ProjectB(1.1)

-

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

ProjectA(1.1, 1.2, 2.3, 2.4, 3.2),

ProjectB(1.1, 1.2),

-

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

ProjectA(1.3),

ProjectB(1.3),

 

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.   

ProjectA(2.1),

Q1 and Q2

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

ProjectA(1.2,2.5, 3.2),

ProjectB(3.2, 3.4),

-

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

ProjectA(2.6)

Q1a, b,c,d,e and Q2a,b,c,d,e

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

ProjectA(2.4, 3.4, 4.4)

Q1e

3. Use functions and features of spreadsheet software.

 

 

 

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

ProjectA(3.3,3.4)

Q1, Q2

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

ProjectA(2.2), ProjectB(1.6)

-

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

ProjectA(3.1)

-

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

ProjectA(2.1, 3.5, 3.6,)

ProjectB(1.2, 3.6)

Q1, Q2, Q1e

4. Finalise spreadsheets.

 

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

ProjectA(1.7)

ProjectB(4.1)

 

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

ProjectA(AR9, 5.0),

ProjectB (5.0)

 

 

Other Information

Underpinning Skills and Knowledge

• numeracy skills to:
      • analyse errors
      • conduct image analysis
      • perform mental calculations
      • interpret and analyse statistics
      • record with accuracy and precision
      • undertake computations
• organisational skills to:
      • research activities
      • prioritise activities to meet contractual requirements
• spatial skills to:
      • display proficiency in the operation of spatial data capture equipment
      • exercise precision and accuracy in relation to spatial and aspatial data acquisition and the use of electronic equipment
      • archive and retrieve spatial data
      • manage and manipulate spatial data

• spatial referencing systems
• spatial data capture methodologies
• project management tools, techniques and methodologies
• quality assurance principles relating to the collection of spatial data

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 Support: 

Study Support provides free learning and academic development advice to you. 
Services offered by Study Support 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 https://www.rmit.edu.au/students/study-support 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 https://www.rmit.edu.au/students/student-essentials/assessment-and-exams/assessment/special-consideration to find more information about special consideration 

Academic Integrity: 


"Academic integrity means acting with the values of honesty, trust, fairness, respect and responsibility in learning, teaching and research."

It means referencing the work of others while developing your own insights, knowledge and ideas.

Breaches of academic integrity include:

  • plagiarism and failure to correctly acknowledge sources
  • contract cheating or paying/getting another person to prepare an assignment
  • submitting work prepared by another person
  • copying other people’s work
  • cheating in exams
  • breaching the Research Code
  • using unauthorised materials or devices

Please Refer: https://www.rmit.edu.au/students/student-essentials/assessment-and-exams/academic-integrity 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