NMIMS BBA – B.Com Essentials of IT Siolved Answer Assignment
11
Oct
2024
Essentials of IT
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)
Filter the table to display the results for students in the year 2018 (1 mark)
Date
Name
English
Math
03-11-2018
Dhaval
59
79
11-05-2019
Prerak
56
59
03-12-2018
Harsh
75
60
26-09-2019
Donny
99
78
12-04-2018
Madhavi
86
87
03-01-2019
Meet
72
88
06-05-2018
Hannah
89
71
21-06-2019
Pooja
67
78
24-07-2019
Dhaval
76
99
22-04-2018
Harsh
80
54
08-06-2019
Dean
71
57
17-10-2017
Ruchi
56
95
28-01-2018
Shailaja
63
55
19-03-2019
Aarti
100
91
18-08-2019
Zeenat
100
76
19-10-2017
Aarti
76
79
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
Date
Name
English
Math
03-11-2018
Dhaval
59
79
11-05-2019
Prerak
56
59
03-12-2018
Harsh
75
60
26-09-2019
Donny
99
78
12-04-2018
Madhavi
86
87
03-01-2019
Meet
72
88
06-05-2018
Hannah
89
71
21-06-2019
Pooja
67
78
24-07-2019
Dhaval
76
99
22-04-2018
Harsh
80
54
08-06-2019
Dean
71
57
17-10-2017
Ruchi
56
95
28-01-2018
Shailaja
63
55
19-03-2019
Aarti
100
91
18-08-2019
Zeenat
100
76
19-10-2017
Aarti
76
79
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.
2) Use the data presented in the table below to answer the questions that follow:
a) Use a clustered column chart to display the data below. What is the importance of using visualizations to interpret data? (5 marks)
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)
Month
Ink Pens
Erasers
Pencils
Jan
897
983
768
Feb
732
547
987
Mar
500
330
763
Apr
122
832
643
May
893
739
567
Jun
734
453
734
Jul
891
874
678
Aug
559
833
546
Sep
433
244
765
Oct
734
873
342
Nov
873
459
324
Dec
730
433
154
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.
Concepts and Applications
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.
3) The data to be used for the pivot table is mentioned below. Present a screen-shot for each sub question.
Date
Colour
Region
Units
Sales
03-Jan-16
Red
North
1
300
13-Jan-16
Blue
East
8
2400
21-Jan-17
Green
West
5
400
30-Jan-17
Blue
South
7
560
07-Feb-16
Green
North
8
2400
13-Feb-18
Red
East
6
760
21-Feb-16
Blue
West
7
770
01-Mar-19
Green
South
2
240
13-Mar-16
Blue
North
7
770
23-Mar-18
Blue
East
6
840
28-Mar-17
Green
West
4
560
03-Apr-19
Blue
South
5
670
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.
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:
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.
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.
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.
Dr. Aravind Banakar prepares two types of Assignments. General assignments & Customized assignments. Both assignments are 100 % Plagiarism-free.
Dr. Aravind Banakar is the number 1 NMIMS Academic Writing Professional. He is a highly experienced academic professional and a reputable and reliable academic content writer with over 24 years of experience. You can obtain ready-made, customized, plagiarism-free MBA, BBA, EMBA, and B.Com assignments.
Important Notice for NMIMS Assignments:
To ensure your NMIMS assignments meet the university’s standards, The NMIMS Assignments must be 100% customized, plagiarism-free, and unique.
Copying from Google, AI tools, blogs, books, or any other sources is strictly prohibited, and if you copy answers, you will get ZERO marks.
Before purchasing assignments from any academic writer, always demand the following verification:
Remember, these reports are not just a formality. They are your shield against ZERO marks. Take charge of your grades by ensuring your work is original and meets NMIMS standards.
Dr. Banakar leads a team of over 100 PhD-qualified professionals dedicated to creating high-quality, plagiarism-free assignments tailored to meet the exact standards and requirements of NMIMS. With a proven track record, students who have used his services often score 25+ marks out of 30, highlighting the level of detail, precision, and thorough research into every assignment. This emphasis on research instills confidence in the quality of the work.
