Student Organizer-Activity Two
Looking at the Numbers of Jews in the Last Century
World Jewish Population
World Jewish Population
Option 1: Using graph paper, create a graph using the information from the table above. Because this information deals with change over time, a line graph is a good choice for presentation. Be sure to label your x and y axes and units of measurement.
When you are finished, calculate the percentage increase or decrease for each of the years listed above.
Option 2: Use Excel to create a graph:
- Open a new spreadsheet in Excel by opening the program, then
selecting "File" and then "New." [If a prompt asks you to select
the type of document you would like to select, choose "Worksheet."]
- Paste the contents of the "Year" category above into column
"A" of the worksheet. Paste the contents of the "World Jewish
Population" into column "B." Then, select all the cells you have
just filled in by holding down the shift key and selecting each
cell with your mouse. [Note: You do not have to include the headings
"Year" and "World Jewish Population" on your worksheet.]
- With your two columns of information still selected, click
on the "Chart Wizard"
icon in the menu bar. If the "Chart Wizard" icon is not visible,
go to Insert > Chart. Select "Column" from the list on the left
of the "Chart Wizard" pop up window and then select the following
icon ("Clustered Column")
in the panel to the right.
- Then, click "Next." This should bring you to a section called "Data Range." Select "Columns."
- Then, look at the tabs at the top of the window. Tab from "Data Range" to "Series." You will see a preview of your chart. Look below your chart. On the left, you should see a white window panel with two listings, "Series One" and "Series Two." Select "Series One." "Series One" is the information you have listed in the "Years" column of your graph. It will turn into the x-axis on your chart. Look at the text field next to the word "Name:" If it does not say "Years," type it in now. Now, do the same thing for "Series Two," only this time, name it "World Jewish Population." Now these names will appear in your chart legend.
- Click "Next." Select the "Titles" tab from the top of the "Chart Wizard" window and type in the title of your chart, and the labels for your x and y axes. If you would like, explore the other tabs in the window. When you are ready, click "Next." Select either option, depending on whether you'd like your chart on a separate page or not. You're done!
- Note: If you would like to create a line graph instead of, or in addition to, the bar graph, choose "Line" from the menu in Step C instead of "Column." Be aware though, that Excel requires that you space your time intervals out evenly, and since the dates listed in the "Years" column are not evenly spaced, your chart will be slightly skewed.
When you are finished, calculate the percentage increase or decrease for each of the years listed on your chart.