Reference no: EM132893123 , Length: word count:2000

GCO4009 Business Applications - Gulf College

Assessment Scenario based Project

Task 1: Microsoft Excel

Home Budget Management System

A Private House owner wants to introduce the automation process to manage the monthly home budget. In this regard, he decided to assign this task to you as a developer.
Moreover, you are requested by him to prepare and submit a month-wise Annual Report in Excel worksheet to keep the complete record of home budget along-with the computational remarks.

The task should contain the following:

Task 1 (a):

i. Create a COMPLETE worksheet along-with the sample data of Grocery expense, Electricity bill, Water bill and other expense (if any) with appropriate labels for the above-mentioned Scenario.
ii. Calculate the total expense after adding all above-mentioned expense collectively by using the appropriate formula in the respected cell.
iii. Identify the Remarks against each month by using IF statement.
Condition for Remarks:
IF, Total expense of each month is more than OR equal to RO. 300, remarks would be "Saving required",
IF, Total expense of each month is less than to RO. 300, remarks would be "Satisfactory".

Task 1 (b)

Also, provide the following statistical data:

i. Count "Number of months" mentioned in the table.
ii. Calculations of "Highest" figure of expense from the Total expense column.
iii. Calculations of "Lowest" figure of expense from the Total expense column.
iv. Count the remarks "Saving required" from "Remarks" column.
v. Count the remarks "Satisfactory" from "Remarks" column.

Task 1 (c)

Draw a labelled "Pie chart" that will show the Total expense of each month mentioned in the table and save the spreadsheet as Task1_ID_MS Excel.

Task 2: Microsoft PowerPoint

Use the statistical data given in "Task 1" and prepare four PowerPoint slides Presentation. The Slides should be arranged as follows:

1. Introduction (Slide 1)
2. Comprehensive Information along-with Pie chart (Slides 2 and 3)
3. Overall insight and outcome of the presentation (Slide 4)

Note:

Use more than one different slide layouts and save the presentation as Task2-ID-MS PowerPoint.

Task 3: Microsoft Access

Create a table related to the "Task 1" in Microsoft Access by using different field data types that will show the complete record of month-wise Annual report of Home budget. You are also required to generate a report of "Saving required" months shown in Remarks column and save with a filename Task3-ID-MS Access.

Attachment:- Business Applications.rar