|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Provided numerical data to create Basic Charts and Scatter Plots
for Technology and Mathematics for Teachers! |
|
|
|
( First thing to be done with this activity is
to print out this Spreadsheet so as to be able to read directions. ) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
A |
|
B |
|
C |
|
D |
|
X |
Y |
|
|
|
|
######## |
|
######## |
|
######## |
|
######## |
|
######## |
######## |
|
|
|
|
1 |
|
9 |
|
42 |
|
91 |
|
2 |
6 |
|
|
|
|
3 |
|
8 |
|
19 |
|
28 |
|
4 |
12 |
|
|
|
|
5 |
|
7 |
|
53 |
|
84 |
|
6 |
18 |
|
|
|
|
7 |
|
6 |
|
27 |
|
17 |
|
8 |
24 |
|
|
|
|
9 |
|
5 |
|
64 |
|
75 |
|
10 |
30 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1. Click on the Number One beneath the Letter A. Drag downward to select all the
numbers. Only numbers are to be Charted! |
|
2. After all the numbers have been selected ( highlighted ), Click on Chart Icon (Looks like colored Bars!) at top of Spreadsheet. |
|
|
3. When the Chart Menu appears, at the left
under Chart Type, Click Line for the set of numbers under letter
A then click Finish. |
|
|
4. Notice created Chart which has
appeared. Now, Click any cell outside chart
in Spreadsheet then click Chart then click Delete. |
|
|
5. Continue Chart creating procedure using Pie for the Letter B then Column for the Letter C. Note Chart then Deleete Chart. |
|
|
6. The 4th Basic Chart ( Picto ) does not show
up well without a lot of work and sometimes frustration. So, Let's not do that one. |
|
|
7. Now for a little advanced Graphing Skill, The Scatter Plot which Graphs
a set of two groups of related numbers.
Not A Chart! |
|
|
8. Click and Drag to select (highlight) the numbers under X & Y. Only the numbers. Click Chart
Icon at the top of Spreadsheet. |
|
|
9. After the Chart Menu appears at the left of
the window Click on Scatter Plot and select the second option in the first column. |
|
|
10. Click Finish! A Scatter Plot of Two Sets of
Numbers should appear. Note the Horizontal Numbers versus Vertical Numbers. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Which set of numbers is Increasing or Decreasing? Which is not? Create another set of related numbers for X & Y then Graph! |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
After you have become comfortable with
Charting & Plotting numbers, select any set of numbers and complete any
Chart of your choice! |
|
After Chart appears, use Control C to copy it!
Minimize the Spreadsheet! Open
a Word Processing File! Hit
Enter/Return a few times. |
|
Now, use Control V to paste the Chart onto the WP document! Center the Chart! Write a few words above the Chart to
describe it! |
|
Now, Save & Print the Word Processing Document with Descriptive
Words and the Centered Chart! Ask if
you can't Center Chart! |
|
|
|
|
|
|
|
|
|
|
|
|
|
. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|