apple92x117bb+.gif (2060 bytes)

bbline520c.gif (4392 bytes)

Table of Contents - Vol. 20 No. 7 - April 2004

  1. Pearls of URLs
    This monthly item will highlight Internet web sites which are considered "gems" by educators.
  2. Notes and Quotes
    This regular column provides information on a potpourri of technological "tidbits".
  3. 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.
  4. 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.
  5. 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.
  6. 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.
  7. 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).

lipearls.gif (1736 bytes)

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, 200                                                                   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.

To: schlib@listserv.pembinatrails.ca
Subject: [Schlib] Earth Day resources - 2004

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]


Return to the "Bits and Bytes" Web Page
Return to the Winnipeg School Division Web Page