Monthly Archives: April 2016

Connect Technology Conference

imgres

I attended the Connect Technology Conference (Canada’s Learning and Technology Conference) this week in Niagara Falls, Ontario.  This was my second time attending this amazing EdTech event.  There were many dynamic speakers and topics but the two tools I was most eager to investigate were Google Hangouts and Skype in the Classroom.   I have already blogged about Skype and will post about Google Hangouts in the near future.  I experimented with Google Hangouts with three classes today and had to work through a few challenges, mainly with adding students, before we were able to get it running properly.  I definitely think this tool would work best with small groups, rather than the whole class, which I attempted today.

Computer Repair Investigation

Slide1

  • The purpose of this investigation is to see if computer repair companies really know what they are doing and if they are charging the correct prices.
  • Many people are desperate to get their technology fixed and do not know much about their devices
  • Marketplace TV rigged an apartment in Toronto, Canada with hidden cameras
  • They created a small problem to a computer and called in 10 repair techies
  • Only 30% of the techs were able to diagnose the problem
  • In all of their testing, one techie performed poorly in every way – service, diagnosis, price and privacy
  • They went to London Ontario to interview one of the founders of Nerds on Site about this employee

Slide1

Google Math g(Math) Add-on for Google Drive

Slide1

• Create and insert Math Expressions and Graphs in Google DOCS, SHEETS and FORMS using a new add-on for Google Drive called g(Math)

• This guide has instructions for accessing the g(Math) add-on and step-by-step instructions for using it

• Use g(Math) with Google Forms to create online quizzes and tests

• For multiple choice quizzes, you can use the Flubaroo add-on in Drive to grade the quiz for you!

Slide 1

Slide2

Slide 2

Slide3

Slide 3

Slide4

Click on the link below to download this free guide…

Google Math g(Math) Add-on For Google Drive

Google Classroom – Deleting a Class

download

I had a question… “How do I delete a class from Google Classroom?”

The main thing to understand is that you can’t delete a class until you archive it.

At the end of a semester of the school year, you may want to archive a class to preserve the class materials, assignments and any postings in the class stream. When you archive a class, you no longer see it among your other classes. It is moved to a separate area.

Slide1

 

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

Create Your Keyboard Activity

Slide1

Here is a fun activity that I created in October and I have used it with four computer classes. Students create and format tables to build their keyboards using Microsoft Word or Publisher. However, I have found that the most user friendly program for this activity is Microsoft PowerPoint.  Using PowerPoint, they build their keyboard on one slide.

Here are a few student exemplars…

Slide2

Slide3

Here is a marking scheme for the project…

Slide4