Course Title: Develop and use complex spreadsheets

Part B: Course Detail

Teaching Period: Term1 2012

Course Code: COSC6087C

Course Title: Develop and use complex spreadsheets

School: 130T Vocational Engineering

Campus: City Campus

Program: C5236 - Diploma of Surveying

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

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 describes the performance outcomes, skills and knowledge required to use spreadsheet software to complete business tasks and to produce complex documents.


National Codes, Titles, Elements and Performance Criteria

National Element Code & Title:

BSBITU402A Develop and use complex spreadsheets

Element:

1. Prepare to develop spreadsheet

Performance Criteria:

1.1. Organise personal work environment in accordance with ergonomic requirements
1.2. Analyse task and determine specifications for spreadsheets
1.3. Identify organisational and task requirements in relation to data entry, storage, output, reporting and presentation requirements
1.4. Apply work organisation strategies and energy and resource conservation techniques to plan work activities

Element:

2. Develop a linked spreadsheet solution

Performance Criteria:

2.1. Utilise spreadsheet design software functions and formulae to meet identified requirements
2.2. Link spreadsheets in accordance with software procedures
2.3. Format cells and use data attributes assigned with relative and/or absolute cell references, in accordance with the task specifications
2.4. Test formulae to confirm output meets task requirements

Element:

3. Automate and standardise spreadsheet operation

Performance Criteria:

3.1. Evaluate tasks to identify those where automation would increase efficiency
3.2. Create, use and edit macros to fulfil the requirements of the task and automate spreadsheet operation
3.3. Develop, edit and use templates to ensure consistency of design and layout for forms and reports, in accordance with organisational requirements

Element:

4. Use spreadsheets

Performance Criteria:

4.1. Enter, check and amend data in accordance with organisational and task requirements
4.2. Import and export data between compatible spreadsheets and adjust host documents, in accordance with software and system procedures
4.3. Use manuals, user documentation and online help to overcome problems with spreadsheet design and production
4.4. Preview, adjust and print spreadsheet in accordance with organisational and task requirements
4.5. Name and store spreadsheet in accordance with organisational requirements and exit the application without data loss or damage

Element:

5. Represent numerical data in graphic form

Performance Criteria:

5.1. Determine style of graph to meet specified requirements and manipulate spreadsheet data if necessary to suit graph requirements
5.2. Create graphs with labels and titles from numerical data contained in a spreadsheet file
5.3. Save, view and print graph within designated time lines


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 2012

 Creating Simple worksheet

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

 
• Enter data, manipulate simple data using formula and save in H drive-  Covering Element 4 

 Brief overview of semester one.

Creating simple worksheets/formula

2 /14 Feb 2012

 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 2012

 Workbook with multiple worksheet

• Learn how to use multiple sheets
• Compute misclose of level run and Arithmetic checks
• Compute adjusted reduced levels
• Save in H drive in a folder

 Class activity will involve reducing raw data gathered in the field and process using spreadsheet
4 / 28 Feb 2012

 Relative, Absolute and mixed cell addresses

• Adjust seats and computers to suit the ergonomic requirements - Covering Element 1
• Submit assignments electronically - Covering Element 1
• Link Data entry, Computed Rise & Fall, Adjusted Reduced level -Covering Element 2

 • 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 / 6 March2012

 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 / 13March 2012  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

7 / 20 March 2012

 Application – Project 1

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

  Class activity will involve reducing raw data gathered in the field and process using spreadsheet

8/ 27 March2012

 Application – Project 1

• Use traverse spreadsheet to link computed bearings and coordinates - Covering Element 2


• Use Micros to automate spreadsheet operation - Covering Element 3

• 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

09/ 03 April 2012 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

10/ 17April 2012

 

 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 / 24 April 2012

  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
 12 / 01May 2012  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

13 /08May 2012

 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
14 / 15 May 2012  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

15 / 22 May 2012  Application – Project 1
Use spreadsheets for Circular curves comps - Covering Element 4

 Class activity will involve reducing raw data gathered in the field and process using spreadsheet

16 / 29 May2012  Application – Project 1

Use spreadsheets for Circular curves comps-Covering Element 4


 Class activity will involve reducing raw data gathered in the field and process using spreadsheet

17 / 05 June 2012  TEST  Closed book TEST
 18 / 12 June 2012

 

Portfolio submission /Supplementary test

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


Learning Resources

Prescribed Texts

Acts and Regulations Occupational Health and Safety Commission.
Surveying, A Bannister and S Raymond, Pitman
Elementary Surveying, Elfick Fryer Brinkner Wolf, Harper Collins
Advanced-Engineering-Surveying-problems-and-solutions, F A Shepard, Arnold.


References

Excel for Engineers & Scientists
SC Bloch


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

Evidence of the following is essential:

- developing complex spreadsheets
- developing graphical representation of data contained in spreadsheets.


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%

Other Information

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/browse;ID=riderwtscifm 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