Tag Archives: Google Sheets

Creating QR codes in Google Sheets

Slide1

QR Codes

• A QR code (Quick Response Code) is a type of matrix barcode first designed for the automotive industry in Japan
• When scanned with a smartphone, tablet or laptop they will take you to a website, article, video, social media page and more
• All you need is a camera lens on your device and a free QR code scanning app
• QR Codes can be used for many classroom activities including website and video investigations

QR Code Generator
QR Code Generator is an add-on for Google Sheets
• It allows you to generate QR codes directly from Google Spreadsheets
• Make multiple QR codes quickly and easily

The instructions below will show you how to create QR Codes in Google Drive using an add-on for Google Sheets called QR Code Generator

Slide 1

Slide2

Slide 2

Slide3

Slide 3

Slide4

Creating Rubrics in Google Forms and Sheets

Slide1

You can create, complete and send rubrics to students using Google Forms.  This allows you to mark projects/activities and send results to students directly in Google Drive.

• The two types of Google Form questions that are effective for creating rubrics are are multiple-choice grid and linear scale
• You can also convert an existing rubric into an image and add it to your Google Form rubric
• You can print out or send the completed form data to students via email by viewing the responses in Sheets

Here is a link to a resource to show you how to do it…

Google Form Rubrics

You can also create, complete and send rubric results to students in Google Sheets by using an add-on for Google Drive called Online Rubrics.

Slide1

Here is a link to a resource to show you how to do it…

Google Sheet Rubrics

Flubaroo – New option to share graded assignments through Google Drive

Flubaroo is an add-on for Google Drive.  I have used Flubaroo several times this semester to grade multiple choice Google Form quizzes.  Flubaroo recently added a new option so that you are now able to share graded quizzes to students through Google Drive instead of just by email.  The screen shots below show the step-by-step process to share grades…

Slide2Slide3

Flubaroo New Feature – Send Graded Assignments to Students through Google Drive

imgres

I have been using Flubaroo a lot this semester to grade multiple choice quizzes I have made in Google Drive Forms.  I found out about a new Flubaroo feature from Richard Byrne on his Free Technology For Teachers Blog that allows you to send graded assignments to students.  Click on the link below to view his post…

Send Graded Assignments to Students Through Google Drive

For step-by-step instructions for sending graded assignments, click on the link below…

Share Grades through Drive – Step-by-step instructions

I am excited to try out this new feature after my students complete their next quiz in Google Forms.