Google Forms
Part 2
In School &
The Classroom
Your Presenters
FSUSD Educational Technology Specialists
Click the link below to make a copy of the form responses we will be working with.
This is NOT a zero
Forms are paired with a sibling spreadsheet.
To make full use, we must learn that tool too.
Agenda - What are we doing here?
Spreadsheet Basics
Freezing Rows
Freezing the top row of a sheet makes column headers.
You can freeze using the View menu or by dragging the dark gray bar past the rows or columns you wish to freeze.
Selecting the Whole Sheet
To format an entire sheet, click the box below fx.
This selects the entire sheet so any formatting selections you make will apply to all cells.
Format Options
Format color of text, color of background (fill color), borders, font, and alignment using buttons on the toolbar.
Text & Fill Color
Text Color
Fill Color
Resizing Columns
Hover your your cursor over the dividing line between two columns until an arrow appears and the line turns blue.
Click & drag the column to the desired width.
Wrap Text
Cells: Conditional Formatting
Conditional formatting uses color to mark certain data. This makes it easier to see patterns.
Start by selecting the cells you want to apply conditional formatting to and then right-click.
Cells: Conditional Formatting
Cells: Conditional Formatting
You may apply several conditional rules at a time, and remove them one at a time.
Sorting Data: 1-Column
The power of spreadsheets is being able to input your data in any order.
Column sorting can help you organize your data exactly how you need it.
Sorting Data: 1-Column
The A→Z alphabetic sort will �also sort numerically.
Sorting Data: Sorting a range (2+)
When sorting a range of date (2 or more columns) our first step is to select the entire range we wish to sort.
Sorting Data: Sorting a range (2+)
Sorting Data: Sorting a range (2+)
With “Range Sorting” we pick the largest groupings first and then work our way down to the smallest groupings.
Sorting Data: Sorting a range (2+)
The range sort did what we told it to do, the data is now sorted by:
Formulas �& �Notifications
A few math tricks and useful communications
Working with Formulas
You can manually enter a formula by clicking into a cell and starting with the “=”.
As you start to type, Google anticipates formulas with a brief explanation of how they work.
Working with Formulas
Example
Formulas - Sum
Start with “=” and the function “sum” and (
Select the first cell in the group you want to add up and drag to last cell.
Close the parentheses.
“ ) ”
Hit [enter].
Formulas - Other Operations
Multiplication uses a “ * ”
Division uses a “ / ”
Use parentheses to force order of operations
Formulas - Countblank
Use Countblank to count all empty cells in a range.
Countif
Use the countif function to quickly count cells within a range that contain a particular name, word, or are greater than or less than a number.
Formulas - Average
Notifications
Get a notification when your form gets responses.
Add-Ons
Add-ons help us carry out automated tasks
Take rows or columns from a spreadsheet and turn them into their own Google Doc.
Click here for a sample Spreadsheet
Flubaroo is a FREE add-on to Google Forms/Sheets which lets you quickly grade and analyze student performance on multiple choice and fill-in assignments.
Flubaroo
Video tutorial
Flubaroo
Now it’s our turn:
Flubaroo - Best Practices
?
Flubaroo - Options
Make Answers Case Sensitive
Flubaroo - Options
Allow more than one correct answer
Flubaroo - Options
Numerical Ranges instead of one number
FYI - Reference
Formulas - Concatenate
Concatenate allows you to string together data from columns or add text.
Formulas - Split
Split can be used to separate info into smaller more useable, sortable pieces.
formMule - Communications Add-on
Hook up any Google Forms destination sheet & set up one or more email templates to send automatically on form submit.