Ask a question from expert

Ask now

ACC508 Informatics and Financial Applications Assignment

6 Pages1528 Words416 Views
   

Informatics and Financial Applications (ACC508)

   

Added on  2019-10-08

ACC508 Informatics and Financial Applications Assignment

   

Informatics and Financial Applications (ACC508)

   Added on 2019-10-08

BookmarkShareRelated Documents
ACC508Informatics and FinancialApplicationsTask 2Semester 2, 2016
ACC508 Informatics and Financial Applications Assignment_1
Assessment and Submission DetailsMarks: 30 % of the Total Assessment for the CourseDue Date: Friday 21st of October, Week 12The 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 thesubmission instructions in Blackboard. DO NOT SUBMIT THE ASSIGNMENT TO THECOURSE CO-ORDINATOR OR TUTOR.The assignment will be marked out of a total of 100 marks and forms 30 % of the totalassessment for the course. Once marked, ALL assignments will be checked forplagiarism and/or collusion between individuals.Refer to your Course Outline or the Course Web site for a copy of the “StudentMisconduct, Plagiarism and Collusion” guidelines.Note: Each student MUST make a second copy of the assignment and this copy MUSTbe produced within 24 hours of it being requested by the Course Co-ordinator. Failureto produce the second copy of the assignment when requested may result in loss ofmarks 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 ofsubmission and requests made on the day of submission or after the submission date willonly be considered in exceptional circumstances. Please note you are expected to manageyour work load so other assignments being due is not sufficient reason to be granted anextension. Page 2 of 6
ACC508 Informatics and Financial Applications Assignment_2
BackgroundThe 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 (they get paid at their normal rate while on holiday) and ten days sick pay (they get paid at their normal rate while sick) in each year that they are employed. This means that they get paid even though they areaway from work. Superannuation is calculated as a percentage the Gross pay and taxed at 15%. Overtime is calculated at time and a half. The task 2 starting workbook consists of two worksheets, named Employee Information and Payroll Calculator.Task 1Format 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. 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.Those columns missing headings, give the columns appropriate headings.Task 2After 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. 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.2.All columns should be formatted to use the correct data type for their contents.3.Using conditional formatting, identify any cells with missing mobile phone numbers and change their background colour to light red.4.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.5.Sort the data alphabetically on “Last Name”Task 31.Add ta new worksheet to your Excel workbook, called "Payroll summary". This should be the first worksheet in your workbook.2.On the “Payroll summary” worksheet add two named cells one called “Medicare_Levy” witha value of 1.5% and the other cell called “Overtime_Rate” with a value of 1.5. These cells should be appropriately labelled in your worksheet.3.Add another named cell to the “Payroll summary” work sheet called “Period_ending” and give it todays date using an Excel Function.Page 3 of 6
ACC508 Informatics and Financial Applications Assignment_3

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Mobile App Development Task 2022
|6
|1356
|14

Implement and Maintain Internal Control Pro
|41
|7014
|23

Assignment 1 Design Document
|8
|1846
|474

This is an individual piece of assessment
|10
|2663
|22

Final Assessment- Financial Markets | Solutions
|10
|2485
|22

Accounting for Business Assignment - General Journal, General Ledger, Trial Balance
|16
|3660
|365