




























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! 













. 









































