Course Title: Use complex spreadsheets for spatial information

Part B: Course Detail

Teaching Period: Term1 2014

Course Code: COSC7351C

Course Title: Use complex spreadsheets for spatial information

School: 130T Vocational Engineering

Campus: City Campus

Program: C5320 - Diploma of Surveying

Course Contact: Program Manager

Course Contact Phone: +61 3 9925 4468

Course Contact Email: vocengineering@rmit.edu.au


Name and Contact Details of All Other Relevant Staff

Surveying Senior Educator: Thierry Demathieu
School of Engineering (TAFE)
Ph: 9925 8359
Email: thierry.demathieu@rmit.edu.au

Teacher: William Ntuwah
School of Engineering (TAFE)
Ph: 99254445
Email: william.ntuwah@rmit.edu.au

Teacher: Stephen Falzon
School of Engineering (TAFE)
Ph: 9925 8359
Email: stephenjoseph.falzon@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 use spreadsheet software to complete spatial tasks using complex spatial data. The skills and knowledge required in this unit focus on creating complex spreadsheets to store and retrieve spatial data.


National Codes, Titles, Elements and Performance Criteria

National Element Code & Title:

CPPSIS5060A Use complex spreadsheets for spatial information

Element:

1. Prepare the task.

Element:

2. Evaluate and standardise spreadsheet operation.

Element:

3. Develop a linked worksheet solution.

Element:

4. Use spreadsheets.

Element:

5. Finalise the task.


Learning Outcomes


Refer to elements


Details of Learning Activities

 

You will learn to:

  • Use logical functions in survey data computations
  • Apply micros 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.
 


Teaching Schedule

 

  This is an indicative teaching schedule, refer to the Blackboard for any changes or announcements

Session/DateTopicElements

Assessment

 

 

 

 

1

(11/02/14)

 Creating Simple worksheet
• Adjust seats and computers to suit the ergonomic requirements - Covering Element 1

• Enter data, manipulate simple data using formula

 Element 4 Brief overview of semester one.
Creating simple worksheets/formula

2

(18/02/14)

 Formulae in problem solving
• Adjust seats and computers to suit the ergonomic requirements- Covering Element 1
• Apply multiplication, Addition and Trigonometric ratios in problem solving - Covering Element 4

 

 Element 1 & 4 Class activity will involve reducing raw data gathered in the field and process using spreadsheet
REFERENCE:
Excel for Engineers & Scientists
SC Bloch

3

(25/02/14)

 Workbook with multiple worksheet
• Learn how to use multiple sheets
• Compute misclose of level run and Arithmetic checks
• Compute adjusted reduced levels
 Element 1 & 2

Compute height difference for each triangle.
Compute the misclose for each triangle and adjust.
Compute the Reduce levels of the PMs 901,902,730 and 903

Reference: SDN 1277

4

(04/03/14)

 Relative, Absolute and mixed cell addresses
• Adjust seats and computers to suit the ergonomic requirements

• Link Data entry, Computed Rise & Fall, Adjusted Reduced level
• Apply absolute and relative cell references in differential levelling
 Element 1,2,4 & 5

Compute the height differences
Compute the misclose and adjust
Compute the Reduced levels of PMs 732,733 and 734

Reference SDN 1282

5

(11/03/14)

 Logical Functions
• Adjust seats and computers to suit the ergonomic requirements
• Link data entry, Computed Rise & Fall, Adjusted Reduced levels
• Use Micros to automate spreadsheet operation
• Apply IF statement in Rise and Fall columns
 Element 1,2,3,4& 5

Assessment 1

Compute the height differences
Compute the misclose and adjust
Compute the Reduced levels of PMs 710,708,905,904 & 709

Reference SDN1283

6

(18/03/14)

 Logical Functions

• Adjust seats and computers to suit the ergonomic requirements

• Link Data entry, Reduced Angles and measured distances

• Use Micros to automate spreadsheet operation 

• Draw reduced measured angles using a pie chart

 Element 1,2,3 & 5

 Assessment 1(Continued)

 

 

7

(25/03/14)

 Application – Project 1

• Adjust seats and computers to suit the ergonomic requirements 

• Link Data entry, Reduced Angles and measured distances

• Use Micros to automate spreadsheet operation

• Draw reduced measured angles using a pie chart

 Element 1,2,3 & 5

Compute height differences from Instrument station to PMs
Compute height differences between PMs and Reduced levels
Adjust reduced angles and compute missing sistances
Compute bearings from computed internal angles
Compute coordinates from bearings and distances of PMs 901,903,730 &903

Reference:

SDN 1352

 

8

(01/04/14)

 Application – Project 1

• Use traverse spreadsheet to link computed bearings and coordinates


• Use Micros to automate spreadsheet operation 

• Enter data in a traverse spreadsheet , compute coordinates and accuracy

 Element 2,3 & 4

Compute height differences from Instrument station to PMs
Compute height differences between PMs and Reduced levels
Adjust reduced angles and compute missing sistances
Compute bearings from computed internal angles
Compute coordinates from bearings and distances of PMs 710,708,905,904 & 709

 

Assessment 1 Due

9

(08/04/14)

 Application – Project 1

• Use traverse spreadsheet to link collected and computed data 

• Use Micros to automate spreadsheet operation 

• Enter data in a traverse spreadsheet , compute local coordinates and accuracy

 Element 2,3 & 4 

10

(15/04/14)

 Application – Project 1

• Use traverse spreadsheet to link collected and computed data

• Use Micros to automate spreadsheet operation 

• Enter data in a traverse spreadsheet , compute local coordinates and accuracy

  Element 2,3 & 4 Compute height differences from Instrument station to PMs
Compute height differences between PMs and Reduced levels
Adjust reduced angles and compute missing sistances
Compute bearings from computed internal angles
Compute coordinates from bearings and distances of PMs

11

(29/04/14)

 Application - Project 1

• Use traverse spreadsheet to link collected and computed data

• Use Micros to automate spreadsheet operation 

• Enter data in a traverse spreadsheet , compute local coordinates and accuracy

 

  Element 2,3 & 4Compute height differences from Instrument station to PMs
Compute height differences between PMs and Reduced levels
Adjust reduced angles and compute missing distances
Compute bearings from computed internal angles
Compute coordinates from bearings and distances of PMs

12

(06/05/14)

 Application – Project 1

• Use traverse spreadsheet to link collected and computed data

• Use Micros to automate spreadsheet operation 

• Enter data in a traverse spreadsheet , compute local coordinates and accuracy

  Element 2,3 & 4

Compute height differences from Instrument station to PMs
Compute height differences between PMs and Reduced levels
Adjust reduced angles and compute missing distances
Compute bearings from computed internal angles
Compute coordinates from bearings and distances of PMs
Transform coordinate from Local to MGA

Reference:

Coordinate Transformation template

 Assessment 2

13

(13/05/14)

 Application – Project 1

• Use traverse spreadsheet to link collected and computed data

• Use Micros to automate spreadsheet operation

• Enter data in a traverse spreadsheet , compute local coordinates and accuracy

 Element 2,3 & 4

Compute adjusted coordinated for PMs 901,902,730 & 903
Apply coordinate transformation (Local to MGA)

Reference:

Coordinate Transformation template

14

(20/05/14)

 Application – Project 1

• Use traverse spreadsheet to link collected and computed data

• Use Micros to automate spreadsheet operation

• Enter data in a traverse spreadsheet , compute local coordinates and accuracy 

 Element 2,3 & 4

 Compute adjusted coordinated for PMs 732,733 & 733
Apply coordinate transformation (Local to MGA)

Reference:

Coordinate Transformation template

 

Assessment 2 Due

15

(27/05/14)

 Application – Project 1
Use spreadsheets for Circular curves comps
 Element  4Compute Coordinates from Tangent Tangent Point

 

 

16

(03/06/14)

 Application – Project 1

Use spreadsheets for Circular curves comps

 Element  4 Compute coordinate from Centre of Radius

17

(10/06/14)

 TEST Element 1,2,3,4 & 5CLOSED BOOK TEST


Learning Resources

Prescribed Texts


References


Other Resources

Check the Library Subject Guides:

http://rmit.libguides.com/geospatial

http://rmit.libguides.com/surveyingandspatial


Overview of Assessment

The assessment is conducted in both theoretical and practical aspects of the course according to the performance criteria set in the National Training Package. Assessment may incorporate a variety of methods including written/oral activities and demonstration of practical skills to the relevant industry standards. Participants are advised that they are likely to be asked to personally demonstrate their assessment activities to their teacher/assessor. Feedback will be provided throughout the course. To successfully complete this course you will be required to demonstrate competency in each assessment task detailed under Assessment Tasks:

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

Assessment Tasks

Assessment

Weight %

Assessment 1

Written Assessment

25

Assessment 2

Test

35

Assessment 3

Portfolio

40

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

Assessment Mapping Matrix

Elements/ Performance Criteria Covered

Assessment 1

Assessment 2

Assessment 3

1.1

X

 

X

1.2

X

 

X

1.3

X

 

X

1.4

X

 

X

2.1

X

 

X

2.2

X

 

X

3.1

X

 

X

3.2

X

 

X

3.3

X

 

X

3.4

X

 

X

4.1

X

X

 

4.2

X

X

 

4.3

X

X

 

4.4

X

X

 

4.5

X

X

 

4.6

X

X

 

4.7

X

X

 

5.1

 

X

X

5.2

 

X

X

5.3

 

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 Task 1 – Weight 25% Due date Week 8
Assessment Task 2 – Weight 35% Due date Week 14
TEST - Weight 40% Due date Week 17

All assessment tasks need to be succesfully completed to demonstrate competence.

Courses delivered in accordance with competency-based assessment, but which also utilise graded assessment.
CHD (80-100%): Competent with High Distinction
CDI (70-79%): Competent with Distinction
CC (60-69%): Competent with Credit
CAG (50-59%): Competency Achieved – Graded
NYC (<50%): Not Yet Competent
DNS: Did Not Submit an assessment
 


Assessment Matrix

 

Element CoveredAssessment TaskProportion of Final Assessment Submission Time
 Element 1,2,3,4 & 5 Assessment 1 25% Week 8
  Element 1,2,3,4 & 5 Assessment 2 35% Week 14
  Element 1,2,3,4 & 5 Closed Book Test 40% Week 17

Other Information

Underpinning Skills and Knowledge

• literacy skills to:
     • evaluate the purposes and uses of various features of spreadsheets
     • use a variety of strategies for planning and reviewing own work
• numeracy skills to:
     • apply trigonometrical functions when using spreadsheets
     • collate and present data, graphs and related references
     • solve spatial and surveying computations
• database structures, including the relationship of spatial features of database
• formatting and design of spreadsheets and their impact on the presentation and readability of data
• surveying and spatial information services (SSIS) reference systems
 

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