Course Title: Develop spreadsheets for spatial data

Part B: Course Detail

Teaching Period: Term2 2017

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

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

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

NIL

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


 On completion of this course, you should be able to:

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 .

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.

 

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.

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.

 

3. Use functions and features of spreadsheet software.

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.

 

4.  Finalise spreadsheets.

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. 

 


Details of Learning Activities

ou will learn to:

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

 

  • 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

Topic

 

 Assessment due date

19

Introduction to Excel and

Lynda.com online tutorials

  

20

Writing formulae using operators and functions

 

 

21

Cell reference ( Relative & Absolute)

 

22

Logical functions

 

23

Level page reduction using Excel

 

24

Trigonometric functions

 

25

Coordinate computation

 

26

Bowditch Adjustment & Area computation

Portfolio Activity 1 & 2 due

27

Trig Heighting /Assessment 1

 

28

Trig - heighting ( portfolio Activity )

Assessment 1 due – 25%

29

Macros & Charts in Excel

Portfolio Activity 3 & 4 due, Friday 11th Week

30

Google Sheets- Flip class activities

  

31

Google Sheets – Portfolio Activity 7

 

32

Lot graphic representation

 Portfolio Activity 5, 6 & 7 due

33

Revision

 

34

Closed book Test

Assessment 2 - 35%

35

Portfolio  Completion

 

36

Feedback to students

 


Learning Resources

Prescribed Texts


References


Other Resources

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. The students will also use equipment and software packages in the laboratory for the project work. During the course, students will be directed to websites to enhance their knowledge and understanding of difficult concepts.


Overview of Assessment

Assessment Tasks

Students must pass each of the following assessment tasks to demonstrate competent. 

Assessment

Weight%

Task 1

Assignment

25%

Task 2

Test

35%

Task 3

Portfolio

40%

These tasks assesses the following Course Learning Outcomes (CLOs):

Assessment Mapping Matrix  

Elements/

Performance Criteria Covered

Task 1

Task 2

Task 3

1.1

X

 

X

1.2

X

X

 

1.3

X

X

 

2.1

X

 

X

2.2

X

X

 

2.3

X

X

 

2.4

X

X

 

3.1

X

X

 

3.2

X

X

 

3.3

X

 

X

3.4

X

X

X

4.1

 

X

X

4.2

 

X

X

 

To be deemed competent you must demonstrate an understanding of all aspects required of the competency. Assessment methods have been designed to measure your achievement of each competency in a flexible manner over multiple tasks.

 


Assessment Tasks

Students must pass each of the following assessment tasks to demonstrate competent

Assessment

Weight

Task 1

Assessment 1

25%

Task 2

Test

35%

TEST

Portfolio

40%

 


Assessment Matrix

Element / Performance Criteria Covered Assessment 1 Assessment 2 Assessment 3
1.1 X   X
1.2 X X   
1.3 X  X  
2.1 X   X
2.2 X X  
2.3 X X  
2.4 X X   
3.1 X X   
3.2 X X   
3.3 X   X
3.4 X X X 
4.1   X X 
4.2   X X 
       

 

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

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/studyandlearningcentre to find more information about Study and learning Support

Disability Liaison Unit:
If you are suffering from long-term medical condition or disability, you should contact Disability Liaison Unit to seek advice and support to complete your studies.
Please Refer http://www.rmit.edu.au/disability to find more information about services offered by Disability Liaison Unit

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/staff/studentadmin/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