Student Name
|
|
Student Number
|
|
Unit Code/s & Name/s
|
BSBITU402 – Develop and use complex spreadsheets
|
Assessment Type
|
☐ Case Study ☒ Assignment ☐ Project ☐ Other
(specify)
|
Assessment Name
|
Assessment 1
|
Assessment Task No.
|
Task 1 of 3
|
Assessment Due Date
|
As per Unit Study Guide
|
Date submitted
|
|
Assessor Name
|
As per Teacher page in Connect
|
Student Declaration:
I declare that this assessment is my own work. Any ideas and comments made by other people have been acknowledged as references. I understand that if this statement is found to be false, it will be regarded as misconduct and will be subject to disciplinary action as outlined in the TAFE Queensland Student Rules. I understand that by emailing or submitting this assessment electronically, I agree to this Declaration in lieu of a written signature.
|
Student Signature
|
|
Date
|
|
PRIVACY DISCLAIMER:
TAFE Queensland is collecting your personal information for assessment purposes. The information will only be accessed by authorised employees of TAFE Queensland. Some of this information may be given to the Australian Skills Quality Authority (ASQA) or its successor and/or TAFE Queensland for audit and/or reporting purposes. Your information will not be given to any other person or agency unless you have given us written permission or we are required by law.
|
|
|
|
|
|
|
Instructions to Student
|
General Instructions:
Students must sign the form and complete Part A and Part B of the question paper:
Part A:
Safe Work Practices form -
form/checklist which is to confirm your use of correct ergonomics and work practices while at your computer workstation, you must also complete questions at the end of the form.
Part B:
Required Knowledge Questions
Follow all instructions provided and proofread your work carefully before submitting Part A and Part B.
Information / Materials provided:
This assessment paper, Safe work Practices form.
Access to the workbook and any notes is allowed. It is not a timed assessment.
Assessment Criteria:
To achieve a satisfactory result, your assessor will be looking for your ability to demonstrate the following key skills/tasks/knowledge to an acceptable industry standard:
- Completion of the Safe Work Practices form to confirm your use of correct ergonomics and safe work practices whilst at your workstation
- Explain how you can follow energy and resource conservation techniques.
- Explain how you can reduce Occupational Overuse Syndrom (OOS) at your workstation
- Describe the impact of formatting and design on presentation and readability of spreadsheet data.
- Use manuals, user documentation and online help to answer questions and resolve issues.
Number of Attempts:
You will receive up to two (2) attempts at this assessment task. Should your 1st
attempt be unsatisfactory (U), your teacher will provide feedback and discuss the relevant sections / questions with you and will arrange a due date for the submission of your 2nd
attempt. If your 2nd
submission is unsatisfactory (U), or you fail to submit a 2nd
attempt, you will receive an overall unsatisfactory result for this assessment task. Only one re-assessment attempt may be granted for each assessment task.
For more information, refer to the Student Rules.
|
Submission details
|
Insert your details on page 1 and sign the Student Declaration. Include this template with your submission.
Access the information in Connect for your Due Date.
This assessment is to be completed, either typewritten (preferred) or written in black pen and scanned and then uploaded to Connect.
Assessment to be submitted via
|
Instructions for the Assessor
|
· Students to complete both Part A (which includes a self assessment of the work environment) and Part B of the assessment.
· All work to be completed by word processor or handwritten and scanned.
· Assessment documents to be uploaded to Connect for marking.
· This is an untimed assessment.
· Students are allowed access to any notes, workbooks and the internet to complete the assessment.
· Please refer to marking guide to ensure consistency, validity and fairness of student outcomes.
|
Note to Student
|
An overview of all Assessment Tasks relevant to this unit is located in the Unit Study Guide.
|
PART A:
SAFE WORK PRACTICES – BSBITU402
NAME OF STUDENT:
DATE COMPLETED:
Mark an ‘X’ in the boxes to confirm your use of correct ergonomics and work practices while at your computer workstation.
If you don’t mark an X in the box, please advise why you are not able do so.
(Cross = Yes, Blank = No).
☐
1. Screen distance should be 40-90 cm from your eyes, an arm’s length distance.
☐ 2. Top of viewing point should be just below eye level.
☐ 3. Arms should form a right angle – hanging
straight from the shoulder.
☐ 4. Adjust the height of the backrest until it
fits into the curve of your back.
☐ 5. Sit well into the chair so that you are supported forward by the backrest.
☐ 6. Adjust the chair height so that your thighs are parallel to the floor.
☐ 7. Feet should be flat on floor. If your feet cannot touch the ground use a footstool.
Please read the OH&S Resource in the Contents Section in Connect
Answer the following questions
:
Describe two ways you could reduce the risk of Occupational Overuse Syndrome (OOS) at your workstation?
·
·
List two ways you could waste less paper in your workplace or study environment?
·
·
Describe two ways you could conserve energy in your workplace or study environment?
·
·
PART B
The key to good spreadsheet performance is to get the initial design right.
Describe
the impact of formatting and design on presentation and readability of spreadsheet data (approximately 100 words).
·
Use manuals, user documentation and online help to look up the following topics below:
Explain what the PMT function is and when you would use it.
·
How would you
split
the screen so you could view the top and the lower part of a worksheet? Provide a simple list of steps required in order to do this task.
·