SchoolCounselor.com
eNewsletter #90
Click
here
to view this and other issues of the newsletter.
Welcome to SchoolCounselor.com, an electronic newsletter designed
to advance counselors' level of technological literacy, application,
and integration. You will find practical solutions and answers to
technology related problems, especially as they apply to your job as
counselor. If you would like to share a tip or trick, or if you
would like to ask a question, e-mail Russ Sabella at
newsletter@schoolcounselor.com.

Data Boot Camp for School Counselors
and Administrators - CD
Russell A. Sabella, Ph.D.
My newest CD is designed to help you become more proficient
in using Microsoft Excel™ to make data an important part of
your comprehensive school counseling program. From
data-driven decision making, to monitoring progress, to
reporting the positive impact you're having on kids -- this
CD will demystify how it's done.
With the Data Boot Camp for School Counselors and
Administrators, what you see and hear on the videos is what
you do. At your fingertips, you'll have access to 30 videos
and lots of graphics, tips, tricks, and resourceful links.
This straightforward step-by-step approach makes learning
how to use Microsoft Excel™ (and a bit of PowerPoint™) as
easy and convenient as watching television. Data Boot Camp
will help school counseling students, practitioners,
administrators, and counselor educators to more easily
unlock the power of data so you can more effectively support
student achievement.
The content on the CD is equivalent to a full-day workshop
in the computer lab!
Visit and learn more about the contents of the CD and view a
couple of sample videos (Remember, these samples may take a
few moments to load because you are online. However, on the
CD, this is not an issue because the videos are all located
on the CD itself!).
http://www.schoolcounselor.com/store/data-bootcamp.htm
$21.95 (FREE shipping)
please allow 5-7 working days to arrive |
FEATURED COLUMN
Using
Video for your Presentations
Frieda,
a SchoolCounselor.com eNewsletter reader, writes, “Thanks for the
newsletter. As always, it has great information. I was wondering if
you could tell me how to get video clips for presentations. I use a
couple of movie parts for some of my presentations, but it is always
frustrating for me to get them paused at the right point and stopped
at the right point. Is there a way or website to get video clips? I
see presenters use them all the time, but I have no idea how. That's
my technology challenge right now. Can you guide me. Thanks.”
Excellent question Frieda, let’s get right to it ...
Your question has two parts – getting short video clips (as is) and
second, editing out a clip from a longer movie or program.
More and more, presenters are using video clips to enhance
understanding in a lesson or training. Indeed, our world continues
to become dependent upon a rich array of media for information and
learning. When working with children who are growing up on
multimedia information it becomes even more true. Although there are
some days when I would like to return to a simpler time when we used
overheads and index cards, I have to admit that I’m glad to see more
videos in presentations, it’s a more effective and appropriate use
of technology.
PowerPoint was never really meant to include screens filled with
paragraphs – only short bullets and, even more important, the
delivery of rich information such as with videos. The good news too
is that using videos in our lessons is now easier than ever given
the proliferation of videos online such as with YouTube and Google
Videos.
Getting that Video into PowerPoint
So the big question is, “How do I get the videos from YouTube into
my presentation (assuming that you are using PowerPoint)?” Well
actually, you don’t really have to. You could just link to an online
video from your presentation if you are sure to have Internet access
during your delivery. However, you could run into a problems such as
your school blocking the video site or that the video eventually
gets deleted by the person who posted it. Your best bet is to
download it and there are a couple of ways to do that. First, check
out this list of websites
here
that allow you to simply put in the website address (URL) of a video
and get a new link to the actual video file. In other words, your
first step is to go to the original web page on which the video
exists, copy the web address of that page, and then insert it into
one of these online services that will extract the video for you.
One thing you should understand is that most online videos are in
the Flash Video (FLV) format which is not easily handled by
PowerPoint. If you do want to download and use the FLV files as they
come, you will first have to install a FLV video player. Then, you
can just link to the FLV file from PowerPoint which will then play
in the FLV player when you click on the link. On a bit of a side
note, I do recommend linking a video from PowerPoint instead of
inserting or embedding it which results in all kinds of problems.
Here’s how it works ....
What I do is simply (1) put a graphic (e.g., a video reel or camera)
into the slide; (2) right click on it and choose Hyperlink; (3) in
the Insert Hyperlink menu, navigate and choose the video file that
you want to play. Click OK. Now clicking on the link while you are
viewing the presentation will launch the associated program in
slideshow mode. If you have linked to a RealVideo movie, this might
initiate RealPlayer or the QuickTime player in case you have linked
to a MOV video. In all cases you will have to close the video clip
independently of PowerPoint (click
here
for more info about videos and PowerPoint).
A free FLV player that I use and recommend is called “FLV Player”
and can be download from
this website.
By the way, a trick I’ve learned with this player is that to close
it, you have to press ALT-F4 on your keyboard because there is not
red “X” button on the top right corner. Another FLV player is “Wimpy
Desktop FLV Player.”
Although I’ve not used it, it seems to be a pretty good one and also
supports Macintosh.
To avoid the FLV format altogether, you can use a free service that
actually converts the video into a more common standard (I recommend
WMV or AVI) before downloading it. My favorite is
Zamzar
(Watch a video of ZamZar in action
here).
Again, once you download the movie, just link to it when you are in
PowerPoint. Another advantage of converting a FLV video to a more
standard format is that you can much more easily edit that video if
you need to.
Editing a Video Clip
Once you have a movie clip, you can use a free and powerful video
editing software to get it just right. I recommend Windows Movie
Maker 2.1 which usually comes with a Windows XP or Vista computer or
you can get it
here.
Macintosh users typically use iMovie. Windows Movie Maker supports
lots of file formats including:
• Video files: .asf, .avi, .wmv
• Movie files: MPEG1, .mpeg, .mpg, .m1v, .mp2
• Audio files: .wav, .snd, .au, .aif, .aifc, .aiff
• Windows Media files: .asf, .wm, .wma, .wmv
• Still images: .bmp, .jpg, .jpeg, .jpe, .jfif, .gif
• MP3 format audio: .mp3
Getting a Video Clip from a DVD
The most difficult thing you might run into is actually getting a
video clip from a DVD movie because the file formats (VOB) are
difficult to deal with and because DVD’s have embedded in them
copyright code which prevents this very thing. There is software out
there that you can purchase to do this such as
AOA DVD Ripper.
Or, you can convert VOB files into something more editable by using
software such as
Yasasoft
or
Blaze Video Magic.
If you run into copyright problems, you could use software which
copies the movie to your hard drive without the copyright code such
as
DVD Shrink
or
DVDFab HD Decrypter.
Speaking of copyright though, I have to say that you should never
infringe upon copyrights and stay within the limits of the law
(e.g., educational fair use).
Other Resources
Here is a list of websites that will help you deliver more dazzling,
impact full, and fun lessons or presentations.
• PhotoStory
3.
Create slide shows using your digital photos, music, and/or
narration. With a single click, you can touch-up, crop, or rotate
pictures and save as a WMV movie. It's that easy and it’s free.
Check out a PhotoStory that my son Joe did a while back ago
here.
• Film
Clips.
Film Clips Spirit of America is a nonprofit organization dedicated
to providing short film clips from major motion pictures to
America's teachers for use as teaching resources.
• TeacherTube
officially launched on March 6, 2007. Our goal is to provide an
online community for sharing instructional videos. We seek to fill a
need for a more educationally focused, safe venue for teachers,
schools, and home learners. It is a site to provide anytime,
anywhere professional development with teachers teaching teachers.
As well, it is a site where teachers can post videos designed for
students to view in order to learn a concept or skill.
• Video:
Don McMillan gives a short comedy sketch around Powerpoint
presentations and the common mistakes that people make.
• Must
See Videos
from SchoolCounselor.com.
• YouTube
Establishes Anti-Bullying Channel.
The first online anti-bullying channel has been launched to
encourage young people to denounce the intimidation. YouTube has set
up a site where youngsters can post their own videos and messages.
• Youtube example of a “Meet
the School Counselor”
video.
• Embed YouTube Video into PowerPoint. If you must embed a
YouTube video directly into PowerPoint, you can watch a video
tutorial
here.
• Zuula
video search now offers searching of video sites, including Google
Video, YouTube, iFilm, MetaCafe, and DailyMotion.
• Create
and distribute a self-running PowerPoint presentation.
P.S. Warning: if you search on the term school counselor or
guidance counselor on YouTube, you will see
results
that are less than flattering. This is a brutal fact and a wake up
call about student perceptions about school counselors. For example,
watch this
one,
this
one,
or even this
one.
On a final note, realize that when you link to a video (or any other
file for that matter) within PowerPoint, the files will not be
included in the presentation if you copy it to another computer or
send it via email. To include all your linked files, you have to
“package” the presentation. In version 2003, click
here
for instructions and for 2007, click
here.
TIPS AND TRICKS
Microsoft SharedView Beta2
Connect with up to 15 people in different locations and get your
point across by showing them what's on your screen. Share, review,
and update documents with multiple people in real time. A Windows
Live ID (Passport, Hotmail, or MSN) is required to start sessions,
but not to join sessions. New in Beta2: now even easier to use, with
group chat and performance improvements!
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Microsoft Office 2007 Compatibility
Adapted from
My Digital Life
Those whom have upgraded to the latest version of Microsoft Office
have already figured out that the newest file formats are not
backwards compatible. Microsoft Office 2007 (or 2007 Office System)
uses a new XML based file formats and extensions for new documents,
workbooks, spreadsheets or presentations that been created by Word
2007, Excel 2007 and PowerPoint 2007. These new file formats (in .docx,
.xclx and .pptx extensions) are not backward-compatible, meaning
older version of Office suites such as Office 2003, Office XP and
Office 2000 cannot open and read the XML files. And by default,
Office 2007 will save the document, workbook or presentation as new
XML file format, which cannot be immediately opened or viewed or
edited by users with earlier version of Office Word, Excel and
PowerPoint.
There are two solution to the problem.
First, recipients using older versions can download the
Microsoft Office Compatibility Pack,
which when installed on the computers of users using Microsoft
Office 2003 or Office XP (2002), will allow them to open, edit and
save documents in the new 2007 XML formats.
Second, to allow a file created by Office 2007 to instantly be
available, readable, or editable across all editions of Office
suites, especially Office for Mac which also does not support new
XML formats, save the file in an earlier Office format (97-2003)
manually. Here are the directions for each program:
Microsoft Word
1. In Word 2007, click the Office button and choose Word Options.
2. On the left, click Save. Then on the right, set Save files in
this format to Word 97-2003 Document (*.doc).
3. Click OK.
4. This will change the default save file type to the older Office
type. You can still choose to save as an Office 2007 file in the
Save As menu.
NOTE: Click
here
to get a visual of these steps. Or click
here
to watch a video that also includes how to make similar changes in
PowerPoint and Excel.
~~~~~~~~~~~~~~~~~~~~~~~~~~~
BreakUpEmail.com, helping you break up with the power of the
internet!
A sign of the times? Sometimes you don't want to dump him or her in
person. Sometimes you don't even want to do it over the phone. So
you send an email to say that your relationship is finished.
http://www.breakupemail.com/
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Charlie Rose Interview with Jim Collins
Although this book focuses on business, it is laden with solution
focused principles that can easily help counselors with leadership.
http://www.schoolcounselor.com/videos/2008/01/charlie-rose-jim-collins.html
____________________________________________
WORTHY WEBSITES AND SOFTWARE
FREE SEARCH & PHOTO SOFTWARE
From photo tools to mapping software, try these for
FREE:
• Google Picasa:
Organize & edit your photos
• Google Earth:
Satellite views and maps
• Google Desktop:
Search your entire drive
• Google Toolbars:
Use the Web better
Get your FREE Google Tools!
http://www.schoolcounselor.com/google/
|
Cyberbullying Talent Show
I show this video during my classroom guidance lessons and it really
has an impact among the students (all levels).
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Lazybase.com
Lazybase allows anyone to design, create and share a database of
whatever they like.
http://lazybase.com/
~~~~~~~~~~~~~~~~~~~~~~~~~~~
In and Out of the Classroom: Practical Guides for Teachers
These tutorials are designed to help students, teachers, and
administrators learn how to use Microsoft software in the classroom.
http://www.microsoft.com/education/IOCTutorials.mspx
~~~~~~~~~~~~~~~~~~~~~~~~~~~
2008 Calendar Templates from Microsoft
http://office.microsoft.com/en-us/templates/CT101425391033.aspx
Better yet, how about a
beautiful or fun art calendar
at my store.
~~~~~~~~~~~~~~~~~~~~~~~~~~~
6 Tips for Reducing E-mail Overload
Lately, more people are declaring bankruptcy. No, they’re not
financially insolvent. They just can’t keep up with e-mail. They
empty their inbox, announce e-mail bankruptcy, and start over from
scratch. Don’t let it happen to you. Get a grip on the problem
before it is too late.
http://office.microsoft.com/en-us/officelive/FX102476771033.aspx
____________________________________________
JUST FOR FUN
Google Puts Up Year End Zeitgeist
Google has continued in its zeitgeist tradition with the release of
a year-end trend summary. The main page shows a listing for the
fastest-growing search terms both in the US and across the world --
the world list includes terms like second life and ebuddy while the
US list includes heroes and transformers. (The iPhone is number one
on both lists). There's also a list of the fastest-dropping search
terms, which includes such nonsurprises as sudoku. Be sure to check
out the tabs on the side of the main page so you can check out the
most popular newsmakers.
http://www.google.com/intl/en/press/zeitgeist2007/
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Very Cool NASA photos
Great for wallpaper.
http://www.texasjim.com/NASApix/NASA%20pix.htm
~~~~~~~~~~~~~~~~~~~~~~~~~~~
The 10,000-Step Guide to Fitness
This feature describes the concept of walking 10,000 steps per day
(using a pedometer to keep track) to obtain health benefits. "The
British Heart Foundation (BHF) says 10,000 steps a day (about five
miles) can give you a healthy heart and reduce body fat." It
includes quick tips regarding the 10,000-step challenge, statistics
on fitness in Britain, and an illustrated description of how a
pedometer works. From the British Broadcasting Corporation (BBC).
http://news.bbc.co.uk/2/hi/uk_news/magazine/3723704.stm
~~~~~~~~~~~~~~~~~~~~~~~~~~~
M-LAW's Wacky Warning Labels
The contest to identify the wacky warning labels as presented on
this site aims to "reveal how lawsuits, and fear of lawsuits, have
driven the proliferation of common-sense warnings on U.S. products."
Features a list of some of the best labels from the first eight
contests, and images of labels for recent years. Includes rules for
submitted labels to the competition. From Michigan Law Abuse Watch
(M-LAW), and organization that opposes frivolous lawsuits.
http://www.mlaw.org/wwl/
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Excit
Excit is the best safe for workspace puzzle game ever. You’re
trapped in a spreadsheet and you need to escape the 30 levels using
the cursor keys without sliding of the screen. The game mechanic
might be familiar from games like Road Blocks and Orbox. So although
it is not entirely innovative, we put some effort into polishing the
game and we introduced some new, cool game play elements in latter
levels. Note that this Version was cropped to fit into the
resolution of Kongregate’s window. The levels are sometimes a bit
cropped on the left and right edge and the Layout is a bit off. I
adjusted the game graphics so you should have no problems because of
that.
http://www.ceeu.de/excit
____________________________________________
SUBSCRIPTION INFORMATION
SchoolCounselor.com does not knowingly send unsolicited e-mail. This
Newsletter is for subscribers only. If you received it and did not
subscribe, please let us know using the link on our home page. We
will remove your name immediately.
TO SUBSCRIBE to this newsletter, simply go to the signup page at
www.SchoolCounselor.com/newsletter
and enter your e-mail address. You will receive an e-mail asking you
to confirm your subscription. We will add your e-mail address to the
list when you reply to the confirmation e-mail.
TO UNSUBSCRIBE from this newsletter, simply go to the signup page at
www.SchoolCounselor.com/newsletter
and click the unsubscribe button after entering your e-mail address.
Important: You will then be asked to click on a link called “click
here” to complete the process.
TO CHANGE YOUR E-MAIL ADDRESS: If your old address will become
inactive, PLEASE
UNSUBSCRIBE with your old address and SUBSCRIBE with your new one.
IF ALL ELSE FAILS send a note. Please allow a week or two for
changes to take effect.
____________________________________________
PRIVACY POLICY
http://www.schoolcounselor.com/privacy.htm
____________________________________________
Want to advertise in this newsletter? Visit
http://www.schoolcounselor.com/advertising.htm
____________________________________________
The SchoolCounselor.com newsletter may contain links to sites on
the Internet owned and operated by third parties.
SchoolCounselor.com is not responsible for the availability of, or
the content located on or through, any such third-party site.
Information in this document is provided "as is," without warranty
of any kind, either expressed or implied, including but not limited
to the implied warranties of merchantability, fitness for a
particular purpose and freedom from infringement. The user assumes
the entire risk as to the accuracy and the use of this document.
SchoolCounselor.com will not be liable for any damages of any kind
arising from the use of this information, including, but not limited
to direct, indirect, incidental, punitive, and consequential damages.
|