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 |
Element: |
2. Access, retrieve and manipulate data |
Performance Criteria: |
2.1. Select and access files |
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 |
Element: |
4. Use keyboard and equipment |
Performance Criteria: |
4.1. Follow OH&S standards and regulations to avoid injury or illness |
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) |
| 1 | Induction; 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 |
|
| 2 | Keyboard & 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 |
|
| 3 | Keyboard & 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. |
| 4 | Using 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 |
|
| 5 | Word 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% |
| 6 | Excel: Basic skills and exercises | 1.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