CREATE A CHART OR GRAPH
Point out to students
that charts and graphs provide an easy way to show relationships between
numbers. Explain that Excel makes it easy to create several different
kinds of charts and graphs. Provide students with the following directions
for creating a chart or graph showing the TV viewing habits of their
class:
- Highlight cells A2:A21
and B2:B21.
- Go to Insert>Chart,
or click the Chart button.
- On Step 1 of the Chart
Wizard, choose Column as the Chart type, and then click Next.
- For beginners, just
click Next on Step 2 of the Chart Wizard.
- On Step Three, type
Student TV Viewing as the title; Names as the Category
(X) axis; and Hours as the Value (Y) axis, and then click
Next.
- Click As New Sheet.
(If you don't, the graph will appear on top of the numbers in
the spreadsheet.)
- Click Finish.
Students' graphs should
resemble the graph below.
Encourage students to
change some of the information in their spreadsheets -- to insert
or delete a row, add a name, or change the number of hours of TV
viewing, for example. Ask: "What happens to the graph when information
in the spreadsheet is changed?"
Next: Learn more!
|