Excel-ent Direction

Excel–ent Directions

1.     Open Excel

2.    Change page orientation to landscape

3.    Press the caps lock button

4.    In cell C4 type X and Center it

5.    Copy and Paste into cells: C5 – C8,

 E4 –E8

 C12 – C17

 E12 – E17

6.    In cell K 17, type LLLLL and Align Right

7.    Copy and Paste into cell L17 and Align Left

8.    In cell G17, type CCCCCC and Center Align

9.    Copy and Paste into cell G4

10.  In cell E9, type XXXX and Align Left

11.  Copy and Paste into cell E11

12.  In cell K4, type L and Center

13.  Copy and Paste into cells K5- K 16

14.  In Cell F5, type CCCC and Align Right

15.  Copy and Paste into cell F16

16.  In cell D10, type XXXXXX and center

17.  Copy and Paste into cell F6 – F15, then center

18.  In cell I4, type EEEE and Align Right

19.  Copy and Paste into cells:         I10

                                                                        I17
                                                                        A4
                                                                       A10
                                                                       A17

20. In cell C9, type XXXX and Align Right

21.  Copy and Paste into cell C11

22. In cell A16, type E and Center

23. Copy and Paste into cells:        A5 – A9

                                                                      A11 – A15
                                         I5 – I9
                                         I11 – I16

24. In cell H5, Type C and Align Left

25. Copy and Paste into cells:         H6

                                                                       H15
                                                                       H16

26. In cell J4, type EEEEEE and Align Left

27. Copy and Paste into cells:        J10

                                                                      J17
                                                                      B4
                                                                      B10
                                                                      B17

28. Preview the page, then print

5th Grade Excel - Pictograph

Pictograph - Lunch Ordered

Students at WPS ordered the following lunch for the week of October 15^th 2012.

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

5th Grade Computer Class

Car Prices        

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
oCar of your Choice
oCar of your Choice

 

· Open Excel and put in the names of the cars and prices in column A and B

· Find the minimum price, maximum, average and sum of all the cars
·Make a bar graph to compare the car prices. Do not include the min,max and average.
·Change page orientation to Landscape
·Change page layout and put your name, date and title in the header.
·Due on Thursday Oct 11 for 5A and Monday Oct 15 for 5B
 

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

6th Grade - Computer Systems

1. The Computer System

a. How a computer system works

b. System Software

c. Application Software

2. Types of Computer

3. Computer Memory

a. Random Access Memory (RAM)

b. Read Only Memory (ROM)

4. Parts of a Computer System

a. Hardware

i. Input Devices

ii. Output Devices

b. Software

i. Operating System Software

ii. Application Software

Due on Wednesday Oct 17. One extra day for students absent during the week.

Useful Websites -
http://www.factmonster.com/ipka/A0774696.html

http://library.thinkquest.org/5862/

http://homepage.cs.uri.edu/faculty/wolfe/book/Readings/Reading04.htm

5th Grade Excel - Texas Cities Population

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. Open Microsoft Excel
4. In cell A1 type - Texas Cities. In cell B1 type 2010 population and in C1 type 2011 population.
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. Create a line chart.
10. Make sure your chart has a title
11. Print and save work in your folder. Also save your work in your Flash Drive.
12. Due on Thursday Nov 14 (5B) and Friday (5A). Late submission will be penalized - 10 points off for each late day.