Sunday, May 17, 2015

SchoolCounselor.com eNewsletter #149


SchoolCounselor.com eNewsletter #149
Date of Publication: May 18, 2015

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 news@schoolcounselor.com
____________________________________________


Must See Videos

New videos have been added since the last issue:

•         TOP 5 DOG VIDEOS #24
•         How to Make Ninja Squishy Balls!
•         Famous Failures
•         Fights on Social Media
•         Never Stop Dancing
•         Creative problem solving ...
•         Dog .. Unconditional Love
•         7 Ingenious Waffle Iron Snacks
•         Misconceptions in Psychology
•         Delta Honor Guard
•         The Average Black Girl
•         “Like a Girl”
•         Whistling At Your Mom
•         The new Bruce Lee
•         How to really wrap a present.
•         Students stepping up for others
•         If Teachers Were Football Players
•         The New Face of Transgender Youth
•         How to pump gas without arms
•         Education: Making Time


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.

– 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.

– Must See Videos. When I see a video that would be useful, inspiring, enlightening among counselors, I post it here.

– Twitter. Postings about all thinks counseling, life, humor, and more.

– PinterestLots of resources for counselors, parents, and others.

– YouTubeCounseling related playlists and more.


_____________________________________________

TIPS AND TRICKS

Un-Google Link
Sometimes you want the direct link that a Google search result is point to, this tool really does the trick. Paste a URL to extract the actual link from the Google search engine link.
~~~~~~~~~~~~~~~~~~~~~~~~~~~

Google Doc Keyboard Shortcuts
Among the many shortcuts specific to Google Docs, these are a few that I tend to use over and again.

Insert or edit link                 Ctrl + K
Open link                            Alt + Enter
Word count                         Ctrl + Shift + C
Center align                        Ctrl + Shift + E
Bulleted list                         Ctrl + Shift + 8
Move paragraph up/down     Alt + Shift + Up/down arrow
Insert comment                   Ctrl + Alt + M


You can find them all at https://support.google.com/docs/answer/179738?hl=en or check out these “cheat sheet”:



~~~~~~~~~~~~~~~~~~~~~~~~~~~

10 Tips for Folders in Google Drive | Teacher Tech

~~~~~~~~~~~~~~~~~~~~~~~~~~~

How to Add Video to a PowerPoint Presentation - YouTube
You may want to add video to a PowerPoint presentation which is easy enough but you might also want to make adjustments such as to the volume, trimming the video, adding bookmarks or getting it to loop.

~~~~~~~~~~~~~~~~~~~~~~~~~~~

The Time Elapsed Analysis & Reporting System (T.E.A.R.S.) is a Microsoft Excel add-in that automatically calculates the total amount of time that you have spent in different aspects of your work. After exporting your calendar data from Microsoft Outlook to Excel, this add-in extracts elapsed time, sums up the number of hours in each category, and then produces both a table and a chart. If you ever wondered where your time goes, you will want to use T.E.A.R.S. to learn more.

~~~~~~~~~~~~~~~~~~~~~~~~~~~

Google Trick: Site:
Get results from certain sites or domains. So, if you want to quickly find the Ethical Standards and other pages related to ethics on the ASCA webpage, put the following into Google search:
site:schoolcounselor.org ethics. Click here to see for yourself.

Bonus: Play Atari Breakout by searching it on Google Images.

Also, this one lets Google flip a coin for you when you don’t have one on hand, good one for doing classroom activities: Search for “flip a coin” or “heads or tails.”

~~~~~~~~~~~~~~~~~~~~~~~~~~~

How to Remove Passwords from Adobe PDF Files
Google Chrome has a built-in PDF reader* and a PDF writer and we can combine the two features to remove the password from any PDF document. Check out how:

~~~~~~~~~~~~~~~~~~~~~~~~~~~

Excel Tip Use Array and RANDBETWEEN To Pick A Random Winner In Excel - YouTube

I also love this site which is fun to use in class: http://wheeldecide.com/. This one is pretty cool and easy to use too: http://www.classtools.net/random-name-picker/
____________________________________________

WORTHY WEBSITES AND SOFTWARE


YouCanBook.me is booking software that integrates with your Google Calendar.
Get a personalized scheduling page so your customers can book you online. A standard account is free as of this writing.

~~~~~~~~~~~~~~~~~~~~~~~~~~~

Checky
How many times a day do you check your phone?

~~~~~~~~~~~~~~~~~~~~~~~~~~~

Down For Everyone Or Just Me
Check if your website is down or up?

~~~~~~~~~~~~~~~~~~~~~~~~~~~

Five Best Mobile Document Scanning Apps
Scanning receipts while you travel, notes on a whiteboard, or sketches on an envelope can be easy. The best apps for the job take a snapshot, can do text recognition, save your scan to the cloud for future reference on other devices, and more. This website gives us five of the best smartphone apps that get the job done. I personally use CamScanner and love it.

~~~~~~~~~~~~~~~~~~~~~~~~~~~

OneTab (Chrome or Firefox Browsers)
Whenever you find yourself with too many tabs, click the OneTab icon to convert all of your tabs into a list. When you need to access the tabs again, you can either restore them individually or all at once.

~~~~~~~~~~~~~~~~~~~~~~~~~~~

5 Smart 'Drinking Water' Apps for Your Phone
Your Smart Phone already manages most of your life, so why not let it handle your drinking water needs as well?

~~~~~~~~~~~~~~~~~~~~~~~~~~~

GuardingKids.com: Kiddle: Visual Search Engine for Kids
Kiddle is a family friendly search engine enhanced by Google safe search, so you know you get quality results without any explicit content.

~~~~~~~~~~~~~~~~~~~~~~~~~~~

Get OneNote 2013 on your PC for Free
Works on Windows 7 and Windows 8

____________________________________________

JUST FOR FUN

Dubsmash
Dubsmash is a video messaging application for iOS and Android. Using the application, users can choose an audio recording of a well known quote from a list and record a video of themselves in which they dub the quote.

~~~~~~~~~~~~~~~~~~~~~~~~~~~

Kahoot!
My students are loving this ... A Kahoot is a collection of questions on specific topics. Created by teachers, students, business-people and social users, they are asked in real-time, to an unlimited number of “players”, creating a social, fun and game-like learning environment.

~~~~~~~~~~~~~~~~~~~~~~~~~~~

Personality Insights Demonstration
The Watson Personality Insights service uses linguistic analytics to extract a spectrum of cognitive and social characteristics from the text data that a person generates through blogs, tweets, forum posts, and more.

~~~~~~~~~~~~~~~~~~~~~~~~~~~

Blabberize.com
Got a picture? Blabberize it!

~~~~~~~~~~~~~~~~~~~~~~~~~~~

Snaptee is the first mobile app that enables you to create your own custom T-shirts with just a few taps on your smart phone.

____________________________________________

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

Wednesday, May 6, 2015

Be Awesome with Excel and Using Data in your Work

Check out my new Facebook page: https://www.facebook.com/DataBootCamp. Stop by and give it a "Like" if you find it helpful.


Also ... the online Data Boot Camp for School Counselors is heating up. Users are telling me that they like the ability to do this on their computer, tablet, or even smartphone.

If you have not checked it out yet, here is a brief description:

This tutorial is designed to provide you with step-by-step instructions for learning tips, tricks, and shortcuts when dealing with data in your work as a school counselor, administrator, or other educator. Particular attention is given to using a popular spreadsheet program, Microsoft Excel™, which is designed to analyze, share, and manage information so that you can make more informed decisions in your work. As a result of learning more about data, you will also be better able to monitor student progress and communicate to other stake holders about how your school counseling program is making a positive difference in the lives of students.

Here you will find both written and detailed video instruction demonstrating data skills in a user-friendly manner. Also throughout this program, I’ve included many bonus articles, links, and tips.

Learn more at: http://www.mydatabootcamp.com/

Blog Archive

Produced by Sabella & Associates, LLC

Copyright, 2009. All Rights Reserved. Contact Dr. Russell Sabella at news@schoolcounselor.com.