TAE40116 Cert IV Assessment: BSBITU212 Create and Use Spreadsheets

This assignment solution demonstrates the planning and execution of assessment tasks for the unit BSBITU212 - Create and Use Spreadsheets, part of the TAE40116 Certificate IV in Training and Assessment. It includes an assessment plan detailing the purpose, target group, context, and specific needs of the cohort, as well as the personnel involved. The assessment plan outlines various assessment methods such as written tests, practical tasks, and group discussions. It also includes assessment instructions and instruments for candidates, including a written assessment, a practical task involving spreadsheet setup, and a group discussion. The document provides detailed instructions, resource requirements, and safety considerations for each assessment task, along with guidelines for assessors and information on resubmission and reasonable adjustments. The assessment aims to evaluate the student's ability to create and use spreadsheets and charts effectively, both in cloud-based and non-cloud-based environments.

Certificate IV in Training and Assessment
TAE40116 – UPGRADE ASSESSMENT

UNITS OF COMPETENCY
TAEASS502Design and develop assessment tools
TAEASS401Plan assessment activities and processes
Assessment Task 3 – Assessment Booklet

Assessment Task 2
In this task, you are required to plan and organise assessment processes for three units of competency.
This assessment template resembles one assessment tool for one unit of competency. You are to duplicate this
booklet three times.
You will need to engage a qualified colleague who has a TAE qualification or has vocational expertise in the
relevant area to provide feedback to you on your training and assessment plan.
There are clear instructions throughout this resource and if at any time you have questions please do not hesitate
to contact your trainer/assessor.
Step 1 - Assessment Plan
You are required to develop an assessment plan for three different units of competency (one in this resource).
The assessment plan template is to be used for each of the threetraining and assessing environment assessment
plans and must be completed using a different unit of competency for each.
You are welcome to use your own templates if you wish. It is your responsibility to ensure your templates provide
all the information required.
Assessment Templates | TAE Training Academy | Page 2

ASSESSMENT PLAN
Unit name and code BSBITU212 Create and use spreadsheets
Purpose of the assessment This unit describes the skills and knowledge required to
correctly create and use spreadsheets and charts using both
cloud-based and non-cloud based spreadsheet applications.
It applies to individuals who perform a range of routine tasks in
the workplace using a limited range of practical skills and
fundamental knowledge of spreadsheet software/applications
in a defined context under direct supervision or with limited
individual responsibility.
Target group VET Students completing a course that this unit is part of
Context of assessment Training and Assessment Environment
Written and practical components assessment classroom
based
Specific needs of the cohort/individual being
assessed
All students completed an LLN prior to their enrolment
Any other special needs will be assisted as required
Personnel involved in the assessment
process?
Narelle Ward
Assessment information and evidence requirements
Assessment methods
Assessment instruments required for
each method
Unit requirements
this meets (PC1.2,
PE2, KE4 etc.)
1 Written test
Written questions
Instructions for candidate
Marking guide for assessor
See mapping at end
of document
2
Practical Tasks
Instructions
Company Policy & Procedures
Observation Check list
See mapping at end
of document
3 Group Discussion/Question Discussion/Question Guideline for the
assessor
Observation Checklist
See mapping at end
of document
Resources
Specialist support (if applicable/required) Integration Aids are available if required
Any tools or equipment required for
assessment
Desk, chair, computer
Any materials required for assessment Company policy and procedures folder
Any other resources required for assessment
(for example, supporting documentation)
Computer manual
Assessment Templates | TAE Training Academy | Page 3

Any human resources required for assessment
(for example, other workplace personnel,
clients/customers etc.)
Not required for this unit
Assessment arrangements
Timeline for assessment – when will each item
be assessed?
All 3 assessments will be completed within the delivery of the
unit
How long will be given to each assessment? Written Assessment 30 mins
Practical Assessment 1 hour
Group Discussion 30 mins
Is integration of activities possible? The group discussion will lead into the practical assessment
Assessment arrangements continued
Work health and safety issues that may
impact on assessment activities being
conducted
No obvious health and safety issues are foreseen for this
assessment plan. It is expected that students will have a safe
environment at all times.
A sight safety assessment will be made as part of the group
discussion assessment
Privacy/confidentiality issues that may impact
on assessment activities/portfolios submitted
None at this stage as they will be handed to the assessor
directly
Any other issues that may impact on
assessment activities (for example,
sustainability)?
The practical assessment will be rescheduled if there is power
shortage
Any reasonable adjustments identified? Students may need additional time for assessments and this is
available if required
Where will assessment outcomes be
recorded?
A student record summary is used for recording all outcomes
and any feedback. A copy of this will be emailed to all student
Date of each assessment to be
submitted/conducted
All assessments are to be submitted and conducted with the
time allocated for the unit
Assessment Templates | TAE Training Academy | Page 4

Step 2 - Assessment Instructionsand Instruments
You are required to develop a complete assessment tool for the unit of competency indicated in the assessment
plan you have developed in the previous step.
Templates for the assessment tasks and methods are includedfor you to use if you wish. Noteyou are required to
use a range of assessment methods throughout your assessment plans (x3).
Assessments methods suitable to VET are listed on the following ASQA fact sheet:
https://www.asqa.gov.au/sites/g/files/net3521/f/Guide_to_developing_assessment_tools.pdf
Delete any templates you don’t use. Create your own or use any other templates as you wish.
You are required to complete (in most cases) at least two instruments for each assessment method chosen. For
instance; a written test for candidates to complete and a written test with answers for the assessor.
You must create at least one of your own assessment instruments per assessment plan. Other existing
instruments can be usedif suitable (acknowledge the source) and must be contextualised to suit your assessment
plan/context.
Assessment Templates | TAE Training Academy | Page 5

DEVELOP THE ASSESSMENT - Assessment Task Instructions
Note: When completing the following assessment questions,don’t forget to complete your mapping document.
ASSESSMENT TASK INSTRUCTIONS
Unit code and title BSBITU212 Create and use spreadsheets
Workplace/Location Classroom/ Simulated office environment
Purpose of assessment This unit describes the skills and knowledge required to correctly create and use
spreadsheets and charts using both cloud-based and non-cloud based
spreadsheet applications.
It applies to individuals who perform a range of routine tasks in the workplace
using a limited range of practical skills and fundamental knowledge of
spreadsheet software/applications in a defined context under direct supervision
or with limited individual responsibility.
Context of assessment Training and Assessment Environment
Written, Oral and Practical components assessment, classroom based
Resources required for
assessment
Assessment Task 1
Pen and Assessment Paperwork
Assessment Task 2
PC loaded with Microsoft
Printer
Room set up in a simulated office environment
Company Policy and Procedures
Assessment Task 3
Assessors guideline notes
Safety considerations Students are made aware of any hazards as part of the safety brief at the start
of the training.
Students are working under supervision at all times
Instructions to the candidate: Assessment Task 1
This assessment is a written assessment made up of 10 questions
You are to read the question and write the answer in the space
provided
This is a closed book assessment
This assessment is completed in the training room in no longer
than 30mins.
Resources Required
 Pen
 Written Assessment Document
 Desk, chair
Assessment Templates | TAE Training Academy | Page 6

ASSESSMENT TASK INSTRUCTIONS
Assessment Task 1
This assessment is a written assessment made up of 20 questions
You are to read the question and write the answer in the space
provided
This is a closed book assessment
This assessment is completed in the training room in no longer
than 40mins.
Resources Required
• Pen
• Written Assessment Document
• Desk, chair
Assessment Task 2
The assessment of this task is, you are required to read the SOP
for the computer and set up the excel spreadsheet as per the
instructions given. At the end of each stage you are to save and
submit your results, there are 3 stages to the instruction
regarding outcomes required for the assessment.
Resources Required
Instructions for the computer
Computer
Desk and Chair
Network availability
Assessment Task 3
Assessment task 3 will be preformed as a group and will be based
around group input to discussions on working with excel
spreadsheets, outcomes and troubleshooting
Conditions of Assessment
You must complete all assessment tasks
Assessment must be conducted in a safe environment where
evidence gathered demonstrates consistent performance of
typical activities experienced in the general administration field of
work and include access to:
• operational manuals
• organisational procedures related to operation and
maintenance of equipment
• records relating to resources
• case studies and, where possible, real situations.
You will be provided feedback on your performance by your
Assessment Templates | TAE Training Academy | Page 7

ASSESSMENT TASK INSTRUCTIONS
assessor.
The feedback will indicate if you have satisfactorily the
requirements for each task or not satisfactorily met the
requirements, the assessor will also clarify the tasks you must re-
attempt at a later date to demonstrat a satisfactory performance.
You have the right to appeal the outcome of the assessment
decisions if you feel you be treated unfairly or have other grounds
for appeal.
What needs to be submitted? Assessment Task 1
Responses to written questions
Assessment Task 2
A document as per the computer task document is saved in 3 stages to show
the process has been completed correctly
Assessment Task 3
Nothing to be submittred a group discussion task, the assessor will note your
involvement
Resubmission For the assessment to be deemed satisfactory, your responses to the written
questions must be correct. If not 100% correct you may be asked to complete a
further task to demonstrate competency
Reasonable adjustments
(assessor to indicate possible
adjustments):
If you have any learning issues that may negatively impact you when attempting
any part of the assessment contact your trainer.
If you have any questions or require clarifications contact your trainer.
Assessor name Narelle Ward Date 27/02/2019
Assessor signature
Assessment Templates | TAE Training Academy | Page 8

Role Play/Scenario/Observation Task Template
ROLE PLAY / SCENARIO/OBSERVATION TASK
Instructions to the candidate:
In this assessment task the students have been asked to use their knowledge and skills to create and
use spreadsheets and charts for both cloud-based and non-cloud based spreadsheet applications.
Students are asked to set their computer system in accordance with proper practices that they
learned previously by using a computer for creating spreadsheets to carry out rouine tasks.
The important resources that are required to perform the task are :-
1. PC and Microsoft spreadsheet
2. Student network on computer
3. Cloud-based and non-cloud based applications
4. Charts and spreadsheets
5. A room with computer providing facilities
6. Access to internet
7. Chairs and tables
8. Printer
9. Company rules and regulatgion
Task.1 this assessment comprises of 10 questions. Students are asked to read and write the
answers. It is closed book assessment.
Students are required to read the questions properly and answer in their respective assessment
document.
They are requited to set their computer systems accordingly with proper practices.
Task 2 – read the SOP for the computer and set up the excel spreadsheet according to
Assessment Templates | TAE Training Academy | Page 9

instruction.
Students are required to read the SOP for the computer and set up the excel spreadsheet as per the
instructions. The results have to be submitted after each stage, there are total 3 stages to the
instruction about the results needed for the assessment.
Task 3 - students will form a group and it will be based on group input to discussions
Students are expected to make group togethers and will be based around group input to discussions
on working with excel spreadsheets, outcomes and troubleshooting.
Conditions of Assessment
Studnets have to complete all assessment tasks
Assessment must be performed in a safe atmosphere where evidence gathered will define the
consistent performance of typical activities experienced in the general administration field of work
and include access to:
 operational manuals
 organisational procedures related to operation and maintenance of equipment
 records relating to resources
 case studies and, where possible, real life situations.
Students will be provided feedback on their performance by their respective assessor.
. Students have the right to ask for the outcome of the assessment decisions when they feel they
have been treated unfairly or have other grounds for appeal.
Assessment Templates | TAE Training Academy | Page 10

Assessment Templates | TAE Training Academy | Page 11

OBSERVATION TASK CHECKLIST
Did the candidate: Yes No N/A Comments
1
The students completed the closed
book assessment task and showed
an ability to assimilate the skills that
are requirements of this unit
Y Completed as per
the assessment
2
The student can execute safe work
practices and to achieve this they
can identify and report to their
asessors
Y Safe work
executed
3
The student must know how to
create spreadsheets and to achieve
this they can identify existing and
potential tasks in the workplace,
report them to designated persons
and record them according to
workplace procedures.
Y Known by the
student
4
The student can follow group
discussionsas their work practices
and to achieve this they can follow
recordings related to resources
Y Workplace
practices have been
followed
5 The student can reflect on practices
related to spreadsheets and to
Y Relection was done
Assessment Templates | TAE Training Academy | Page 12