Lunch Ordered
Students at WPS ordered the following lunch for the week of November 14th 2011.
Monday – 85 students ordered Pork Egg Rolls, there were 60 large portions ordered and 25 small portions.
Tuesday – 280 students ordered chicken nuggets, there were 168 large portions ordered and 112 small portions.
Wednesday – 152 students ordered pesto turkey sandwich, there were 82 large portions ordered and 70 small portions.
Thursday – 300 students ordered pizza, there were 188 large portions ordered and 112 small portions.
Friday – 130 students ordered beef taco, there were 87 large portions ordered and 43 small portions.
On excel make 5 columns with the following column heading –
· Day, Lunch, Orders, Large and small – 10pts
· Put in the data into the appropriate cell – 10pts
· Find the sum of the total orders, the large portion and the small portion – 10pts
· Find the min, max and average for the orders and portions – 30pts
· Select the lunch and order columns and make graph using the column chart. Your chart must have a title – 10pts
· Format data point of each column and insert the appropriate picture of the lunches to make a picture graph -15pts
· Go the internet and find pictures of the lunches for your columns.
· Change your orientation to landscape and type your name in the header before you print – 10pts
No comments:
Post a Comment