Sunday, April 22, 2018

Checkboxes in Google Sheets!

That's right - check-boxes are available in Sheets.
When you are in a sheet simply select
  • Insert
  • Checkbox
Checkboxes in sheets have many uses - the one I show below deals with my wife who teachers 4th grade and has students write a state report. Students can not double up, so pasting in all 50 states and then adding checkboxes in the 2nd column easily shows what states have and have not been chosen.

FYI - this new feature was available in my personal Google account and has not yet been added to my school account.

Embedded below is a 31 second YouTube tutorial.

Take care,

Saturday, April 21, 2018

How to sign up for Epic! and have access to 25,000+ books on any device for children 12 and under

If you would like to have access to over 25,000 books available to on any deviceto children 12 and under try Epic!

Epic! is free for educators; however, for families it is $7.99 (unless you get a referral by a teacher in which case it is $5.99 a month). Please note you have 30 days to try it for free.

In order for families to have access at home (after school hours) families would need to sign-up for an account. 
The free educator version is for use in the classroom or school library only. For use at home, students should be using the home version of Epic!. This is due to our Terms of Service and our contracts with publishers.

In order to sign up you will need to follow the instructions on the site. If you are a teacher make sure you enter all information necessary so your school will be verified.

For more information please click here for educator resources as well as a a quick start guide.

Embedded below is a 1 minute and 14 second YouTube tutorial I created.

Take care,

Friday, April 20, 2018

Personal Dictionary in Google Docs

The other day I was working with a student whose name was always underlined as a spelling suggestion in his Google Docs. Once I showed him he could add his name in "personal dictionary" under Tools > Spelling his face shone so brightly!!

Embedded below is a 29 second YouTube tutorial.

Take care,

Thursday, April 19, 2018

How to add your YouTube video with captions to Facebook

If you have added closed captioning to your YouTube videos (click here for a short blog post) and have noticed that it does not load onto Facebook with the captions it can be very frustrating.

In order for the captions to load on Facebook follow these steps * note Twitter does not allow as of the date of this post (4/19/2018).

  • In YouTube's video manager select Subtitles/CC
  • Select English/Automatic
  • Select Actions (left side) and then select the .srt file
  • Make sure you download the video to your computer
  • Enter into your page on Facebook and add the video
  • On the right you have some choices under subtitles and captions (cc)
    • select the video language
    • you can have Facebook auto-generate them or write them in yourself
    • or you can upload the .srt file from YouTube
      • you will need to rename the file with the name of the file and then
      • example =
  • Select Publish and you are good to go
Embedded below is a 2 minute and 8 second YouTube tutorial.

Take care,

Wednesday, April 18, 2018

Week in Review - Create your own memes, Classroomscreen, SOS on iPhone, and closed captioning in YouTube

Hello everyone,

This past week I shared posts dealing with creating your own memes, Classroomscreen, SOS on iPhone, closed captioning in YouTube.

To access the posts please click below.

Take care,

YouTube: How to see your videos transcript as well as force closed captioning to be played for users

So... this post falls under the "Why didn't I do this before?" as well as "Better late than never!" categories. Adding closed captioning to your videos has numerous benefits including:
  • makes your post available to more users
  • Captions let viewers watch your video in more places
    • According to a study by the United Kingdom’s Ofcom, 80% of people who watch video with closed captions on are not deaf or hard of hearing. One major reason why people use captions is due to their environment.
  • Boosts views as well

If you would like to have your YouTube videos to include closed captioning here are the steps:
  • enter into your video manager and select Subtitles/CC
  • set your language
  • select language (English in my example)
  • select Edit
  • check the transcript (edit where necessary)
  • publish edits
  • go back to Info / Settings
  • in the tags field enter in the proper tags to go along with your video to make it available as well as one major tip
    • yt:cc=on this will force closed captioning for all users when they select your video
Embedded below is a 2 minute and 3 second YouTube tutorial (with captions)!

Take care,

Tuesday, April 17, 2018

Pop-ups blocked when trying to access a site?

If you are using Google Chrome and trying to access a site and get the notification that Popups need to be disabled it can be frustrating.

Fortunately, the solution is pretty straightforward. In the address bar at the top you will notice a rectangle with a red square. Click on the square and allow the pop-ups.

If you would like to see the settings enter into the 3 dots (upper-right) next to address bar.

  • settings
  • select Advanced
  • select content settings
  • see popups that are blocked as well as allow
  • change any of these settings by selecting the 3 dots 
Embedded below is a 1 minute YouTube tutorial I created.

Take care,

Monday, April 16, 2018

Emergency / SOS on iPhone + how to quickly call emergency services

An important and potentially life-saving feature on your iPhone is the Emergency SOS feature. The feature is available by selecting...

  • Settings
  • Under the third section it is the 7th option
Once selected a notice alerts you that to call emergency services you need to rapidly click the sleep/wake button 5 times.

You can then set up the Emergency Contact in Health.
Under your Medical ID you can add 
  • Name
  • Photo
  • Medical 
    • Conditions
    • Notes
    • Allergies & Reactions
    • Medications
  • Blood Type
  • Add organ donot
  • Weight
  • Height
  • Add emergency contact
Embedded below is a 1 minute and 14 second YouTube tutorial.

Take care,

Sunday, April 15, 2018

Want to create your own memes? Try

If you would like to know how to create your own meme (picture with a funny or motivational caption) one option is to try the website

You will not need to sign-up to use the site (although signing up is easy and stores your creations). Just know that a watermark (bottom left) will show up unless you pay the $3 a month charge.

In the embedded 1 minute and 31 second YouTube video below I walk you through the basics of how to create one from a template as well as your own.

Here is a meme I created last night of my son finishing some popcorn!

Take care,

Saturday, April 14, 2018

Students collaborating on a Google Site? Remember these settings

A few things to remember if your students are collaborating on a shared Google Site (if you are the owner).

  1. Check out the published settings.
  2. I would recommend checking the box next to "Prevent editors from publishing, changing access and adding new people".
Embedded below is a 49 second YouTube tutorial.

Take care,