Google Apps Level 2: Self Paced Course

Event Details

  • Date:
    • January 24, 2022 - March 11, 2022
  • Presenter Name:
    • Darlene Kennedy
  • Registration Deadline:
    • January 23, 2022
  • PGP Points:
    • 6
  • ESC Member Price:
    • $100.00
  • Non Member Price:
    • $100.00
  • Facilitator:
  • Location:
Event Cancellation Policy
Go Back

Description:

This course is designed to build on your knowledge of Google Apps by diving deep into two areas:  Google Forms & Add-Ons for core Google Apps

  • Collect data with Google Forms
  • Extend the ability of data collection with sections, document submission, and add-ons
  • Response analysis with charts, sheets, and notifications
  • Explore Add-Ons in Docs, Sheets & Slides
  • Use Classroom for Administrators & Office Staff

SEE REGISTRATION FORM AT BOTTOM OF THE PAGE

Agenda:

 

WEEK 1

Google Forms: 

Collect Data

  • Create/Setup a new Form
  • Settings
  • Using/Finding Templates
  • Question Options
  • Adding Pictures
  • End-User Adds Document
  • Turning a Form to a Quiz
  • Point Values
  • Grading Answers
  • Connect to Classroom for Office Use
WEEK 2

Google Forms: Responses

  • Viewing Individual Responses
  • Viewing Question Summaries
  • Using Graphs/Charts 
  • Collect Data in Spreadsheet 
  • Lock Responses
  • Print Options
WEEK 3

Google Forms:

Sections & Add-ons

  • Create Sections for end-user efficiency
  • Mapping Sections
  • Add signature options
  • What are add-ons?
  • Using Add-ons for automated responses to submissions
  • Sending certificates of completion
  • Create timers for responses
WEEK 4

Google Doc Add-Ons

  • What are Add-Ons for Docs?
  • How to review an add-on
  • How to install an add-on
  • Review the following add-ons:
  • Grammarly: more than spellcheck
  • Translate: Multiple languages
  • DocuSign: signature options
  • Fillable: Create forms
  • Doc Builder
  • QR Code Generator
WEEK 5

Google Sheet Add-Ons

  • What are add-ons for Sheets?
  • Review Add-Ons for Sheets
  • How to install an add-on
  • Review the following add-ons:
  • Template Gallery
  • FormBuilder (works with Forms)
  • Advanced Summary
  • Translate my Sheet
  • MailMerge
  • Flaticon
WEEK 6

Google Slides Add-Ons

  • What are add-ons for Slides
  • Review Add-Ons for Slies
  • How to install an add-on
  • Review the following add-ons:
  • Math equations
  • Pear Deck
  • Flaticon: Add Icons
  • Unsplash: Free image library
BONUS MATERIAL

Google Classroom for Office Users & Admins

  • Walk through how to use Google Classroom for Administrators
  • Create classrooms for your teaching staff to access resources
  • Allow teachers to submit documentation and keep it automatically organized

Target Audience:

  • K-12 Building or Central Office Staff/Administrators
  • Individuals comfortable with the use of creating/sharing in Google Apps
  • Office Staff and Administrators wanting to learn how to take Google Apps to the next level!
  • Data Collectors: HIPPA/FERPA compliance in Forms

Register:


Event Cancellation Policy

NIESC Cancellation Policy

Registrants who notify NIESC of their cancellation on or before the registration deadline date will not be required to pay the registration fee.

  • Registrants who cancel after the registration deadline but one week before the workshop date or call to cancel on the day of the workshop, will pay 50% of the registration fee.
  • Registrants who neglect to call or notify NIESC of their cancellation will be responsible for paying the full registration fee.
  • On official school corporation weather-related cancellation days, registrants will not be required to pay registration fees