Course Title: Operate computing packages
Part B: Course Detail
Teaching Period: Term2 2011
Course Code: COSC5417C
Course Title: Operate computing packages
School: 130T Engineering (TAFE)
Campus: City Campus
Program: C6069 - Advanced Diploma of Engineering Technology
Course Contact : Program Manager
Course Contact Phone: +61 3 9925 4468
Course Contact Email:firstname.lastname@example.org
Name and Contact Details of All Other Relevant Staff
Co-ordinator: Leon Mattatia
Phone 9925 4668
Teacher: Mark Burns
Telephone: 9925 4604; Fax: 9925 4377;
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
There may be benefit in concurrent learning with the following units:
• ICAU2005A Operate computer hardware
• ICAU2231A Use computer operating system. (or equivalent)
This unit defines the competency required to identify, select and correctly operate three desktop applications for a
range of purposes.
This unit encompasses the following three units:
• ICAU1129A Operate a word processing application
• ICAU1130A Operate a spreadsheet application
• ICAU1131A Operate a database application.
National Codes, Titles, Elements and Performance Criteria
National Element Code & Title:
ICAU2006A Operate computing packages
1. Use appropriate software
1.1 Select software appropriate to perform activity
2. Access, retrieve and manipulate data
2.1 Select and access files
3. Access and use help functions within each application
3.1 Identify the help resources available for basic difficulties with the software
4. Use keyboard and equipment
4.1 Follow OH&S standards and regulations to avoid injury or illness
• OH&S principles and responsibilities
• basic understanding of system usage
• basic technical terminology in relation to reading help files and responding to system help prompts
• personal computer access and logon procedures.
• basic analysis of desktop layout, monitor and chair positioning, keyboard techniques and use of the mouse
• basic problem solving in application management and help function usage
• reading and writing at a level where basic workplace documents are understood
• clear and precise communication
• interpretation of user manuals
Details of Learning Activities
You will be working in a computer laboratory developing/reinforcing your Word, Excel and Access skills, Help and Safe working 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 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.
Session No. Topic PC=Performance Criteria
1 Overview of cluster units; detailed review of Operate computing packages unit (Word, Excel & Access): Course Guide review;
Word self assessment; basics review & practice: Recreate exactly.doc exercise and class review. PC 1.1.-1.3; 2.1-2.5
2 Word basics (cont): headers & footers, tables, ruler tabs, equation editor, etc. Superscript & subscript exercise; Equation Editor Exercise. PC 1.1.-1.3; 2.1-2.5
3 Word: Styles, Images, Captions, Table of contents, PC 1.1.-1.3; 2.1-2.5
4 Word: Practice test and class correction. Switch between several open documents, print preview. PC 2.1-2.5; Keyboard & equipment: OHS intro: Workstation setup; use of wrist rests and document holders; use monitor anti-glare (& rad reduction: if appropriate)
5 Word test PC 1.1.-1.3; 2.1-2.5; Keyboard & equipment multi choice test. (PC 4.1-4.4)
6 Excel: Intro/basics: Terminology & concepts; Using toolbars, Creating basic spreadsheets. defining cell types, simple formulas with cell referencing, autofill, common functions (Sum, Average, Count, Max, Min), handling common formula errors, using manual and Auto Format, copying formatting features, closing & saving SS to disk folder; PC 1.1-1.3, 2.1-2.4, 3.1-3.2
7 Excel: Setting print area, adjusting page layout, margins, headers & footers, print preview, print part/all worksheet; relative & fixed formulas, useful functions (countif, vlookup, if, etc), locating lookup tables PC1.1-1.3; 2.1-2.4; 3.1-3.2
Using variable/range names, Viewing multiple spreadsheets concurrently, saving ss in another format
8 Excel: Importing objects, formatting imported objects, creating/modifying charts, formatting charts. Designing, building & maintaining your SS. Review 1.1-1.3; 2.1-2.4; 3.1-3.2
9 Excel: Review & practice assessment. help system:
10 Excel test. Help system: Using Word, Excel & Access Help systems practice. PC 1.1-1.3; 2.1-2.5
11 Access: Intro/basics: Terminology & concepts; Using toolbars, creating & modifying tables, creating primary key, creating fields and attributes, creating table relationships, adding & modifying data, adding & deleting records. 1.1-1.3; 2.1-2.4; Help test. (PC 3.1, 3.2)
12 Access: Adjusting page layout, changing fonts for database data entries, creating forms, add & modify database records. 1.1-1.3; 2.1-2.4; 3.1-3.2
13 Access: retrieve information using tables, simple queries and queries with multiple criteria. Access Design, create & modify reports. Distribute reports as required. PC 1.1-1.3; 2.1-2.4; 3.1-3.2
14 Access: Review & practice assessment. (1.1-1.3; 2.1-2.5)
15 Access: Assessment test (1.1-1.3; 2.1-2.5)
Notes and exercises will be provided.
Overview of Assessment
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.
Evidence of student’s competence can be gathered through a variety of ways including:
• observation of processes and procedures;
• oral and/or written questioning on required knowledge and skills;
• testimony from supervisors, colleagues, clients and/or other appropriate
• inspection of the final product or outcome;
• a portfolio of documentary evidence.
Graded Assessment out of 100 Marks will be based on the results obtained for Assignments, Practical Reports & Unit Tests.
Students must gain a pass in ALL forms of assessment in order to gain this competency.
Assessment Task No. (ATN)
ATN 1 – Word workplace simulated test (open book) 30%
ATN 2 – Keyboard & equipment: Multi choice assessment–5%
#ATN 3 – Excel workplace simulated test (open book) 30%
#ATN 4 – Access workplace simulated test (open book) 30%
ATN 5 – Help test (Word, Excel & Access): 5%
Only the assessments listed above contribute to the final result for this course.
# Parts of this assessment is used to assess Computer Applications (1999).
1. ICAU2006A/01 Use appropriate software (ATN 1+3+4)
- 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.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.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.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
Course Overview: Access Course Overview