Jump to content

Unit 2: Utilizing Google Suite Products

From KNILT

Navigation Links:

Unit 2: Utilizing Google Suite Products

Performance Objectives

Upon completion of Unit 2, students will understand how to utilize additional Google Suite products in combination with Google Suites By the end of this unit students will be able to:

  1. Identify compatible products
  2. Explain selection of products
  3. Create activity using (2) or more Google products
  4. Implement functions from Unit 1

Directions

  • Please navigate through the mini-lesson
    • Google Suites
    • Google Sheets with Google Suite Products
    • Examples for Classroom Use: Sheets & Forms
    • Video Lesson
  • Complete Learning Activity
    • In/Out Ticket

Mini-Lesson

1. Google Suites

Please review the simple overview of each product:

2. Google Sheets with Google Suite Products

Check out this article on 4 products to combine with Google Suites
Key takeaways:

  1. Digital Portfolios with Google Forms
  2. Digital Rubrics and Rubric Portfolios
  1. Class Resource Sheet
  2. Research Planning & Archiving

3. Examples for Classroom Use: Sheets and Forms

Please read this article for ideas: 25 practical ways to use Google Forms in class, school

Key Takeaways:

Procedural Stuff
  • Daily Check-in
  • Sign out sheets
  • Customized email newsletters
Assessment
  • Auto-graded quizzes
  • Exit ticket
Learning & Creating
  • Logs
  • Conference Schedule

4. Video Lesson

  • Auto Filling Sheets with Forms
Load video
YouTube
  • How to Format Form Responses in Sheets
Load video
YouTube
  • Refer back to Unit 1 for automatic grading techniques
    • Conditional Formatting
    • CountIF
    • SUM

Learning Activities

1. Create an In/Out ticket using Google Forms. Have the Google Sheets perform (2) automatic grading functions.

Next Unit: Unit 3

Extended Resources

25 practical ways to use Google Forms in class, school. Ditch That Textbook. (2021, January 24). https://ditchthattextbook.com/20-practical-ways-to-use-go.

4 Creative Uses of Google Sheets in the Classroom. EdTechTeacher. (2017, January 5). https://edtechteacher.org/google-sheets-in-the-classroom/.

Google. (n.d.). Google Docs: Online Word Processing for Business | Google Workspace. https://workspace.google.com/products/docs/.

Google. (n.d.). Google Forms: Online Form Builder for Business | Google Workspace. https://workspace.google.com/products/forms/.

Use Google Forms to Auto Fill Google Sheets with Data. (2019). YouTube. https://youtu.be/jxqlkxRO5Aw.

Retrieved from "https://knilt.arcc.albany.edu/index.php?title=Unit_2:_Utilizing_Google_Suite_Products&oldid=180754"