BBA/B.Com Essentials of IT

Description

Essentials of IT

Dec 2024 Examination

 

 

 

PLEASE NOTE:  This assignment is application based, you have to apply what you have learnt in this subject into real life scenario. You will find most of the information through internet search and the remaining from your common sense. None of the answers appear directly in the textbook chapters but are based on the content in the chapter

Q1. You are the sales manager at XYZ Retail, overseeing the performance of three major product categories: Electronics, Clothing, and Groceries. You’ve compiled the sales data for the past six months to help guide your team’s strategy for the next quarter. You must analyze this data to identify trends and determine where to focus your efforts. Use the provided dataset to visualize the information and answer the following questions.

Month	Electronics	Clothing	Groceries
January	120	80	50
February	140	75	60
March	130	85	70
April	150	90	80
May	160	95	90
June	170	100	100

 

1. Create a line chart representing the monthly sales trends for all three product categories from January to June. Ensure the chart clearly distinguishes between each category. What insights can you draw from the line chart about the sales performance over time? (2 marks)
2. Generate a bar chart comparing the sales of the three categories across months. Based on the bar chart, which product category had the highest sales in June? (2 marks)
3. Create a pie chart to show the percentage contribution of each product category to total sales in May. Which category contributed the largest share of sales in May, and what was the approximate percentage? (2 marks)
4. What is the average monthly sales for Electronics, Clothing, and Groceries? Which category has the highest average monthly sales? (2 marks)
5. Use the Sort function in Excel to arrange the table in descending order based on the Electronics sales column, with the highest sales listed first. (2 marks)

(10 Marks)

Ans 1.

Introduction

Information Technology plays a crucial role in modern business operations by enabling data-driven decision-making. For sales managers, analyzing and interpreting sales data using IT tools such as Excel and visualization techniques is essential to identify trends, assess category performance, and optimize strategies. In this assignment, sales data for Electronics, Clothing, and Groceries at XYZ Retail is analyzed over six months to derive actionable insights. Using line charts, bar charts, and pie charts, the trends and contributions of each product category are explored, providing clarity on performance dynamics. Additionally, functions like sorting and averaging reveal key

 

It is only half solved

 

Buy Complete from our online store

 

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

 

NMIMS Fully solved assignment available for session DEC 2024,

 

your last date is 4^th Dec 2024.

 

Lowest price guarantee with quality.

Charges INR 199 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 OR Contact no is +91 8755555879

 

 

 

 

Q2(A) You are considering taking out a loan to buy a new house. You have two options for the loan and need to calculate the monthly payment for one and the duration of payments for the other.

Loan Option 1:

– Loan Amount: Rs. 2,000,000

– Annual Interest Rate: 6%

– Loan Term: 20 years (240 months)

Loan Option 2:

– Loan Amount: Rs. 2,000,000

– Annual Interest Rate: 6%

– Monthly Payment: Rs. 15,000

1. Use the PMT() function to calculate the monthly payment for Loan Option 1. What is the monthly payment for Loan Option 1? (2 marks)
2. Use the NPER() function to fully calculate the total payments needed to repay Loan

Option 2. How many months will it take to pay off Loan Option 2 with a monthly payment of Rs. 15,000? (3 marks)

(5 Marks)

Ans 2A

Introduction

When considering loans for large investments such as purchasing a house, it is essential to evaluate repayment terms and financial feasibility. Loan calculations involve key parameters such as loan amount, interest rate, repayment term, and monthly payment. Using financial formulas like PMT() for monthly payment and NPER() for the number of payments, borrowers can make informed decisions. This analysis compares two loan options for a house purchase to determine the monthly payment for one and the duration of payments for the other.

Concept with

 

 

Q2(B) The annual performance report for the marketing team at XYZ Ltd. is shown below. The table displays each team member’s name, target assigned to them, generated revenue, and performance percentage. To identify which regions are underperforming, you want to highlight cells using different conditional formatting styles in the table.

1. Highlight the percentage column in blue for any team member achieving above 120% of their target (1 mark)
2. Display data bars for the actual revenue column to visually represent the revenue generated by each team member (1 mark)
3. Highlight the team member named James Dawson in orange with bold black font (1 mark)
4. Use purple to show a team member with a target of less than Rs. 1,00,000 in revenue (2 marks)

Marketing Team – Annual Performance Report

Name	Target (in Rs.)	Actual Revenue (in Rs.)	Performance (%)
James Dawson	1,25,000	1,47,500	118.00%
Sofia Malik	1,50,000	1,65,000	110.00%
David Menon	90,000	1,05,000	116.67%
Emily Walker	85,000	1,20,000	141.18%
Noah Abraham	1,30,000	1,50,000	115.38%
Sarah Lee	70,000	60,000	85.71%
Jack Richardson	1,10,000	1,38,000	125.45%
Mary Ann	95,000	94,750	99.74%
Olivia George	1,40,000	1,48,000	105.71%
Peter Johnson	1,00,000	1,20,000	120.00%

 

(5 Marks)

Ans 2B

Introduction

Conditional formatting is a powerful tool in Excel that helps visually analyze data by applying specific formatting styles based on defined criteria. It is widely used in business reports, such as performance evaluations, to quickly identify trends, highlights, and underperformance. In this case, we will apply conditional formatting to the annual performance report of the marketing team at XYZ Ltd.