BSBITU212: When is It Necessary to use a Spreadsheet rather than a Word Processing Application: Create and Use Spreadsheets Assignment, DU, Australia
Subject | BSBITU212: Create and Use Spreadsheets |
Assignment Details:
Question 1
When is it necessary to use a spreadsheet rather than a word processing application?
Question 2
Explain in a short paragraph how to format numbers in a spreadsheet?
Are You Searching Answer of this Question? Request Australian Writers to Write a plagiarism Free Copy for You.
Question 3
List some points to consider when planning a spreadsheet. Name some specification which could be included in an organization’s procedures or guidelines. Your answer should include ergonomic standards and conservation techniques practiced within an organization. Give at least three examples of each.
Question 4
What is the difference between a Relative Reference and an Absolute Reference when using formulae for calculations? Give at least one example of each.
Question 5
In a brief sentence explain how labels or titles on a chart can be changed.
Question 6
When designing spreadsheets, why is it a good idea to have a plan? How can you clarify purpose, objectives, etc.?
Question 7
Why is it important to preview and check documents and names and store them in an appropriate directory before finalizing them?
Question 8
Explain the organizational requirements for ergonomic standards, work periods, and breaks?
Question 9
Explain the purpose of using charts in presenting information to the other members of staff?
Question 10
What is Ergonomics and what are the organizational requirements for meeting ergonomics?
Assessment 2: Project
Get Solution of this Assessment. Hire Experts to solve this assignment for you Before Deadline.
Your Tasks: Task 1
Part A
Adjust the workstation to suit WHS requirements and energy and resources conservation techniques. This will be documented by your assessor in Assessment Task 3.
Part B
The information provided in the table below is for the six employees currently employed at Food Truck Express for the week ending 1st July 2018. Replicate the table below in a spreadsheet.
Staff Name | Ordinary Hours | Overtime (OT) Hours | Hourly Rate $ | Miscellaneous Deductions $ | |||||
Andrew | 38 | 10 | 25.36 | 38.20 | |||||
Brown | 38 | 10 | 28.50 | – | |||||
Carter | 38 | 8 | 18.75 | 26.50 | |||||
Davis | 30 | – | 22.90 | – | |||||
Edwards | 38 | – | 28.50 | 20.00 | |||||
Fletchers | 38 | 4 | 24.60 | 10.00 |
Part C
After completing Part A and B you are required to print the spreadsheet. But before you are allowed to print the spreadsheet you are required to apply formatting to enhance the appearance of your worksheets, such as bold, text color, text size, borders and etc. (all information on 1 page).
You are required to insert a header and footer. If you are unsure of how to add a header and footer, you may use the help feature in your software application.
Part D
Using the spreadsheet you have developed in part B. You are required to calculate the ‘pay hours’, ‘gross pay’, ‘tax’, and ‘net pay’ for each of the staff members in the table. (NB: You are required to use the formula feature in your spreadsheet application to calculate the required information
Example of how your table could look like: (An example has been provided for your reference)
A | B | C>= A + (B x 1.5) | D | E= C x D | F= (E – 80) x 0.32 | G | H= E–(F+G) | |
Staff Name | Ordinary Hours | Overtime (OT) Hours | Pay Hours | Hourly Rate ($) | Gross Pay ($) | Tax ($) | Miscellaneous Deductions ($) | Net Pay ($) |
E.g. Gigs | 38 | 4 | 44 | 27.50 | 1210.00 | 361.60 | 72.50 | 775.90 |
Extra Information:
- The formulas in the table above are provided to assist you.
- Overtime (OT) rate is 1.5 times the ordinary rate.
- Tax is calculated at 32 cents in the dollar, after the $80 tax-free deduction.
Part E
After completing Part A, B, C, and D. you are required to apply formatting to enhance the appearance of your worksheets, such as bold, text color, text size, borders and etc.
You are required to insert a header and footer. If you are unsure of how to add a header and footer, you may use the help feature in your software application.
Part F
You are now required to preview, adjust, and print your spreadsheet (all information on 1 page).
There are two printouts required. The first printout will be the ‘normal view’ print out with all the calculation on it and the second one will be the ‘formula view’ print out (to access the formula view print out format, you are required to press CTRL + ` (2 keys, this includes the Control (CTRL) and the apostrophe (`) at the same time – refer to the picture below).
Part G
Create a column chart on a new sheet showing the ordinary hours, overtime (OT) hours, and pay hours of each staff member. Add a page header and footer.
Stuck in Completing this Assignment and feeling stressed ? Take our Private Writing Services.
Part H
Create a bar graph (the 100% stacked bar graph) on a new sheet showing the net pay of all the staff members in one bar. Add a page header and footer.
Get Help By Expert
We prepare (BSBITU212) create and Use Spreadsheets assignments as per the student's requirements. We have online assignment experts who are always available to guide Duke University students in data analysis assessments.
Recent Solved Questions
- How can nurses help improve patient health and well-being in Aotearoa, New Zealand? In New Zealand, an essential part: Nursing Essay, VU, Australia
- What is the current and future role of personal care workers within the broader aged care and disability care workforce: Health Science Report, VU, Australia
- Identify a clinical situation you have encountered during your placement concerning: Reflective writing Assignment, ANU, Australia
- CHCCOM005: You enter a client’s room without personal protective equipment (PPE). After leaving the room, a co-worker tells you that the client has an infection that requires contact precautions: Communicate and work in health or community services coursework, QU, Australia
- CCF501: Demonstrate An Understanding Of The Fundamentals Of Cloud Computing: Cloud Computing Fundamentals Assignment, DU, Australia
- What styles of leadership do you recognize and how? Is it innovative/creative and in what ways is it effective: Management Assignment, KPU, Australia
- DESPITE a 56% DECREASE IN the national incidence of sudden infant death syndrome from deaths per 1000 live births in 1992: Epidemiology Assignment, MU, Australia
- CHCCCS023: The Candidate Must Show Evidence Of The Ability To Complete Tasks: Support Independence And Wellbeing-Disability Course Work, VU, Australia
- NRSG265 : Mr. Vinh Nguyen is a 48-year-old male, who emigrated from Vietnam over 30 years ago: Principles of Nursing: Medical Case Study, ACU, Australia
- MBA631: You are Required to Select an Australian Small to Medium Size Business and Conduct a Digital Marketing Audit: Digital Marketing and Communication Assignment, KU, Australia