# BSBITU314 - Assessment 1 & 3.docx - Assessment 1 Part A 1...

• 10
• 100% (3) 3 out of 3 people found this document helpful

This preview shows page 1 - 4 out of 10 pages.

Assessment 1 Part A 1. Calculate Gross Pay, Superannuation, Tax Withheld and Net Pay. Monthly Pay Roll First Name Last Name Hourly Rate Number of Hours per week Gross Pay Superannuation (10%) Tax Withheld (30%) Net Pay Jack Smith \$32.00 37.5 1200.00 120.00 324.00 756.00 Nathen Wang \$39.00 37.5 1462.50 146.25 394.88 921.37 Gilbert Wilson \$28.00 37.5 1050.00 105.00 283.50 661.50 Thomas Davis \$21.00 37.5 787.50 78.75 212.63 496.13 Aron Woods \$47.00 37.5 1762.50 176.25 475.88 1110.38 Paxton Brown \$19.00 37.5 712.50 71.25 192.38 448.88 Harris Jones \$24.00 37.5 900.00 90.00 243.00 567.00 Arun Sharma \$35.00 37.5 1312.50 131.25 354.38 826.88 2. Short Report The purpose of spreadsheet is to categorize and organize the data in a logical format. Spreadsheet can store all different kinds of data such as financial data, product data and client’s data. Business now a day use spreadsheet to track all the business accounts and data. Formulas are provided in spreadsheet by which it will help to do all the calculations. This reduce a lot of time by doing the calculations manually. The characteristics of a good spreadsheet are the design of the workbook, the areas of the worksheet and the standards that the company required for. When creating a spreadsheet, it should be accurate, flexible, clear, efficient and auditable. In this spreadsheet, the design used is the timesheet style. The “fill” function will be used to auto fill all the data with same formula. While the formatting and formula used are summation, multiplication and subtraction. The formulas used will allow to make calculation more accurate and efficiently. Sometimes, it is difficult to navigate the large workbooks. The row of sheet tabs across the bottom of the window is a terrible mechanism for finding way around if there are more than a handful of tabs. When there are more tabs than can be displayed across the screen, it becomes
even more difficult to find the one looking for. It can right-click on the arrows to the left of the sheet names to bring up the Activate Sheet dialog, but even that only lists the first 20 sheets before have to scroll the list – and there’s no way to sort, group or search for the sheet want.
Part B 1. Ergonomic standards Monitors Set the eye-to-screen distance at the distance that permits you to most easily focus on the screen. Usually this will be within an arm's length. Set the height of the monitor so that the top of the screen is below eye level and the bottom of the screen can be read without a marked inclination of the head. Usually this means that the centre of the screen will need to be near shoulder height. Your eyes should be level with the tool bar. Desks Adjust the height of the work surface and/or the height of the chair so that the work surface allows your elbows to be bent at 90º, forearms parallel with the floor, wrist straight, shoulders relaxed. Place all controls and task materials within a comfortable reach of both hands so that there is no unnecessary twisting of any part of the body.