CLAYDON BROTHERS ICTICT203 Student Assessment Book User Guide
- June 17, 2024
- CLAYDON BROTHERS
Table of Contents
CLAYDON BROTHERS ICTICT203 Student Assessment Book
Product Information
- Specifications
- Product Name: Student Assessment Book ICTICT203 – Operate Application Software Packages (Release 1)
- Author: Claydon Brothers
- Version: 1.0
Product Usage Instructions
- Introduction
- This product is designed to help individuals identify, select, and operate three commercial software packages, including word-processing and spreadsheet applications, within an office environment to produce various documents.
- Learning Outcomes
- Use appropriate workplace health and safety (WHS) office work practices
- Use appropriate word-processing software
- Use appropriate spreadsheet software
- Use a third-application software package
- Assessment Types
- In this unit, you will complete the following assessments:
- Assessment Task 1: Written Assessment
- Assessment Task 2: Portfolio/Practical Activities
- Assessment Task 1: Written Assessment
- Instructions for this task:
- Answer all questions in the space provided.
- You will be required to have a good understanding of the following areas:
- Identify application software packages used by the organization and list the purpose of each.
- Explain basic technical terminology related to reading help files and responding to the system.
- FAQ (Frequently Asked Questions)
- Q: Are there any certification requirements for this unit?
- A: No, there are no licensing, legislative, or certification requirements for this unit at the time of publication.
- Q: How can I order this product?
- A: Please order through the website provided in the document. The product is printed in Australia.
Introduction
- 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.
- No licensing, legislative or certification requirements apply to this unit at the time of publication.
Pre-requisite Unit
- Nil.
Learning Outcomes
- Use appropriate workplace health and safety (WHS) office work practices
- Use appropriate word-processing software
- Use appropriate spreadsheet software
- Use a third-application software package
Assessment types
In this unit, you will complete the following assessments:
- Assessment Task 1: Written Assessment
- Assessment Task 2: Portfolio/ Practical Activities
Assessment Task 1: Written Assessment
Instructions for this task:
- Answer all questions in the space provided.
You will be required to have a good understanding of the following areas:
- 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.
Benchmark
You must get all questions 100% correct and all documentation requested in this assessment is submitted to gain a satisfactory in this task.
Resources required for this assessment task:
You need to have access to the following:
- Pen and Paper
- This Booklet
- Access to learning materials
- Access to the internet
- Access to a PC and word-processing software
Location: Classroom/Computing Lab
Submission
- Submit your responses by the due date and per the general instructions at the beginning of this unit of competency.
- Attach the Assessment Agreement and the Assessment cover sheet for this assessment task.
Questions to respond to.
Q7| Explain how you link different worksheets in Excel
Q8| Explain the basics of ergonomics and how work periods and breaks impact on ergonomics.
Q9| List three input and three output devices
Evidence to submit
Did you submit the following evidence? | Yes | No |
---|---|---|
1 | Answers to Questions 1 – 9 in this task | ☐ |
2 | Answers correctly sourced and referenced if applicable | ☐ |
3 | The handwriting was neat and legible, or word-processed | ☐ |
4 | Cover sheet attached | ☐ |
5 | Assessment Agreement attached | ☐ |
Assessment Task 2: Portfolio/ Practical Activities
Instructions for this task:
- You are to test your ability to operate application software.
- Ask your Assessor to clarify items you are unsure about before commencing. Complete all tasks as
- stated and submitted all work for assessment by the due date.
You will be required to have a good understanding of the following areas:
- 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.
- Note: If a specific volume or frequency is not stated, then evidence must be provided at least once.
Benchmark
- Using the Assessment Matrix below you are to achieve at least a rating of 4 to be deemed satisfactory in this task.
- You must complete all activities in full and you must answer all questions in full.
- You must demonstrate that you can Operate application software packages.
- All criteria listed in the Assessor’s Checklist must be met to the industry standards specified in this unit.
Location: Classroom/computer lab
Resources:
- The Learning Guide
- Internet and PC
- Pen and Paper
Client Brief/Scenario
- Complete all tasks listed below. Submit a soft copy as well as a hard copy of your projects to your
- Teacher for Assessment by the due date specified by your teacher.
- The projects will be marked against the criteria stated in the Marking Guide section.
- Ensure you have read this and covered each criterion in your assignment.
- These activities must be completed in class time.
- Before beginning this task, ensure that there are no loose cables that could cause injury and that your chair and workstation are free from any defects that could cause injury.
Requirements: You are required to produce:
116 | Soda Water | 1 litre | 980 |
---|---|---|---|
117 | Soda Water | litres | 650 |
118 | Bitter Lemon | 600 ml | 688 |
119 | Bitter Lemon | 1 litre | 552 |
Part E: Lucy Livingston, the Accountant, has asked you to set up a spreadsheet to calculate the monthly payroll figures for Administrative and Executive staff. From the following information create a spreadsheet to calculate the November payroll details.
Staff No | Name | Hourly Rate | Hours Worked |
---|---|---|---|
12345 | Henry Fizz | 40.00 | 100 |
12346 | Ron Howard | 35.00 | 140 |
12347 | Colin Firth | 25.00 | 135 |
12348 | Richard Gere | 24.00 | 120 |
12349 | Lucy Livingston | 24.00 | 120 |
12350 | Sally Saunders | 15.00 | 120 |
12351 | Olive Oil | 26.00 | 105 |
Part F:
You will need to work out the gross and net monthly pay for each staff member
using the following tax rates:
- $0 – $5,999 Nil Tax
- $6,000 – $20,999 17%
- $21,000 – $57,999 30%
- $58,000 – $70,000 42%
Student’s Name|
---|---
Name of Assessor|
Unit of Competency| ICTICT203 – Operate application software packages
Assessor’s Signature:|
Date:|
Evidence to submit
Did you submit the following evidence? | Yes | No |
---|---|---|
1 | Letterhead for the company | ☐ |
2 | Template Document | ☐ |
3 | Advertising Leaflet | ☐ |
4 | PowerPoint Presentation | ☐ |
5 | Payroll Spreadsheet | ☐ |
6 | Memo | ☐ |
7 | Table of Contents and Title Page | ☐ |
8 | Letter, mail merge, agenda | ☐ |
9 | Help and OSH Standards Memo | ☐ |
10 | Assessor checklist submitted | ☐ |
11 | Cover sheet attached | ☐ |
Record of Assessment Outcomes
This section records all the evidence used to form the final assessment decision. Please document all types of evidence used in this assessment.
Student Name|
---|---
Unit of Competency| ICTICT203 – Operate application software packages
Assessment Requirements| Task Outcomes
Satisfactory (S)| Not Satisfactory (NS)|
Resubmit
Assessment Task 1: Written Assignment| ☐| ☐| ☐
Assessment Task 2: xxx Portfolio/ Practical Activities| ☐| ☐| ☐
Overall Assessment Outcome
☐ Competent| ☐ Not Yet Competent| ☐ Resubmit
If a resubmission is required what additional evidence or corrections are
required?
Assessor Name:|
Assessors Signature:| | Date|
Appendix 1 – Student Survey
- At the end of each unit, we would like to collect feedback, so we can identify areas for improvement in our materials.
- Circle or highlight the response you wish to use. We would appreciate your assistance in providing your constructive feedback.
- Please complete the survey and return it to Claydon Brothers Pty Ltd by email: sales@claydonbrothers.com.au.
- Thank you for your time.
Qualification code and name|
---|---
Unit code and name| ICTICT203 – Operate application software packages
Date:|
Please read the statements below and circle the most appropriate response:|
Strongly Disagree| Disagree| Neutral| Agree| Strongly Agree
1. The amount of time for the assessment was appropriate.| 1| 2| 3| 4| 5
2. The training and assessment materials for this unit were suitable to my
learning style and easy to use.| 1| 2| 3| 4| 5
3. The content was interesting and engaging.| 1| 2| 3| 4| 5
4. The topics were presented in a logical sequence.| 1| 2| 3| 4| 5
5. The assessment tasks were clear, and it was easy for me to understand what
was required of me.| 1| 2| 3| 4| 5
6. What did you find most interesting or useful about this unit?
7. What, if anything, did you find the least useful about the unit?
8. Please make any constructive suggestions that would improve these materials for future students.
Thank you for providing your valuable feedback. © Claydon Brothers Version 1.0
Document Control
Version | Date | Author | Rationale |
---|---|---|---|
0.1 | Bronwyn Blencowe | Author | |
0.2 | Alan Blencowe | Review by Industry Validator | |
0.3 | Review by Editor | ||
0.4 | Michael Claydon | Final version for sign-off | |
1.0 | Michael Claydon | Issued |
Copyright Information
- © Claydon Brothers Pty Ltd
- 1/1/2021 – Terms of Use
Copying for educational purposes: the Australian Copyright Act 1968 allows a maximum of one chapter or 10% of this booklet, whichever is the greater, to be copied by an educational institution for its educational purposes provided that the educational institution has paid remuneration to the Copyright Agency Limited (CAL) under this Act.
For details on the CAL Licence for educational institutions contact:
- Copyright Agency Limited: Toll-free phone number (landlines only): 1800 066 844
Copying for other purposes: Except as permitted under the Act (fair dealing for purposes of study or research), no part of this booklet may be reproduced in any way, stored in a retrieval system online or hard copy, or transmitted in any form or by any means without prior permission of the copyright owner. For all enquiries/requests, write to the publisher, addressed “Attention: Permissions Coordinator,” at the address below.
- Email: sales@claydonbrothers.com.au.
- www.claydonbrothers.com.au.
- Telephone: +61 0438930162
Disclaimer: Every effort has been made to ensure the accuracy of its
content, but the publishers do not accept any responsibility for any loss,
injury or damage arising from such information. Claydon Brothers Pty Ltd does
not give any warranty nor accept any liability concerning the contents of this
work.
Ordering Information: Please order through the website above. Printed in
Australia.
References
Read User Manual Online (PDF format)
Read User Manual Online (PDF format) >>