Course Title: Develop and use complex spreadsheets
Part B: Course Detail
Teaching Period: Term1 2011
Course Code: COSC5956C
Course Title: Develop and use complex spreadsheets
School: 130T Vocational Engineering
Campus: City Campus
Program: C5237 - Diploma of Spatial Information Services
Course Contact: Program Manager
Course Contact Phone: +61 3 9925 4468
Course Contact Email: engineering-tafe@rmit.edu.au
Name and Contact Details of All Other Relevant Staff
William Ntuwah
william.ntuwah@rmit.edu.au
+61 3 99254445
Nominal Hours: 20
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 covers the use of spreadsheet software to complete business tasks and produce usable complex documents. This unit is related to BSBCMN214A Create and use simple spreadsheets.
National Codes, Titles, Elements and Performance Criteria
National Element Code & Title: |
BSBADM404A Develop and use complex spreadsheets |
Element: |
1 Use safe work practices |
Performance Criteria: |
1.1 Workspace, furniture and equipment are adjusted to suit the ergonomic requirements of the user |
Element: |
2 Develop a linked spreadsheet solution |
Performance Criteria: |
2.1 Task is analysed and specifications for spreadsheets are determined |
Element: |
3 Automate and standardise spreadsheet operation |
Performance Criteria: |
3.1 Tasks are evaluated to identify those where automation would increase efficiency |
Element: |
4 Use spreadsheets |
Performance Criteria: |
4.1 Data is entered, checked and amended in accordance with organisational and task requirements |
Element: |
5 Represent numerical data in graphic form |
Performance Criteria: |
5.1 Style of graph is determined to meet specified requirements and spreadsheet data is manipulated if necessary to suit graph requirements |
Learning Outcomes
Refer to elements
Details of Learning Activities
Teacher led :
Classroom &/or tutorial instruction the use of spreadsheet software to complete business tasks and produce suitable complex documents, as well as tasks associated with the elements above including the use of computers and relevant software/s, capabilities of survey methodologies and technologies in a simulated workplace environment.
Student managed:
Develop data management strategies to determine suitable sources of information for the creation of new spatial data sets to industry standards.
Participation in group activities based on simulated workplace exercises. Individual exercises carrying out research, computations, data compilation and appraisal.
Compilation of Portfolio of examples of work, client reports, management reports and data management records.
Teaching Schedule
This is an indicative teaching schedule, refer to the Blackboard for any changes or announcements
Session/Date | Topic |
Comment/ Assessment Tasks |
1/07 Feb 2011 |
Creating Simple worksheet • Adjust seats and computers to suit the ergonomic requirements - Covering Element 1 |
Brief overview of semester one. Creating simple worksheets/formula |
2 /14 Feb 2011 |
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
|
Class activity will involve reducing raw data gathered in the field and process using spreadsheet REFERENCE: Excel for Engineers & Scientists SC Bloch |
3 / 21 Feb 2011 |
Workbook with multiple worksheet • Learn how to use multiple sheets |
Class activity will involve reducing raw data gathered in the field and process using spreadsheet |
4 / 28 Feb 2011 |
Relative, Absolute and mixed cell addresses • Adjust seats and computers to suit the ergonomic requirements - Covering Element 1 • Apply absolute and relative cell references in differential levelling - Covering Element 4 • Draw the profile of the terrain using a line graph - Covering Element 5 |
Class activity will involve reducing raw data gathered in the field and process using spreadsheet |
5 / 7 March2011 |
Logical Functions • Adjust seats and computers to suit the ergonomic requirements - Covering Element 1 • Link data entry, Computed Rise & Fall, Adjusted Reduced levels - Covering Element 2 • Use Micros to automate spreadsheet operation - Covering Element 3 • Apply IF statement in Rise and Fall columns - Covering Element 4 • Draw the profile of the terrain using line graph - Covering Element 5
|
Class activity will involve reducing raw data gathered in the field and process using spreadsheet |
6 / 14 March2011 | PUBLIC HOLIDAY - NO CLASS | |
7 / 21 March 2011 |
Logical Functions • Adjust seats and computers to suit the ergonomic requirements - Covering Elent 1 • Link Data entry, Reduced Angles and measured distances - Covering Element 2 • Use Micros to automate spreadsheet operation - Covering Element 3 • Draw reduced measured angles using a pie chat - Covering Element 5 |
Assignment 1 Class activity will involve reducing raw data gathered in the field and process using spreadsheet |
8 / 28 March 2011 |
Application – Project 1 • Adjust seats and computers to suit the ergonomic requirements - Covering Elent 1 |
Class activity will involve reducing raw data gathered in the field and process using spreadsheet |
9 / 4April 2011 |
Application – Project 1 • Use traverse spreadsheet to link computed bearings and coordinates - Covering Element 2
• Enter data in a traverse spreadsheet , compute coordinates and accuracy - Covering Element 4 |
Assignment 1 Due date Class activity will involve reducing raw data gathered in the field and process using spreadsheet |
10/ 11 April 2011 |
Application – Project 1 • Use traverse spreadsheet to link collected and computed data Covering Element 2 • Use Micros to automate spreadsheet operation - Covering Element 3 • Enter data in a traverse spreadsheet , compute local coordinates and accuracy - Covering Element 4
|
Class activity will involve reducing raw data gathered in the field and process using spreadsheet |
11/ 18 April 2011 |
Application – Project 1
|
Class activity will involve reducing raw data gathered in the field and process using spreadsheet |
12 / 25 April 2011 | EASTER MONDAY | |
13 / 2 May 2011 |
Application - Project 1 • Use traverse spreadsheet to link collected and computed data Covering Element 2 |
Class activity will involve reducing raw data gathered in the field and process using spreadsheet |
14 / 9 May 2011 | Application – Project 1 • Use traverse spreadsheet to link collected and computed data Covering Element 2 • Use Micros to automate spreadsheet operation - Covering Element 3 • Enter data in a traverse spreadsheet , compute local coordinates and accuracy - Covering Element 4 |
Assignment 2 Class activity will involve reducing raw data gathered in the field and process using spreadsheet |
15 /16 May 2011 | Application – Project 1 • Use traverse spreadsheet to link collected and computed data Covering Element 2 • Use Micros to automate spreadsheet operation - Covering Element 3 • Enter data in a traverse spreadsheet , compute local coordinates and accuracy - Covering Element 4 |
Class activity will involve reducing raw data gathered in the field and process using spreadsheet |
16 / 23 May 2011 | Application – Project 1 • Use traverse spreadsheet to link collected and computed data Covering Element 2 • Use Micros to automate spreadsheet operation - Covering Element 3 • Enter data in a traverse spreadsheet , compute local coordinates and accuracy - Covering Element 4 |
Assignment 2 Due date Class activity will involve reducing raw data gathered in the field and process using spreadsheet |
17 / 30 May 2011 | TEST | |
18 / 06 June 2011 | Portfolio submission & Evaluation |
Learning Resources
Prescribed Texts
Acts and Regulations Occupational Health and Safety Commission. |
References
Excel for Engineers & Scientists |
Other Resources
Web Resources:
http://www.rmit.edu.au/ - Online@RMIT – Program and Course information, documents, resources and links.
http://www.lands.vic.gov.au/ - Land Channel (Victoria) - Survey Mark Enquiry Service, GPSnet, Maps & Images, Property Information, Land Management.
http://www.isaust.org.au - Institute of Surveyors, Australia
http://www.mappingsciences.org.au - Mapping Sciences Institute, Australia
http://www.anzlic.org.au - ANZLIC: Australian and New Zealand Spatial Information Council
http://www.surveyorsboard.vic.gov.au - Surveyors Board, Victoria – Survey Practice Handbook, Key Legislation for Surveyors.
http://www.icsm.gov.au/ - Intergovernmental Committee on Surveying and Mapping - Standards and Practices for Control Surveys
http://www.ga.gov.au/ - Geoscience Australia – National Mapping Agency, Geocentric Datum of Australia, GPS
Overview of Assessment
A person who demonstrates competency in this unit must be able to provide evidence of:
• Successful operation of linked spreadsheets
• Knowledge and application of advanced spreadsheet features
• Formatting and design on the presentation and readability
• Literacy skills to interpret and evaluate the purposes and uses of various features of spreadsheets; use a variety of strategies for planning and reviewing own work
• Proofreading and editing skills to check for accuracy and consistency of information by consulting additional resources
• Problem solving skills to use processes flexibly and interchangeably
• Numeracy skills to collate and present data; graphs and related references
• Communication skills to follow complex oral instructions when using technology; listen to and interpret complex sequenced instructions
• Keyboarding skills
• Ability to relate to people from a range of social, cultural and ethnic backgrounds and physical and mental abilities
Assessment Tasks
Grading Criteria
NYC 0-49% Not yet competence
CP 50 – 59% Competence
CCR 60 – 69% Competence with credit
CDI 70 – 79% Competence with distinction
CHD 80-100% Competence with high distinction
Academic Misconduct
Students are reminded that cheating, whether by fabrication, falsification of data, or plagiarism, is an offence subject to University disciplinary procedures. Plagiarism in oral or written presentations is the presentation of the work, idea or creation of another person, without appropriate referencing, as though it is one’s own. Plagiarism is not acceptable.
The use of another person’s work or ideas must be acknowledged. Failure to do so may result in charges of academic misconduct which carry a range of penalties including cancellation of results and exclusion from your course.
Students are responsible for ensuring that their work is kept in a secure place. It is also a disciplinary offence for students to allow their work to be plagiarized by another student. Students should be aware of their rights and responsibilities regarding the use of copyright material. It is strongly recommended that students refer to the RMIT 2001 Guidelines for Students or to the RMIT University Homepage.
Assessment 1 = Assignment 20% due Week 9
Assessment 2 = Assignment 20% due Week 16
Assessment 3 = TEST40% on Week 17
Assessment 4 = Portfolio 20% on Week 18
Context of Assessment:
This unit is to be assessed in a simulated workplace and under the normal range of work conditions.
Assessment Matrix
Assessment Task | Element | Percentage loading |
Assignment 1 | Element 1, 2 , 3& 4 | 20% |
Assignment 2 | Element 1, 2 , 3& 4 | 20% |
TEST | Element 1, 2 , 3, 4 & 5 | 40% |
Portfolio | Element1, 2 , 3, 4 & 5 | 20% |
Course Overview: Access Course Overview