Assessment Details
Qualification Code/Title
Assessment Type Assessment -03 Time allowed
Due Date Location AHIC Term / Year
Unit of Competency
National Code/Title BSBITU402 Develop and use Complex spreadsheets
Student Details
Student Name Student ID
Student Declaration: I declare that the work submitted is my own, and has not been copied or plagiarised from any person or source. Signature: ____________________________
Date: _____/______/__________
Assessor Details
Assessor’s Name
RESULTS (Please Circle) SATISFACTORY NOT SATISFACTORY
Feedback to student:
............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
Student Declaration: I declare that I have been assessed in this unit, and I have been advised of my result. I am also aware of my appeal rights.
Signature: _______________________________
Date: ______/_______/___________
Assessor Declaration: I declare that I have conducted a fair, valid, reliable and flexible assessment with this student, and I have provided appropriate feedback.
Signature: ________________________________________
Date: ______/_______/___________
Instructions to the Candidates
? This assessment is to be completed according to the instructions given below in this document.
? Should you not answer the tasks correctly, you will be given feedback on the results and gaps in knowledge. You will be entitled to one (1) resubmit in showing your competence with this unit.
? If you are not sure about any aspect of this assessment, please ask for clarification from your assessor.
? Please refer to the College re-submission and re-sit policy for more information.
? If you have questions and other concerns that may affect your performance in the Assessment, please inform the assessor immediately.
? Please read the Tasks carefully then complete all Tasks.
? To be deemed competent for this unit you must achieve a satisfactory result with tasks of this Assessment along with a satisfactory result for another Assessment.
? This is an Open book assessment which you will do in your own time but complete in the time designated by your assessor. Remember, that it must be your own work and if you use other sources then you must reference these appropriately.
? Resources required completing the assessment tasks are Learner guide, PowerPoint presentation, Unit Assessment Pack (UAP), Access to other learning materials such as textbooks, Access to a computer, the Internet and word-processing system such as MS Word.
? Submitted document must follow the given criteria. Font must be Times New Roman, Font size need to be 12 and line spacing has to be Single line.
? This is Individual Assessments. Once you have completed the assessment, please upload the softcopy of the Assessment into AHIC Moodle.
? Plagiarism is copying someone else’s work and submitting it as your own. Any Plagiarism will result in a mark of Zero.

BSBITU402 Develop and use complex spreadsheets
Record of Evidence (Learner Instructions)
This document forms part of the primary evidence of competency against the unit criteria. It is the Assessors’ responsibility to ensure that evidence collected is undertaken in line with the Principles of Assessment, Rules of Evidence and Training Package requirements.
It is your responsibility as the learner to follow instructions and to ensure that the work and evidence you submit is your own. Submitting work that has not been completed wholly by yourself is not authentic, this includes copying answers from other students, searching for the answers on the internet or paying a company or another person to complete work for you. In the event that any of the above occurs, the college may choose to cancel your enrolment.
If you have questions before or during the assessment process, you need to speak with your assessor to clarify the instructions and requirements.
If you have a learning need which has not been disclosed, please ensure that you discuss this with your assessor and the assessor may be able to make a contextualisation or reasonable adjustment to better meet your needs.
1. ASSESSMENT INTRODUCTION
This assessment has been designed to address the gaps of the unit BSBITU402 for learners of AIHC. This assessment has three parts or tasks and you will need to submit two documents one via soft copy email and this document in hard copy as your assessment evidence. An overview of each task is below.
Task 1
Create two (2) graphs from given data using help from online.
The assessor will provide you with the initial data, take this information to create a pivot table and graph similar to the following (please note figures below have been changed):
Row Labels Sum of Amount
Fruit 693069
Australia 91221
Canada 82338
France 125931
Germany 66430
New Zealand 62392
United Kingdom 87786
United States 176971
Vegetables 336665
Australia 40492
Canada 12407
France 15125
Germany 88738
New Zealand 4390
United Kingdom 85351
United States 90162
Grand Total 1029734
Reference the websites that you used to help you create the pivot tables.
Task 2 Filter, sort and reorganise the information to create three 3D column graphs (standard, stacked and 100% stacked) of consumption by month of different fruits and vegetables in Australia.
Your file must be saved, emailed to your trainer with the subject header BSBITU Gap Asst (Surname, First Name).
Once completed you will need to answer the questions provided.
Task 3 In a group, discuss and compare graphs based on format, design and creation process.
Together in a group you will review the graphs you have developed and discuss the following questions, during the discussion you will need to take notes.
• Discuss some of the advanced functions, including how they may be applicable for different businesses
• Compare the different charts, how do different formats affect the readability of the data? Which of the charts do you think are the most effective in relation to conveying the datas purpose?
• How could you improve upon your own efficiency if you had to repeat a similar task like this?
The gap for this unit requires you to be able to complete the following:
Skills-
• Use manuals, user documentation and online help to overcome problems with spreadsheet design and production
• Create graphs with labels and titles from numerical data contained in a spreadsheet file
• Uses listening and questioning skills to clarify requirements
• Recognises and follows explicit and implicit protocols and meets expectations associated with own role
• resolve issues by referring to user documentation and online help
• evaluate tasks to improve efficiency
• communicate with relevant personnel

Knowledge-
• explain advanced functions of spreadsheet software applications
• describe impact of formatting and design on presentation and readability of data
• explain organisational requirements for work periods and breaks
All components of this assessment must be evidenced satisfactorily in order for the Learner to be deemed competent.
Resources you will need to complete assessment:
• One copy of the spreadsheet via soft copy
• A copy of this record of evidence
• A computer or laptop with Microsoft office and access to the internet
Task 1: Create Pivot Table & Graph
Create Pivot Table & Graph from data set provided using online help.
Create two (2) graphs from given data using help from online.
The assessor will provide you with the initial data, take this information to create a pivot table and graph similar to the following (please note figures below have been changed):
Row Labels Sum of Amount
Fruit 693069
Australia 91221
Canada 82338
France 125931
Germany 66430
New Zealand 62392
United Kingdom 87786
United States 176971
Vegetables 336665
Australia 40492
Canada 12407
France 15125
Germany 88738
New Zealand 4390
United Kingdom 85351
United States 90162
Grand Total 1029734
Reference the websites that you used to help you create the pivot tables.

Task 2: Create 3D Graphs
Filter, sort and reorganise the information to create three 3D column graphs (standard, stacked and 100% stacked) of consumption by month of different fruits and vegetables in Australia.
Your file must be saved, emailed to your trainer with the subject header BSBITU Gap Asst (Surname, First Name).
Once completed you will need to answer the questions provided.
Discuss some of the advanced functions, including how they may be applicable for different businesses
Compare the different charts, how do different formats affect the readability of the data? Which of the charts do you think are the most effective in relation to conveying the data’s purpose?
How could you improve upon your own efficiency if you had to repeat a similar task like this?
Task 3: Discuss
In this last task, you will discuss with the group the questions that you have answered, take notes about other opinions, questions that you asked, points that you found interesting. Please ensure that you provide at least four points below.