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.
Great resource about add-ons available for Google Forms and Sheets.
A recent update to Flubaroo gives teachers the option to hand score open ended questions, as well as the ability to include comments about student responses. These are two features many teachers have asked for. See the link below for detailed instructions on how to use the new options.
Read more about Flubaroo’s new features
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.
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.
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.
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:
- You create an assessment using Google Forms.
- Students complete the form/survey, and then Google automatically records the responses in a spreadsheet that it creates in your Google Drive.
- 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.
- 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.
- 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.