NMIMS BBA – B.Com Essentials of IT Solved Answer Assignment

Essentials of IT

NMIMS BBA – B.Com Essentials of IT Siolved Answer Assignment

1) Use the table presented below to answer the following questions:

• Highlight all the dates after October 10, 2018 (1 mark)
• Highlight all the grades above average in English (1 mark)
• Highlight all the duplicate names (1 mark)
• Highlight all cells greater than the median of the range in English. (2 mark)

• Use a data bar to show how big the marks in Maths are as compared to the other values in the range (2 mark)
• Sort the table to display marks in the ascending order of scrores obtained in Maths (2 mark)

1. Filter the table to display the results for students in the year 2018 (1 mark)

Ans:

Introduction

Using information bars to visually represent the dimension of marks in Maths compared to other values in the range can give many advantages. This sort of information visualization allows for simple contrast and analysis of data through its consolidation of metrics, research, and statistics.

Concepts and Applications

a.We need to pick all the cells that contain dates after October 10, 2018. These cells are highlighted by yellow color in the day column. We can highlight these cells by selecting them and applying color or shading.

Conclusion

Using data bars to stand for the dimension of Maths marks contrasted to various other values in the array can give an effective tool for information analysis and communication. Highlighting all cells higher than the array type in English can provide a concise and straightforward approach to data analysis.

NMIMS BBA – B.Com Essentials of IT Siolved Answer Assignment

2) Use the data presented in the table below to answer the questions that follow:

1. a) Use a clustered column chart to display the data below. What is the importance of using visualizations to interpret data? (5 marks)

2. b) With the help of a pivot table, present the sum of sales of the three products in April, May and June. Explain any three kinds of charts and the best scenarios under which they are used. (5 marks)

Ans:

Introduction

A pivot table is a handy device for data evaluation that allows you to review & examine large amounts of realities rapidly. By a pivot table, you could transform complex data into actionable insights. The charm of pivot tables depends on their versatility and modification. They permit you to filter, kind, group, and summarize your information in many methods.

NMIMS BBA – B.Com Essentials of IT Siolved Answer Assignment

Concepts and Applications

1. Here is a clustered column chart representing the information provided in the table:

Visualizations are essential when analyzing information since they allow us to understand designs & organizations, which may not be directly deceptive in a table of numbers. If we were looking at the raw numbers, they could help highlight patterns, outliers, and other information features that might be missed out on. Furthermore, visualizations can be far more remarkable and appealing than just reviewing a checklist of numbers, which can assist in connecting the essential findings to a broader audience.

Conclusion

Pivot tables are user-friendly and additionally user-friendly. They need little technological competence to use and create, making them obtainable to anyone who requires to analyze information. They are more adjustable, allowing you to change them to your specific requirements and preferences.

NMIMS BBA – B.Com Essentials of IT Siolved Answer Assignment

3) The data to be used for the pivot table is mentioned below. Present a screen-shot for each sub question.

1. Using a Pivot table, what is the sum of sales for each of the colours. (5 marks)

Ans:

Introduction

To produce a pivot table in Microsoft Excel, initially, we prerequisite to choose the information and afterward, most likely to the “Insert” tab and choose “Pivot Table” from the drop-down menu. After that, we need to specify the range of cells and select where to keep the pivot table.

Concepts and Applications

After developing the pivot table, we can respond to the adhering to sub-questions.

1. a) Utilizing a Pivot table, what is the summation of sales for separately of the colors?

To answer this inquiry, we need to slog the “Shade” area to the “Rows” part & the “Sales” field to the “Values” component. Below is the screenshot of the pivot table for this inquiry:

1. b) Utilizing a Pivot table, what is the summation of auctions for each region?

To answer this question, we need to drag the “Region” field to the “Rows” area & the “Sales” field to the “Values” location.

Conclusion

Pivot tables can be used for predictive analytics. Pivot tables could be used to classify designs & propensities in info, which could then be used for anticipating analytics. For instance, a pivot table could be used to analyze sales data and identify the items that will offer well in the future.

NMIMS BBA – B.Com Essentials of IT Siolved Answer Assignment

1. b) What is the sum of sales each year? How many units of each colour were sold?(5 marks)

Ans:

Introduction

Pivot tables are not restricted to assessing structured information in spreadsheets. They can likewise be used to analyze disorganized data, such as social media site messages or consumer feedback.

Concepts and Applications

Pivot tables can be used to do accomplice analysis. Cohort analysis is the process of analyzing teams of clients or customers over time. Pivot tables can be used to group data by mate and analyze patterns and patterns within each accomplice. These details can inform company decisions like marketing campaigns or item development. Pivot tables can be used for information visualization. Pivot tables could be made use of to generate images of data, like graphs or charts.

NMIMS BBA – B.Com Essentials of IT Solved Answer Assignment

Conclusion

Pivot tables can execute view analysis on big datasets, such as client evaluations or social networks blog posts. By grouping the information by sentiment, users can recognize patterns and trends in consumer feedback and act to enhance customer satisfaction.