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
Teaching Schedule
| Week | Topics | Learning materials and Activities | Assessment 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 |
|
|
|
Week 2 04 March 2020 Blended Learning |
Information Technology, Computer and Network Systems Fundamentals Microsoft Word, Microsoft Excel, and Microsoft Powerpoint |
|
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 |
|
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 |
|
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 |
|
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 |
|
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
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