5th Grade Excel - Texas Cities

 

Useful website -

https://www.tsl.state.tx.us/ref/abouttx/popcity5.html

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 Nov 15 (5A). Late submission will be penalized - 10 points off for each late day.

E- Book Survey

Please take the survey below for Ms. Johnson
It would only take about 3 minutes

http://www.surveymonkey.com/s/PYGVKL9

Rocks and Minerals

Software and Programs

Paint
www.animoto.com
http://qrcode.kaywa.com/

Directions

On paint –
Define Rocks
Define Minerals

Find 3 examples of each
Make a paint page for each with interactive questions.

For example –  

I am dark grey and shiny

I am very fine grained
I am used in roofing, shingles and floor

What rock/mineral am I?

Make a video for each rock/mineral
Your video will have answers to your riddle

Site your reference on each video
Each video should be at least 20 seconds long

Put interactive questions and characteristics of the rock/mineral

Use the website http://qrcode.kaywa.com/ to convert your video into a QR Code and insert it into your paint document.

Print each paint page with the QR code on it.

Make a cover page with your name
Have Fun with this :)

Useful Website –

http://www.rocksforkids.com/RFK/identification.html

http://www.sciencespot.net/Pages/kdzethsci3.html
http://www.kidsgeo.com/geology-games/rocks-game.php

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