5th Grade - Excel - Picture Graph and Functions (sum, min, max and Ave)

 Lunch Ordered

Students at WPS ordered the following lunch for the week of November 14^th 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

2nd Grade and 3rd Grade Blog

Hi 2nd Graders!! Click on the link below to go to your teacher's blog


Mrs. Wilkins Class - http://mrswilkins2ndgrade.blogspot.com/

Mrs. Meeks Class -  http://mrsmeeks2ndgrade.blogspot.com/

Mrs. Blevins Class - http://www.tblevins.blogspot.com/

Cool Web Site for K - 5

http://www.abcya.com/

Learning and having fun!!

5th Grade - Excel

                        Texas Cities

                                                

1. Your assignment is to create a spreadsheet of the population of 10 Texas cities.
2. Use the map above and the internet to find your information.
3. Create a line chart.
4. Make sure your chart has a title
5. Then add up the populations to find the sum of Texas population.
6. Find the average, the minimum and maximum population.
7. Change the page orientation to Landscape
8. Click on Page Layout View and insert your name in the header.
9. Print and save work in your folder. Also save your work in your Flash Drive.              

5th Grade - Excel

Week of Oct 17                  5^th Grade Computer Class

Remember to save all work in your flash drive

·         Go to the inter net and find prices for the following vehicle

o   Hummer

o   Avalanche

o   Acura MDX

o   Honda Element

o   Nissan

o   Infinity QX4

o   Lexus GX 470

o   Porsche Cayenne

o   Mercedes-Benz ML555

o   BMW X5

o   Cadillac Escalade

o   Land Rover

o   Toyota Sequoia

o   Toyota Camry

·        Open Excel and  plot in the names  of the cars and prices

·        Find the minimum price, maximum, average and sum of all the cars

http://www.carmax.com      Zip Code - 77380