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 datadriven
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 metrics and aid in identifying focus areas for the upcoming quarter.
By leveraging IT-based analysis, businesses can make informed decisions, allocate resources
It is only half solved
Get Complete assignment help from us
Price – 290/ assignment
NMIMS Complete Solved Assignments
Available for session DEC 2024
The last date is 29th NOV- 2024
Our assignment help is affordable
Our goal is to provide you with the best and the cheapest services
Contact No – 8791514139 (WhatsApp)
OR
Mail us- [email protected]
Our website – www.assignmentsupport.in
Online buy – https://assignmentsupport.in/shop/
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
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.
a. Highlight the percentage column in blue for any team member achieving above 120%
of their target (1 mark)
b. Display data bars for the actual revenue column to visually represent the revenue
generated by each team member (1 mark)
c. Highlight the team member named James Dawson in orange with bold black font (1
mark)
d. 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. to evaluate individual performance and identify underperforming