How to Grade Vizia Quizzes in Google Sheets

In this afternoon's Practical Ed Tech Live session I answered a couple of questions about the video quiz platform, Vizia. One of those questions was about how to grade the responses in Google Sheets. I suggested using the Flubaroo Add-on for Google Sheets to grade responses to Vizia quizzes. In the video below I show how to do that.


Here's how to create a quiz in Vizia.

Practical Ed Tech Live! Episode 5

Earlier today I hosted the fifth episode of Practical Ed Tech Live. Thank you to all who submitted questions in advance to those who joined in during the live broadcast. I'll be hosting another episode next week at 3:30pm EDT on Thursday, May 18th. If you missed today's episode, the recording is embedded below. The text of the questions that I answered are copied below the embedded below.


Questions answered in the show:

What’s your email address?

I’ve been following you for a while. I watched for the webinar you did with Greg Kulowiec about virtual reality. I’m still a little confused about the difference between virtual reality and augmented reality. Do you have anything I can read about the differences?

I am going to be a technology coach in our small district next year (I just found out last week). I’ve been following your blog for years. Do you have any tips for new technology coaches?

I was looking at your list of ten ways to use Google Earth in the classroom and I want to try layering old maps onto Google Earth. Do you have recommendations for places to find old maps?

Will Vizia.co work in Google Classroom?

I’m trying to join a Google Classroom with a code that a colleague gave me so that we could learn Classroom together. The code she sent me keeps saying “invalid” no matter how many times she resets it. Do you have any idea why this might be happening?

My Two Most Requested Documents

Last night I forgot to silence my phone before bed. Not ten minutes after putting my head on my pillow I heard a Google Drive alert. I looked over at my phone to see that someone had requested access to my file titled Life on Minimum Wage. That is one of the two most frequently requested documents that I have. The other is titled Captains of Industry. Both documents outline hands-on economics lesson for middle school and high school students. I have now uploaded both documents to Box.com and I have embedded them below for viewing and downloading.

The purpose of Life on Minimum Wage is for students to recognize how difficult it is to save money when your only job(s) pay minimum wage without benefits. To win at Life on Minimum Wage the students have to reach five financial goals that they select. To earn money the students have to complete the tasks of their assigned jobs. The students then have to pay required bills before using money for their selected financial goals. As the game progresses students will be issued "surprise" cards which require them to spend money on things like speeding tickets, trips to a health clinic, and increases in rent.

All of the jobs in Life on Minimum Wage are connected so that if one "business" slows production or closes, the workers of another business are also effected. The goal here is to demonstrate the effects of a business closing on a small town's economy.


Captains of Industry is an economics simulation activity. The original version of this activity was developed by my colleague Jason Long. What I'm sharing here is the activity as I've modified it for my classroom. My version is about 75% the same as Jason's original. The point of the activity is for students to experience and experiment with the tactics of American businessmen in the second half of the 19th century. Before trying the activity it is best for students to have some familiarity with the business practices of Rockefeller, Carnegie, Vanderbilt, and Morgan.


(Note, before you email me about the Browning rifle goal card in Life on Minimum Wage, please understand that these were goals chosen by my students in a rural community. You're welcome to change that card for use in your own classroom). 

Vectr - Free Vector Graphics Design Software

Vectr is a free vector image design and editing tool that you can use online or download to use on your Mac, Windows, or Linux desktop. Vectr provides some pre-made elements and templates that you can use in designing your own graphics.  You don't have to use any pre-made elements as Vectr lets you design completely from scratch. You can also import existing graphics files to edit them. Completed projects can be exported in PNG, JPG, and SVG formats.

For folks like me who might be a bit intimidated by learning how to use a vector design tool, Vectr offers an extensive collection of tutorials in print and video formats.


If you're wondering what a vector image is, it's an image format that easily scales so that you don't lose resolution quality when you expand or contract an image for use in a variety of places. For example, the logos for Practical Ed Tech and Free Technology for Teachers were created as vector images so that they could be used online, on business cards, and on coffee mugs without the image quality being affected by where the image was placed.

Applications for Education
Vectr could be a good tool for students to use to design logos for after school clubs or use to create a logo that represents their academic team. One of my old colleagues used to have his students make logos that represented the groups that they worked in in his classroom. I thought that was a neat way to have students take a little ownership and pride in group work.