Course Title: Use advanced features of computer applications

Part B: Course Detail

Teaching Period: Term1 2019

Course Code: OFFC5307C

Course Title: Use advanced features of computer applications

School: 650T Vocational Business Education

Campus: City Campus

Program: C5371 - Diploma of Business (Public Relations)

Course Contact: Julia Makin

Course Contact Phone: +61 3 9925 5175

Course Contact Email: Julia.makin@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

NA

Course Description

This course describes the performance outcomes, skills and knowledge required to use computer applications employing advanced features. It involves manipulating data and accessing support resources to solve routine problems.


National Codes, Titles, Elements and Performance Criteria

National Element Code & Title:

ICAICT308A 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 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 online 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, using troubleshooting results and alert messages

Learning Outcomes


On successful completion of this subjects students will attain the skills use advanced computer applications for the use of a variety of commercial uses.


Details of Learning Activities

This course is structured to provide students with the optimum learning experience. Students will participate in a combination of group and individual learning activities. These activities will be provided through a combination of face to face teacher/student delivery plus classroom work time. Additional learning activities will also be provided to students to complete outside of timetabled class time.


Teaching Schedule

This course is co-delivered and co-assessed with Manage the PR Publication Process - MKTG 6048C, Use Digital Media for Public Relations - MKTG 7882 and Use Development Software and IT Tools to Build a Basic Website - COSC 7356C.

This course is delivered in five 3-hour work shops. All content is available online.

Workshop

Week and Date Commencing

 Content

Federico’s Workshops

Duration: 3 hours

Workshop 1 

Week 1

11/2

Introductions

Workshop 1

Worksheet 1

 

Week 2

18/2

 

 

 

Week 3

25/2

 

 

Workshop 2

Week 4

4/3

Assessment 1 and 2 preparation

How to write for PR

Friday Workshop:

8/3 - 8:30 -11:30am

Labour Day

Week 5

11/3

Online:

Research Relevant Legislation and Protocols

 

 

 

Week 6

18/3

Online:

Research Relevant Legislation and Protocols

Worksheet 2 Due

 

Week 7

25/3

 

 
 

Week 8

1/4

 

Assessments 1 and 2 due (upload - Sunday, 7/4)

Workshop 3

Week 9

8/4

How to create a style guide

Feedback and Writing Workshop

Presentations

Introduction to WordPress

Workshop 3

Worksheet 3

Assessments 1 and 2 due
 

Week 10

15/4

 

 

Easter Break

EASTER BREAK

19/4 - 26/4

 

 
 

Week 11

29/4

 

Assessment 3 due (upload Sunday, 5/5)

Workshop 4

Week 12

6/5

WordPress Workshop

Workshop 4

Assessment 3 due

 

Week 13

13/5

 

 

 

Week 14

20/5

 

Assessment 4 due (upload - Sunday, 26/5)

Workshop 5

Week 15

27/5

Refinements and Presentations

Workshop 5 & Presentation

Assessment 4 due
 

Week 16

3/6

 

Resubmissions 

 

Week 17

10/6

 

Resubmissions due


Learning Resources

Prescribed Texts


References


Other Resources


Overview of Assessment

Overview of Assessment

In order to achieve competency in this unit, you must provide:

Required skills 

  • communication skills to:
  • communicate with supervisors and peers
  • seek assistance and expert advice
  • use online help
  • literacy skills to interpret technical documentation, equipment manuals and specifications
  • planning and organisational skills to prioritise and monitor own work
  • problem-solving skills to solve operational problems as they arise
  • research skills to source support resources to solve routine problems
  • safety awareness skills to work systematically with required attention to detail without injury to self or others, or damage to goods or equipment
  • technical skills to:
  • apply technical support for system problems
  • operate software applications
  • use applications features
  • use online help.

 

Required knowledge 

  • basic knowledge of operating systems software and system tools
  • vendor product directions in computer applications
  • vendor applications and their features.

Assessment Conditions

Critical aspects for assessment and evidence required to demonstrate competency in this unit 

Evidence of the ability to:

  • use at least three computer applications employing advanced features and import and export capacities for efficiency and productivity purposes
  • solve routine problems using support resources.

You are advised that you are likely to be asked to personally demonstrate your assessment work to your teacher to ensure that the relevant competency standards are being met.

Feedback

Feedback will be provided throughout the semester in class and/or online discussions.  You are encouraged to ask and answer questions during class time and online sessions so that you can obtain feedback on your understanding of the concepts and issues being discussed. Finally, you can email or arrange an appointment with your teacher to gain more feedback on your progress.

You should take note of all feedback received and use this information to improve your learning outcomes and final performance in the course.


Assessment Tasks

This course is co-delivered and co-assessed with Manage the PR Publication Process - MKTG 6048C, Use Digital Media for Public Relations - MKTG 7882 and Use Development Software and IT Tools to Build a Basic Website - COSC 7356C.

There are 4 assessment tasks to complete and submit and 3 Worksheets to upload in class.

The assessments are for a project for a real life client and are all interrelated. This means that each assessment is connected to the others.

The Worksheets will be completed during the workshops.

Assessment Task 1

Requirements Report for Website (PR Research brief) with target audience segmentation - Individual

You will develop a requirements report and target audience segmentation based on information acquired from your client.

Assessment Task 2

Planning Document - Individual
This document is including all your planning documentation for assessment 3. You will include drafts, target audience considerations, word lists and planning outlines for press releases (2), an EDM on MailChimp, blog posts (3) and your research for relevant legislation

Assessment Task 3

Portfolio of Work - Individual

This document includes all your publication work, as well as a media list and a small style guide:

  • 1 EDM on MailChimp
  • 2 Press Releases
  • 3 Blog Posts
  • Media List in Google Sheets
  • Small Style Guide

Assessment Task 4

Develop and Test Website - Individual/Group (Testing)
5 pages including a blog with 3 posts with engaging copy.

Worksheet 1

Create Shortcuts and include links for various software packages

Completed in class and to be uploaded on Canvas by the end of class

Worksheet 2

Research relevant legislation and protocols for Press Release, EDM and blog posts

Completed in class and to be uploaded on Canvas by the end of class

Worksheet 3

Create a Small Style Guide

  • user manual/instructions
  • what to do and what to avoid - with
  • recommendations for improvement –
  • peer review and make suggestions on maintenance protocol.
  • Link to online help

Completed in class and to be uploaded on Canvas by the end of class

 


Assessment Matrix

The assessment matrix that maps all the assessment is available on CANVAS.

Other Information

Submission Requirements   You should:

  • Ensure that you submit assessments on or before the due date.  
  • Always retain a copy of your assessment tasks. (hard copy and soft copy)
  • When you submit work for assessment at RMIT University you need to use the Assessment task document that includes a declaration and statement of authorship.
  • Each page of your assessment should include footer with your name, student number, the title of the assessment, unit code and title and page numbers. 

Course Overview: Access Course Overview