ACC508 Informatics and Financial Applications Task 2 ATMC Semester 2, 2019
Assessment and Submission Details
Marks: 30 % of the Total Assessment for the Course
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. The assignments can only be marked if submitted through Blackboard.
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 Coordinator. Failure to produce the second copy of the assignment when requested may result in loss of marks or a fail grade for the assignment.
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 workload so other assignments being due is not enough reason to be granted an extension.
Background
The assignment of a customer information workbook 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. This workbook should be dynamic so if you change a value the change should flow to all affected values.
The starting workbook consists of one worksheet, please download from BlackBoard.
Task 1
Format the worksheet to create professional looking worksheet, format the column headings, width and it is best not to use Excel to create tables. Those columns missing headings, please give the columns appropriate headings. Rename the worksheet to CustomerData
Task 2
After completing task 1, a sequence of tasks needs to be completed on the CustomerData worksheet. These tasks are listed below: Hide the columns that you no longer need as you have formatted them, do NOT delete them.
Task 3
Task 4
Task 5
Task 6
Assignment Requirements and Deliverables
The report is to be prepared as a single Microsoft Excel.
Submission
The completed assignment is to be submitted by the due date and is to be an electronic submission of assignments please upload your Excel file. The file naming format should be lastName_FirstName_StudentNumber_ACC508_Assn2.
The assignment will be assessed according to the marking sheet (Appendix A). Late submission of the assignment will result in a deduction of 10% of the available marks for each day that the assignment is late. This includes Saturday and Sunday.
Assignment Return and Release of Grades
Where an assignment is undergoing investigation for alleged plagiarism or collusion the grade for the assignment and the assignment will be withheld until the investigation has concluded.
Appendix A
Marking Sheet for ACC508 S2.2019 Task 2
Criteria 
High distinction 
Distinction 
Credit 
Pass 
Not Yet 

Task 1 Development and presentation of Excel Spreadsheet and use of appropriate formulas. (5 Marks) 
Thorough – Extended: Uses appropriate, relevant, and correct formulas producing correct and nicely presented content. A skillful use of presentation tools to produce a professional level spreadsheet. All queries are complete and correct. 
Systematic Uses appropriate, relevant, and correct formulas producing correct content. A consistent use of presentation tools to produce a mostly professional level spreadsheet. All queries are complete and almost correct. 
Developing: Uses mostly appropriate, relevant, and mostly correct formulas producing almost correct content. Use of presentation tools to produce a professional level spreadsheet through most of the spreadsheet. Almost all queries are complete and mostly correct. 
Basic: Uses mostly appropriate, relevant, and correct formulas producing some correct content. Some use of presentation tools to produce a nearly professional level spreadsheet. Some queries are complete and mostly correct. 
Uses little to no appropriate, relevant, and correct formulas producing little correct content. A lack of use of presentation tools, spreadsheet is not of a professional level. Some queries have not been completed and may not be correct. 

Task 2 Development and presentation of Excel Spreadsheet and use of appropriate formulas. (15 Marks) 
Thorough – Extended: Uses appropriate, relevant, and correct formulas producing correct and nicely presented content. A skillful use of presentation tools to produce a professional level spreadsheet. All queries are complete and correct. 
Systematic Uses appropriate, relevant, and correct formulas producing correct content. A consistent use of presentation tools to produce a mostly professional level spreadsheet. All queries are complete and almost correct. 
Developing: Uses mostly appropriate, relevant, and mostly correct formulas producing almost correct content. Use of presentation tools to produce a professional level spreadsheet through most of the spreadsheet. Almost all queries are complete and mostly correct. 
Basic: Uses mostly appropriate, relevant, and correct formulas producing some correct content. Some use of presentation tools to produce a nearly professional level spreadsheet. Some queries are complete and mostly correct. 
Uses little to no appropriate, relevant, and correct formulas producing little correct content. A lack of use of presentation tools, spreadsheet is not of a professional level. Some queries have not been completed and may not be correct. 

Task 3 Development and presentation of Excel Spreadsheet and use of appropriate formulas. (20 Marks) 
Thorough – Extended: Uses appropriate, relevant, and correct formulas producing correct and nicely presented content. A skillful use of presentation tools to produce a professional level spreadsheet. All queries are complete and correct. 
Systematic Uses appropriate, relevant, and correct formulas producing correct content. A consistent use of presentation tools to produce a mostly professional level spreadsheet. All queries are complete and almost correct. 
Developing: Uses mostly appropriate, relevant, and mostly correct formulas producing almost correct content. Use of presentation tools to produce a professional level spreadsheet through most of the spreadsheet. Almost all queries are complete and mostly correct. 
Basic: Uses mostly appropriate, relevant, and correct formulas producing some correct content. Some use of presentation tools to produce a nearly professional level spreadsheet. Some queries are complete and mostly correct. 
Uses little to no appropriate, relevant, and correct formulas producing little correct content. A lack of use of presentation tools, spreadsheet is not of a professional level. Some queries have not been completed and may not be correct. 

Task 4 Development and presentation of Excel Spreadsheet and use of appropriate formulas. (20 Marks) 
Thorough – Extended: Uses appropriate, relevant, and correct formulas producing correct and nicely presented content. A skillful use of presentation tools to produce a professional level spreadsheet. All queries are complete and correct. 
Systematic Uses appropriate, relevant, and correct formulas producing correct content. A consistent use of presentation tools to produce a mostly professional level spreadsheet. All queries are complete and almost correct. 
Developing: Uses mostly appropriate, relevant, and mostly correct formulas producing almost correct content. Use of presentation tools to produce a professional level spreadsheet through most of the spreadsheet. Almost all queries are complete and mostly correct. 
Basic: Uses mostly appropriate, relevant, and correct formulas producing some correct content. Some use of presentation tools to produce a nearly professional level spreadsheet. Some queries are complete and mostly correct. 
Uses little to no appropriate, relevant, and correct formulas producing little correct content. A lack of use of presentation tools, spreadsheet is not of a professional level. Some queries have not been completed and may not be correct. 

Task 5 Development and presentation of Excel Spreadsheet and use of appropriate formulas. (20 Marks) 
Thorough – Extended: Uses appropriate, relevant, and correct formulas producing correct and nicely presented content. A skillful use of presentation tools to produce a professional level spreadsheet. All queries are complete and correct. 
Systematic Uses appropriate, relevant, and correct formulas producing correct content. A consistent use of presentation tools to produce a mostly professional level spreadsheet. All queries are complete and almost correct. 
Developing: Uses mostly appropriate, relevant, and mostly correct formulas producing almost correct content. Use of presentation tools to produce a professional level spreadsheet through most of the spreadsheet. Almost all queries are complete and mostly correct. 
Basic: Uses mostly appropriate, relevant, and correct formulas producing some correct content. Some use of presentation tools to produce a nearly professional level spreadsheet. Some queries are complete and mostly correct. 
Uses little to no appropriate, relevant, and correct formulas producing little correct content. A lack of use of presentation tools, spreadsheet is not of a professional level. Some queries have not been completed and may not be correct. 

Task 6 Development and presentation of Excel Spreadsheet and use of appropriate formulas. (20 Marks) 
Thorough – Extended: Uses appropriate, relevant, and correct formulas producing correct and nicely presented content. A skillful use of presentation tools to produce a professional level spreadsheet. All queries are complete and correct. 
Systematic Uses appropriate, relevant, and correct formulas producing correct content. A consistent use of presentation tools to produce a mostly professional level spreadsheet. All queries are complete and almost correct. 
Developing: Uses mostly appropriate, relevant, and mostly correct formulas producing almost correct content. Use of presentation tools to produce a professional level spreadsheet through most of the spreadsheet. Almost all queries are complete and mostly correct. 
Basic: Uses mostly appropriate, relevant, and correct formulas producing some correct content. Some use of presentation tools to produce a nearly professional level spreadsheet. Some queries are complete and mostly correct. 
Uses little to no appropriate, relevant, and correct formulas producing little correct content. A lack of use of presentation tools, spreadsheet is not of a professional level. Some queries have not been completed and may not be correct. 
Follow Us