KII4003 Working With Spreadsheets Assessment 2 KII4003-AT-V XXXXXXXXXX XXXXXXXXXXDowntown Australia Pty Ltd t/a Kingsford International Institute XXXXXXXXXXRTO:45363 | CRICOS: 03689D XXXXXXXXXX1...

i have attached the assingment


KII4003 Working With Spreadsheets Assessment 2 KII4003-AT-V1.22052018 Downtown Australia Pty Ltd t/a Kingsford International Institute RTO:45363 | CRICOS: 03689D 1 KII4003 Working With Spreadsheets Assessment 2 KII4003-AT-V1.22052018 Downtown Australia Pty Ltd t/a Kingsford International Institute RTO:45363 | CRICOS: 03689D 2 Assessment Information Welcome to your Student Assessment Workbook for KII4003 Working with Spreadsheets. Unit of Competency BSBITU402 Develop and use complex spreadsheets This Student Assessment Workbook is where you will write all your responses for the knowledge questions and simulation tasks. Please refer to the Student Assessment Guide for more information. This assessment has the following two events: Assessment Event 1 – Knowledge Questions There are five questions that will provide us with evidence of your general knowledge of concepts in relation to ergonomics, work organisation strategies, energy and resource conservation techniques, and spreadsheet functions. Assessment Event 2 – Simulation: Milk Daily Fresh You will complete a number of tasks associated with designing and developing an automated spreadsheet template. These tasks will be based on your role of Document Management Specialist in a simulation for Milk Daily Fresh, an organisation that retails fresh milk products. To complete the Simulation, you will need to refer to the following resources: Project Brief.pdf Outlines the business needs and provides a paper design prototype to give you an idea of how the Sales Report Template must look. You will produce the Template based on the requirements specified in this document. Current Sales Data.xlsx Spreadsheet that holds raw data for the current year’s sales performance per quarter for the entire range of products. You will use this data to retrieve the current sales performance for the selected range of products as specified in the Project Brief. Historical Sales Data.txt Text file that holds raw data for the previous year’s sales performance per quarter for the selected range of products. You will import this file into your spreadsheet environment as per the requirements given in the Project Brief. Organisational Logo.png Milk Daily Fresh company logo. You will use this media file as stipulated in the organisational Style Guide. Milk Daily Fresh Style Guide.pdf Organisational Style Guide that provides the standards for spreadsheet production. You must conform to these standards when designing and producing the Sales Report Template. Ergonomics and Work Organisation Policy and Procedures.pdf A policy and procedures document that outlines Milk Daily Fresh’s organisational ergonomic, energy, and resource saving practices for document production. You will demonstrate yours understanding on these in Task 1. Please note that your responses for both assessment events can (where appropriate) use dot point format. See below an example of a dot point response and a full sentence response. KII4003 Working With Spreadsheets Assessment 2 KII4003-AT-V1.22052018 Downtown Australia Pty Ltd t/a Kingsford International Institute RTO:45363 | CRICOS: 03689D 3 Dot point format Presentation Plan includes the following:  outcomes  needs of the audience  context. Full sentence format When you are preparing for a presentation, there are a number of tasks that must be carried out. These are listing the outcomes that you want to achieve, followed by the identification of the needs of your audience. When you have completed these two tasks you then check on the room that you will be conducting the presentation in. KII4003 Working With Spreadsheets Assessment 2 KII4003-AT-V1.22052018 Downtown Australia Pty Ltd t/a Kingsford International Institute RTO:45363 | CRICOS: 03689D 4 Important Information: Remember, you do not type your answers in the Student Assessment Guide but use this Student Assessment Workbook instead. The Student Assessment Guide is simply a guide to explain what you are required to do, and by doing so, this will assist you to perform at your best. Please type your answers for the questions in Assessment Event 1 in this Student Assessment Workbook. In Assessment Event 2, you are required to produce a spreadsheet template and a PDF export of this template as the output of the simulation. Your Assessor will need electronic copies of these files in order to assess your performance in these assessment tasks; therefore, you will not use the Student Assessment Workbook for this purpose, rather, you will upload these files to the web-based cloud storage platform which you will have created in Task 2.2. Please refer to Task 2.2 in the Student Assessment Guide for specific instructions. However, note that Task 8 will require you to produce screenshots of your cloud platform with folders and files, and then attach to this Student Assessment Workbook as an Appendix. To Achieve Competence