Friday, April 28, 2017

10 Chrome-ifying Tips and Tricks

Are you an avid user of the Google Chrome browser? Did you know that Chrome is full of shortcuts and hidden functions that can save you time? I’ve compiled my favorite tips and tricks that will help you work faster and do more with your favorite web browser. All you have to do is carve out a few minutes and learn how to take advantage of them.

Save Web Pages as PDFs

Chrome Tips and Tricks Infographic
         Click on image to download infographic.
Google Chrome has a built-in PDF writer. Open any web page, press Ctrl+P on Windows (or Cmd+P on your Mac) and choose “Save as PDF” from the list of available printers in order to download that page as a PDF file. No extensions required.

Make Favicons Your Bookmarks

In Chrome, there is another way to get quick access to your favorite websites by creating a favicon of the website instead of whole URL text. To do this, first click on “Settings” (the vertical dots icon in the upper right-hand corner), select “Bookmarks,” and then select “Show bookmarks bar.” Next, bookmark a site by clicking on the Star in the omnibox (address box). Then right-click on the bookmark and delete the text in the name box, leaving only the favicon.

Pin Tabs

In Chrome, there is an option to pin a tab that can minimize the tab to display only the icon. When you have a number of tabs opened, this feature is very useful, as it will display the icons, leaving more space for multitasking. This option also avoids tabs lost on the side of the screen when you have numerous tabs open at one time. To pin a tab, right click on the tab, and select “Pin tab.”

Open Recently-Closed Tabs

You can open any recent tab that has been closed by mistake. To do this, press Ctrl + Shift + T. You can also reopen it by right-clicking on the title bar and selecting “Reopen closed tab.”

Go into Incognito Mode (Secret Mode)

For private browsing, you can enable incognito (secret) mode, where Chrome will not keep your browsing or download history. You can enable secret mode by pressing Ctrl + Shift + N, or by clicking on “Settings” and selecting “New incognito Window.” Using incognito mode is great for reserving hotels, booking flights, or shopping. This way, your email is not later plagued by spam or ads.

Navigate Between Tabs Quickly

You can navigate between open tabs very quickly by using some shortcut keys. Use Ctrl+Tab to navigate tabs one by one, Press Ctrl-1 to go to the first tab, Press Ctrl-2 to go to the second tab, and so on. You can also switch to the last tab by pressing Ctrl-9.

Open Multiple Pages on Start Up

You can control what page or pages appear when you launch Chrome on your computer. Rather than opening your browser with just one homepage, Chrome gives you an option to open several pages as it starts up, providing instant access to the different websites and services you prefer to start your day with. To set your startup pages, select “Settings” and then scroll to “Settings.” Under the On Startup section, select “Set pages” and enter the URLs of your preferred start-up pages.

Solve Mathematical Problems, Equations, and More 

The omnibox (the address bar in Chrome) can solve mathematical calculations. It can even solve questions such as “How many cups in 4 liters?” Try to add or multiply any math calculation in the omnibox without pressing the enter. For example, try typing, 60 x 90 and see what appears.

Play Media Files in Google Chrome

Did you know that you can play a wide variety of movie and music files (.avi, .mov, .mp4, .mp3, .mkv, .ogv, .ogm,.webm, .wav etc) using Google Chrome? Simply drag your file into the search bar and enjoy listening or watching it play. Chrome can even be used to view images and open Microsoft Office files and PDF files as well.

Bookmark All Tabs

If you have several tabs open and want to bookmark them all at once, all you have to do is right-click on one of the tabs and scroll to “Bookmark all tabs.” A bookmark popup dialog box will appear asking you where you want to save your bookmarks.
This blog was originally published at

Monday, April 24, 2017

Easily Analyzing Student Data with Google Explore

Teachers are responsible for monitoring student learning on a regular basis. One way to do this is by analyzing student data, and if you have that data in Google Sheets, you’ll really appreciate how Google Explore makes it so much easier to connect you to your students and their learning.

What Is Google Explore?

Google Explore is a built-in application interface that monitors what you type and responds with related, on-the-fly content. It was introduced in the fall of 2016 and is available for not only Google Sheets, but for Google Docs and Slides as well. You can also find it on Android and now on iOS, too. Think of it as another set of hands (and eyes!) to help you examine student data to better ensure mastery.
Explore in Sheets helps you decipher your data easily, whether you’re new to spreadsheets or are a pro with them. Just ask Explore and get answers about your data. You can ask questions like “Which person has the top score?” This equates to less time spent crunching numbers and more time finding key insights and using them to help your students.

How to Get Answers About Your Data

As you examine how to use Google Explore, use this Example Grade Sheet I created that contains some simple data.
To use Google Explore:
  1.  Open a spreadsheet in Google Sheets.explore_icon
  2. In the bottom right, click the green Explore icon.
  3. Under “Answers,” type your question in the box and press the Enter key. Try asking some of these questions:
    • Which student has the top score on Test 1?” (Note: You must use the fields that exist in your spreadsheet. For example “student” and “test 1”)
    • Which five students have the lowest score on Test 1?
    • What is the average of Assignment 1?
  4.  Google will give you some suggestions to explore as well. To see the suggestions, click on the suggestions under the text box.

See Automatic Chartsexplore_chart

To see automatic charts about your data:
  1. Open the Example Grade Sheet, if you don’t already have it open.
  2. In the bottom right, click Explore and scroll down.
  3. Charts and an analysis will appear showing trends and patterns from the data in your spreadsheet. Hover over a chart to see which data in the spreadsheet is being used in that chart.
  4. The charts can easily be inserted into your sheet by clicking on the insert chart icon or by clicking on the chart and dragging it into your sheet.
  5. Once a chart is added into your spreadsheet, you can use the Advanced edit option from the drop-down menu in the top right of the chart to further edit the chart.

View Even More Analyses

To see more information about a specific portion of your data, try the following:
  1. Open the Example Grade Sheet, if you don’t already have it open.
  2. In the bottom right, click Explore.
  3. Highlight column E and see what happens.
  4. Try highlighting different sets of data as well.

Depend on Google Explore

The next time you need to analyze student data, don’t forget about Google Explore. It’s incredibly helpful, easy-to-use, and will become a tool you can depend upon.
This blog was originally published at

Thursday, April 20, 2017

Transform your Classroom into a Game Show

The ever popular TV game show Jeopardy can provide an enjoyable way of reviewing content with students. At a recent Google workshop, I divided participants into teams and we played the game. Immediately, the participants’ eyes lit up and everyone was actively learning together.
I created the Jeopardy game using Flippity. Flippity is a great service that offers a handful of templates for creating interactive games that you can use in the classroom. There are 11 tools that you can select from:
  • Flashcards
  • Quiz Show
  • Bingo
  • Hangman
  • Spelling Words
  • Random Picker
  • Mix and Match
  • Badge Tracker
  • Progress Indicator
  • MadLibs
  • Certificate Quiz
Each tool has a link to a demo page, so you can see it in action, and a link to the step-by-step instructions for the tool. In addition, each tool also has a Google Sheets template that you can make a copy of and then fill in with your own information.

Steps for Making Your Own Game Show

If you want to make your own Jeopardy quiz show, follow the steps below:
Step 1: Modify the Google Spreadsheet Template
• Make a copy of this template. (You’ll need to sign-in with your Google account.)
• Edit all the Quiz Show Questions (and answers and categories) to fit your content.
• Do not edit any cell with a blue background and don’t delete rows or columns.
Step 2: Publish Your Spreadsheet
• Go to File, Publish to the Web, and then click Publish.
Step 3: Get Your Flippity Link
• Click on the Get the Link Here tab of the template (at the bottom).
• Click on the link to test out your game.
Step 4: Bookmark, Share, and Play
• Make a shortcut or bookmark to get back to the game whenever you want to play.
• Share the game with your colleagues and have them try it out.
• Play the game with your students.

Flippity Add-On

This past November, the Flippity Add-on for Google Sheets became available. Now it is easier than ever to create games. With this add-on, even your students can create review games with Flippity.
To get the Flippity Add-On:
1. Open a new Google Sheet and click on the “Add-ons” menu.
2. Search for “Flippity” and click on the blue “Free” button to install the add-on.
3. Allow the add-on to connect to your Google account.
4. Go back to the Add-ons menu and click on Flippity–>Pick a Template.
5. After you select your template, your Google sheet is reformatted and you are ready to enter your data.
pick a template_border


Flippity can be a great learning tool for students. I think it is a powerful and fun way for them to review content at home, too. The fact that they can use the review games on their phones and/or tablets makes Flippity even more appealing. Turn your classroom into a game show by giving it a try or by having your students give it a try! It’s certainly a fun way to prepare your students.
Please share your creations in the comments below.
This blog was originally published at