Search this site:
Custom Search

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


_____________________________________________


Posters
Beautiful ... Inspiring .. Motivational ... Touching
Counseling Posters for your Office and Home

Career Posters
Inspiration/Motivation
Change
Most Popular



Get Back Issues of SchoolCounselor.com .. Free
Back Issues 20-95
http://bit.ly/96QyEk

Back Issues 96-114
http://bit.ly/8YXNRm



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

 

     

GuardingKids.com: A Practical Guide to Keeping Kids Out of High-Tech Trouble

Russell A. Sabella, Ph.D.

From podcasts to porn, cyberbullying to cell phones, Dr. Russell Sabella helps readers understand the risks that emerge when high-tech tools, uninformed parents, and exuberant youth collide. Because kids are growing up with modern technologies, many are more expert than their parents. As a result, a parent's ability to make effective decisions for how technology is used may be compromised.

GuardingKids.com empowers parents, educators, and other care takers to better understand the electronic terrain. Readers will be better able to help children safely and securely navigate a minefield of inappropriate and risky situations.

http://www.guardingkids.com/

 

Sabella & Associates, LLC ©2013