"Effective teachers apply technology in the
classroom."
Files marked with an asterisk* require Adobe Acrobat Reader to be viewed.
This software is free.
The introduction of
Information and Communication Technology (ICT) as a new core curriculum subject
will have a tremendous impact on teachers and students in the classroom. It is now compulsory *
for me as a teacher to become conversant with both the use and instruction of
modern technology as a means of exploring and obtaining the goals of the other
core curricular objectives.
Technology is one of the most rapidly changing elements of the classroom. The use of technology in its many forms can
have a phenomenal impact on student learning.
I have found my lessons, and their preparation, to be immeasurably
improved by the use of new technologies.
It is through the use of technology that I spend less time preparing
lessons and more time honing and improving them.
Artefact One

return to artefact links

return to artefact links
Data
Management Lab
Using
Excel to Make a Graph
Procedure:
Open Excel by clicking on the 'X' icon.
You will see a spreadsheet (with numbered rows and lettered columns). Columns go up and down, notice column A, then Column B. Rows go from left to right (i.e. row 1, row 2, etc.).
Each rectangle is called a "cell". The first cell in the top left corner is called "A1" the next over to the right is called "B1", "B2", then, "B3" and so on . . .
The cell directly below "A1" is "A2", then "A3" and so on . . .
You will take turns making a graph each of you must make one -- flip a coin to decide who goes first. To begin your graph, follow these steps (as carefully as you can):
Ø in Column A enter the names of the teams (see the data that you must use at the bottom of this page)
Ø in Column B enter the scores of the teams
Ø Click in the left top corner of your group of cells and drag so that all of the cells are highlighted
Ø Go to "Insert", and select Chart then select Column and finally click on Next
Ø Now, Simply click Next
Ø Click in the box for Chart title and then enter the Chart Title. The title must be descriptive of the data (information) being used and your name (e.g. Title, by George Renoir)
Ø Do the same for category x and y (the x and y-axis).
Ø Click on Next
Ø Click on "As New Sheet".
Ø Click on "Finish"
Your graph should be finished (turn page over to see a sample). If you have time consider experimenting with the font or layout..
BE CAREFUL, save before you experiment.
Print when you have your finished product and I will collect it from the printer. No queuing at the printer please.
Data
Colorado 120 Edmonton 80
Buffalo 110 Ottawa 76
New Jersey 105 Toronto 56
Philadelphia 100
Detroit 97
Rangers 90
Pittsburgh 85
return to artefact links