Google (Classroom, Docs, Forms, etc.)
Page Navigation
- Google Chrome
- Google Calendar
- Google Certification & Training
- Google Chat
- Google Classroom
- Google Contact Group
- Google Docs/Drive
- Google Drawings
- Google Earth
- Google for Education Blog
- Google Forms
- Google Jamboard
- Google for Littles
- Google Meet
- Google My Maps
- Google Sheets
- Google Sites
- Google Sketchup
- Google Slides
- Add Voice Notes in Google using Mote
- Instructional Technology
- Google Sheets
-
Google Sheets
Basics
How to use Google Sheets (Google Support Page)
Customize your Spreadsheet & Data Cheat Sheet
Beyond the Basics
Google Sheets Resources - from Eric Curts
Spreadsheet Skills Everyone Should Know - YouTube Channel from Trevor Beck
-
Autocrat - Google Sheets Add-On
What is it?
- Autocrat is an Add-On in Google Sheets that lets you merge the spreadsheet data with a Google Doc, Sheet, or Slide.
- Create a Google Form to gather information from a group of people (students, teachers, parents, etc.), then run Autocrat in the Google Sheet of results that merges the fields into a Google docs/slides template you created.
- Set it up so the Google Doc/Slide is automatically emailed to the participant when they complete the form. (Or run it manually)
Examples
- Your students/teachers complete a Google Form when they've finished a project/training.
- Upon submitting the Form, they receive an email with a certificate of completion to acknowledge their accomplishment.
- It's all automated using the Autocrat you applied to the Google Sheet of form responses!
- Great for administrators to use for teacher walkthrough feedback, too!
How do I get it?
Install the Autocrat add-on from the Google Workspace Marketplace
How does it work?
Step 1: Create your Google Form*
*not necessary if you're running the Autocrat from spreadsheet data that you already have
Step 2: Create your template letter/certificate in Google Docs/Slides
Step 3: Set up Autocrat in the Form's Google Sheet of responses
User Guide
Autocrat User Guide
Video Instructions
-
Sheet Share add-on
- Share individual sheets/tabs easily.
- Allow two-way editing and keep data synchronized.
- Google sheets only allows sharing the whole spreadsheet. If you want to share a single sheet, you either use "publish to web" or "import range" as workarounds. These have limitations. Sheet Share can help!
How do I get it?
Install the Sheet Share add-on from the Google Workspace Marketplace
-
Awesome Autocrat templates and samples!
Google Drive folder (below and linked here) of templates and samples created by @Physed_Pomeroy!