g(Math) Google Add-on

gMath is a handy mathematical expression builder for Google Docs, Sheets and Forms. that lets you create complex expressions and graphs with ease. The following videos demonstrate how to use this handy tool.

Google Forms – student assessment

Google Docs – student worksheets

Google Sheets – worksheets and quick quizzes

gMath Help – In case your question about gMath wasn’t answered in these videos, there is  additional information at the manufacturer’s site.


CECA – Form Notifications

CECA Pre-conference: October 25, 2015.

Harness the power of Google’s notification feature to automatically receive email alerts when someone submits your Google form or survey, and use Gmail’s filtering capability to organize these emails for easy access.

Accessing the form’s data file

  1. Create a Google Form
  2. Open the associated Google Sheets file for the form either by clicking on it in Drive or:
    1. Open the form
    2. Select “Responses” from the menu
    3. Select “View responsesFORM1

Set notification rules in Google Sheets

  1.  Within Google Sheets, select Tools > Notification rules…screen1
  2. A window will open to let you set notification rules. Choose:
    1. A user submits a form” from the notify me at section
    2. Email-right away” if you want an email for every form submission or “Email-daily digest” if you prefer to receive a single email each day which contains all the submissions.screen2

Create a filer in Gmail to organize emails

  1. To create a filter in Gmail to group form submission emails:
    1. Open one of the auto generated emails in Gmail
    2. Select More > Filter messages like these
    3. Leave the default choices on the first screen of the pop-up window and select Create Filter with this Search linkgmail2
    4. Put a check mark next to the “Apply the label” and choose your label from the list (you can also choose New label if you have not already created the label).gmail3
    5. Press Save
    6. Press Create Filter

Now every time someone submits the form you will get an email and it will automatically go into the folder/label you just created.

Introduction to Google Sheets

Google Spreadsheets allows you to organize, edit and analyze different types of information using spreadsheets. In this lesson, you’ll learn about the different ways you might use spreadsheets and how to navigate the Google Spreadsheets interface. You’ll also learn the basic ways to work with cells and cell content, including how to select cells, insert content, copy and paste cells, and more. Watch the video to learn how to navigate the Google Spreadsheets interface.

Every row and column of a new spreadsheet is always set to same height and width. As you begin to work with spreadsheets, you will find that these default sizes are not always well-suited to different types of cell content. Watch the video to learn about modifying columns, rows, and cells, including wrapping text and merging cells.

A quick how-to guide for sorting and filtering in Google Spreadsheet

A convenient and time-saving feature of Google Spreadsheets is its ability to add, subtract, multiply, and divide numerical information for you. Spreadsheets uses mathematical expressions called formulas that make handling these calculations easy. In this lesson, we are going to focus on formulas that contain one mathematical operator.

Most of the time you will be using a cell’s address in the formula. This is called using a cell reference. The advantage of using cell references is that you can change a value in a referenced cell and the formula will automatically recalculate. Using cell references in your formulas will make sure the values in your formulas are accurate. Watch the video to learn how to work with simple formulas in Google Spreadsheets.

Google Sheets: List of Names

Two great tools to make working with lists of names easier.

A spreadsheet (like Google Sheets or Excel) is a great tool to sort and manage lists of names. Depending on how the data was entered, sorting and manipulating the data can sometimes be a challenge. Occasionally it is easier to have the first name and last name in separate columns. Other times, it would be nice to have one column with the first and last names combined. In this video, I demonstrate two easy formulas that let you take control of your data and save you time.

Quick Sum in Google Sheets

If you need to sum a column of numbers in a spreadsheet, and aren’t comfortable using formulas, then this video about the “quick sum” feature in Google Sheets is for you. Simply highlighting your data gives you the sum, mean, min, max and count of the values. Fast, easy and NO formulas. You’re going to love it.

Flubaroo – A tool to grade assessments

Lots of teachers are asking questions about using Flubaroo to grade assessments. It’s a great tool. Flubaroo is an add-on for Google Sheets that must be installed from the Chrome store (super easy). (Google Sheets is Google’s spreadsheet program which is similar to Excel).

This is how it works:

  1. You create an assessment using Google Forms.
  2. Students complete the form/survey, and then Google automatically records the responses in a spreadsheet that it creates in your Google Drive.
  3. You add a row to your spreadsheet with the correct answers for your assessment.
    • You can have more than one correct answer
    • Answers are exact matches, so Flubaroo works best with multiple choice, true/false type questions. You can use text boxes, but realize that US does not equal USA or United States or any other combination. Flubaroo uses a letter by letter match and they must be identical.
  4. Tell Flubaroo to grade the assignment and in just a few moments it will create a new worksheet in your spreadsheet with a summary of the data.
  5. You’re done! When you get some practice with this, you can go from students completing an assessment to a graded assessment in under a minute. Grades still need to be entered into Powerschool manually. Consider it for entrance/exit surveys.

This intro video (3:14) explains how to get started with Flubaroo. If you have additional questions, I can always come to your PLC meetings. Just ask.

A more detailed explanation of using Flubaroo.