Scribd
Upload
12 views4 pages

Excel Project Work

The document contains three datasets: student test scores, a weekly weather report, and school tuckshop sales. Each dataset includes specific data points and instructions for entering the data into Excel, applying conditional formatting, and creating charts. The document outlines tasks to analyze and visualize the data effectively.

Uploaded by

madhavv.deva
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
12 views4 pages

Excel Project Work

The document contains three datasets: student test scores, a weekly weather report, and school tuckshop sales. Each dataset includes specific data points and instructions for entering the data into Excel, applying conditional formatting, and creating charts. The document outlines tasks to analyze and visualize the data effectively.

Uploaded by

madhavv.deva
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

90S🟦 Dataset 1: Student Test Scores

Scienc
Student Name Maths English
e
Amina 78 85 74
Kwame 65 72 80
Yaw 90 88 92
Sarah 55 60 50
Kojo 82 79 87
Linda 70 75 68
Fred 95 92 88
Akua 60 65 72
Daniel 77 80 76
Kofi 83 89 85
Cynthia 58 61 64
Michael 88 91 95
Benedicta 72 70 69
Ebenezer 66 63 60
Anita 79 83 81
Isaac 54 49 59
Lucy 92 87 90
Felix 47 50 55
Nana Ama 68 74 73
Richmond 76 78 70

78📝 Try Questions:

1. Enter the data into Excel.


2. Add a column titled Average Score using a formula.
3. Use Conditional Formatting to highlight:
a. Scores below 60 in red.
b. Scores above 85 in green.
4. Sort the data by Average Score in descending order.
5. Create a bar chart showing each student's average score.
🟨 Dataset 2: Weekly Weather Report
(Extended - 4 Weeks)

Wee Temperature Rainfall Wind Speed


Day
k (°C) (mm) (km/h)

Monday 1 30 5 10
Tuesday 1 32 0 12
Wednesd
1 28 15 8
ay
Thursday 1 25 20 5
Friday 1 31 2 9
Monday 2 29 4 11
Tuesday 2 33 1 13
Wednesd
2 26 18 7
ay
Thursday 2 27 12 6
Friday 2 30 3 10
Monday 3 28 6 9
Tuesday 3 34 0 14
Wednesd
3 31 10 9
ay
Thursday 3 26 22 4
Friday 3 33 2 11
Monday 4 30 7 10
Tuesday 4 29 5 12
Wednesd
4 25 19 6
ay
Thursday 4 28 10 5
Friday 4 32 0 13

📝 Try Questions:

1. Enter the data into Excel.


2. Use Conditional Formatting to:
a. Highlight temperatures above 30°C in orange.
b. Highlight rainfall above 10 mm in blue.
3. Calculate the average temperature for each week.
4. Calculate the total rainfall for each week.
5. Create a line chart for temperature over time.
6. Create a bar chart comparing weekly total rainfall.

🟩 Dataset 3: School Tuckshop Sales


(Extended)
Catego Price Quantity Total
Item
ry (GHS) Sold Sales
Meat Pie Snack 5 40

Water Drink 2 80

Juice Box Drink 4 50

Fried Rice Meal 10 20

Sandwich Snack 6 25

Biscuit Snack 3 35

Coconut Fruit 4 18

Milk Drink 3 55

Yam Chips Meal 8 22


Sausage
Snack 5 42
Roll
Donut Snack 4 30

Malt Drink Drink 5 27

Apple Juice Drink 6 33

Pineapple Fruit 3 20

Spring Roll Snack 6 19

Cake Slice Snack 4 24


Boiled Egg Snack 2 50

Fufu Meal 12 15

Kenkey Meal 5 17
Orange
Drink 5 29
Juice

📝 Try Questions:

1. Enter the data into Excel.


2. Calculate the Total Sales using a formula (Price × Quantity Sold).
3. Format Price and Total Sales as currency (GHS).
4. Use Conditional Formatting to highlight:
a. Items that sold more than 40 units in green.
b. Items that made over GHS 200 in sales in blue.
5. Sort the data by Total Sales from highest to lowest.
6. Create a pie chart showing the percentage of Total Sales by
Category.

You might also like