BSBITU402 Develop and Use Complex Spreadsheets Assignment Help

BSBITU402 Develop and Use Complex Spreadsheets Assignment Help

BSBITU402 Develop and Use Complex Spreadsheets Assignment Help

Introduction

The assignment is prepared with the aim of gathering knowledge on learning tools and techniques which can be successfully used in completing competency requirement. The report will first develop a personal work experience by organizing an environment in accordance with ergonomics requirements. The report will further identify the organizational requirements in relation to entering data and storage output. The report will further provide with the work organization strategies which can be use for work activities. There will be utilisation of spread sheet designing under which formatting of cells, absolute cells will be applied. Further excel will also be used to identify the automation task which would increase efficiency of the excel function. There will be creation of macros in excel and templates will be design and edited in order to understand its way of using. In the last report will give an understanding of all the above items as discussed above. The aim will be developed an understanding of concepts in effective manner.

Assessment 1

Part 1

BSB51915 Diploma of Leadership and Management Assignment Help

The photo was taken on 29-07-2017 of the workplace and it shows the key point of the organization compliance. The photo above shows the arrangement of the computer system at the workplace. All the equipment at the workplace is properly kept to ensure safety of the workers full stop (Alberte-Hallam, et. al., 2014).At the workplace there is proper height of the chairs so that the screen of the computer is clearly visible also there are proper racks for the storage of the key documents which are required at the time of working. All the key hardware’s which are part of the computer are stored at the proper place to prevent them from water and dust. Also there is proper light at the workplace to prevent damage to the eyes of the employees and the equipment kept at the workplace proper guidelines of uses to avoid hazard at the workplace.

 

Yes

No

Are you placed under pressure to meet demanding work targets or deadlines?

Yes

 

If yes, is the pressure a result of external sources or your owndisorganisation?

 

No

Has there been consistency in workload recently? (this is preferable to sudden increases in workload or working overtime)

 

No

Have work pauses been taken as appropriate?

yes

 

Is the chair easily adjusted from a seated position?

Yes

 

Can you get close to the workstation without impediment?

yes

 

Is the seat height adjustable so that your thighs are parallel to the floor, with feet resting on the floor or a footrest?

Yes

 

Is the backrest height-adjusted to fit into the small of your back and adequately support your spine?

 

No

Is the backrest angle-adjusted so that you are sitting upright while typing?

Yes

 

Are your forearms parallel with the floor or slightly angled downward?

Yes

 

Is the desk height adjustable?

 

No

If yes, is the adjustment easily operated?

If no, do you have a footrest?

 

No

If there is a footrest, is it large enough to support both feet and allow a change of position?

Yes

 


 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Part 2

Role Play

To avoid the risk of injury at the workplace company needs us to properly store the devices which are the part of the computer. Also the company need to ensure that the workers wear proper Eye care equipment to prevent damage to their size as they are working beyond a certain limit on the computer system. Yes a workplace has the setup for energy Converse conservation to make effective utilisation of existing resources and reduced cost also the monitors are kept shut down after 15 minutes of inactivity at standby after 1 hour of an activity to preserve the energy.

Part 3

To conserve energy at cover book the organisation need to create the policy that the student’s employees turn off the system after the use or an activity. Also the employee should turn off the light when they are not in use your organisation should have regular check over is activity that they are implemented and effective as these are the important steps to conserve the energy at the workplace.Silva, et. al., (2014).

Part 4

The two spreadsheets required at the workplace our customers purchasing and payment option and it uses option.

Customer Purchasing and paymentoption - the spreadsheet will be used to check the sales made by the company during the particular period and payment option adopted by the customer. It will keep proper track of the amount deposited by the customer till date and the amount due for the payment in future. It also provides us with the date on the payment is due and track of the fine collected during the period.

IT usage- the spreadsheet helps us in keeping the amount of it uses made by the customer during the particular. It also keeps the proper track of ID passwords of the customer to ensure safety of the data (Lottrup, et. al., 2013). The spreadsheet also helps in identifying the area over which the company needs to control the wastage.

Part 5

To ensure the safety of the data it should be stored both under hard and soft storage. In the present era of storage is highly preferred as it reduces the cost of recording the data and prevention of the data by making the use of innovative software. But many of the times it's hard to prevent the data stored under soft storage so there comes needs to create a backup of the resources and hard storage in to overcome the situation of emergency. Also the company needs to store the data at an offset location which can be accessed only by the key resources of the business and should only used in the case of emergency (Nogueira, et. al., 2016).These documents are the key part of the business and may create impact over the stability of the business.

Part 6

The policy of the government has a huge impact over the functioning of the business and the ignorance of the same leads to huge penalty. The following are the few of the policy which create impact over the functioning of the business.

Ethical principle- The ethical code of practice of the company encompasses the principle which all the employees need to follow. These principle guides the decision making and behaviour at the workplace. The major issues with the implication of the ethical code of conduct as most of the employee are unaware of such ethical code (Fernandez & Pearson, 2015). Those at the position of authority such as manager should follow these ethics to implement the same and create impact over the employee. It helps in reporting code violation or ask ethical question when trying to making the decision on special event. It creates stronger impact over the behaviour of the employees at the workplace.

Privacy law- The privacy act 1988 is an Australian law which prevent the personal information of an individual. Privacy law create a significant event impact on the private sector business and government Agencies which are involved in handling personal information (Butler & Rodrick, 2015).The act says that says that it is important for business to understand obligation to lead up the introduction of new laws. The cover books are the data of the public so need to prevent the data as per the privacy law. The privacy law also help in safeguarding the personal data of the customer which is kept with the company.

Occupation health and safety law and regulation- The law provides proper attention to the workers health and safety which has extension benefit. The law of focus on healthy workers to overcome the poverty and avoid risk any work place. At focus on save environment which contributes the sustainable development and helps in controlling pollution and reducing exposure. At Health Organisation in effectively managing health and safety program at the workplace. Also it creates positive Image of the organisation and increases the moral of the staff of the company. The policies are the company increasing productivity and reduce the absenteeism of the employee from the workplace (Selwyn & Emir, 2014).It also reduces Healthcare insurance costs and fines and litigation which are the implicated on the company. It helps in reducing the stress of the employee this increases the productivity at the workplace. The non compliance with the regulation will lead to his penalty to the company and also causes increase in both direct and indirect cost of the company.

Assessment 2

Part 1

Employee ID

Name

Hourly Wage

Tax Status

Federal Allowance (From W-4)

State Tax (Percentage)

Federal Income Tax (Percentage based on Federal Allowance)

Social Security Tax (Percentage)

Medicare Tax (Percentage)

Total Taxes Withheld (Percentage)

Insurance
Deduction
(Dollars)

Other Regular
Deduction
(Dollars)

Total Regular Deductions (Excluding taxes, in dollars)

N00011

Sally

$8.23

1

4

2.30%

28.00%

6.30%

1.45%

38.05%

$20.00

$40.00

$60.00

N00012

David

$9.88

1

3

2.30%

28.00%

6.30%

1.45%

38.05%

$20.00

 

$20.00

N00013

Natalie

$11.52

2

2

2.30%

28.00%

6.30%

1.45%

38.05%

$20.00

 

$20.00

N00014

Cameron

$13.17

1

3

2.30%

28.00%

6.30%

1.45%

38.05%

$20.00

 

$20.00

N00015

Justine

$14.82

1

4

2.30%

28.00%

6.30%

1.45%

38.05%

$20.00

 

$20.00

N00016

Grace

$16.47

1

4

2.30%

28.00%

6.30%

1.45%

38.05%

$20.00

 

$20.00

Part 2

Employee ID

Employee Name

Regular Hours Worked

Vacation Hours

Sick Hours

Overtime Hours

Overtime Rate

Gross Pay

Taxes and Deductions

Other
Deduction

Net Pay

1

Sally

50

5

1

 

 

$230.00

$20.00

$20.00

$190.00

2

David

45

6

2

 

 

$220.00

$10.00

 

$210.00

3

Natalie

32

8

5

 

 

$180.00

$5.00

 

$175.00

4

Cameron

40

9

1

 

 

$225.00

$10.00

 

$215.00

5

Justine

38

4

2

 

 

$205.00

$15.00

 

$190.00

6

Grace

35

2

4

 

 

$198.00

$10.00

 

$188.00

The specification required for the above sheet is the name and employee ID keep the proper track of the records of the employee of the cover book. The spreadsheet will calculate the number of working days for which the employee have worked and the number of Hour working hour during the period. The spreadsheet also helps in classifying the employee under certain basis to determine the payment made to them within the particular period.

The Spreadsheet will helps in creating the link between the different data which is required to determine the payment of the employee. Also It also helps in creating proper track of the employee which are working with the company and the amount paid to them to make the various decision related to the business. The spreadsheet also carries the description on the basis of which each of the employees can be classified to determine the rate at which they are paid wages.

Also the spreadsheet will help us in maintaining proper track of the data of the employee who will join the company and have left with the company. Also the spreadsheet assists in easy maintenance of the data in relation to employee throughout his working with the organization and discharging all his dues when he leaves the organization. It will also provide with the easy calculation of the gross amount paid to the employee and tax payable to the government. The formula used in  the excel will help us in calculating the total hour, gross pay, net pay and the amount of the tax paid by the company during the particular period.

Assessment 3

1, 2, 3, 4

Year

Investment prices

Price of each share

Value of each share

Jun-09

500

20

10000

Jul-09

2500

82.5

206250

Aug-09

1200

100

120000

Sep-09

1000

40

40000

Oct-09

1500

10

15000

Nov-09

2000

90

180000

Dec-09

1600

170

272000

Jan-10

1400

30

42000

Feb-10

700

80

56000

Mar-10

1900

65

123500

Apr-10

2500

200

500000

May-10

1200

210

252000

Jun-10

1800

100

180000

Jul-10

1700

75

127500

 

 

 

 

 

 

Totals

2124250

 

 

Average value of each
 investment

151732.1429

 

Total Investment values

Year

Total investment

Jun-09

10000

Jul-09

206250

Aug-09

120000

Sep-09

40000

Oct-09

15000

Nov-09

180000

Dec-09

272000

Jan-10

42000

Feb-10

56000

Mar-10

123500

Apr-10

500000

May-10

252000

Jun-10

180000

Jul-10

12750

BSBITU402 Develop and Use Complex Spreadsheets Assignment Help

As per the above graph it can be analysed that in the month of April, 2010 there was high price of investment. Further that month was the great opportunity to sell. This option would have provided fruitful returns which can be utilised in some other essential activities of business.

Assessment 4

1. Formula is a calculation in excel for statistics, mathematics, financial, and other uses, whereas function defines the formula which includes a predefined calculation. Formula includes value, reference to cells, and functions. Function is a code which is designed and used inside of formulas.

2. Macro is set of instruction which feeds in module of visual basic. This function in excel helps to make excel perform commands and actions which has been set. Thus the set task in macro function can be repeat in excel several times. Thus it helps to perform the task which is repetitive in daily use of excel.  Excel used to store each and every function and command thus facilitates automation in performance of task (Walkenbach, 2010). There is enhancement in convenience in using macro function in excel. They reduce the possibility of errors and faults from the part of human. Thus there is reduction of amount of time for doing the same activity. The records of actions in macros can also be further change as per the needs of the user.

Macro in excel can be run in following steps as provided below:-

1.There are several ways which are available for running macro in excel.

2.There is first need to display developer tab by default.

3.In order to show development tab there is need to follow the following discussed steps:-

1.Clicking on Microsoft office file button.

2.Then there is required to click on excel options.

3.Further a customise ribbon button will be selected.

4.Under this customize ribbon the main tabs will be selected and then developer check box will be selected.

4.Macro can also run automatically whenever excel would be open, in running excel automatically the shortcut key can be used Alt+F11 under which an opening of VBA editor will be made.

5.Then double click will be made on workbook from project explorer.

6.There will be filling of some predefined code after opening of window.

7.Then the file is saved with micro enabled workbook.

8.After opening of file the message box will appear there will be present the running of macro in excel (Zhang, et. al., 2010).

Templates are found in Microsoft office button under the new option. Templates can be created on own in excel and once it gets created then it can be reused again time to time. It assist in creating consistency and attractive documents, these are used in frequently used document such as budget planners, calendars, invoices and dashboards. There are diverse range of benefits which are involved in using templates in excel, one of the effective function which aids in accelerating speed, reduction of errors and maintains consistency and conciseness in the working in future. For accessing to excel there are many templates which are available such as simple table based templates, table spreadsheets database and excel tables use of format function. It also includes a tabular layout for pivot tables. In using template only an updating is required in future task with the use of same template.

3. Excel can be design in variety of ways. The designing is depending on the needs and demand of the user. User needs to clear about the purpose and then decide the calculations which are required in that work. Formatting in excel assist in deciding the look which the user want to have. The first step will include typing of data and then selecting the formula in order to complete the table and then the last step will be designing and formatting which can be perform  by using formatting option in home function of excel (Walkenbach, 2010).

4. Chart selection in excel is found in insert function under which charts are available such as column, line, bar, area, scatter, and other charts. Charts are prepared in excel after selection of spreadsheet data on the basis of which chart is required to be prepared. The required chart can be selected from insert chart option from excel. 

5. Ergonomics is designing made at workplace in such way to enable people to use systems in order to make fit people whosoever uses them. This is a discipline which understands the interactions of human beings among the various elements of a system. It assist in taking care of health and safety of people after understanding the needs and people and design and arrange the things in order to make people feel ease and comfort in using the same. It an occupation safety which identify problems, encourage early reporting of MSD symptoms and implement solutions to control hazards (Murrell, 2012).

Conclusion

From the report it can be summarised that excel has enormous benefits. It has number of functions which makes the business various functions smoothly. It not only assist in calculations and preparation of charts, tables and statistics but is lot more including automated functions which can lead to ease of task and reduction of time and efforts. One needs to have a good command on excel in order to utilise the maximum benefits from excel. From the report there has been made number of learning such as way of demonstrating and understanding of role play. From the report the learning is also been made on payroll records with the use of excel. Furthermore the report has also given an understanding of using macro function with the use of excel. The report has also provided with the difference between the function and formula in excel. The use of macro and template is also been provided in the report.

References

1.Alberte-Hallam, T., Hallam, S. F., & Hallam, J. (2014). Instructor's Manual to Accompany Microcomputer Use: Word Processors, Spreadsheets, and Data Bases with Accompanying MicroUSE Software. Academic Press.

2.Butler, D. A., & Rodrick, S. (2015). Australian media law. Thomson Reuters (Professional) Australia Limited.

3.Fernandez, J., & Pearson, M. (2015). POLITICAL JOURNALISM: Shield laws in Australia: Legal and ethical implications for journalists and their confidential sources. Pacific Journalism Review, 21(1), 61-78.

4.Lottrup, L., Grahn, P., & Stigsdotter, U. K. (2013). Workplace greenery and perceived level of stress: Benefits of access to a green outdoor environment at the workplace. Landscape and Urban Planning, 110, 5-11.

5.Murrell, K., 2012. Ergonomics: Man in his working environment. Springer Science & Business Media.

6.Nogueira, M., Duraes, M., Duhamel, C., Pedrosa, F., Otero, E., Matos, G., ... & Arezes, P. (2016). Analysis of thermal environment at a workplace: A case study in a jewelry shop. In Occupational Safety and Hygiene IV-Selected, Extended and Revised Contributions from the International Symposium Occupational Safety and Hygiene (pp. 585-589). Taylor & Francis.

7.Saffer, D., 2010. Designing for interaction: creating innovative applications and devices. New Riders.

8.Salvendy, G., 2012. Handbook of human factors and ergonomics. John Wiley & Sons.

9.Selwyn, N. M., & Emir, A. (2014). Selwyn's law of employment. Oxford University Press, USA.

10.Silva, E. M., Claypool, R., Munsch, J., Hendrickson, J., Mitchell, P., & Mills, J. (2014). Veggie Compass: A Spreadsheet-based Tool to Calculate Cost of Production for Diversified Organic Vegetable Farmers. HortTechnology, 24(3), 394-402.

11.Style furniture, (2017). Modern furniture for your home photo blog. Available at:http://clubblanco.club/computer-repair-workstation-desk.html.[Accessed on 29-07-2017].

12.Triola, M.F., 2013. Elementary statistics using Excel. Pearson.

13.Walkenbach, J., 2010. Excel 2010 power programming with VBA (Vol. 6). John Wiley & Sons.

14.Zhang, Y., Huo, M., Zhou, J. and Xie, S., 2010. PKSolver: An add-in program for pharmacokinetic and pharmacodynamic data analysis in Microsoft Excel. Computer methods and programs in biomedicine, 99(3), pp.306-314.