BSBTEC302 Design and produce spreadsheets Assignment

SCENARIO

You are working as an administration officer for The Computer Warehouse, a large wholesale company which imports and then on-sells computer hardware componentry to the computer industry.

The company has a large volume of online orders to pack and distribute to their clients. You have been asked by your manager, to create a spreadsheet to record the weekly staff wages. The spreadsheet will be used by administration staff to record the orders each employee packs on each day of the week as well as calculate the total number packed and the total pay for the week for each employee.

PART 1: SHORT ANSWER QUESTIONS

Task 1 IDENTIFY SPREADSHEET REQUIREMENTS

1.1 Name a computer program (web or desktop based) best suited to creating spreadsheets

1.2 List 5 items of data entry for the spreadsheet requirements above. 

TASK 2 IDENTIFY THE AUDIENCE and PURPOSE

Referring to the spreadsheet requirements in the Scenario above and the charts to be created in Task eleven      (11) below, who will use the spreadsheet you are designing and what will they use it for (its purpose)? (10-20 words)

TASK 3 AMEND AND ADJUST

How might the spreadsheet need to be adjusted to accommodate changes in staff or rate of pay? (Approx. 10-20 words)

TASK 4 AUTOMATE FOR EFFICIENCY

How might you automate and store the spreadsheet for efficiency to eliminate having to reproduce it for each weekly pay run? (Approx. 20 words)

TASK 5 IDENTIFY OUTPUT REQUIREMENTS

Using the ASDS “Computer Warehouse and Style and Procedures Guide”. describe 3 points to consider when printing the spreadsheet:

TASK 6 IDENTIFY PRESENTATION REQUIREMENTS

Using the “Computer Warehouse and Style and Procedures Guide“. list 3 points to consider when presenting a spreadsheet:

PART 2 CREATE AND DESIGN SPREADSHEET

Task 7 PLAN AND DRAFT SPREADSHEET

As an administration officer for The Computer Warehouse, a large wholesale company you are about to draft the layout of a spreadsheet to incorporate a design where each employee can record their total pick for each day. The layout should have a column for employee names and a row to show the days of the week they will pack.

A separate space for the daily rate should be included to allow for total pay to be calculated later.

Using the table below, draft and insert a design of your spreadsheet to meet the needs of the scenario above ensuring your spreadsheet design suits the purpose, audience and information requirements of this task.

TASK 8 AUTOMATED DATA ENTRY

Based on your draft layout in Part 2 Task 7, feedback from your assessor and referring to the Computer Warehouse Style and Procedures guide (from here known as the Style guide), create a new spreadsheet with the following requirements:

Insert a tick in the “check” column below to confirm that you have completed each checklist task.