
SchoolCounselor.com
eNewsletter #126
July
8, 2011
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.
____________________________________________
Please take a moment to visit our
sponsor:
|
Ablebits: Merge Tables Wizard
for Microsoft® Excel®
Merge Tables Wizard for Microsoft Excel is an easy-to-understand
and comfortable-to-use alternative to Microsoft Excel Lookup and
Vlookup functions. This cute add-in, which was specially
designed for combining data from different sources, finds and
merges matching data from two Excel tables in seconds. The two
tables can be located in the same Microsoft Excel file or in two
different files. The intuitive and smart wizard guides you
through the merge process. Rows from two Excel spreadsheets with
different number of columns will be matched perfectly without
copying and pasting! Ideal for conducting pre to post analyses.
For Microsoft Excel 2010 32-bit and 64-bit, Excel 2007, Excel
2003, Excel XP (2002), Excel 2000.
http://www.ablebits.com/excel-lookup-tables/index.php
Use the coupoon code below for a 10% discount
MTW20P-SCHOOLCOUNSELOR |
Highlights from SchoolCounselor.com

Top 5 Training Topics for School Counselors
http://www.schoolcounselor.com/top5training.htm

New Must See videos
have been
added since the last issue:
Emily Osment: Delete Digital Drama to
Stop Cyberbullying
http://counselingvideos.blogspot.com/2011/07/emily-osment-delete-digital-drama-to.html
Two Dogs Dining
http://counselingvideos.blogspot.com/2011/07/two-dogs-dining-so-funny.html
OMG - Really?
http://counselingvideos.blogspot.com/2011/06/omg-really.html
Secure a new PC in 5 easy steps
http://counselingvideos.blogspot.com/2011/05/secure-new-pc-in-5-easy-steps.html
Terry Moore: How to tie your shoes |
Video on TED.com
http://counselingvideos.blogspot.com/2011/05/terry-moore-how-to-tie-your-shoes-video.html
TED Video: The Hidden Power of Smiles
http://counselingvideos.blogspot.com/2011/05/ted-video-hidden-power-of-smiles.html
YouTube - Tour Of Excel: Formulas, Formatting, Sort, Filter,
PivotTables, Charts, Keyboards
http://counselingvideos.blogspot.com/2011/05/youtube-tour-of-excel-formulas.html
Secret Service questions 13-year-old
over Facebook post
http://counselingvideos.blogspot.com/2011/05/secret-service-questions-13-year-old.html
Youtube: Using Google Forms
http://counselingvideos.blogspot.com/2011/05/youtube-using-google-forms.html
Eliminating the "R-Word"
http://counselingvideos.blogspot.com/2011/05/eliminating-r-word.html
Using Google Sites
http://counselingvideos.blogspot.com/2011/05/using-google-sites.html
YouTube - Ultimate Dog Tease
http://counselingvideos.blogspot.com/2011/05/youtube-ultimate-dog-tease.html

Webinars
http://www.schoolcounselor.com/webinars/

Handouts!
http://www.schoolcounselor.com/resources/publications2.htm
|
Postings from Russ Sabella ...
– Keeping Kids
Out
of High Tech Trouble. This
blog supports Dr. Russell Sabella's work on educating children,
parents, educators and other stake holders about the responsible
use of technology. Included in these pages you will find helpful
resources, lesson plans, links, and more. Russ's most recent
book and workshops are primary resources for meeting this
mission.
http://guardingkids.blogspot.com/
– SchoolCounselor.com eNewsletter.
The SchoolCounselor.com e-Newsletter is an electronic
publication 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.
http://counselingtechnology.blogspot.com/
– Must See Videos.
When I see a video that would be useful, inspiring, enlightening
among counselors, I post it here.
http://counselingvideos.blogspot.com/
– Twitter.
Postings about all thinks counseling, life, humor, and more.
http://twitter.com/rsabella
|
_____________________________________________

TIPS
AND TRICKS
YouTube - 10 Things you can do Easily in
Excel under 10 Minutes
1. Auto sum a bunch of values
2. Save Excel file as PDF
3. Insert Org chart
4. Insert Euro Symbol
5. Change Tab Colors
6. Insert clickable buttons that take user to other sheets
7. Paste Excel Data / Tables / Charts to PPT
8. Use Format Painter to Speed up Formatting
9. Create Splits & Freeze Panes
10. Hide Unused Rows & Columns
http://www.youtube.com/watch?v=g_tQ4D7wCL0
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Edutopia: Free Classroom Guides and
Downloads
Get our easy-to-print guides that include useful tips for
educators, parents, and school administrators alike.
http://www.edutopia.org/classroom-guides-downloads
~~~~~~~~~~~~~~~~~~~~~~~~~~~
New Way to Get Air Flight Information
with Google Search
http://www.techsupportalert.com/content/new-way-get-air-flight-information-google-search.htm
~~~~~~~~~~~~~~~~~~~~~~~~~~~
iTunes Parental Controls and Safe
Syncing
from Social Networking and Internet Safety Information for
Parents
http://internet-safety.yoursphere.com/2011/06/itunes-parental-controls-and-safe-syncing-.html
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Creating a Table of Contents from
Heading Levels (Microsoft Word)
If you are writing a long document or a book, you may want to
create a Table of Contents (TOC) for your document. The easiest way to
create a TOC is to use heading levels, as defined by the Word styles.
This link takes you to how it’s done.
http://word.tips.net/T000037_Creating_a_Table_of_Contents_from_Heading_Levels.html
~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~
New from Google
Source:
Google Tutor
Voice search. If you have a
microphone for your PC, you will be able to speak to your computer and
tell it what to search. If you are using Chrome 11 or higher, and have a
mic attached to your PC then you can click on the mic in the Google
search bar (as it is shown in the image above) and say your query. This
could be useful for searching really long queries or searches that are
easy to say but hard to type due to their difficult spelling. It can
also come in handy when your hands are not free to type. You can just
say your search out loud.
Search By Image. A picture is
worth a thousand words. Google realized it and decided that it should
also let users use images as search queries instead of just the plain
old text. And that’s how the “Search by Image” feature was born
Coming Soon. The Google+ Project
This is Googles Social Network .. Will Facebook be impacted?
http://www.google.com/+/learnmore/
Check this video of the Google+ Network in action
http://www.youtube.com/watch?v=L7SzBV20TgE
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Cyberbullying: Who, What, Where, Why,
and What Now?
Comprehensive article by Russell A. Sabella, Ph.D.
http://bit.ly/cyberbullying-article
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Articles about technology and youth
safety on Education.com excerpted from Guardingkids.com.
http://bit.ly/mgqYLp
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Tomighty Is a Simple, Elegant Pomodoro
Timer for Boosting Productivity
Fans of the Pomodoro technique for productivity work in focused,
timed bursts. Tomighty is an easy to use, pretty desktop timer to help
you organize your tasks with this method. Tomighty has a very simple
elegance and many configuration options: configurable times, sounds, and
a few themes and languages. You can easily select from taking a long (15
min., by default) or short (5 min.) break.
http://lifehac.kr/nB2gwa
or
here
____________________________________________

WORTHY WEBSITES
AND SOFTWARE
Elance
Elance helps individuals and businesses hire and manage in the
cloud. For businesses looking to staff-up a team on an hourly or project
basis, Elance offers instant access to qualified professionals who work
online and provides the tools to hire, view work as it progresses and
pay for results.
http://www.elance.com/?rid=WS0E
~~~~~~~~~~~~~~~~~~~~~~~~~~~
StudyBlue
Source: The Scout Report, Volume 17, Number 20, May 20, 2011
Online flash cards held in the cloud? A way to mobilize study notes more
effectively? StudyBlue can be used for both tasks and several more that
will be most efficacious for students and others. First-time visitors
will need to sign up for an account and then they can go ahead and get
started. Among the other features is a "Set a Study" reminder, which
will send users a text message to remind them to get back to their flash
cards. This version is compatible with all operating systems, including
Linux.
http://www.studyblue.com/
~~~~~~~~~~~~~~~~~~~~~~~~~~~
joinable.org | Disrupting Homelessness
By providing the homeless and jobless with permanent and secure access
to communication, joinable.org aims to disrupt social problems
http://joinable.org/
~~~~~~~~~~~~~~~~~~~~~~~~~~~
CloudApp was designed to be the
quickest possible way to share images (and other files) with others.
While CloudApp is Mac only, its Windows counterpart, FluffyApp, brings
the same features to Windows. Drag and drop an image to the CloudApp
icon in your menu bar, or on Windows, to FluffyApp in your system tray,
and the file is instantly uploaded, and the short URL to that image gets
copied to your clipboard, ready for sharing. Plus, you can make the
files you share as private or as public as you choose, so it's another
great app to share images but also does much more.
Source:
http://lifehacker.com/5804337/five-best-services-for-quick-image-sharing
Direct link:
http://www.getcloudapp.com/
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Outlook Sender's Time Zone - free plugin
for Outlook 2007/2003/XP
This handy little plug-in for Outlook will take just a few
minutes of your time on installation. Once the Sender's Time Zone for
Outlook plug-in is installed, no setting and no configuring is required.
You just open an e-mail message and besides the standard Outlook
timestamp you see the sender's current time as well as your time zone
difference, that is the number of hours ahead or behind. You will see at
a glance when the e-mail was really sent, regardless of where the
sender's office is located, whether it be East or West coast (EST, EDT,
CST, CDT, PST or PDT), Europe (GMT, WET, CET, EET) or Asia.
http://www.ablebits.com/outlook-sender-timezone/index.php
~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~
TED Blog | Resources for suicide
prevention, post-attempt survivors and their families
http://t.co/wsNrY9C
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Klip.me - Enjoy Mobile Reading
http://klip.me/
More and more people like to do reading on their Kindle, iPhone and iPad.
"Klip.me" is a simple tool for sending web content to mobile devices.
Furthermore, it can remove ads and other junk from the article, letting
users view only most relevant material in clean text. You can Read,
Collect, Search, Share your favorites web articles anytime anywhere, no
need to install any APP on your device.
~~~~~~~~~~~~~~~~~~~~~~~~~~~
School Counselor Blog
School Counselor Blog - a place where school counselors share
innovative ideas, creative lessons and quality resources.
https://www.facebook.com/schcounselor
http://www.schcounselor.com/
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Screenr | Instant screencasts: Just
click record
http://www.screenr.com/
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Top 100 Counseling Related Posters
http://www.schoolcounselor.com/posters/best-sellers.asp
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Docs.com
Facebook has partnered with Microsoft
Office to provide educators with web-based versions of Word, PowerPoint
and Excel that can easily be used to create and share projects, reports
or other information with students, colleagues and parents.
When you create new files or upload existing Office files into the
Docs.com Facebook App (http://docs.com/) your document will have an
unique URL that, depending on your privacy settings, allows you to
easily share the document with anyone you want.
You can quickly share Docs.com files in Facebook Groups and Facebook
Pages. Since you don’t have to recreate your learning materials from
Office in another format, this is a great time saving trick!
Docs.com can be used as a web-based document repository where you store
your files for quick access and safekeeping. The Docs.com Facebook App
can provide students with several templates for reports, essays and even
a resume.
Docs Facebook Page: http://www.facebook.com/Docs
Docs Guide: http://docs.com/42Q
Free Teacher Resources on Docs: http://bit.ly/f8cYHX
____________________________________________

JUST FOR FUN
More Movies on YouTube
More than 3,000 full-length feature films from major Hollywood
studios are now available on YouTube. Watch one of the hundreds of free
movies available, or rent blockbuster new releases like The King's
Speech, The Green Hornet or Despicable Me. Many movie pages feature
YouTube Movie Extras: free behind-the-scenes videos, cast interviews,
parodies, clips and remixes from YouTube's community of content
creators.
http://www.youtube.com/movies
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Google Advisor
Google Advisor helps you quickly find relevant financial products
from many providers and compare them side-by-side. Enter information
about what you're looking for in a mortgage, credit card, CD, checking
or savings account and receive a list of offers that match your
criteria, along with rates and contact information. Google Advisor is
currently available in the U.S.
https://www.google.com/advisor/home
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Tilt-shift miniature style photos
are pictures of real-life scenes that are manipulated to look like model
photographs. Now you can easily transform your existing digital camera
photos into tilt-shift style miniatures using tiltshiftmaker.com. Our
online photo editing tool is fun and requires no registration or signup.
http://tiltshiftmaker.com/
~~~~~~~~~~~~~~~~~~~~~~~~~~~
YouTube - Music Discovery Project
Source:
PC World
Just type in the name of a favorite song or artist, then click Disco!.
In a flash, YouTube creates a playlist based on that song or artist--the
contents displayed in a scrolling thumbnail bar at the bottom of the
screen. You can mouse over any song and click it to jump directly to it,
or just let the playlist run in its regular order. You'll also notice
controls (on the right side of the bar) to turn Autoplay on or off and
enable or disable shuffle mode.
http://www.youtube.com/disco
~~~~~~~~~~~~~~~~~~~~~~~~~~~
5 places to get great free stuff
Source:
Komando.com
There are a number of sites that list free stuff. You can find air
mattresses, clothing, plants and furniture. I've even seen expensive
appliances on occasion. You never know what you'll find.
~~~~~~~~~~~~~~~~~~~~~~~~~~~
What does your phone number spell?
http://www.phonespell.org/
____________________________________________
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 visit go to the signup page
at
http://www.schoolcounselor.com/unsub.htm
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.
Sabella & Associates,
LLC, 4922 SW 26th PL, Cape Coral, FL 33914
Sabella@Schoolcounselor.com
|