Course Title: Use complex spreadsheets for spatial information
Part B: Course Detail
Teaching Period: Term1 2016
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
Indira Wittamperuma
Indira.wittamperuma@rmit.edu.au
Ph: 9925 4176
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 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 |
Task / Assessment |
1 |
Introduction to Excel and Lynda.com online tutorials |
|
2 |
Writing formulae using operators and functions |
|
3 |
Cell reference ( Relative, Absolut & mixed) |
|
4 |
Logical functions |
|
5 |
Levelling using Excel |
|
6 |
Trigonometric functions |
|
7 |
Class Activity- Angle computation and Trigonometry |
|
8 |
Trig - heighting using Excel |
Assessment 1- submission |
9 |
Google Sheets- Lynda.com online tutorial |
|
10 |
Google Sheets - Flip class activities feed back |
|
11 |
Area by coordinates |
|
12 |
Coordinate computation |
|
13 |
Bowditch Adjustment |
|
14 |
Lot graphic representation in Excel |
|
15 |
Revision |
|
16 |
Test |
Test |
17 |
Portfolio Completion |
Portfolio Submission |
18 |
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
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 |
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 | |
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 |
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