Scribd
Upload
9 views1 page

Employee and Student Performance Analysis

Uploaded by

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

Employee and Student Performance Analysis

Uploaded by

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

1.

Employee Performance
Employee Target Achieved Achievement % Bonus (5% if ≥90%)
John 100 95
Sara 120 110
Alex 90 85
Emma 150 145
👉 Tasks:
1. Calculate Achievement
2. Use an IF formula to check if Achievement ≥90%, then Bonus = Achieved * 5%.
3. Insert a Bar Chart showing Target vs Achieved.

2. Student Marks Analysis


Name Math English Science Total Average Percentage
A 78 65 80
B 90 88 95
C 55 60 58
D 72 75 70
E 85 80 90
👉 Tasks:
1. Use SUM to calculate Total for each student.
2. Use AVERAGE to calculate their average marks.
3. Use Percentage formula:
4. Insert a Bar Chart to compare student totals.
5. Insert a Pie Chart to show the subject-wise contribution for one student.

1. Question:
The pie chart below shows the favorite fruits of 200 students in a school.
Fruit Percentage
Mango 35%
Apple 25%
Banana 20%
Orange 15%
Others 5%
Tasks:
1. Find the number of students according to fruits?
2. What is the total number of students who like banana and mango together?
3. Which fruit is liked by the least number of students?

You might also like