A Clear Explanation of Your Various Microsoft Office Options

I am occasionally asked about whether I recommend buying Microsoft Office or not. To go a step further, I am also asked about which version of Microsoft Office to buy. Then, there is the matter of how many licenses you get when you buy it, and which applications come with each version, and is it worth using the free online version? I also get asked what the difference is between Office 365 and the plain Office 2016, the product which used to come on a disc that you would install onto your desktop or laptop computer. In short (too late for that), people have a lot of questions about Microsoft Office and thank God for How-To Geek, which wrote this excellent and thoroughly helpful post about the ins and outs of Microsoft Office, version 2016, for example. Also included is a bit about the differences between 2016, Office 365, and whether the free online version of Office is even worth using. Thanks, How-To Geek!

I might add that Office 365 is also free for students and educators at eligible institutions. Teachers at my school district get it for free, for example (we have a .us domain), as do students with an .edu domain in his or her email address. When you go to this site, you can enter your school email address to get started. If you have questions, a Chat pop-up will appear in the lower right corner of your screen, where you can find out if you are eligible.

If you are not eligible for the free version of Office, this link will provide you with pricing for the various options of Office for both Home and Business users.

One more thing. If you scroll quite a bit further down the same page, you can get to the apps for the free online version of Microsoft Office. For example, the link for the online version of Word is https://office.live.com/start/Word.aspx. The free version, for my money, is definitely worth trying, as is Google's free G-Suite. I just wanted to provide equal opportunity so that no one thinks I work for either company. I don't. Just don't forget to create a free Microsoft account (or a Gmail account if you ever plan to use the Google suite) before even trying anything mentioned in this article.

4 Free and Easy Audio Recording Tools for Google Slides

I just wanted to promote a great tutorial on a topic that really needed a great tutorial: Audio Tools for Google Slides. Eric Curtis over at Control Alt Achieve did another beautiful job of explaining something (audio recording tools) that could be considered complicated by many. This tutorial is clear and complete with many screenshots included, as is his standard. So, I will save you all the trouble and just include a link to it here. 

Transferring Google Drive Data from a School Account to a Home Account (2 Methods)

This year, I have created a couple of tutorial videos and a set of print directions on how to transfer student (and staff) Google data from a district account to a home Google account. This transfer can include only specific selected folders (shown in the Method #1 video below) or your entire Google Drive (shown in the Method #2 video and the print directions below). If you are a student, staff member or teacher who would like to see the different processes, in order to pick the one that best fits your individual needs, please scroll down and check them out. If any senior student asks about this process, please direct them here also.

All 12th-grade student accounts in our school district will be deactivated shortly after their last day of school. It is highly recommended that this process be completed before then. 

Video Playlist (includes both methods in separate videos)

Print Directions (shows method #2 where you can move everything to a different Google account). 

We Dumped DirecTV for fuboTV. Here Is Why

When we took a good hard look at our monthly entertainment bill, it became increasingly apparent that something would have to go. We had already cancelled Hulu and our phone land line, but that was still not enough. We still had a huge DirecTV bill that was largely going unused from month to month. Something had to be done. Of course my wife and I were hearing from friends and reading more and more articles about "cutting the cable" and going strictly streaming, instead of using satellite or cable TV. This scared me in particular, because I didn't want to lose the local channels, and in the area where we live, a TV antenna is not a good option. For one, our neighborhood has a lack of broadcast reception from a TV antenna. We tried to buy a digital antenna from Best Buy, and they told us that everyone who has ended up returning it due to lack of channels in our area. 

I finally did some targeted research. After finally deciding that the cost savings would be worth it in the long run, I gathered up all of my DirecTV equipment and drove it to the nearest UPS store, which was about two miles away.  Interestingly, UPS will box up your equipment and ship it for you free of charge. Nice! The first replacement product we are trying already seems very good. It is called FUBO TV. The price is $44.99 for the first month and $54.99/month thereafter. What I like about it is that we can use it on any TV in the house, as long as we have the app installed. For instance, we now have an Amazon Fire TV Stick plugged into each of our TVs. The app is on the Fire TV Stick, so we just install the app and we're good to go. It runs off of the Fire TV Stick. Your fuboTV subscription allows you to stream from two devices at a time, so I'm assuming that means two TVs at once, or one TV and a mobile device at the same time. Here is more about fubo TV: https://www.fubo.tv/welcome

What drove up the price of our DirecTV the most was that we had a Wireless Video Bridge (an expensive accessory which resembles a tiny DirecTV satellite), four small DVR/receivers (one for each room) and the big Master Genie DVR from which all of smaller ones connected. So we had five different pieces of hardware plus a satellite dish outside the house. And we paid for each of these accessories a la cart. So the total amount we were paying was around $150/month just for DirecTV. By returning all DirecTV hardware and removing the service completely, keeping our Internet service and then getting fuboTV instead, we are saving about $95/month or $1,000+/year. fuboTV is about the same price as YouTubeTV. Other options include Sling TV (which is cheaper but not as many features or channels), Hulu TV and others, too. But here are the features I like best about fuboTV:

1. About 85 Live Channels + some on-demand channels. Over 100 channels total.
2. You can watch local channels, such as your local news channels. I was afraid of missing our local news, but that is not a problem;
3. All major networks, including TNT, TBS, IFC, History, the Food Network, the Golf channel, HGTV, the Weather Channel, AMC, Lifetime, etc.;
4. Here is a list of the channels that we get in the Detroit area: https://www.fubo.tv/welcome/channels;
5. Free Cloud DVR;
6. A very nicely organized TV Guide grid. This is far better than the one that DirecTV provided us. I mean you can actually search and it brings up accurate results, unlike DirecTV which was so badly organized and all they really seemed to care about was that you saw their scrolling On Demand shows, which you could NOT hide. You had to scroll through those every time you used the Guide. This has nothing irritating like that;
7. You get Fox Sports 1 and 2, which is where our local baseball, basketball games, etc. come from. And the Tigers and Pistons games are not blacked out even when at home. You also get the BTN. With DirecTV, local sporting events were often blacked out. I'm not sure if that was part of DirecTV's policy or if we were having a technical problem with our zip code;
8. No hidden costs, and you can cancel anytime. And no additional hardware to purchase. If you have a smart TV, it may already have the app, but I like the Fire Stick and consider it essential for every TV. 

The emphasis of fubo TV seems to be sports, but you get the major networks, shows, many streaming movies, etc. At least as many as you would get from your cable company, and probably much more. Again, it is a combination of both On-Demand and Live channels. 

Of course we are big-time streamers, so we also have subscriptions to MLB TV (so that I can watch my beloved Washington Nationals games and any other MLB games I want to see), Netflix, the Criterion Channel and Amazon Prime Video. All of these live on the Fire TV Stick too, so they are also available on every TV that has a Fire Stick plugged in. 

I really like the combination of local sports, good video quality, local news channels, all major networks, cloud DVR and a user-friendly guide. We may try Sling TV and YouTube TV, but so far we're pretty happy with fubo. 

Gmail Contacts: Creating Labels, Moving Contacts, and Sharing a Group (2019)

Here is the newly-updated version of one of my most popular videos on YouTube. The old way of sharing contact groups in Gmail is now obsolete. Here is the new way, along with how to create a new label/group, move a contact to one or more labels, and how to get Chrome to ask where to save your downloads. I hope it is even better than the previous video on this topic and that it will clear up the many questions of "Where did everything go?" in trying to complete this import/export process. 

How to Download YouTube Videos (from PCMag)

I was looking for a way to download videos from YouTube in various sizes and formats. Hats off to PCMag's Eric Griffith for this great article titled "How to Download YouTube Videos." The one I ended up using was WinX YouTube Downloader and it works very well (plus, it's free).

Screenshots on a Chromebook, Part 2: The Awesome Screenshot Extension

In part 2 of my look at screenshots on a Chromebook, the focus is on the Awesome Screenshot Chrome extension, which takes screenshots to a whole new level, with many great features demonstrated here. The final step of this tutorial shows how to turn in your annotated screenshot to Google Classroom.

Screenshots on a Chromebook, Part 1: How to Create Them and Turn in to Google Classroom

This video takes a look at capturing basic screenshots on a Chromebook from the student perspective. It also gives a good example of how to turn in these screenshots to Google Classroom and even rename them on a Chromebook.

Chromebook Tips & Tricks for Students and Teachers: Bookmarks & the Launcher

In Part 3 of my continuing series on Chromebook Tips & Tricks, I will take a look at creating and editing Bookmarks in Google Chrome using the Bookmarks Bar and how to search these bookmarks from the Chromebook Launcher.

Chromebook Tips & Tricks for Students and Teachers, Part 2: Moving Photos from Camera App to Drive

In my continuing series on Chromebook Tips & Tricks, Part 2 takes a look at pinning and unpinning apps to the Shelf, using the App Launcher, taking photos with the built-in Camera app, and moving photos and other files from the Files app to Google Drive.

Chromebook Tips & Tricks for Students and Teachers, Part 1: Pin a Tab in Chrome and Google Drive Tips

In Part 1 of my series on Chromebook Tips & Tricks, I will look at how to shuffle the Google Apps list, how to pin a tab to Google Chrome, different ways to right-clicking and scrolling, how to sync Docs for offline viewing, and other Google Drive tips. All of this, and it's only the first part of the series.

Live Streaming Broadcasts via YouTube

Learn how to quickly Go Live to YouTube and produce videos that are recorded and sharable for both live use and future reference. Teachers can use this method to record their teaching, and anyone wanting to do online webinars and training will also find this very useful.

Canva: Graphics without Work (2018 Video Tutorial)

If you create any kind of online graphics professionally, you probably already know about Canva. But for those out there who don't, I have created a video tutorial which will get you up to speed pretty quickly. It is what I like to call a 15-minute mini-class. 

Canva is used quite a bit by social media people who need a quick design template for their posts. It takes very little time to whip up something professional-looking with its helpful built-in design tools, such as frames placeholders and grids. Most of the included images and text designs are free, and you can save the designs that you create - to be used later or just upload your own graphics to re-use in future design projects. 

Canva is extremely easy to use and will save you a great deal of time. Not that it is a replacement for Adobe Photoshop, but who has the time to use Photoshop for each and every graphic project we do? Canva even has some quick and dirty photo editing tools...and once you've created your design, you can save it online, share it with your team members, share through Social Media or download it to your computer to be used elsewhere. Sound interesting? Check out my video below to see a pretty in-depth overview of what you can do with Canva. Then, try it out yourself and save to your own account at canva.com.

Using Screencastify with Google Slides and Google Classroom 2018

This video tutorial shows the complete student workflow of recording a Google Slides Presentation using Screencastify and then turning in the video through Google Classroom two different ways. Many of the newest features of Screencastify's Tab recording toolbar are shown, including the timer, spotlight, pen, pause button, start and stop keyboard shortcut and the eraser.

Using Vocaroo to Record Student Audio Projects

This tutorial shows the workflow of how students can record class audio projects using Vocaroo and then turn them in through Google Classroom.

How to Extract Audio from Your Videos

While I was working on a video editing project, I started picturing the final product in my head. I recorded an interview with my client. Then, I recorded him running (because he is an avid marathon and competitive runner). I then decided to play the audio of his voice from the interview underneath the clip of him running. Unfortunately, I have not yet installed any decent video editing software on my new laptop. 

Being pressed for time, I only had a free video editor at my disposal which only allows for one video track and one audio track. So, the question was how to take the audio from one clip and add it to a different clip. This brought up a need for an audio extractor which could take the audio from one clip and allow me to export it as an MP3 file, for instance. I did a search and found 5 awesome online audio extractors to extract audio from video. 

The article also explains how to extract audio from video with Filmora Video Editor. If you are looking for other software along these lines, such as video editors, audio editors, password managers, photo editors, malware removal tools, music managers, etc., I recommend visiting Giveaway of the Day where they feature at least one good free software download every day of the week. I have found so many great tools this way. Just remember that any future upgrades of the programs you download are not included for free.  

Transforming Videos into Formative Assessments with EDpuzzle

On Wednesday, August 23rd, I will be presenting a session entitled "Transforming Videos into Formative Assessments with EDpuzzle" at Marysville High School from 11:15 to 12:15 in Computer Lab A101. Supporting resources for this session are found below:

Transforming Videos into Formative Assessments with EDpuzzle (the full session presentation)

Transforming Videos into Formative Assessments with EDpuzzle (Agenda and Class Notes)

EDpuzzle Step-by-Step (a very quick Getting-Started slideshow with steps & no pictures)

EDpuzzle Teacher Instructions (a step-by-step guide with screenshot pictures for teachers)

EDpuzzle Student Instructions (a step-by-step guide with screenshot pictures for students)

Android Advanced User Guide to Google Docs and Sheets

Roland Dean at Joyofandroid.com has put together the most thorough and advanced user guide for Google Docs and Sheets for Android that I have seen so far. I found it very useful and can see why he is so proud of it. The guide will help users get the most out of Google Docs, for instance, right away, as well as Sheets (Google's version of Excel) and even Slides (Google's version of PowerPoint). Here is a brief look at the file view in the screenshot below.

I'm going to open this guide on my phone and/or tablet and keep it there. To check it out for yourself, head over to the site and read it right away, or just click on the link below:
http://joyofandroid.com/android-advanced-user-guide-to-google-docs-and-sheets/

Resources & Tools for Creating a Free Business Logo

Desktop Apps to Use:

• In Google Docs (docs.google.com), use the Add-In called Open ClipArt.  This adds ClipArt to your Google Docs.
• In Google Slides (slides.google.com), go to the Insert menu and insert WordArt, Line, Shape and Image.
• In PowerPoint, go to Insert>>Pictures or Insert>>Shapes.  Use a different slide for each of your logo designs.
  Note: Upload to Google Drive when finished.  

Legal Image Search Tips:

• In Google Slides: If you go to Insert>>Image, use the Search tab.  It searches only images that are free and legal to use to use (not copyrighted).
• Creative Commons (CC Search): What makes CC Search so great is that it is more than just an image search. Search 12 different media sites from within one page (including Flickr, Google and YouTube). It searches music and video sites as well as images.
• Pixabay.com: Free high-quality images. Only requires a login if you want to save the images to your account. Otherwise, you can download to your desktop, and upload to Google Drive. 
• If you use a Google Images search, click on the Search Tools button, then Usage Rights.  Click on "Labeled for Reuse."

Design Your Logo Online (Online Resources):

Note: First you need a Company Name.  Then you can use any of these resources to help you get started. Most of these are perfect for creating business cards:

• Canva: lets you create a logo design from their various templates at which ever size you need, including the correct social media formats. Canva is a designer, a canvas and a photo editor, so you can do all of your designing in one place. You will need to set up a free account at the Canva site.
• Freelogoservices will offer a step-by-step with various options to choose from.  Use it only as a starting point to help you create your own ideas. Includes a business card creator and you get 50 free business cards. 
• LogoGarden: Easy pick-n-click tools to help you design a logo. Starts with just a business category and a symbol. 
• DesignMantic: Just enter your company name to get started. Creates several logo design variations with one click. 
• VistaPrint: This not only helps you design a logo, but it also lets you make a batch of free business cards.
• LogoMaker: Takes you step-by-step through the creation of a logo.  Requires an account, but you can step through it without one.  
• Google Drawings: Google's design canvas tool. Drag or insert images and text, and then design your logo, which can be saved directly to your Google Drive or go to File>>Download As  and choose a format like PDF, PNG or Scalable Vector Graphics (SVG).

Saving Your Images and Designs:

• When finished, make sure you log in to your Google Drive (drive.google.com) and upload your designs.  
• Pictures should first be downloaded to a desktop folder you create, called something like "Logo Images." As you download your photos, right-click and choose "Save Image As" or "Save Picture As" and store them on your classroom computer. 
• When your images are downloaded and collected, upload them to Google Drive, and delete the Logo Images folder from your classroom desktop.
• Note: To save your designs online all in one place, try Canva.com and sign in with your Google account.
  --You must have an account to save your designs. You can also use pre-created designs that are already pre-formatted for Facebook, Twitter, Instagram and other online platforms. 

Free Vector Images, ClipArt, Logo and Text Generators:

• Cooltext: a free graphics generator for web pages and anywhere else you need an impressive logo without a lot of design work.  Simply choose what kind of image you would like. Then fill out a form and you'll have your own custom image created on the fly. 
• Cannypic: This site offers its own collection of high-quality hand-made vector images for personal and commercial use, absolutely free.
• SoftIcons: Allows you to download free icons, icon sets and icon tools, at least for personal use. 
• OpenClipArt: Free ClipArt on a variety of searchable topics. 
• Clker: Free ClipArt you can use for anything you like.

How to Use VoiceOver on the iPad and iPhone

Yes, the iPad and iPhone can speak to students. The accessibility feature called VoiceOver can be activated and used by students with reading accommodations. The presentation below shows you how to use VoiceOver and gives several useful tips.