Essentials of IT - NMIMS University MBA Solved Assignments Latest

 

Dear students, get fully solved assignments by professionals

Do send your query at :

help.mbaassignments@gmail.com

or call us at :08263069601

Essentials of IT

April 2023 Examination

 

 

1. Create a Pivot Table based on the information given in the worksheet which depicts the sales (in thousands) of Havdairy ice-cream flavours across cities in the month of April. Create a standalone PivotChart based on the given information. Present the total and sales across the different cities     (10 Marks)

TABLE BELOW

 

Flavours	City A	City B	City C	City C
Butterscotch	25	25	35	63
Vanilla	36	36	24	45
Strawberry	24	45	35	87
Chocolate	45	64	83	36
Kesar-Pista	64	63	69	24
Blackcurrent	35	85	45	35
Choco-Almond	85	69	87	85
Tender Coconut	69	57	35	69
Mango	57	36	52	24
Guava	63	24	45	45
Kala Jamun	45	45	64	64
Chickoo	87	64	63	75

 

Ans 1.

Introduction

A pivot table can be called a stats tool that briefs, summarizes, and reorganizes picked rows and columns in a database or spreadsheet to acquire a preferred report. The tool does not alter the database or spreadsheet itself; it just transforms or pivots the information to see it from different perspectives.

Pivot tables work with large quantities of data that would be costly in terms of time to compute by hand. A few information handling works a pivot table can do is recognizing sums, averages,

2. Refer to the table below to perform the tasks mentioned below:  (10 Marks)

a. Use Conditional formatting to highlight the quantity which is greater than 200 b. Use the slicer tool to filter data based on the item weight

c. Use an appropriate text function to combine the first name and the last name and display the results

d. Use the colour scale option and format the Item Weight. What does this indicate?

e. Use the strikethrough option ti mark out those dates that are between 07-05-2020 and

14-08-2020

f.  Explain the difference between SUM(), SUMIF() and SUMIFS() with an example

 

REFER TO THE TABLE BELOW

 

First Name	Last Name	Region	Met Sale Goal	Item #	Quantity	Item Weight	Item Manufactured on
Anurag	Shah	West	Yes	115-74	15	8	07-05-2020
Vedant	Patel	East	No	105-70	958	7	15-04-2020
Smithin	Rastogi	South	Yes	117-74	22	10	14-08-2020
Jagprit	Nair	North	Yes	121-49	69	12	30-04-2020
Prerak	Iyer	West	Yes	121-54	3	7	10-05-2020
Keshav	Hari	East	No	122-71	71	10	02-05-2020
Pavan	Sathe	North	Yes	120-49	113	8	14-08-2020
Tushar	Rego	East	No	122-71	532	7	14-08-2020
Shezil	Malhotra	North	Yes	119-36	212	11	13-04-2020
Hiren	Bhatia	West	No	107-35	371	10	02-05-2020
Shailendu	Shroff	East	Yes	104-55	147	10	13-04-2020
Pratik	Patel	West	Yes	113-65	79	8	10-05-2020
Mihir	Ashar	South	Yes	104-36	48	8	14-08-2020
Utkarsh	Chajjed	North	Yes	114-68	78	12	23-04-2020
Jigar	Nath	West	No	120-37	54	8	17-04-2020

 

 

Ans 2.

Introduction

First  Name	Last  Name	Full name	Region	Met  Sale	Item #	Quantity	Item	Item  Manufacture
							Weigh	d on
				Goal			t
Anurag	Shah	Anurag Shah	West	Yes	115	15	8	07-05-2020
					-74
Vedant	Patel	Vedant Patel	East	No	105	958	7	15-04-2020
					-70

 

 

3. Answer the questions that follow:

a. Explain the difference between data and information. Explain the need for databases.

What are the advantages of using Database Management Systems (DBMS) to manage data?      (5 Marks)

Ans 3a. 

Introduction

Data	Information
Data is superficial and unorganized truths.	Information consists of arranged, processed data provided in a purposeful context.
Data is a private component consisting of basic materials that do not have any meaning.	Information is a group of data that is collected and brings a rational meaning
	Information calls for data

 

 

b. Write a note on Database Languages that are used to perform different types of operations on an exisiting database  (5 Marks)

Ans 3b.

Introduction

Database languages, additionally data question languages, clarify an explanation of programming languages that programmers use to gain access to and define databases, which are collections of data that customers can access online. These languages enable users to fulfill jobs such as specifying, managing access to data, upgrading

 

 

            Dear students, get fully solved assignments by professionals

Do send your query at :

help.mbaassignments@gmail.com

or call us at :08263069601

 

Strategic Management - NMIMS University MBA Solved Assignments Latest

 

Dear students, get fully solved assignments by professionals

Do send your query at :

help.mbaassignments@gmail.com

or call us at :08263069601

 

NMIMS Assignment Solution April 2023

Strategic Management

April 2023 Examination

 

 

Q1. Founded  in  2011  and  launched  in  2013  in  St  Jose  California  USA,  Zoom  Video communications had made steady progress in the enterprise communications domain with a structured growth pattern, the company also received regular funding from venture funds and was listed on the New York Stock exchange in 2019. It was also the year in which Zoom hit profit territory, in December of 2019 Zoom had a total user base of 10 million; then, the pandemic struck, the user load of Zoom  zoomed from 10 million to 300 million by January of 2020, as the pandemic wanes Zooms growth rate is slowing down as well, the  drop in growth has seen its stock value plummeting in

2022. In a situation like this if you are the chief strategy officer of the company what plans would you make to acquire new customers. What would be your USP and how would you focus on the core business strategy to make the company more relevant for its consumers. (10 Marks)

Ans 1.

Introduction 

Zoom video communications, Inc, usually called Zoom, is an American technology company. Its headquarters lie in San Jose, The Golden State. It aids us in getting in touch with our family and friends living much from us through video seminars. It is additionally made used professionally by several companies for online conferences. It has a high user base and is extra well-known among people than any other company. Its key uses are video calls, talks, voice calls, digital occasions, and getting in touch with facilities. It additionally allows a free platform for third-party designers to

 

2. You are the marketing director of ISL the Indian Super league which is India’s premiere soccer league ISL has added 16% growth of viewership in 2020 season over 2019 season but the league compares poorly with the 400 billion viewers delivered by the IPL in 2020. What strategies would you adopt to make ISL popular amongst consumers?   Create a strategic plan with a 10-year vision. (10 Marks)

Ans 2.

Introduction 

Soccer is no question preferred throughout the entire globe. It is delighted in by numerous individuals. Whenever there is a soccer world cup, many people visit the host country and enjoy and buzz the game. But sadly, in India, the fad of soccer is not that much. People do enjoy football, yet it is less popular. Soccer gamers are underpaid because there are fewer. Yet, with time, soccer is likewise obtaining appreciated, and players are getting renowned for their skill and game. It will take a while; however, individuals will be as captivated by soccer

 

 

Q3. You are the CEO of super events a successful event organization working with top movie stars and organizing one of the marquee events in the annual entertainment calendar. During the pandemic, your business was completely shut down. Post pandemic the business environment is opening again.

a. As CEO of the company, what strategies would you evolve in ensuring your organization remains relevant in the post pandemic world? Evaluate and create the type of events your organization can get into to rebuild the business. (5 Marks)

Ans 3a.

Introduction

The Covid pandemic has hit the global economy very hard. Businesses have yet to have the ability to stand up to the pandemic. Many talks are taking place that the world economy is going into an economic downturn as the rising cost of living is already high in all the countries. Businesses must develop new strategies to help them through these challenging

 

b. Create a blueprint for the diversifications your organization can adopt for expanding its business.  (5 Marks)

Ans 3b.

Introduction

Business expansion is complex as it requires a considerable circulation of funds and an increased workforce. A company must create an appropriate strategy and execute it effectively to attain preferred

 

 

            Dear students, get fully solved assignments by professionals

Do send your query at :

help.mbaassignments@gmail.com

or call us at :08263069601

 

NMIMS Assignment Solution April 2023