Graphing Parish Population

Using Census Population for different decades in their parish, the teacher/students can graph results using the Excel Program.  Excel or Graph Master can be used as tools to graph population numbers. (Note the graphing program will need to be able to graph larger numbers.) Once completed and displayed, the class will discuss what the graph "shows them" about their parish. (Example: Growth: Has it grown? Have the numbers decreased? Ask why do they think the reasons could be.)

100 Years of Parish Population Using Excel

Print MS Word Directions with Pictures                 Print pdf Directions with Pictures  
Print MS Word Directions No Pictures                   Print pdf Directions No Pictures

1. Locate your Parish Population for each decade before you begin.

2.  Go in your start menu and locate “Excel”

3. Go under “A” column #1, you need to leave this box blank.

4.   Now slide to Column B #1 Type “Population

5. Under “A” column #2,Type “Year

6. Go under “B” column #2, you need to leave this box blank.

7.    Under “A” column near #3, type in 1900.

8. Now slide to Column B (still on line 3) and type in the population for 1900

9. Under “A” column near #4, type in 1910.

10.    Now slide to Column B (still on line 4) and type in the population for 1910.

11. Under “A” column near #5, type in 1920.

12. Now slide to Column B (still on line 5) and type in the population for 1920

13. Under “A” column near #6, type in 1930

14. Now slide to Column B (still on line 6) and type in the population for 1930

15. Under “A” column near #7  type in 1940.

16. Now slide to Column B (still on line 7) and type in the population for 1940.

17. Under “A” column near #8 type in 1950

18. Now slide to Column B (still on line 8) and type in the population for 1950.

19. Under “A” column near #9, type in 1960

20. Now slide to Column B (still on line 9) and type in the population for 1960.

21.    Under “A” column near #10, type in 1970.

22. Now slide to Column B (still on line 10) and type in the population for 1970.

23. Under “A” column near #11, type in 1980

24. Now slide to Column B (still on line 12) and type in the population for 1980

25. Under “A” column near #12, type in 1990

26. Now slide to Column B (still on line 13) and type in the population for 1990

27. Under “A” column near #13, type in 2000.

28.    Now slide to Column B (still on line 13) and type in the population for 2000.

29. Now take your mouse and drag to highlight all of your results then go under “Insert” at the top and click “Charts” and decide the type of chart you want to display.

30.    Click “Next” at the bottom.

31.    Type in the Title “Parish Population for 100 years”. Then type your name under Population.

32.    Then click the button that says “as new sheet” and title it “Parish Population for 100 years” and click finish.

33. For different color bars, click on the bar itself and you will see the color chart pop up.  Choose the color you want.

34.    Go to the top menu and find “file”.  Then drag it down and find “SAVE DATA SET AS” and click on that.

35. Save the data as your initials or name and parpop on the desktop. Example: Samparishpop or smparpop and print.

 

Example of Vermilion Parish Census

Vermilion Parish Census Data

1900

20,705

1910

26,390

1920

26,482

1930

33,684

1940

37,750

1950

36,929

1960

38,855

1970

43,071

1980

48,458

1990

50,055

2000

53,807

 

Vermilion Parish Curriculum Page  Elementary Links   3rd Grade Curriculum Link  Louisiana for Our Kids Site!  Vermilion Parish Schools  Testing Links   Graphic Organizers    18 Literacy Strategies

Vermilion Parish Schools (Louisiana)

Note: Most sites need Java. Adobe Flash, Shockwave, or Adobe Acrobat Reader
To report broken links or comments, please email
Stacy Bodin.

Hit Counter