B.Com/BBA Essentials of IT June 2024

Description

Essentials of IT

June 2024 Examination

 

 

Q1. Create a pivot table of the property portfolio to show:      (10 Marks)

• The ‘asking price’ is the value field
• The ‘type of property’ in the rows
• The ‘location’ of the columns
• The variables in the Filter are;’bedroom’, ‘stories’, ‘furnishing status’.

Change the filters according to point given below, find out average ‘asking price’ and then

aggregate functions to show a count of properties that have:

• Three bedrooms; Furnished and two-storied house

Present your findings from the Pivot Table created.

Link to the dataset :  https://docs.google.com/spreadsheets/d/1hTSIO6597cx9bkJthAz3ka- oylkE6Zvo/edit?usp=sharing&ouid=109847162970842203843&rtpof=true&sd=true

Ans 1.

Introduction:

The pivot table analysis of the property portfolio provides valuable insights into the asking prices based on various attributes such as the type of property, location, number of bedrooms, stories, and furnishing status. This analysis helps in understanding the average asking price of properties with specific characteristics, such as three bedrooms, furnished, and two stories. By using pivot tables, we can easily filter and analyze the data to identify trends and patterns in the property market, which can be crucial for making informed decisions.

Concept

It is only half solved

 

Buy Complete from our online store

 

https://nmimsassignment.com/online-buy-2/

 

NMIMS Fully solved assignment available for session JUNE 2024,

 

your last date is 29^th May 2024.

 

Lowest price guarantee with quality.

Charges INR 350 only per assignment. For more information you can get via mail or Whats app also

Mail id is [email protected]

 

Our website www.aapkieducation.com

After mail, we will reply you instant or maximum

1 hour.

Otherwise you can also contact on our

whatsapp no 8791490301.

Contact no is +91 87-55555-879

 

 

 

Q2. As a healthcare provider, you’re considering implementing a new Electronic Health Record (EHR) system for your practice. You’re curious about the role of a Database Management System (DBMS) in this context and would like to understand the significance of DML and DDL. How would you respond to this inquiry?      (10 marks)

Ans 2.

Introduction:

The implementation of a new Electronic Health Record (EHR) system is a pivotal decision for healthcare providers, impacting the efficiency, accuracy, and accessibility of patient information. A crucial component in this process is the Database Management System (DBMS), which is responsible for managing the EHR data. Understanding the role of a DBMS, particularly the Data Definition Language (DDL) and Data Manipulation Language (DML), is essential for healthcare providers considering EHR implementation. DDL is used to define the structure of the database, including tables, fields, and relationships, while DML is used to retrieve, insert, update, and delete data in the database. This paper explores the significance of DDL and DML within the context of a DBMS in EHR implementation, highlighting their importance in

 

Q3a. You are a sales manager at a retail company and have been given a dataset containing monthly sales information for the past year. Your task is to perform various calculations and analysis using Excel functions to derive meaningful insights from the data.

The dataset includes the following columns:

• Month: The month of the sales report (e.g., January, February, etc.).
• Units Sold: The number of units sold in the respective month.
• Revenue: The monthly Revenue generated from sales in dollars.
• Cost of Goods Sold (COGS): The monthly cost incurred to produce the sold units.
• Gross Profit: The monthly gross profit calculated as (Revenue – COGS).

Month	Units Sold	Revenue	Cost of Goods Sold (COGS)	Gross Profit
January	1000	15000	8000	7000
February	1200	18000	9000	9000
March	1500	20000	10000	10000
April	1300	19000	9500	9500
May	1400	21000	10500	10500
June	1600	22000	11000	11000
July	1700	23000	11500	11500
August	1800	24000	12000	12000
September	1600	23000	11500	11500
October	1500	22000	11000	11000
November	1400	21000	10500	10500
December	1600	24000	12000	12000

 

Using the provided dataset, perform the following calculations and analysis using Excel functions:   

1. Calculate the average monthly  Revenue for the months  presented in  the table (January-December).
2. Find the maximum monthly Gross Profit and identify the month in which it occurred.

Apply conditional formatting to colour-code the cells in the “Gross Profit” column based on the gross profit margin. For example, cells with a gross profit margin above

50% could be highlighted in green, those between 30% and 50% in yellow, and below 30% in red.

3. Apply conditional formatting to create a data bar in the “Revenue” column to visualize the revenue performance across months.
4. Calculate the total Gross Profit for the months presented in the table (January- December).
5. Compute the percentage change in Revenue from September to October.

Ans 3a.

Introduction

In the retail industry, analyzing sales data is crucial for understanding performance and making informed decisions. This report analyzes a dataset containing monthly sales information, focusing on key metrics like revenue, cost of goods sold (COGS), and gross profit. Using Excel functions, we’ll calculate average monthly revenue, identify the month with the maximum gross profit, apply conditional formatting to visualize data, calculate total gross profit, and compute the percentage change in revenue between two months. These analyses will provide