Course Title: Operate computing packages

Part B: Course Detail

Teaching Period: Term1 2012

Course Code: COSC6082C

Course Title: Operate computing packages

School: 130T Vocational Engineering

Campus: City Campus

Program: C6069 - Advanced Diploma of Engineering Technology

Course Contact: Leon Mattatia

Course Contact Phone: +61 3 9925-4668

Course Contact Email: leon.mattatia@rmit.edu.au


Name and Contact Details of All Other Relevant Staff

Teacher Mark Burns;
Telephone: 9925 4604;
Fax: 9925 4377;
Email: mark.burns@rmit.edu.au

Nominal Hours: 60

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 defines the competency required to identify, select and correctly operate three desktop applications for a range of purposes. (Word processor, spreadsheet and a database.)


National Codes, Titles, Elements and Performance Criteria

National Element Code & Title:

ICAU2006B Operate computing packages

Element:

1. Use appropriate software

Performance Criteria:

1.1. Select software appropriate to perform activity
1.2. Use software to produce required outcome using a range of features related to the activities
1.3. Save documents in appropriate directories/folders

Element:

2. Access, retrieve and manipulate data

Performance Criteria:

2.1. Select and access files
2.2. Amend and save files according to requirements
2.3. Produce documents and files that meet organisational needs
2.4. Save files in appropriate directories/folders
2.5. Exit software correctly without loss of data

Element:

3. Access and use help functions within each application

Performance Criteria:

3.1. Identify the help resources available for basic difficulties with the software
3.2. Access user help documentation and other resources for basic difficulties with the software

Element:

4. Use keyboard and equipment

Performance Criteria:

4.1. Follow OH&S standards and regulations to avoid injury or illness
4.2. Use wrist rests and document holders where appropriate
4.3. Use monitor anti-glare and radiation reduction screens where appropriate
4.4. Ensure user equipment is maintained and free from defects that could cause injury


Learning Outcomes



Details of Learning Activities

You will be working in a computer laboratory developing/reinforcing your Word, Excel and Access skills, so that you have all the Office computer skills needed to successfully complete your program and prepare for your professional career.
The total number of scheduled hours of teaching, learning and assessment involved in this course includes all planned activities (face to face workshops, and external visits). It also covers the amount of effort necessary to undertake, evaluate and complete all assessment requirements, observation of work performance, discussions, one on one and group assessment sessions with students.


Teaching Schedule

 

Session
No.
Topic Content Delivery
Including Learning activities
 Performance
 Criteria
Assessment
 task(s)
1Induction; Overview of competency and curriculum units; Overview of Operate computing packages unit (Word, Excel & Access): Part B walk-through of delivery and assessment. Skills survey & Basic Word skills exercise.1.1.-1.3;
2.1-2.5
 
2Keyboard & equipment: OHS intro: Workstation setup; use of wrist rests and document holders; use monitor anti-glare (& rad reduction).
 Word basics (cont): headers & footers, tables, ruler tabs, Superscript & subscript, equation editor, etc.
4.1-4.4
1.1.-1.3;
2.1-2.5
 
3Keyboard & Equipment Multi choice Test (closed book).
Word: Styles, Images, Captions, Table of contents;
(PC 4.1-4.4); 1.1.-1.3;
2.1-2.5
ATN 1: K&E Test: 5% weighting.
4Using Word, Excel & Access Help systems review;
Word: Footnotes, Review, Practice assessment + class correction
3.1 & 3.2
1.1.-1.3;
2.1-2.5
 
5Word test (open book)
Word, Excel & Access Help systems test (closed book)

Excel introduction, screen parts & terminology
1.1.-1.3;
2.1-2.5
3.1 & 3.2
ATN 2: Word Test: 30%
ATN 3: Help test: 5%
6Excel: Basic skills and exercises1.1-1.3
2.1-2.4
 
7 Excel: Basic skills and exercises (cont) 1.1-1.3
2.1-2.4
 
8 Excel: Importing objects, formatting imported objects, creating/modifying charts, formatting charts; Designing, building & maintaining your SS. 1.1-1.3
2.1-2.4
 
9 Excel: Review; practice assessment & class correction 1.1-1.3
2.1-2.4
 
10 Excel test (Open book)
Access: Intro/basics: Terminology & basic concepts; using ribbon, Parts of screen
 1.1-1.3
2.1-2.4
 
 ATN 4: Excel Test: 30%
11 Access: Tables: Designing, creating & modifying tables. 1.1-1.3
2.1-2.4
 
12 Access Forms: creating forms, adding & modifying database records.
Access Queries: retrieving information using tables, simple queries and queries with multiple criteria.
 1.1-1.3
2.1-2.4
 
13 Access Reports: Designing, creating & modifying reports. Distributing reports as required. 1.1-1.3
2.1-2.4
14 Access: Review; practice assessment & class correction. 1.1-1.3
2.1-2.4
 
15 Access test (Open book) 1.1-1.3
2.1-2.4
 ATN 5: Access Test: 30%
    
    
    
    
    
    
    
    


Learning Resources

Prescribed Texts

None. Required resources will be provided.


References


Other Resources

Required resources will be provided.


Overview of Assessment

Evidence of the following is essential:
• Assessment must confirm the ability to produce several workplace documents utilising a minimum of three different computing packages. Learner will demonstrate the use of a wide range of features from each package.


Assessment Tasks

Assessment Task No. (ATN)
ATN 1 – Keyboard & equipment: Multi choice assessment–5%
ATN 2 – Word workplace simulated test (open book) 30%
ATN 3 – Help test (Word, Excel & Access): 5%
#ATN 4 – Excel workplace simulated test (open book) 30%
#ATN 5 – Access workplace simulated test (open book) 30%

# NB: Parts of Excel and Access will be co-delivered and co-assessed with the Computer Applications (1999) unit. (Refer separate Course Guide).

Feedback will be provided throughout the course.

Competency requirements:

To be deemed competent students must satisfactorily demonstrate competence in all elements listed above. Assessment methods have been designed to measure achievement of each competency in a flexible manner over multiple tasks.

Students are advised that they will be asked to demonstrate their competence per class observation, computer laboratory tasks and tests which will be used to assess their competence.

All assessments for this course must be successfully completed to achieve a Competency grade.

Only if unit competency has been satisfactorily achieved will students will be given a competent with grade result, which is the total of the % assessments listed above.


Assessment Matrix

1. Use appropriate software: # ATN 2, 4, 5
1.1 Select software appropriate to perform activity
1.2 Use software to produce required outcome using a range of features related to the activities
1.3 Save documents in appropriate directories/folders

2. Access, retrieve and manipulate data: # ATN 2,4, 5
2.1 Select and access files
2.2 Amend and save files according to requirements
2.3 Produce documents and files that meet organisational needs
2.4 Save files in appropriate directories/folders
2.5 Exit software correctly without loss of data

3. Access and use help functions within each application: ATN 3
3.1 Identify the help resources available for basic difficulties with the software
3.2 Access user help documentation and other resources for basic difficulties with the software

4. Use keyboard and equipment: ATN 1
4.1 Follow OH&S standards and regulations to avoid injury or illness
4.2 Use wrist rests and document holders where appropriate
4.3 Use monitor anti-glare and radiation reduction screens where appropriate
4.4 Ensure user equipment is maintained and free from defects that could cause injury

# NB: Parts of Excel and Access will be co-delivered and co-assessed with the ISYS5415 Computer Applications (1999) unit. (Refer separate Course Guide).

Other Information

Please note: while your teacher will cover all the material in the above schedule, the weekly teaching and assessment order is subject to change depending on class needs and availability of resources.

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 lodgement 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