Course Title: Use advanced features of computer applications

Part B: Course Detail

Teaching Period: Term1 2012

Course Code: COSC5346C

Course Title: Use advanced features of computer applications

School: 345T Media and Communication

Campus: City Campus

Program: C4197 - Certificate IV in Creative Industries

Course Contact : program Administration - Adam Lovell

Course Contact Phone: 03 9925 4976

Course Contact Email:adam.lovell@rmit.edu.au


Name and Contact Details of All Other Relevant Staff

Nominal Hours: 40

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

This course is assessed with the competencies Operate a Word Processing Application (ICAU1129A) and Identify Physical Database Requirements (ICAB4060A).

Course Description

This course allows students to use a number of computer applications employing advanced features. This course is co-delivered with ICAU1129A and ICAB4060A


National Codes, Titles, Elements and Performance Criteria

National Element Code & Title:

ICAU3126A Use advanced features of computer applications

Element:

1.  Manipulate data

Performance Criteria:

1.1 Employ advanced features of applications in the preparation and presentation of data.
1.2 Efficiently transfer data between applications, linking and embedding related data files as required.
1.3 Create and employ objects, macros and templates for routine activities.
1.4 Use shortcuts and features to increase personal productivity

Element:

2.  Access and use support resources

Performance Criteria:

2.1 Solve routine problems using support resources
2.2 Use on-line help to overcome difficulties with applications
2.3 Solve problems with manuals and training booklets.
2.4 Access and apply technical support for system problems, utilising troubleshooting results and alert messages.

Learning Outcomes


On successful completion of this unit, you will be able to use three computer applications to their full capacity employing advanced features and import/export facilities.


Details of Learning Activities

Learning activities will consist of:-
• demonstrations
• practical exercises
• independent project based work
• class presentations.


Teaching Schedule

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


Week Class Content Other Elements
Week 1 WORD
Email – logging onto RMIT system
Accessing Blackboard
Setting up passwords
Ergonomic principles and practices
General O.H. & S. principles and responsibilities
Establish assessment requirements
Word applications		   ICAU1129A – 1.1-4
Week 2 WORD
Formats, spacing
Purpose of business documents
Layout of business documents
Letters/letterheads		   ICAU1129A 1.1-4,
2.1-6
Week 3 WORD
Business documents – mail merge
using templates
Tabulation		  
Week 4 WORD
Proofreading symbols
Using tabulation		   ICAU1129A
1,1-4
2.1-6
3.1-5
Week 5 WORD
Creating tables, forms and
columns		 Portfolio Exercise 3 - Business documents/Merged documents (25%) ICAU1129A
2.1-6
3.1-5
4.1-4
5.1-2
Week 6 USING POWERPOINT
- page layout
- text enhancements
- using templates		   ICAU3126A
1,1-4
2.1-4
Week 7 POWERPOINT
Using Graphics – Word Art and Clip Art
Leaflets – Combining graphics and text

Developing a slide show		   ICAU3126A
1,1-4
2.1-4
Week 8 POWERPOINT
Developing a slide show		 Newsletter (10%) due ICAU3126A
1,1-4
2.1-4
Week 9 EXCEL
Designing a spreadsheet
Basic formula 		Slideshow Presentation (15%) due ICAU3126A
1,1-4
2.1-4
Week 10 EXCEL
Customising a formula
Creating graphs		   ICAU3126A
1,1-4
2.1-4
Week 11 EXCEL
Class exercises		   ICAU3126A
1,1-4
2.1-4
Week 12 EXCEL
Class exercises		 General Store Superannuation (15%) ICAU3126A
1,1-4
2.1-4

ICAU1129A
1,1-4
2.1-6
3.1-5
4.1-4
5.1-2
6.1-3
7.1-3
Week 13 ACCESS
Designing a database
Purpose
Structure
Relative/absolute formula
Data filters
Creating queries		 Portfolio Ex. 9 – Tennis Club (5%) ICAB4060A – 1, 2
ICAU1129A
1,1-4
2.1-6
3.1-5
Week 14 ACCESS
Customising queries
Designing reports Designing and creating your own database
Class exercises		 Tennis Club /Your own database (15%) ICAB4060A – 1, 2
Week 15 ACCESS
Class exercises		   ICAB4060A – 1, 2
Week 16 Finalise Portfolio documents
TEST		 Integrated Assignment (20 %) ICAB4060A – 3, 4
       


Learning Resources

Prescribed Texts

class handouts


References

You are advised to look at the course Blackboard site for ongoing updated information.


Other Resources

USB storage - memory stick


Overview of Assessment

Assessments  include:

Development of a portfolio of documents demonstrating competence in various software packages.


Assessment Tasks

For further information on the assessments and grading criteria, please refer to the course Blackboard site.

To demonstrate competency in this course, you will need to complete each one of the following pieces of assessment to a satisfactory standard.

PORTFOLIO

Assessment Task No 1
Portfolio Exercises 1 and 2 – Business Documentation 15%
Students are to incorporate student learning of business documentation and ergonomic principles and practices. Due Week 4

Assessment Task No 2
Portfolio Exercise 3 – Merged Documents 10%
Students are to incorporate student learning of mail merge and manipulating data. Due Week 5

Assessment Task No 3
Portfolio Exercise 4 and 5 – Newsletter 10%
Students are to incorporate student learning of text enhancements and page layout. Due Week 8

Assessment Task No 4
Portfolio Exercises 6 - PowerPoint
Slideshow Presentation 15%
Students are to incorporate student learning of PowerPoint and graphical presentation. Due Week 9

Assessment Task No 5
Portfolio Exercises 7 and 8 - Excel
General Store 5%
Superannuation 10%
Students are to incorporate student learning of Excel using basic and customised formula and graphical information. Due Week 11 & 12

Assessment Task No 6
Portfolio Exercises 9 and 10 – Access
Tennis Club Database 5%
Personal Database 10%
Students are to incorporate student learning of Access using basic to advanced data base skills. Due Week 13 & 14

Assessment Task No 7
Integrated Assignment 20%
Students are to incorporate all student learning by submitting a portfolio of the semester’s work and undertaking a final test.
Due week 16


Grades used in this unit are as follows:

80 – 100% HD High Distinction
70 – 79% DI Distinction
60 – 69% CR Credit
50 – 59% PA Pass
Under 50% NN Fail


Assessment Matrix

The assessment matrix demonstrated alignment of assessment tasks with the relevant Unit of Competency. These are available through the course contact in Program administration

Other Information

Special consideration Policy (Late Submission)
All assessment tasks are required to be completed to a satisfactory level. If you are unable to complete any piece of assessment by the due date, you will need to apply for an extension.
Please refer to the following URL for extensions and special consideration:
http://www.rmit.edu.au/browse;ID=qkssnx1c5r0y;STATUS=A;PAGE_AUTHOR=Andrea%20Syers;SECTION=1;

Course Overview: Access Course Overview