Salina Intermediate Teacher Technology Training Camp - Excel Agenda

Excel Graphs Activities:

1. Math: A.RP.06.08 Understand that relationships between quantities can be suggested by graphs and tables. Activity - Conducting a Survey: Students may conduct a survey and create a line graph to illustrate the results of the survey. Some simple survey topics can include:
a. Who is your favorite athlete?
b. What is your favorite type of animal?
c. What is your favorite class?

2. Science: S.IP.06.15 Construct charts and graphs from data and observations. Activity – Comparing height or temperature: Students may construct a bar graph comparing the height of animals, people, or other objects. Additionally, you could create a bar graph of the high or low temperatures during the week.

Making a Graph:

A. Type in the data in vertical columns. The first column should have the object. The second column should have the data.
Sample:
Monday 54
Tuesday 56
Wednesday 58
Thursday 62
Friday 59
Saturday 60
Sunday 63

B. Highlight the data.
C. Click on ChartWizard.
D. Select the type of graph you wish to use.
E. Adding X axis labels: Click on Series.
a. Click on Category X axis labels.
b. Highlight the data that you wish to use as X axis labels.
c. Press Enter on the keyboard.
F. Press Next.
G. Enter in the following information:
a. Chart Title
b. X Axis Values
c. Y Axis Values
H. Press Next.
I. Press Finish.