Google Sheets & Forms

Agenda

Getting Started

• Prerequisites

  • Google account created

  • Familiarity with Google Drive

  • Familiarity with Google Docs (recommended)

• References

  • Google Apps Learning Center

    • Getting Started with Google Drive

    • Using Google Docs, Sheets, and Slides

• Overview

  • • Sheets - Spreadsheet (like Excel)

    • Forms - Make online survey, quiz, etc.

    • Add-Ons - Add extra functionality, like automated quiz grading (Flubaroo)

Google Sheets

• Info

  • If you know MS Excel, you can learn G Sheets in no time.

  • Google Sheets: Spreadsheet Basics

• Activity

  • • Student datasheet

Google Forms

• Info

  • "Google Forms is a useful tool to help you plan events, send a survey, give students a quiz, or collect other information in an easy, streamlined way."

  • Google Forms is closely integrated with Google Sheets.

  • Create a Google Form

• Activity

  • Survey

Add-Ons (Flubaroo)

• Scripts / Add-Ons

  • Google Scripts allow anyone to customize Google's Apps.

  • Creating a script requires technical knowledge (beyond the scope of this PD).

  • Third-party organizations package their scripts into Add-Ons

  • Add-Ons are relatively easy to use, and can be easily accessed in G Docs and Sheets

• Flubaroo

  • "Flubaroo is a free tool that helps you quickly grade multiple-choice or fill-in-blank assignments."

  • Made by a teacher, for teachers

  • Flubaroo User Guide

• Activity

  • Quiz