Table of Contents - Vol. 20
No. 7 - April 2004
- Pearls of URLs
This monthly item will highlight
Internet web sites which are considered "gems" by educators.
- Notes and Quotes
This regular column provides
information on a potpourri of technological "tidbits".
- An "excel"lent way to create
pictographs for younger students
Brian Metcalfe, of Technology Education,
shares a step-by-step procedure for creating a chart using the Excel
spreadsheet. To enhance the "I Love to Read" data, Brian shows how a piece
clip art can be introduced to change the rather plain column display to a
more "user-friendly" pictograph representation.
- SCHLIB - Subscribe to receive
timely educational resources
In 1998, as part of a Manitoba School
Library Association initiative, Margaret Stimson facilitated the
establishment of the SCHool LIBrarian (SCHLIB) listserv to distribute
e-mail to interested educators. Marg, who is currently the Educational
Resources/Library Consultant for the Pembina Trails School Division,
shares a process by which teachers who are "interested in educational
resources" can subscribe to this service and receive information in a
timely manner. An e-mail sample of Marg's Earth Day resources is
included.
- School Daze ... Eh?
(Educational humour)
Knowing how important it is to reduce
the stress in our lives, Brian Metcalfe decides to introduce a new article
format in which he will share educationally-related humorous stories with
readers. If you encounter any stories that cause you to chuckle and smile,
please forward them to Brian at the e-mail address below for possible
inclusion in future issues.
- Food for Thought: A lesson for
all of us in this story
Aleda Sloane forwarded this powerful
story about a learning disabled child who wanted to play baseball.
- Freebie Favourites
With the exponential explosion of
unsolicited e-mail or spam, Brian Metcalfe shares a web site for those
readers who might wish to install the "SpamPal" for Windows freeware on
their home computer(s).
Pearls of URLs
"Going
Digital in the Classroom"
at: http://www.forsyth.k12.ga.us/sbeck/digital/goingdigital.htm
"The
Canadian Junior Rockhound"
at: http://www.canadianrockhound.com/junior/index.html
"The Techno-Savvy,
Book-Rich Media Center" an article by Jamie McKenzie
http://fno.org/apr04/technosavvy.html
Thanks to John Berestiansky,
Educational Technology Consultant, of the Pembina Trails School Division
for sharing this resource through the
SCHLIB e-mail listserv.
"Bits and Bytes" is an educational publication for the
students and staff of the Winnipeg School Division
Brian Metcalfe - Editor:
bitsandbytes@wsd1.org
Copyright © 2004 (ISSN 1195-5864)
Last revision date: April 21, 2004
Information has been shared with 420

Notes and
Quotes
by Brian Metcalfe - Technology
Education

Proposed Tax Break for Teachers
On Friday, April 16, 2004, I was fortunate to attend MERLIN's 7th annual
"Technology Day" at Winnipeg Technical College. The keynote speaker was Mike
Parkhill, Director of the Academic Sector for Microsoft Canada. In the
middle of Mike's presentation, titled "From e-learning to me-learning:
Progress and Challenges in Online Learning", the audience broke into
applause when he described a personal initiative that he has undertaken. He
indicated that he is very concerned when 90% of students today can gain
access to the Internet at school, home or libraries yet only 55% of teachers
know how to use computers. However rather than "use such data as drunks use
lampposts - more for support than illumination", he decided that we must
adapt our educational system and provide additional incentives to teachers.
To this end, Mike is working with politicians to introduce a Private
Members' Bill which, if passed, would provide each teacher with up to a
$2000 tax break every two years to purchase a new home computer to help
prepare lessons and classroom resources. Mike cautioned that this initiative
is still in its infancy and that it will likely take another 6-8 months
before it be voted upon. I'll do my best to keep readers aware of any
announcements regarding this proposed tax break initiative.
"Riding the Wave of Change"
2004 Conference - Gimli - May
13 & 14
Once again, Lloyd Roche, Technology Consultant
from the
Evergreen School Division, is coordinating this annual technology
conference. On-line registration and details are mow
available off their web site at:
http://www.esd.mb.ca/wave/
Shaughnessy Park - More Movie Winners
Last month, I identified schools in our Division who were recognized at
the "Freeze Frame 2004" festival. Shortly thereafter, Brenda Pundyk
principal of Shaughnessy Park School, informed me by e-mail about the video
talents of their students. "Our students along with Mitch Rygiel went to
Ottawa to receive their awards for their video that can be viewed on the
website of <www.march21.com>"
I was intrigued with the web URL until I visited this "Stop Racism Campaign"
site and learned that March 21st is the "International Day for the
Elimination of Racial Discrimination". Shaughnessy Park students were once
again one of 10 national winners with their 2004 award-winning video
entitled "What's Wrong With These Pictures". Check out this year's winning
video and their past winners including "Racism Stinks" (2003), "Teach Your
Children That Discrimination is Wrong!" (2001) and their first video award
in 2000 at:
http://www.pch.gc.ca/march-21-mars/hands-mains/10videos_e.shtml
Quote of the Month
"..if we teach today as we taught yesterday, we rob our children
of tomorrow." - John Dewey
[Table of Contents]

An "excel"lent way to create pictographs for younger students
by Brian Metcalfe - Technology Education

A Chinese proverb states that "One picture is worth ten thousand words".
Younger students find this to be so when they use an Excel spreadsheet to
tabulate data and then learn how to insert images to convert the
plain-looking chart into a "user-friendly" pictograph. The following steps will produce a pictograph
example showing the books read during February's "I Love to Read" month:
1. Start Excel and enter data
Start Excel and in row #2, enter the labels "Students" and "Books
Read" in the columns as shown. Next enter each
student's name in column A and the respective books read in column B. |
 |
2. Select or highlight data to be
graphed
To graph the data, click in cell A3 and
drag across to B3 and down until the last student's name and respective
books have been highlighted. Make certain that the labels in row #2 are
not selected. |
 |
3. Use the Chart Wizard
Click on the Chart Wizard button on the tool bar. |
 |
4. Enter the Chart title
In Step 1 of the Chart Wizard process,
leave the default "Column" chart type selected and click on the "Next"
button twice to arrive at the Step 3 screen shown at right. Enter
an appropriate "Chart title" such as "Books Read". Click on the "Next"
and "Finish" buttons to create a chart on the same worksheet as the
original data. |
 |
5. Prepare to insert clip art
Once the "Column" chart is created, one must
find a suitable image or pictograph. Click on the "Insert" pull down menu
and select the "Picture/Clip Art" items as shown. |
 |
6. Search for
appropriate clip art
Type "book" (or an appropriate image
name) in the "Search for clips" field and press the <Enter> key to
display those images that best meet the search criteria. |
 |
7. Inserting clip art
In this case, one clicks on the "owl
reading a book". When presented with four icons in the vertical bar,
click the top option which automatically "inserts" the selected image
into the open spreadsheet. |
 |
8. Re-size clip art & copy it to memory
If eight tiny squares do not surround
the image, click on the image once to activate these "handles".
Next click on a corner "handle" of the clip
art and drag it to re-size the image proportionally. Resize the image to
the approximate width of one of the columns in the chart. Next, click on
the owl once to highlight it and then select the "Edit/Copy" menu
items to place this image in the computer's memory. |
 |
9. Select all columns in graph
In preparation for pasting the owl
pictograph into the chart, one must click once on one of the columns. Do
not proceed until ALL the bars are highlighted with a dot in each
column as shown. |
 |
10. Paste clip art to represent data
values
When ALL columns are highlighted,
select the "Edit/Paste" menu items to insert the image into the chart.
Unfortunately only a single distorted owl is placed in each column. |
 |
11. Format Data Point on left-most
column
To improve this display, one must set
the scale factor for each column. Begin by clicking the left-most column
to select it. Next right-click on this column and, depending on the
version of Excel, select the "Format Data Point" or "Format Data Series"
option. |
 |
12. Select "Fill Effects"
Click the "Fill Effects" button in the
"Format Data Point" or "Format Data Series" window. |
 |
13. Select "Stack and Scale to:" ratio
Click on the "Picture" tab and select
the "Stack and scale to:" option. Students with smaller values
should enter a 1 in the "Units/Picture" area. One can change the scale
so that each image represents 2 or 3 items. |
 |
14. Left column done. Now repeat as
required
The left-most column will now be scaled
with the appropriate number of images. Repeat the steps 11-13 on the
remaining columns so that the pictograph accurately displays the books
read. |
 |
15. Change background colour as required
One may wish to right-click on the grey
background and select "Format Plot Area" item. Although a contrasting
colour may be selected, it is recommended that a white background be
selected if one wishes to save ink when printing the resulting
pictograph. |
 |
16. Insert a title to
complete pictograph
Enhance the pictograph with a WordArt title. Row #1 was left blank to
insert additional rows. Select the
Insert/Picture/WordArt menu items and print out a completed data table
and chart.
 |
[Table of Contents]

SCHLIB - Subscribe to receive timely educational resources
by Brian Metcalfe - Technology Education

School librarians and those active in the
Manitoba School Library Association know of the dedication of Margaret
Stimson. As the Educational Resources/Library Consultant for the Pembina
Trails School Division, Margaret is known to many educators as the creator
and maintainer of the award-winning "Info
Zone" research web site at:
http://www.pembinatrails.ca/infozone/
In addition, Margaret has shared a wealth
of educational on-line resources with primarily librarians through an
e-mail distribution mechanism or listserv known as SCHLIB which was
created in 1998 as an initiative of the Manitoba School Library
Association. I have been fortunate to be one of more than 150 individuals
who presently subscribe to this distribution service and rarely does a
week go by that I do not receive a message from Margaret. Not only does
she identify a variety
of Internet resource links but Margaret also takes the time to include
personal annotations and comments about them. Although many of the
messages may have a school library slant, others are intended for the
classroom teacher.
For example, on Sunday
April 18, Margaret sent out the following e-mail to all subscribers on the SCHLIB
listserv.
Earth Day is April 22nd. Here are some links that might help with the
celebration of that.
Cheers,
Marg S
----------------------Earth Day------------------------------
Teacher Planet - Earth Day
http://www.teacherplanet.com/resource/earthday.php
Lessons, units, worksheets, online activities such as Dr Seuss: Save the
Tree Game. There are links for all levels.
Source: Teacher Planet News #16
Online version available at http://www.globeteacher.com
National Geographic : Earth Day
http://www.nationalgeographic.com/earthday/
Games, news, wallpapers, audio, video, photos, interviews, conservation
tips, "lesson plans" and more. High quality site.
Source: http://www.marcopolosearch.org/
Canadian Parks and Wilderness Society (MB Chapter) :
Take Action Toolkit
http://www.cpawsmb.org/take-action/toolkit.html
Manitoba contacts for environmental issues. Student letters make a
difference. If you or your students wish to comment on aspects of the
health of our part of the Earth, such as the algae blooms on our large
lakes, you'll want to visit this page. Links are available for other
provincial and federal contacts.
Eco Kids Canada
http://www.ecokids.ca/pub/index.cfm
Downloads, printables, forum. The site is intended for young students.
Source: Earth Day Canada
http://www.earthday.ca/
Impact of Climate Change : Prairies
http://adaptation.nrcan.gc.ca/posters/reg_en.asp?Region=pr
Print and digital materials available from Environment Canada, Natural
Resources Canada. Order the Climate Change in the Prairies poster by fax: (819)-799-288 or phone 1-800-622-6232
Over the years, many of Margaret's web sites have been included in the
"Pearls of URLs". Furthermore Margaret prides herself in distributing
information to educators in a timely manner. Unfortunately, I often find
that by the time I receive her SCHLIB information and re-publish it in my
up-coming monthly issue of "Bits and Bytes", the event, like Earth Day on
April 22, has past or educators have very little lead time to use
Margaret's resources in planning relevant activities. However, I was
extremely pleased when Margaret sent me an e-mail indicating that anyone
"interested in educational resources" could view the
archives
and register to join the SCHLIB listserv. I encourage those who want to receive Margaret's information and resources
in a timely fashion to subscribe as indicated in her following e-mail message:
Hi,
Everyone is welcome to join SCHLIB. Anyone who is interested in
educational resources, particularly online resources, children's
literature, educational technology, information literacy, or school
libraries may find something of interest. Messages from this date forward
will be accessible through the SCHLIB archives.
The listserv has found a new home on updated equipment. A great big "thank
you" to John Berestiansky who arranged this.
To subscribe to SCHLIB go to
http://listserv.pembinatrails.ca/mailman/listinfo/schlib
You will receive an e-mail to confirm your membership. After you join, you
will automatically receive SCHLIB messages.
If you wish, you will be able to write to SCHLIB at schlib@listserv.pembinatrails.ca
SCHLIB began in 1998 as an initiative of the Manitoba School Library
Association. More than 150 people presently subscribe.
Cheers,
Marg
THANKS Marg for caring and sharing.
[Table of Contents]

School Daze ... Eh? (Educational humour)
by Brian Metcalfe - Technology Education

Over the years, I have received a variety
of feedback from "Bits and Bytes" readers. Many appreciate the educational
resources and freebies that are shared through this distribution
mechanism. Others admit that they are not as technologically savvy as they
would like to be but often find inspiration and motivation in the
non-technical "Food for Thought" articles. Over the years, I have found
that humour has helped me cope in challenging situations and laughter has
helped me reduce a great deal of stress. In trying to meet the varied
needs of educators today, I think it is perhaps time to introduce a
humourous educational story into the odd issue of "Bits and Bytes".
Hopefully the image below and the story of our kindergarten student and
teacher will cause
you to chuckle or at least bring a smile to your face. (:-)


Especially for K-1 teachers
Did you hear about the teacher who was helping one of her kindergarten
students put on his boots? He was really struggling, so she began pulling
and him pushing. The boots still didn't want to go on. Finally, after
several minutes the first boot was on. When the second boot was on, she had
worked up a sweat.
She almost whimpered when the little boy said, "Teacher, they're on the
wrong feet."
She looked and sure enough, they were. It wasn't any easier pulling the
boots off than it was putting them on. She managed to keep her cool as
together they worked to get the boots back on -- this time on the right
feet.
He then announced, "These aren't my boots."
She bit her tongue rather than get right in his face and scream, "Why
didn't you say so?" like she wanted to. Once again she struggled to help him
pull the ill-fitting boots off.
He then said, "They're my brother's boots. My Mom made me wear them."
She didn't know if she should laugh or cry. She mustered what grace and
courage she had left to wrestle the boots on his feet again.
"Now," she said sweating profusely, "where are your mittens?"
He said, "I stuffed them in the toes of my boots. . ."
[Source:
http://www.longislandweb.com/longislandweb-cgi-bin/webbbs_files/chalktalk/funstuff/funstuff_config.pl?read=125]
[Table of Contents]

Food for Thought: A lesson for all of us in this
story
forwarded by Aleda Sloane, a retired teacher from Dr. D.W.
Penner School in the Louis Riel S.D.

In Brooklyn, New York, Chush is a school that caters to learning disabled
children. Some children remain in Chush for their entire school career,
while others can be mainstreamed into conventional schools.
At a Chush fundraising dinner, the father of a Chush child delivered a
speech that would never be forgotten by all who attended. After extolling
the school and its dedicated staff, he cried out, "Where is the perfection
in my son, Shay? My child cannot understand things as other children do. My
child cannot remember facts and figures as other children do. Where is
perfection?"
The audience was shocked by the question, pained by the father's anguish and
stilled by the piercing query. "I believe," the father answered, "that when
a child like this is brought into the world, the perfection is in the way
people react to this child."
He then told the
following story about his son Shay: One afternoon, Shay and his father
walked past a park where some boys Shay knew were playing baseball. Shay
asked, "Do you think they will let me play?" Shay's father knew that his son
was not at all athletic and that most boys would not want him on their team.
But Shay's father understood that if his son was chosen to play it would
give him a comfortable sense of belonging. Shay's father approached one of
the boys in the field and asked if Shay could play. The boy looked around
for guidance from his teammates. Getting none, he took matters into his own
hands and said "We are losing by six runs and the game is in the eighth
inning. I guess he can be on our team and we'll try to put him up to bat in
the ninth inning." Shay's father was ecstatic as Shay smiled broadly.
Shay was told to
put on a glove and go out to play short center field. In the bottom of the
eighth inning, Shay's team scored a few runs but was still behind by three.
In the bottom of the ninth inning, Shay's team scored again and now with two
outs and the bases loaded with the potential winning run on base.
Shay was scheduled to be up. Would the team actually let Shay bat at this
juncture and give away their chance to win the game? Surprisingly, Shay was
given the bat. Everyone knew that it was all but impossible because Shay
didn't even know how to hold the bat properly, let alone hit with it.
However as Shay stepped up to the plate, the pitcher moved a few steps to
lob the ball in softly so Shay should at least be able to make contact.
The first pitch
came and Shay swung clumsily and missed. One of Shay's teammates came up to
Shay and together they held the bat and faced the pitcher waiting for the
next pitch. The pitcher again took a few steps forward to toss the ball
softly toward Shay. As the pitch came in, Shay and his teammate swung at the
ball and together they hit a slow ground ball to the pitcher. The pitcher
picked up the soft grounder and could easily have thrown the ball to the
first baseman. Shay would have been out and that would have ended the game.
Instead, the pitcher took the ball and threw it on a high arc to right
field, far beyond reach of the first baseman.
Everyone started yelling, "Shay, run to first. Run to first." Never in his
life had Shay run to first. He scampered down the baseline, wide-eyed and
startled. By the time he reached first base, the right fielder had the ball.
He could have thrown the ball to the second baseman who would tag out Shay,
who was still running. But the right fielder understood what the pitcher's
intentions were, so he threw the ball high and far over the third baseman's
head.
Everyone yelled, "Run to second, run to second." Shay ran towards second
base as the runners ahead of him deliriously circled the bases towards home.
As Shay reached second base, the opposing short stop ran to him, turned him
in the direction of third base and shouted, "Run to third." As Shay rounded
third, the boys from both teams ran behind him screaming, "Shay run home."
Shay ran home, stepped on home plate and all 18 boys lifted him on their
shoulders and made him the hero, as he had just hit a "grand slam" and won
the game for his team.
"That day," said the father softly with tears now rolling down his face,
"those 18 boys reached their level of perfection."
Funny how people can send a thousand 'jokes' through e-mail and they spread
like wildfire, but when one starts sending messages regarding life choices,
people think twice about sharing. Funny how the lewd, crude, vulgar and
obscene pass freely through cyberspace, but public discussion of morality is
too often suppressed in school and the workplace.
Funny how when you go to forward this message (if you choose to forward it),
you will not send it to many on your address list because you're not sure
what they believe, or what they will think of you for sending it to them.
Funny how we can be more worried about what other people think of us than
what we think of ourselves.
The paradox of our time in history is that we have taller buildings, but
shorter tempers; wider freeways, but narrower viewpoints; we spend more, but
have less; we buy more, but enjoy it less. We have bigger houses and smaller
families; more conveniences, but less time; we have more degrees, but less
sense; more knowledge but less judgment; more experts, but more problems;
more medicine, but less wellness. We have multiplied our possessions, but
reduced our values. We talk too much, love too seldom, and hate too often.
We've learned how to make a living, but not a life; we've added years to
life, not life to years. We've been all the way to the moon and back, but
have trouble crossing the street to meet the new neighbor. We've conquered
outer space, but not inner space; we've cleaned up the air, but polluted the
soul; we've split the atom, but not our prejudice. We have higher incomes,
but lower morals; we've become long on quantity, but short on quality.
These are the times of tall men, and short character; steep profits, and
shallow relationships. These are the times of world peace, but domestic
warfare; more leisure, but less fun; more kinds of food, but less nutrition.
These are days of two incomes, but more divorce; of fancier houses, but
broken homes.
It is a time when there is much in the show window and nothing in the
stockroom; a time when technology can bring this letter to you, and a time
when you can choose either to make a difference or just hit delete.
Keep reaching for that level of perfection.
[Source:
http://www.geoffmetcalf.com/lesson_20010222.html ]
[Table
of Contents]

Freebie Favourites
by Brian Metcalfe - Technology Education

Readers who are becoming deluged with the exponential growth
of unsolicited e-mail or spam, may want to consider installing the following
Windows freeware on their home computer(s).
|
 |
|
[Table
of Contents]
|