Scribd
Upload
18 views2 pages

Assignment

The assignment focuses on practical applications of IT tools, specifically spreadsheets and word processing, to analyze business data for a retail store. Students are required to create a dataset, apply formatting, use functions and formulas, analyze data with pivot tables and charts, and report their findings in a Word document. Submissions must be made in specified formats and named appropriately before the deadline.

Uploaded by

saa
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
18 views2 pages

Assignment

The assignment focuses on practical applications of IT tools, specifically spreadsheets and word processing, to analyze business data for a retail store. Students are required to create a dataset, apply formatting, use functions and formulas, analyze data with pivot tables and charts, and report their findings in a Word document. Submissions must be made in specified formats and named appropriately before the deadline.

Uploaded by

saa
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Assignment: Practical Application of Basic IT Tools

Course: Basic IT Tools


Objective:
This assignment is designed to help students develop hands-on experience with spreadsheets
and word processing by solving real-life problems. Students will work with actual data, apply
IT tools effectively, and generate meaningful insights.
Submission Guidelines:
v Submit the assignment containing:

Ø Spreadsheet (.xlsx)

Ø Word Document (.docx)

v Clearly name your files as StudentName_College Roll No.

v Upload to Google Classroom before the deadline.

Spreadsheet Application – Business Data Analysis


Scenario: You are working as a data analyst for a retail store. The manager has given you sales
data for the last three months and wants insights to improve business performance.
Task:
1) Data Entry & Formatting:
a) Create a dataset for sales records with at least 30 rows and the following columns:
i) Date of Sale
ii) Product Name

iii) Category (Electronics, Clothing, Groceries, etc.)

iv) Quantity Sold

v) Selling Price per Unit

vi) Total Sales Amount (Use a formula to calculate: Quantity Sold × Selling Price per

Unit)
b) Apply cell formatting (bold headers, color coding, borders).

c) Use conditional formatting to highlight the top 5 selling products.


2) Functions & Formulas:
a) Calculate the total revenue generated using the SUM function.
b) Find the average sales amount per product using the AVERAGE function.

c) Identify which products had sales greater than Rs. 500 using an IF condition.
d) Implement absolute and relative references in calculations.
3) Data Analysis:
a) Create a pivot table to analyze sales performance by category.
b) Generate a bar chart representing monthly sales trends.

c) Insert a pie chart showing the percentage contribution of different product categories to
overall sales.
4) Report Findings:
a) Prepare a report in Microsoft Word of all the findings and interpret the key insights
from the charts and pivot table.

You might also like