Instructions: It is an Excel Assignment in my Business Information System course. The requirement is in the file I attached (BISM7202). You may work on the template and base on the description and also the performance data file. This assignment requires you to create a professional business application using Microsoft Excel 2016/ Microsoft Excel 365 (or later compatible releases). The purpose of this assessment is to test the student’s ability to operate and manage business data in spreadsheets.

The assessment requires no prior technical background. Moreover, it is designed for business students in general to appreciate basic IS applications. Prior familiarity with the software tool could be beneficial but will not guarantee a significate advantage or higher marks. Through tutorials, students are exposed to practical exercises like those in the assessment and develop the skills to manage data in Excel and use these skills to complete this assessment. It is essential that students carry out the required readings and preparation for each tutorial before attending/attempting each tutorial and this assessment.

The assessment is worth 40% of your grade in this course. This is an individual assessment – group work or any collaboration on the assessment is not permitted. This assessment consists of several tasks to be completed in Excel. The Excel template of the expected worksheets is available on the BISM7202 Blackboard site. The Excel template provided must be used as the basis for the assignment. You may change the visual formatting (colour, fonts, data format presentation, etc) to provide a professional finished project, but nothing else (e.g. its structure except when you are asked to do so).

You must use Microsoft Excel 2016 (or Microsoft Excel 365) for this assignment. Any of the previous Microsoft Excel versions (e.g. Microsoft Excel 2007) might cause some problems. It is highly recommended that, prior to assignment submission, you check that your solution works on the university machines if you have developed it on your own machine. Please develop your solution based on the provided files.

Late Submission - Request for extension of the assignment due date. The lecturer cannot grant any assessment extensions to students. You will incur penalties of 5% of the total available marks if your work is submitted late (i.e. after the due date and without an approved extension). The penalty once calculated is deducted from the marks awarded for the assessment. Assessment submitted more than 10 days after the due date will receive zero marks.

Marking Rubric - This assignment is worth 40 marks. The marking rubric below is designed to reflect a marking scheme of 100 points that are at the end scaled back to 40 marks. If you received 75 points out of 100 points on the below rubric, your final mark out of 40 is calculated as follows: 75 ÷100 × 40 = 30. Therefore, the final mark would be 30 out of 40.