CALCULATE THE GROSS PAY FOR EACH EMPLOYEE BASED ON THE NUMBER OF HOUR WORKED + SICK HOURS+ VACATION HOURS.Excel The assignment of a payroll calculator demonstrates Excels ability to automate and present financial calculation information clearly.
CALCULATE THE GROSS PAY FOR EACH EMPLOYEE BASED ON THE NUMBER OF HOUR WORKED + SICK HOURS+ VACATION HOURS.Excel The assignment of a payroll calculator demonstrates Excels ability to automate and present financial calculation information clearly.
Excel The assignment of a payroll calculator demonstrates Excels ability to automate and present financial calculation information clearly. The ability to build and professionally present a workbook is an important skill. Please note: that where the assignment states that you must use an expression, we mean a function.
High Distinction required
Assessment and Submission Details
Marks: 30 % of the Total Assessment for the Course
Due Date: Friday, 22rd October 2015
The assignment MUST be submitted online using Blackboard and on time
The submission link will be open at least a week before the due date. Please follow the submission instructions in Blackboard. THIS OPTION IS PERFERRED BY THE TEACHING TEAM.
DO NOT SUBMIT THE ASSIGNMENT TO THE
COURSE CO-ORDINATOR OR TUTOR.
The assignment will be marked out of a total of 100 marks and forms 30 % of the total assessment for the course. Once marked, ALL assignments will be checked for plagiarism and/or collusion between individuals.
Refer to your Course Outline or the Course Web site for a copy of the “Student Misconduct, Plagiarism and Collusion” guidelines.
Note: Each student MUST make a second copy of the assignment and this copy MUST be produced within 24 hours of it being requested by the Course Co-ordinator. Failure to produce the second copy of the assignment when requested may result in loss of marks or a fail grade for the assignment.
Assignment submission extensions will only be made using the official Faculty of Arts & Business Guidelines.
Requests for an extension to an assignment extension MUST be made prior to the date of submission and requests made on the day of submission or after the submission date will only be considered in exceptional circumstances. Please note you are expected to manage your work load so other assignments being due is not sufficient reason to be granted an extension.
Background
The assignment of a payroll calculator demonstrates Excels ability to automate and present financial calculation information clearly. The ability to build and professionally present a workbook is an important skill. Please note: that where the assignment states that you must use an expression, we mean a function.
Please Note:
In Australia, permanent employees get given 20 days holiday pay and ten days sick pay in each year that they are employed. This means that they get paid even though they are away from work. Superannuation is calculated as a percentage of the Gross pay and taxed at 15%. Overtime is calculated at time and a half.
The assignment 2 starting workbook consists of two worksheets, named Employee Information and Payroll Calculator.
Task 1
Format the two worksheets to create professional looking tables for each of these two worksheets. This formatting should be done using an appropriate table format selected from the home ribbon in Excel 2010. At this stage none of the data in the two worksheets should be modified. This will also require that you modify row height and column width.
Task 2
After completing task 1, a sequence of tasks needs to be completed on the Employee information worksheet. These tasks are listed below:
1. Separate the State & Postcode data into two columns. This must be done using the various text functions available in Excel 2010. It will require that you insert two additional columns into this worksheet. One column should be labelled “Postcode” and the other column should be labelled “State”. In addition all excess spaces should be removed from the text and all “State” text should be full upper case. This must be done using functions from Excel 2010.
2. All columns should be formatted to use the correct data type for their contents.
3. The mobile phone number must be in the format “1234 567 890” and this must be done using the format cells function.
4. Using conditional formatting, identify any cells with missing mobile phone numbers and change their background colour to light red.
5. Format the data in both “First Name” and “Last Name” and so that it begins with a capital letter. This must be done by using the appropriate Excel function.
6. Sort the data alphabetically on “Last Name”
Task 3
. .
The post CALCULATE THE GROSS PAY FOR EACH EMPLOYEE BASED ON THE NUMBER OF HOUR WORKED + SICK HOURS+ VACATION HOURS.Excel The assignment of a payroll calculator demonstrates Excels ability to automate and present financial calculation information clearly. appeared first on My Nursing Writer.
