Unit 6 Create and Use Spreadsheets

Unit 6 – Create and Use Spreadsheets.

Assessment Agreement

Candidate Name:
School Name:
Assessor Name:
Units of Competency to be assessed: / BSBITU202A Create and use spreadsheets
Evidence to be collected: / · Assessment Task 1: Written Answers
· Assessment Task 2: Products Produced
Candidate (Student) to read and answer the following questions and sign: / Yes / No
· As the candidate are you ready for assessment? / ☐ / ☐
· Has the assessment process been explained to you and that to achieve a successful outcome for this unit of Competency you must be deemed Satisfactory in all assessment tasks? / ☐ / ☐
· Do you understand The Recognition of Prior Learning (RPL) process? / ☐ / ☐
· Do you understand which evidence is to be collected and how? / ☐ / ☐
· Do you understand your rights and the appeal system? / ☐ / ☐
· Have you discussed any special needs that should be considered during the assessment process? / ☐ / ☐
· Do you require an adjustment to the conduct of the assessment to respond to a specific or a special need.e.g. Cultural, Language, Disability, Literacy or Numeracy purposes. / ☐ / ☐
· I understand the purpose of the Assessment Tasks / ☐ / ☐
· All work I have submitted is my own / ☐ / ☐
· I know that I must follow all safety instructions when completing my assessments / ☐ / ☐
I agree to undertake this assessment in the knowledge that the information gathered will only be used for the purpose of determining my skills as Satisfactory or Not Satisfactory for each assessment method. Additionally the information gathered is for the determination of my Competency by the collection of all assessment evidence for this unit of competency and can only be accessed by my workplace supervisor, my RTO and nominated regulatory authorities. / ☐ / ☐
Candidate Signature: / Date:

Task 1 - Assessment: Written Answers

Objective: To test the student’s knowledge toCreate and use spreadsheets.

Question 1: (RK1)

Explain the reason why we would format a spreadsheet in a particular way. Give an example. What part does the audience play in this reason? What is absolute Cell Referencing?

______

Question 2: (RK2)

a. How often should you take a break when working with computers especially entering data into a spreadsheet?

______

b. Describe how to meet ergonomic requirements when using a computer. Why are these so important?

______

c. How can you conserve paper, toner and other computer consumables and save the environment and save your employer money?

______

Question 3: (RK3)

Explain how a business can manipulate a standard spreadsheet template to suit their own needs? Give at least two examples.

______

Question 4: (RK4)

a. State the purpose of a spreadsheet.

______

b. List four spreadsheet functions and state what the use is.

______

Assessment Workbook: BSBITU202A Create and use spreadsheets