Tuesday, December 9, 2014

Could you use help with Microsoft Excel and Using Data in your work?

Check out the lessons covered in the Data Boot Camp for School Counselors, Administrators, and other Educators 2.0. This online tutorial is 50% off until December 14, 2014.

Visit http://www.mydatabootcamp.com/ to learn more. 


Or click here

Unit 1: Excel Basics
  • Basics: This video covers some basic terminology and features of Microsoft Excel ™.
  • Accessing Your Data: There are four (4) primary ways for accessing data, this page shows you each one.
  • Adjusting your column width: There are three primary ways to adjust your columns to reveal all of the data contained within.
  • Moving Data Around: In this video, you will learn the basics for navigating Excel and moving data around according to your needs.
  • Splitting or Merging Data: These videos will show you how to either split data from one column to two or vice versa. This procedure is incredibly useful such as when dealing with first and last names, for example.
  • Freeze Pane: Have you asked yourself this question yet, "When I scroll down to view data, how do I know which columns I am looking out because the top row with labels are no longer visible?" This is one of those Excel annoyances that does have a quick solution. Watch the video to check it out.
  • Formatting: This video will demonstrate some common formatting techniques to help you get your data looking just the way you want it.


Unit 2: Data Snooping
  • Sorting Data: This video will show you how to do one or more levels of sorting.
  • Filtering Data: This one shows you how to isolate data by using the filtering function in Microsoft Excel.
  • Highlight and Calculate: You can get basic descriptive data in Excel just by highlighting the data you want.
  • Formulas: This video overviews and demonstrates how to enter basic formulas.
  • Describing Data: Microsoft Excel can help you to get a basic description of your data which includes central tendencies (i.e., mean, median, mode, maximum, minimum, standard deviation, and more).
  • Disaggregating Data: This section demonstrates two ways to disaggregate a "dependent variable" by one or two "categorical variables." For example, a common procedure is to disaggregate an academic achievement variable such as attendance (dependent) by ethnicity (categorical) and/or gender (categorical). You can select multiple dependent variables.

Unit 3: Analyzing Data
  • Differences: Learn how to create a new column which shows the difference between two scores, typically pre-test to post-test. I'll show you the difficult way and an easy way.
  • Percent Change: This video shows you how to calculate percent change between two variables over time.
  • Paired Sample T-test: The T-test assesses whether the means of two groups are statistically different from each other. Using EZAnalyze, we will calculate a T score and P value for the observed difference between two "repeated measures" or paired variables. A bar graph is also automatically generated.
  • Independent Sample T-Test: This procedure compares the mean scores of two independent groups on a given variable.
  • One Sample T-test: The one sample T-test allows you to test for significant difference between an observed group and another known sample (the numeric test value or NTV).
  • Correlation: Correlation is a statistical technique which can show how strongly pairs of variables are related.

Unit 4: Charts or Graphs
  • Choosing Charts: Among all my choices (e.g., bar, line, pie, scatterplot, stacked), how do I know which chart to choose? And, how do I create a chart within Microsoft Excel, anyway?
  • Chart Rules or Guidelines: This lesson will overview several principles of effective chart design and layout.
  • EZAnalyze Charts: This video demonstrates how to use EZAnalyze to generate or create your chart.
  • The F11 Trick: One of the neatest keyboard shortcuts in Excel is the "F11" trick which generates bar charts in Excel in two easy steps ... watch.
  • Switch Row-Column: Sometimes your data is a bit backwards such as when your student names show up on the legend (right side) and the data shows up on the bottom (X-axis). This video shows you how to reverse that.
  • Goal Lines: Especially useful for creating charts for Response to Intervention (RtI), this video will show you how to include both student performance data and a baseline when creating a chart.
  • Trend Lines: These may help students (individuals or groups) get excited about future progress.
  • Customizing Charts: Once you have created your graph or chart, you can customize various formatting such as colors, fonts, backgrounds, and content type.
  • Waffle Charts are similar to pie charts in that they communicate proportion (relative part to the overall whole).
  • Thermometer Chart: Learn how to make a thermometer chart to help students know when they're getting "hot."
  • Charts by Google Docs: See how Google Docs can do many of the same things that Microsoft Excel™  can do and a bit more.
  • Time and Task: Calculate how many hours you have spent in different categories of tasks using a combination of Microsoft Outlook and Excel.

Unit 5: Multimedia Results Reports
  • Narrated, Self-Advancing, Multimedia PowerPoint: Can you imagine sending to your administrators, school board members, parents, teachers, and other stake holders a brief multimedia accountability report that demonstrates the positive impact you have on student achievement? Picture your superintendent receiving an email from you with an attachment. She clicks on the attachment and within seconds begins to listen to (and watch) a digital story that describes how you systematically and collaboratively impacted growth and achievement among your students. The superintendent enjoys the show better than reading about it on paper and you love it because it takes less time and is more fun to create.
  • Converting your PowerPoint to Video: There may be instances when you want to convert your PPT to video which is more easily viewed by others online such as with YouTube or TeacherTube. This section will show you how.

Unit 6: Other Tips and Tricks
  • Identifying (and removing) duplicate data. This video demonstrates how you can have Microsoft Excel identify and give you the option to delete duplicated data -- a common procedure.
  • Merging data from two sheets or files.
  • Filling in cells with a common value.
  • Adding "zebra stripes" to your spreadsheet or shading alternating rows.
  • Printing tricks.
  • Converting PDF documents.
  • My favorite Excel and PowerPoint support websites.

 Visit http://www.mydatabootcamp.com/ to learn more. 

Monday, December 8, 2014

One week left! We're Giving Away the Data Boot Camp at 50% OFF

SchoolCounselor.com eNewsletter: We're Giving Away the Data Boot Camp at 50% OFF: We here at MyDataBootcamp.com  want to provide you with 50% off the new   Data Boot Camp for School Counselors, Administrators, and Educa...

Sunday, November 30, 2014

45% off Beautiful, motivational, educational posters for your home or office.

Beautiful, motivational, educational
prints/posters for your home or office.

 Save now


Simply enter the following coupon code: 
CYBER45 
Enter the code in the "Add Gift Certificate Or Coupon Code" box on the"Please Confirm Your Purchase" page to receive your discount.

Click now to start saving. 
Terms & Conditions-

*Promotional discounts apply to order total before shipping, taxes, and duties. Promotional offers cannot be applied to previous or pending purchases. Promotional offers cannot be combined with any other offers, discounts, coupons or promotions, except that free shipping offers may be combined with already marked-down items. Discounts may not be applied to the purchase price of gift certificates or limited editions. We reserve the right to cancel any order due to unauthorized, altered, or ineligible use of discount. We respect your privacy and will not share your email address with third parties for their marketing purposes without your consent.This offer expires December 1, 2014 - 23:59 in your local time zone


Wednesday, November 26, 2014

SchoolCounselor.com eNewsletter #148

SchoolCounselor.com eNewsletter #148
Date of Publication: November 26, 2014

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
____________________________________________


           Please take a moment to visit our Sponsors:

Get AWESOME
with Microsoft Excel
and using data in your work!
With this new online tutorial, you will find both written and detailed video instruction demonstrating data skills in a user-friendly manner. What you see is what you learn. Throughout the program, you'll also see many bonus articles, links, and tips.  And, best of all, in addition to the many descriptive pages, you’ll have access to 39 videos covering 206 minutes of tutorial footage.  And, until December 15th, the program is 50% off! Click here to see the lessons.
Click here to purchase your two year pass at 50% off. The final price is only $11.

http://www.mydatabootcamp.com/


 Going to College in California: Student & Family Connections and International & Out-of-State Students are Kindle books, and available only on Amazon.com. Think of them as your "getting started" pocket guides, something that you can reference quickly, easily, often, and anywhere. You can read these books on a Kindle, iPad, iPhone, Android phone, or any device that has the Kindle app installed, including laptops and desktops.
 

Games and Play to Enhance Counseling and Teaching Strategies, Vol I and II is Grace Wilhelm's new DVD set that gives you demonstrations and ideas to integrate play therapy techniques into everyday, familiar games in order to teach students counseling strategies for stress management, anger control, study and organization skills, making friends, test taking, communication skills and more. It is engaging, creative and FUN! The techniques are easy to replicate for all age groups and in all settings for individual, small group and classroom lessons. Get your creative juices flowing! A six page booklet is included with each DVD.
http://counselorgames.com/



Must See Videos
New videos have been added since the last issue:

●         
Life-Changing Baking Tricks Everyone Can Do
●        What's Trending Online 2014
●        Amazing Canine Adventurist
●        How to pump gas without arms
●        Education: Making Time
●        Positive Post-it Day
●        Pancake painting
●        Our Story In 2 Minutes
●        You poked my heart......
●        Your Brain on Drugs: Alcohol
●        Believe in Yourself!
●        6 Ways To Pack A Better Lunch
●        Giving
●        Pen Beats
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

– Pinterest. Lots of resources for counselors, parents, and others.
http://pinterest.com/rsabella/

– YouTube. Counseling related playlists and more.
http://www.youtube.com/user/cyberprof



TIPS AND TRICKS

9 Rules For Emailing From Google Exec Eric Schmidt
I like the last one the most which I have found quite useful. From all my accounts, I forward to my gmail account with lots of extra key words. Once in gmail, I can archive the email and make it easy to find later.
http://time.com/3425368/google-email-rules

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

Wordcounter is a word count and a character count tool. Simply place your cursor into the box and begin typing. Word counter will automatically count the number of words and characters as you type. You can also copy and paste a document you have already written into the word counter box and it will display the word count and character numbers for that piece of writing. In addition, word counter automatically shows you the top 10 keywords and keyword density of the article you're writing.
http://www.wordcounter.net/

Also know that Microsoft Word has a version of this feature available, see
here.

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

Microsoft Excel: Selecting Cells
There are much faster ways to select a dataset than using the mouse and dragging the cursor. Click in the first cell you want to select and hold down Ctrl+Shift, then hit either the down arrow to get all the data in the column below, up arrow to get all the data above, or left or right arrow to get everything in the row (to the left or right, of course). Combine the directions, and you can get a whole column then everything in the rows left or right. It'll only select cells with data (even invisible data). If you use Ctrl+Shift+End, the cursor will jump to the lowest right-hand cell with data, selecting everything in between. So if the cursor is in the upper left cell (A1), that's everything. Even faster: Ctrl+Shift+* (the asterisk) will select the whole data set no matter what cell is selected. (Image)
Source:
http://www.pcmag.com/slideshow/story/327311/20-excel-tips-for-becoming-a-spreadsheet-pro/1

Want to become awesome with Microsoft Excel? Check out
http://www.mydatabootcamp.com/

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

Great Microsoft Excel Shortcut Keys

Excel, like any great software, has many excellent keyboard shortcuts. Here are some of the best.

●Ctrl+; —Inserts today's date.
●         Ctrl+Shift+:—Inserts the current time (the colon is what is in a clock reading, like 12:00).
●         Ctrl+Shift+#—Changes the format of a date.
●         Ctrl+5—Apples a strikethrough to the text in a cell.
●         Ctrl+0— Hides the current column.
●         Ctrl+9—Hides the current row.
●         Ctrl+F6—Switches between open workbooks (that is, open Excel files in different windows).
●         F2—Start editing the current selected cell (much faster than double-clicking).
●         Shift+F10—Opens the right-click menu for the cell you're in.
Source: http://www.pcmag.com/slideshow/story/327311/20-excel-tips-for-becoming-a-spreadsheet-pro/20

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

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

FollowUpThen | Email Reminders via Email Itself
Clear out your inbox. Shorten your to-do list. Never forget to follow up. All with a simple email address.
https://www.followupthen.com

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

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.
http://www.schoolcounselor.com/tears/

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

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


Career Posters
Inspiration/Motivation
Change
Most Popular


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

20 Awesome Things Google Can Do For You
A list of helpful things Google can do for you, along with a few fun secrets that not many people know about.
http://www.stumbleupon.com/su/5vTuxx/tuZNWE$4:5WFJ4YE!/www.lifebuzz.com/google-tricks

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

AVG AntiVirus Free does a great job of blocking and eradicating malware, and it includes extras such as a secure shredder, Do Not Track protection for your browser, and the ability to schedule automated scans.
http://free.avg.com/us-en/homepage

Also know that many Internet service providers (e.g., Comcast/Xfinity) provide great antivirus software for free. I get Norton Security Suite and I love it. Does more than keep the computer clean but also tuned up and humming. In addition to antivirus, I highly recommend malwarebytes which is available at
https://www.malwarebytes.org/antimalware/. The free version needs to be run manually about once a week. I schedule this using Windows task scheduler (see http://windows.microsoft.com/en-US/windows/schedule-task#1TC=windows-7) to learn more.

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

Test your internet connection speed to make sure you are getting the speeds that your provider promises. I use two of them now and then when I think something isn’t quite right:
http://www.speedtest.net/
http://speedtest.comcast.net/

____________________________________________

WORTHY WEBSITES AND SOFTWARE

RAW
Raw is an open web app to create custom vector-based visualizations from your data. That’s a fancy way of saying that it creates fancy charts.
http://raw.densitydesign.org/

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

MozBackup is a simple utility for creating backups of Mozilla Firefox, Mozilla Thunderbird, Mozilla Sunbird, Flock, SeaMonkey, Mozilla Suite, Spicebird, Songbird and Netscape profiles. It allows you to backup and restore bookmarks, mail, contacts, history, extensions, passwords, cache etc.
http://mozbackup.jasnapaka.com/

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

Yet Another Duplicate File Remover
Another duplicate file finder/remover. But this one is ULTRA FAST, safe, easy to use and of course free and open source.
http://sourceforge.net/projects/yadfr/

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

Pixlr has been a favorite online photo editor and mobile app for years. Now, you can get the same Pixlr experience with even more fun and powerful tools on your Mac or Windows computer.
https://pixlr.com/desktop

I still love the online version:
http://apps.pixlr.com/express/

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

Quote Pic Maker for Facebook, Twitter, Google Plus, Wallpapers, E-cards, Prints
QuotesCover.com turns any ordinary saying texts into a beautiful typography art picture for use on Facebook, Twitter header, Google Plus, E-Cards, Wallpapers, and Prints.
http://www.quotescover.com/

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

7-Zip is a file archiver with a high compression ratio.
http://www.7-zip.org/

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

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

LastPass Password Manager
Like many of you, I use a lot of sites and services that require a log in with a password. Complex and different passwords for different sites are an absolute requirement these days and I suspect that only people with total recall can get along without a password manager. My favorite is LastPass. This works on multiple platforms and has served me very well.
https://lastpass.com/

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

( OFFTIME ) - Life Unplugged. - Android Apps on Google Play
( OFFTIME ) lets you customize your connectivity so you can do the things that matter. Unplug and focus on your work, be with the people you care about, or simply enjoy some peace of mind.
https://play.google.com/store/apps/details?id=co.offtime.kit

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

calm.com     
Source:
http://www.techsupportalert.com/content/and-relax.htm
Calm is a web-based service that helps you to relax after a particularly busy or stressful time. Just sit back, plug in some headphones if you want, then head to the web site. You can choose a period of 2, 5, 10, 15 or 20 minutes for your session. And you can choose whether you just get to hear calming music, or whether there's also a soothing voice too. Combine those with the flowing, meditative graphics on the screen (or just close your eyes if you prefer) and you'll be back to a calm state in no time.
http://www.calm.com/

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

AllDup - Find Duplicate Files      
A free tool that helps you to find and remove duplicate files on your PC.
http://www.alldup.de/en_download.htm#alldup
____________________________________________

JUST FOR FUN


Atari Arcade
http://www.atari.com/arcade

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

FlightGear Flight Simulator
The goal of the FlightGear project is to create a sophisticated and open flight simulator framework for use in research or academic environments, pilot training, as an industry engineering tool, for DIY-ers to pursue their favorite interesting flight simulation idea, and last but certainly not least as a fun, realistic, and challenging desktop flight simulator.
http://www.flightgear.org/

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

Sleep Talk Recorder app
Do you need solid evidence that your spouse snores? Do you talk in your sleep? The Sleep Talk Recorder app listens for noises while people slumber and starts recording the second it hears any mumbling during the night. The Sleep Talk Recorder is active all night, but it doesn't eat up the space on your phone. It turns on when there's a noise, a loud snore.

iTunes:
https://itunes.apple.com/us/app/sleep-talk-recorder/id391767653?mt=8
Android:
https://play.google.com/store/apps/details?id=com.madinsweden.sleeptalk&hl=en

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

Story of the#web25
The World Wide Web has gone from “never heard of it” to “can’t live without it” in 25 years. It took off because of its instant user appeal, but also because it’s open and free. From HTML to hacktivism, the W3C to MP3s, lolcats to LulzSec, from one website to over 180 million, here are its defining moments.
http://www.storyoftheweb.org.uk/
____________________________________________

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 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. Or, you depending on the database you signed up with originally, you may have an unsubscribe link at the bottom of this email...

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



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

Monday, November 10, 2014

We're Giving Away the Data Boot Camp at 50% OFF

We here at MyDataBootcamp.com want to provide you with 50% off the new  Data Boot Camp for School Counselors, Administrators, and Educators course (DBC 2.0). This second edition is bigger, better, and completely online.

DBC 2.0 is designed to help users be awesome
with Microsoft Excel and using data in their work.

     The DBC 2.0 provides 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. (Actually, the program is valuable for anyone who wants to access, analyze, and report on data, especially in the area of sales.) Particular attention is given to using a popular spreadsheet program, Microsoft Excel™, which is designed to assist in making more informed decisions in one's work.

     As a result of learning more about data and Microsoft Excel, you will be better able to monitor student progress and communicate to other stake holders about how your work is making a positive difference.

     All the videos have been updated using more recent versions of Microsoft Excel and PowerPoint (2010). In addition to the many descriptive pages, users have access to 39 videos of tutorial footage. Lots has been added since version 1.0 and the course is now fully online! You can learn more by visiting http://www.mydatabootcamp.com/ 

You can see a list of all the lessons and competencies included in the DBC 2.0  here. Also, see below to watch an introductory video. 

Click here to purchase your two year pass at 50% off. The final price is only $11.

The direct link for purchase is:

Offer ends September 25, 2019

After you purchase, look out for a window that opens up in your browser to register with your own userid and password. Finally, check your email for a link to a confirmation. If you need, you can email me at support@mydatabootcamp.com.

Russ Sabella, Ph.D.

Wednesday, October 29, 2014

More Resources for School Counselors on my Twitter Feed

Dear Newsletter Reader,

In addition to the SchoolCounselor.com newsletter, I want you to know that I provide lots of resources for school counselors on my Twitter feed. Whether it's a tool, tip, trick, lesson plan, job opening, or more ... you can find it on my feed.

To follow and monitor these, go to https://twitter.com/rsabella and follow me.

Russ Sabella

Tuesday, October 14, 2014

The Time Elapsed Analysis & Reporting System (T.E.A.R.S.)

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.



This addin is included for free as part of the Data Boot Camp 2.0
www.myDataBootcamp.com 

Thursday, October 9, 2014

I’m going on a walk to save lives ...

I’m going on a walk to save lives on 12/13/2014. Will you help me?
I’m a proud participant in the 2014 Lee County Heart Walk, an American Heart Association event that raises much-needed funds to fight heart diseases and stroke, the No. 1 and 4 killers in America.

Did you know that one person dies from heart disease every 39 seconds? But it doesn’t have to be this way!

The American Heart Association has made enormous strides in reducing deaths from heart diseases and stroke. It’s trained millions of Americans in CPR and is the top funder of heart disease research outside of the federal government. It can only do these amazing, lifesaving things with gifts from people like us.

I’ve set a personal goal of raising $300.00. Your support would mean so much to me.
Will you help me save lives and reach my goal with a donation today?

Thank you so much for considering this request.
In great appreciation,

Russell Sabella, Ph.D.

Wednesday, September 17, 2014

Data Boot Camp 2.0 Giveaway!

Bigger, Better, and Now Online! The DBC 2.0 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.
The DBC 2.0 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.
With the DBC 2.0, you will find detailed written and video instruction that demonstrates data skills in a user-friendly manner. What you see is what you learn. Also throughout this program, I’ve included many bonus articles, links, and tips.
Learn more at www.mydatabootcamp.com 


a Rafflecopter giveaway

Wednesday, August 27, 2014

Data Boot Camp for School Counselors, Administrators, and Other Educators

  

With this new and updated online tutorial, you will find both written and detailed video instruction demonstrating data skills in a user-friendly manner. What you see is what you learn. Throughout the program, you'll also see many bonus articles, links, and tips.  And, best of all, in addition to the many descriptive pages, you’ll have access to 39 videos covering 206 minutes (almost 3.5 hours) of tutorial footage.  Learn more >>>

Friday, August 8, 2014

SchoolCounselor.com eNewsletter #147

SchoolCounselor.com eNewsletter #147
Date of Publication: August 8, 2014

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 ____________________________________________
Please take a moment to visit our Sponsors:

Positive Relations @ School (& Elsewhere) is Nancy Willard's new book that provides guidance to schools on how to reduce bullying and harassment and limit its harmful effects in a manner that will both effectively address the well-being of students and assist schools from avoiding litigation and civil rights enforcement actions.
http://www.embracecivility.org/


Amazon.com Student Membership

Amazon Student is a free membership program created especially for college students. Read more here and sign up here.



 

Customized Webinars for School Counselors by Dr. Russ Sabella. Each webinar is customized for either 60 or 90 minutes. Other options available upon request.
http://www.schoolcounselor.com/webinars/


BASED ON A TRUE STORY of OLD-FASHIONED LOVE ... Sina is a devoted daughter, an average student, and just happens to be at the center of the greatest tomato-flying mishap in Sicily's history.  This heartwarming story of food, family, and a deep and lasting love is destined to become a classic in children's literature.
PASTA is LOVE may make you laugh, and it may make you cry, but one thing is for certain, it will make you hungry!  It may also answer the age-old question, it there really a 'happily ever after?'   Ages 6-9
Available now at: http://www.pastaislove.com/

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.

http://www.schoolcounselor.com/tears/


Must See Videos
New videos have been added since the last issue:
∙         Chocolate Dishes from Balloons
•         "Weird Al" Yankovic - Word Crimes
•         Fireworks filmed with a drone
•         Always #LikeAGirl
∙         Proper Way to Eat Pringles Chips
∙         Lift Labs Launch Video
∙         Made with Code - Film
∙         Fatherhood
∙         Google Flight Search
∙         Volkswagen - Eyes on the road

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

– Pinterest. Lots of resources for counselors, parents, and others.
http://pinterest.com/rsabella/

– YouTube. Counseling related playlists and more.
http://www.youtube.com/user/cyberprof
TIPS AND TRICKS
Top Handouts
Many of my handouts that I use for workshops, keynotes, and teaching are available online. Below are the top five most highly downloaded. Combined, they have been downloaded over 26,000 times! In order of popularity:
1. Training Catalog: http://bit.ly/sabella-training
2. SFBC Chart Template: http://bit.ly/sfbc-chart
3. Available Upon Request Article: http://bit.ly/on-call-counselor
4. Solution Focused Brief Counseling & Consultation Training Packet: http://bit.ly/sfbc-handout
5. SchoolCounselor.com Newsletter Issues #96-114: http://bit.ly/8YXNRm
6. Creating Charts: http://bit.ly/chart-handout
7. School Counseling Tracking Software (article): http://bit.ly/tracking-software
8. My Top Ten Training: http://bit.ly/sabella-topten
9. Helpful Technology: http://bit.ly/tech-handouts
10. Google Cheat Sheet: http://bit.ly/google-cheat-sheet
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Percent Change Calculator
http://www.percent-change.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~
How to make Google Now reminders from your desktop browse
http://googlesystem.blogspot.co.uk/2014/07/create-reminders-in-google-search.html
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Convert Google Link to Direct Link for Easier Copying and Pasting
Sometimes, links in Google results points to horrifically long URL’s that look kind of cryptic. Use this online tool to make a quick and easy conversion.
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Remind
Remind is a free, safe, and easy way for educators to connect instantly with students and parents.
http://rmd.me/9XI6
~~~~~~~~~~~~~~~~~~~~~~~~~~~
WorkFlowy is an organizational tool that makes life easier. It's a surprisingly powerful way to take notes, make lists, collaborate, brainstorm, and plan.
https://workflowy.com/invite/23fad4b8.emlx
~~~~~~~~~~~~~~~~~~~~~~~~~~~
CloseAll
CloseAll lets you close all running applications with just a single click. It doesn’t use any system resources at all and unloads right after completing its task. CloseAll simply flashes a ‘close’ signal to all open applications on the desktop and then ceases.
http://www.ntwind.com/software/utilities/close-all.html
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Problem Steps Recorder in Windows 7
The Problem Steps Recorder in the Windows 7 operating system is a feature that enables users to record their interactions with an application and provide a detailed screen-by-screen view with accompanying information. Learn how the recording can be used to quickly identify problems and help reduce time spent with the help desk.
http://technet.microsoft.com/en-us/windows/problem-steps-recorder-overview.aspx
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Windows: Shake and shrink
Here's a fun yet handy trick: Click and hold the title bar of the program you're working in, then shake it back and forth rapidly. All other open windows will minimize to the task bar, leaving your desktop nice and clutter-free. Sure, you can do the same by pressing Windows key + Home, but where's the fun in that?
Source: Click
here.
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Google Search: 5 of the Most Useful Instant Answers          
There are dozens of different instant answers you can get from Google, but here are the five that I find the most useful on a day-to-day basis.
http://www.pcworld.com/article/2461402/google-search-5-of-the-most-useful-instant-answers.html
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Add Hours, Minutes and Seconds
This page adds up any amount of hours, minutes and seconds. It can convert seconds to minutes, seconds to hours, hours to minutes, or virtually anything else. You can put any numbers in the boxes, even decimals and negative numbers.
http://www.dollartimes.com/calculators/hours-minutes-calculator.htm
~~~~~~~~~~~~~~~~~~~~~~~~~~~
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.
http://www.schoolcounselor.com/tears/
~~~~~~~~~~~~~~~~~~~~~~~~~~~
70 of the Most Useful Websites on the Internet - StumbleUpon
Click here.
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Educational Technology and Mobile Learning
Motherload of tech tips and informative articles.
http://www.educatorstechnology.com/p/site-map.html
___________________________________________
WORTHY WEBSITES AND SOFTWARE
Quixey
There are millions of apps and the ecosystem shows no signs of slowing down. Quixey helps people search through the clutter and find the right apps and functionality for any need, at any time. You can filter by your device type (e.g., Android, iPhone, iPad, Windows Phone, Blackberry).
http://www.quixey.com/
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Duolingo
Learn Spanish, French, German, Portuguese, Italian and English for free.
https://www.duolingo.com/
~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Anki
Friendly, intelligent flash cards. Remembering things just became much easier.
http://ankisrs.net/
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Crowd Mics turns iOS and Android devices into wireless microphones! Text commenting and polling too. Thank you to Sara Williams MA, LPSC for pointing this one out.
http://crowdmics.com/
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Powerpoint Templates, Backgrounds and Powerpoint 2013 Templates
http://www.freeppt.net/
~~~~~~~~~~~~~~~~~~~~~~~~~~~
iPads in the Classroom - Kathy Schrock's iPads4teaching

Amazingly long list of iPad apps for education.
http://www.ipads4teaching.net/ipads-in-the-classroom.html
~~~~~~~~~~~~~~~~~~~~~~~~~~~
IFTTT stands for “If this then that”
IFTTT has long been one of my favorite apps. This free tool, which works on the web and on Android and iOS devices, lets you create recipes that result in automatic actions online.
https://ifttt.com/
~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Pushbullet connects your devices, making it easy and automatic to share almost anything between them.
http://www.pushbullet.com/
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Free Malware Removal Tool | Anti-Malware Scan Software from Microsoft
The Microsoft Malicious Software Removal Tool is an anti-malware utility that checks computers running Windows 8, Windows 7, Windows Vista, Windows XP*, Windows 2000, Windows Server 2012, Windows Server 2008, and Windows Server 2003 for infections by specific, prevalent malicious software—including Blaster, Sasser, and Mydoom—and helps remove malware and any other infections found.
http://www.microsoft.com/security/pc-security/malware-removal.aspx
To scan your computer for malicious and potentially unwanted software, see the Microsoft Safety Scanner.
http://www.microsoft.com/security/scanner/en-us/default.aspx
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Full lets you track & measure what’s important to you (iOs only)
http://thefullapp.com/
____________________________________________
JUST FOR FUN
NASA FREE e-Books
There are currently a dozen titles to choose from, but more are added periodically.
http://www.nasa.gov/connect/ebooks/#.U4h_ePldWSr
~~~~~~~~~~~~~~~~~~~~~~~~~~~
nick reboot | feed your inner child
Continuously stream 90's cartoons for free.
http://nickreboot.com/
~~~~~~~~~~~~~~~~~~~~~~~~~~~
1 HOUR of Concentration Music - Study and Work Music - YouTube
https://www.youtube.com/watch?v=ct6Df_6eHhw
~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~
2048
I’m addicted to this game. Use your arrow keys to move the tiles. When two tiles with the same number touch, they merge into one!
http://gabrielecirulli.github.io/2048/
____________________________________________
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 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. Or, you depending on the database you signed up with originally, you may have an unsubscribe link at the bottom of this email...
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.
Posters
Beautiful ... Inspiring
 .. Motivational ... Touching
Counseling Posters for your Office
 and Home


Career Posters
Inspiration/Motivation
Change
Most Popular

____________________________________________
____________________________________________
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

Blog Archive

Produced by Sabella & Associates, LLC

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