Friday, January 23, 2015

g(Math) for Google Sheets

I have been approached numerous times by math teachers who wish they could write mathematical expressions into Google Forms to create online quizzes.  At the moment, I know teachers are creating the expressions in a drawing program and then inserting them as images into a Google Form.  Time consuming?  Yes.  Frustrating?  Yes.

g(Math) for Sheets to the rescue!  This is a Google Sheets Add-on that allows you to create mathematical expressions directly in a Sheet for use in Form.  It is easy to add into your Google Sheets.  Simply pull down the Add-ons menu while creating your Form.  Search for gmath.  Add it.  You're ready to roll!  g(Math) for Sheets will remain in your Add-ons menu whenever you need to access it in the future.

I admit I am mathematically challenged.  So I won't pretend to understand all the features of g(Math) for Sheets.  However, I encourage our math teachers to watch the video below to get an understanding of how to use g(Math) for Sheets and what this add-on is capable of achieving.  As always, contact me if you need any help using this tool.  I hope this saves you a lot of time.  Additionally, this website offers help with g(Math) for Sheets:  http://www.gmath.guru .


Wednesday, January 21, 2015

Save As Doc: Create easy-to-read pages from Google Spreadsheets responses

If you've ever administered a test using a Google Form, you may have been frustrated by the results when students complete extended response essays. Student responses are recorded in a spreadsheet. Each answer is placed in a cell. The extended response cells are very difficult to read because the sentences are squeezed into a very small area.  Save As Doc to the rescue!  Save As Doc is a Chrome extension that converts the spreadsheet into an easy-to-read document.  Those extended response essays can now be read clearly online with the click of a button.

Here's how to use Save As Doc:

1.  Sign into Chrome.
2.  Open the results spreadsheet for the online test.
3.  Pull down the Add-ons menu.
4.  Select Get add-ons.


5.  Search for Save As Doc.
6.  Click on the Save As Doc add-on and install it.  Authorize and accept all permissions.
7.  Select the Add-ons menu again.  Select Save As Doc.  Select Start.



8  Select all the cells in your spreadsheet (including the Row 1 header) that you wish to grade.  [I recommend selecting all of the completed cells in the spreadsheet, even the non-extended response answers.  This will ensure that you include the students' names and class periods.]


9.  Type a name for your document in the Save Doc file as section.
10.  Check the boxes for First row of selection contains headings and Add a pagebreak after each row.
11.  Press the blue Save as Doc button.
12.  Once it finishes working its magic, click the link to Open the Doc.  (This document has been saved in your Drive.)
13.  Voila!  You can now scroll through the results and easily read your students' extended responses.  :-)

Thursday, January 15, 2015

Using Goobric and Doctopus in Google Classroom to create scorable online rubrics

If you are using Google Classroom to have students submit assignments, you will likely benefit from being able to grade the assignments completely online.  In the olden days, you would create and print a rubric.  Now you can use Goobric to integrate rubrics created in Google Docs to grade your students' online projects with no paper.  Every student receives a customized rubric in their Google Classroom.  Grading is a cinch.

I created a step-by-step guide to help teachers set up Goobric and Doctopus.  It does take a bit of tinkering, but the effort is well worth it.  In the long run, you will save yourself a lot of time, and you will streamline your grading.

Click here for the tutorial:  http://t.co/G6MM2oVZ4F

First-timers are strongly encouraged to watch the video below when getting started.  The video is easy to follow.  It helped me create my first Goobric.


As always, please contact me if you want help setting this up or if you run into any snags along the way.  Happy Goobricking!  :-)