Essay GCO3000: Information Technology in Business Case Study – Management Assignment Help

Assignment Task:

Task:

Assessment Details and Guidelines to Students:

This Scenario based Project comprises 50% of the total assessments’ marks. Make sure you reference (proper Harvard Referencing should be observed) any sources you have used to complete this assessment. Analytical skills. The reflection report enables the students to analyse and evaluate the benefits of the different activities done in the class. This skill will eventually help them evaluate options necessary to make decisions in the workplace.

In addition, the assessment will test the following learning outcomes:

LO 2: Develop and apply current application software to support business objectives. 

Assessment Task Task 1 (Microsoft Excel): (80 marks) Online Pizza Delivery A well renowned Pizza delivery company in Oman wants to introduce the automation process to facilitate the customers. The Director of the company has decided to assign a task to you as a developer to maintain the billing system for the customers. In this regard, you are requested by him to prepare and submit a report in Excel worksheet to keep the complete record of minimum ten (10) customers along-with the calculation of their bill amount for Pizza(s) including Municipality Tax and Home delivery charges.

The task should contain the following:

Task 1 (a): Create a COMPLETE worksheet with appropriate labels for this Scenario. The following should be included in your worksheet:

i. Name of the file (Student ID – Student Name).

ii. Title of the task (table).

iii. Complete contents and headings of the table.

iv. Page orientation to Landscape along-with the professional look of document.

v. Use filter by category.

Task 1 (b)

: i. Calculate the Total amount of ordered Pizza(s) by each customer by using appropriate formula in the respected cells.

ii. Calculate the 3% Municipality Tax on Total amount of ordered Pizza(s) against each customer by using appropriate formula in the respected cells.

iii. Calculate the Grand total after adding the Municipality Tax (3%) along-with the Home delivery charges (RO 1.500) in the Total amount of ordered Pizza(s) against each customer by using appropriate formula in the respected cells.