Course Title: Operate application software packages

Part B: Course Detail

Teaching Period: VE 2020

Class Number: 2274

Class Section: MST1

For flexible terms and optional semesters, a Part B course guide may have been published for the entire teaching period, or for the specific class number in which you are enrolled. If there is no Part B course guide published for your specific class number, please refer to the guide for the teaching period in which you are enrolled. Enrolment Online is the definitive source for details regarding your class enrolment.

Course Code: OFFC5342C

Course Title: Operate application software packages

School: 650T Vocational Business Education

Campus: City Campus

Program: C4403 - Certificate IV in Information Technology

Course Contact: Val Christou

Course Contact Phone: +61 3 9925 5076

Course Contact Email: val.christou@rmit.edu.au


Name and Contact Details of All Other Relevant Staff

Course Leader: Aminul Islam

Email: aminul.islam@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 describes the skills and knowledge required to identify, select and operate three commercial software packages, including a word-processing and a spreadsheet application package.

It applies to individuals who utilise different software applications within a small to large office environment to produce diverse documents.


National Codes, Titles, Elements and Performance Criteria

National Element Code & Title:

ICTICT203 Operate application software packages

Element:

1. Use appropriate workplace health and safety (WHS) office work practices

Performance Criteria:

1.1 Use safe work practices to ensure ergonomic, work organisation, energy and resource conservation requirements are addressed

1.2 Use wrist rests and document holders where appropriate

1.3 Use monitor anti-glare and radiation reduction screens where appropriate

Element:

2. Use appropriate word-processing software

Performance Criteria:

2.1 Select word-processing software appropriate to perform activity

2.2 Identify document purpose, audience and presentation requirements, and clarify with personnel as required

2.3 Identify organisational requirements for text-based business documents, and design document structure and layout to ensure consistency of style and image

2.4 Match document requirements with software functions to provide efficient production of documents

2.5 Use technical functions, other data and formatting to finalise documents

2.6 Ensure the naming and storing of documents in appropriate directories or folders and the printing of documents to the required specifications

Element:

3. Use appropriate spreadsheet software

Performance Criteria:

3.1 Select spreadsheet software appropriate to perform activity

3.2 Identify document purpose, audience and presentation requirements, and clarify with personnel as required

3.3 Enter simple formulas and functions using cell referencing where required

3.4 Customise spreadsheet settings to meet requirements

3.5 Ensure the naming and storing of documents in appropriate directories or folders and the printing of documents to the required specifications

Element:

4. Use a third application software package

Performance Criteria:

4.1 Select software application package appropriate to perform activity

4.2 Identify purpose, audience and presentation requirements, and clarify with personnel as required

4.3 Use technical functions, other data and formatting to finalise documents

4.4 Ensure documents are named and stored in appropriate directories or folders and printed to required specifications


Learning Outcomes



Details of Learning Activities

A range of learning activities are planned for this course on a variety of topics as shown in the teaching schedule.   This may include self-paced and collaborative classroom activities such as:  

  • Practice exercises
  • Challenges 
  • Problem solving
  • Project work
  • Quizzes
  • Discussion
  We expect you to participate and contribute in all scheduled learning activities as each week builds on the next.


Teaching Schedule

WeekTopicsLearning materials and ActivitiesAssessment Tasks 

Week 1

26 February 2020

Face-to-Face Learning

 

Introduction to Online Learning and Testing - Canvas, GMetrix and Certiport

Introduction to MOS and MTA Exams

Information Technology  Computer and Network Systems Fundamentals

Microsoft Word, Microsoft Excel, and Microsoft Powerpoint

 
  • Exploring course schedules and discussion
  • MOS and MTA Exam discussions
  • Create Student Accounts for Online Learning and Testing
  • MOS Practice Exercises
  • Discussion - Assessment Tasks
 
 

Week 2

04 March 2020

Blended Learning

 

Information Technology,   Computer and Network Systems Fundamentals

Microsoft Word, Microsoft Excel, and Microsoft Powerpoint

 
  • MOS and MTA Exam discussions
  • Microsoft Word Exercises
  • MOS Practice Test
  • Work on Assessment Task1
 

Assessment Task1

Due Date :

08 March 2020

 

Week 3

11 March 2020

Face-to-Face Learning

 

Information Technology,   Computer and Network Systems Fundamentals

Microsoft Word, Microsoft Excel, and Microsoft Powerpoint

 
  • MOS and MTA Exam discussions
  • Microsoft Word and Excel Exercises
  • MOS Practice Test
  • Work on Assessment Task2
 

Assessment Task2

Due Date :

15 March 2020

 

Week 4

18 March 2020

Blended Learning

 

Information Technology,   Computer and Network Systems Fundamentals

Microsoft Word, Microsoft Excel, and Microsoft Powerpoint

 
  • MOS and MTA Exam discussions
  • Microsoft Excel and Powerpoint Exercises
  • MOS Practice Test
  • Work on Assessment Task3
 

Assessment Task3

Due Date :

22 March 2020

 

Week 5

25 March 2020

Face-to-Face Learning

 

Information Technology,   Computer and Network Systems Fundamentals

Microsoft Word, Microsoft Excel, and Microsoft Powerpoint

 
  • MOS and MTA Exam discussions
  • Microsoft Excel and Powerpoint Exercises
  • MOS Practice Test
  • Work on Assessment Task4
 

Assessment Task4

Due Date :

29 March 2020

 

Week 6

01 April 2020

Blended Learning

 

Information Technology,   Computer and Network Systems Fundamentals

Microsoft Word, Microsoft Excel, and Microsoft Powerpoint

 
  • MOS and MTA Exam discussions
  • Review Exercises - Microsoft Word, Excel and Powerpoint
  • MOS Practice Test
  • Work on Assessment Task5

Assessment Task5

Due Date :

05 April 2020


Learning Resources

Prescribed Texts


References


Other Resources

You will need a desktop computer or a laptop to work on learning activities and assessment tasks outside the classroom.   You may also refer to various media, websites, textbooks and e-books as indicated in Canvas or advised by your class Teacher.


Overview of Assessment

To achieve competency in this unit you are required to satisfactorily complete a number of assessment tasks.

Performance Evidence

Evidence of the ability to:

  • produce workplace documents using a minimum of three different software application packages
  • open, amend and save files and documents according to organisational requirements
  • apply workplace health and safety (WHS) principles and responsibilities for ergonomics, such as work periods and breaks
  • use help manuals and online help.

Knowledge Evidence

To complete the unit requirements safely and effectively, the individual must:

  • identify application software packages used by the organisation and list the purpose of each
  • explain basic technical terminology related to reading help files and responding to system help prompts
  • outline current business practices related to using software to prepare reports
  • list features and functions of commercial computing packages
  • describe import and export software functions
  • describe the process of linking documents
  • outline WHS principles and responsibilities for ergonomics, such as work periods and breaks
  • explain the purpose of input and output devices.

Assessment Conditions

Gather evidence to demonstrate consistent performance in conditions that are safe and replicate the workplace. Noise levels, production flow, interruptions and time variances must be typical of those experienced in the general information and communications technology (ICT) industry, and include access to:

  • a personal computer (PC) and printer
  • software currently used in industry
  • documents detailing organisational style guide and policy
  • documents or information containing data suitable for developing software application documents.

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

Assessment Task1 - Input and Output Devices

This short-answer assessment task is the first of five assessment tasks you need to complete satisfactorily, in order to be deemed competent for this unit. 

This assessment task allows you to demonstrate your knowledge on identifying, selecting and operating commercial software packages, including a word-processing and a spreadsheet application package.

 

Assessment Task2 - Microsoft Office Word

This product assessment task is the second of five assessment tasks you need to complete satisfactorily, in order to be deemed competent for this unit. 

This assessment will allow you to demonstrate your ability to use word processing software to produce a series of word documents.

 

Assessment Task3 - Microsoft Office Excel

This product assessment task is the third of five assessment tasks you need to complete satisfactorily, in order to be deemed competent for this unit.

This assessment will allow you to demonstrate your ability to use spreadsheet software to produce a series of spreadsheet documents.

 

Assessment Task4 - Microsoft Office Powerpoint

This product assessment task is the fourth of five assessment tasks you need to complete satisfactorily, in order to be deemed competent for this unit. 

This assessment will allow you to demonstrate your ability to use presentation software to create a PowerPoint Presentation that includes a linked spreadsheet.

 

Assessment Task5 - Ergonomics

This practical assessment task is the final of five assessment tasks you need to complete satisfactorily, in order to be deemed competent for this unit. 

his practical assessment will allow you to demonstrate your ability to set up an ergonomic computer-based workstation and adjust the energy conservation settings on your computer

 


Assessment Matrix

Element

Performance criteria

 

 

 

 

 

 

 

Assessment

Task 1: Input & Output Devices

Assessment

Task 2: Letter and Brochure

Assessment

Task 3: Excel

Assessment

Task 4: PowerPoint

Assessment

Task 5:Work Station

1. Use appropriate workplace health and safety (WHS) office work practices

1.1 Use safe work practices to ensure ergonomic, work organisation, energy and resource conservation requirements are addressed

 

 

 

 

Part 1,

Part 2, Q1, Q2, Q3

1.2 Use wrist rests and document holders where appropriate

 

 

 

 

Part 1

1.3 Use monitor anti-glare and radiation reduction screens where appropriate

 

 

 

 

Part 1

2. Use appropriate word-processing software

2.1 Select word-processing software appropriate to perform activity

Q3, Q4

Part 1,

Part 2

Part 1

 

 

2.2 Identify document purpose, audience and presentation requirements, and clarify with personnel as required

Q14

Part 1,

Part 2

Part 1

Part 1

 

2.3 Identify organisational requirements for text-based business documents, and design document structure and layout to ensure consistency of style and image

Q14, Q15, Q16, Q17, Q18

Part 1,

Part 2

Part 1

 

 

2.4 Match document requirements with software functions to provide efficient production of documents

Q4, Q20

Part 1,

Part 2

Part 1

 

 

2.5 Use technical functions, other data and formatting to finalise documents

Q8, Q9, Q10, Q11, Q19

Part 1,

Part 2

Part 1

 

 

2.6 Ensure the naming and storing of documents in appropriate directories or folders and the printing of documents to the required specifications

 

 

 

 

 

Q5, Q10, Q12, Q13

Part 1,

Part 2

Part 1

 

 

3. Use appropriate spreadsheet software

3.1 Select spreadsheet software appropriate to perform activity

Q3, Q4

 

Part 1

 

 

3.2 Identify document purpose, audience and presentation requirements, and clarify with personnel as required

Q14

Part 1,

Part 2

Part 1

Part 1

 

3.3 Enter simple formulas and functions using cell referencing where required

 

 

Part 1

 

 

3.4 Customise spreadsheet settings to meet requirements

 

 

Part 1

 

 

3.5 Ensure the naming and storing of documents in appropriate directories or folders and the printing of documents to the required specifications

Q5, Q10, Q12, Q13

 

Part 1

 

 

4. Use a third application software package

4.1 Select software application package appropriate to perform activity

Q3, Q4

 

 

Part 1

 

4.2 Identify purpose, audience and presentation requirements, and clarify with personnel as required

Q14

 

 

Part 1

 

4.3 Use technical functions, other data and formatting to finalise documents

Q9

 

 

Part 1

 

4.4 Ensure documents are named and stored in appropriate directories or folders and printed to required specifications

Q5, Q10, Q12, Q13

 

 

Part 1

 

Other Information

Submission Requirements

You should:

  • Ensure that you submit assessments on or before the due date via CANVAS.
  • 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 a cover sheet that includes a declaration and statement of authorship. You must complete, sign and submit a cover sheet with all work you submit for assessment, whether individual or group work. On the cover sheet you declare that the work you are presenting for assessment is your own work.
  • 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. For example, Julie Macpherson, 324567, Task 2, OHS2345C Ensure safe workplace, Page 1 of 10.
  • Projects must be submitted via Canvas.

Late Submission Procedures

You are required to submit assessment items and/or ensure performance-based assessment is completed by the due dates. 
If you are prevented from submitting an assessment item on time, by circumstances outside your control, you may apply in advance to your teacher for an extension to the due date of up to seven calendar days.

More Information: https://www.rmit.edu.au/students/student-essentials/assessment-and-exams/assessment/extensions-of-time-for-submission-of-assessable-work
Form to use: http://mams.rmit.edu.au/seca86tti4g4z.pdf

Special Consideration Procedures

Where an extension of greater than seven days is needed, you must apply for special consideration. Applications for special consideration must be submitted no later than two working days after the assessment task deadline or scheduled examination

More Information: https://www.rmit.edu.au/students/student-essentials/assessment-and-exams/assessment/special-consideration
Online special consideration link: https://specon.rmit.edu.au/specon/

Re-submissions

If you are found to be unsuccessful in a Course Assessment Task, you will be allowed one re-submission only. Your teacher will provide feedback regarding what you need to do to improve and will set a new deadline for the re-submission. 

If you are still not meeting the assessment requirements you must apply to your Program Manager in writing outlining the steps you will take to demonstrate competence in your course. Your submission will be considered by the Program Team and you will be advised of the outcome as soon as possible.

Adjustments to Assessment

In certain circumstances students may be eligible for an assessment adjustment. For more information about the circumstances under which the assessment arrangements might be granted please access the following website.

More Information: https://www.rmit.edu.au/students/student-essentials/assessment-and-exams/assessment/adjustments-to-assessment

Marking Guide (Courses delivered in accordance with competency-based assessment):

You must demonstrate that you have all the required skills/knowledge/elements in the unit of competency you are studying. You will receive feedback on each assessment task that will inform you about your progress and how well you are performing.

CA       Competency Achieved

NYC    Not Yet Competent

DNS    Did Not Submit for assessment

Course Overview: Access Course Overview