Assessment Event 2: Milk Daily Fresh  

In this assessment, you will undertake a number of tasks associated with designing and developing a spreadsheet template which automates a series of work tasks. The focus is on gathering design and task requirements to accurately produce the spreadsheet template adhering to the organisational style guide in order to maintain consistency of style, design and layout. 

In this simulation, you will demonstrate your: 

• interpersonal skills to effectively listen and question to clarify spreadsheet requirements 

• technical and numeracy skills to design and develop an automated spreadsheet based on specific design and task specifications 

• ability to follow organisational work practices including ergonomics, work organisation and energy management. 

Please ensure that you familiarise yourself with this set of requirements that underpin this activity. This includes understanding the background and the criteria you will be assessed on. These are located in the Appendix of this document. 

Task 1: Prepare to Develop Spreadsheet 

In this task, you will demonstrate your interpersonal skills in listening and questioning to clarify spreadsheet design and task requirements. Also, you will demonstrate your knowledge and ability to follow organisational work practices in terms of ergonomics, work organisation, and energy management in accordance to Milk Daily Fresh’s organisational policy and procedures. 

Task 1 Requires you to interact with a stakeholder (Milk Daily Fresh Sales Manager) to clarify spreadsheet requirements and demonstrate your ability to apply organisational policy and procedures related to ergonomics, work organisation strategies, and energy management. Task 1 is divided into the following two areas: 

 Task 1.1: This task is focused on your interpersonal skills to effectively listen and question the Sales Manager to clarify spreadsheet requirements. Your Assessor will observe your interaction with the Sales Manager in a total duration of 20 minutes and document their feedback using Observation Check Sheet 1 in Appendix B. 

 Task 1.2: These tasks are centred on your ability to organise your work environment in accordance with Ergonomics and Work Organisation Policy and Procedures. Task 1.2 will occur straight after the completion of Task 1.1. Total duration for Task 1.2 is 25 minutes. Your Assessor will observe your interaction with the Sales Manager in a total duration of 25 minutes and document their feedback using Observation Check Sheet 2. 

Please see Simulation Background section further in this document for more detailed instructions. 

1.1 Clarify spreadsheet specifications 

R 1. hold a 20-minute session with the Sales Manager to clarify spreadsheet design and task requirements R 2. demonstrate sound understanding for the Project Brief and Milk Daily Fresh Style Guide R 3. actions must meet all the criteria in the Observation Check Sheet 1 in Appendix B. 

1.2 Organise work environment in accordance with organisational requirements  

R 1. hold a 25-minute session with the Sales Manager and demonstrate your: 

• ability to follow Milk Daily Fresh’s ergonomic and work organisation practices 

• understanding for the energy and resource conservation techniques 

R 2. actions must meet all the criteria in the Observation Check Sheet 2 in Appendix B.

Appendix