Fifth Grade Exam Review

Fifth Grade Exam Review

You are given the following facts –

Plot them into the indicated cells and calculate the sum,

Average, min and max

Make a column Graph

Landscape

Put your name and title ( Class Grades) in the header

Print

 

	A	B	C	D	E	F	G	H	I
1	Name	Student ID	Science	English	Math	History	Average Grade	Min	Max
2	Harry Henry	1234	87	90	80	92
3	Jonny Jones	1235	90	91	99	92
4	Sarah Smith	1236	80	81	75	85
5	Nick Nathan	1237	100	92	100	90
6	Lauren Larry	1238	96	85	100	80
7	Joe Jackson	1239	89	78	90	75
Total

 

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