Course Title: Use advanced features of computer applications

Part B: Course Detail

Teaching Period: Term2 2015

Course Code: OFFC5307C

Course Title: Use advanced features of computer applications

School: 650T Vocational Business Education

Campus: City Campus

Program: C5335 - Diploma of Business (Public Relations)

Course Contact : Sally Parrott

Course Contact Phone: +61 3 9925 5175

Course Contact

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


Course Description

This course covers 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


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


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

Details of Learning Activities

Students will work with at least three computer applications to their full capacity employing all advanced features and import/export capacities for efficiency and productivity purposes, using at least two industry-recognised application packages.

Teaching Schedule

Week 1 - Course Induction
Week 2 - Assessing the needs of the business
Week 3 - Assessing the needs of the business
Week 4 - Software tools, web design platforms and hosting options
Week 5 - Examination of different web software applications available
Week 6 - Introduction to software application. Students will be shown the themes they can work with.
Week 7 - Exploring principles of design
Week 8 - Photoshop training skills to make site graphics

Mid semester break - 31 Aug - 7 Sept

Week 9 - Further development of site graphics
Week 10 - Content development
Week 11 - SEO Introduction and Tips
Week 12 - Further exploration of social media integration including Twitter, Facebook & Instagram
Week 13 - Website Presentations to Client
Week 14 Website Validation & Testing
Week 15 - In class user testing exercise
Week 16 - Assessment Feedback
Week 17 - Any resubmissions due – final date

Learning Resources

Prescribed Texts


Other Resources

Overview of Assessment

Assessment may incorporate a variety of methods including technical requirements documentation, homework, assignments, group and/or individual projects, in class exercises, written and practical assessments, problem solving exercises, presentations, direct observation of actual and simulated work practice, presentation of a portfolio of evidence which may comprise documents, and/or photographs and/or video and audio files, review of products produced through work-based or course activities.

Students are advised that they are likely to be asked to personally demonstrate their assessment work to their teacher to ensure that the relevant competency standards are being met. Students will be provided with feedback throughout the course to check their progress.

Assessment Tasks

Assessment Tasks
Students are required to complete 3 tasks. All tasks must successfully be completed to be deemed competent in this unit.

Assessment Task 1 Requirements Presentation (Due in class Week 5)
In pairs, students will find or be given a real client who needs a basic website for a business or product. Students are then to produce a detailed requirements report to be delivered in class. This presentation will cover the business needs and appropriate recommendations for a new website. The report should detail a client brief, substantial research and analysis as to the market and competitor sites, functionality requirements, hosting and domain name recommendations, a site map, software tool recommendations and project timelines incorporating scope for user feedback and site testing.

Assessment Task 2 Website (Due in class Week 13)
Working in the same pairs, the second assessment will focus on students’ ability to create a valid basic website based on the above requirements report. This project will involve a range of research and technical tasks to be completed using various software tools and computer applications.

Assessment Task 3 User Testing (Due in class Week 15)
Individually students will user test a site of another class member. You will need to examine how the website meets design and functionality specifications, site navigation and functionality, plus branding and copywriting.

*More detailed assessment sheets for each assessment task will be disseminated throughout course delivery.

Assessment Matrix

Other Information

This course is co-delivered with Use Software To Build a Basic Website

Course Overview: Access Course Overview