G-Suite Videos

The following are a collection of videos explaining how to use various aspects of G-suite (Google Forms, Google Sheets, etc.). They are designed for Tohoku University staff, but anyone may use them. If there are any requests for more videos, please let me know.

How to Use Google Forms (from absolute beginner to intermediate):

Part 1: (0:40) Creating a Google Form

Part 2: (4:36) Populating a Google Form with Questions

Part 3: (11:27) Settings for Quiz/Test/HW

Part 4: (17:20) Setting the Answers

Part 5: (20:21) Advanced Tips

Part 6: (27:41) Sending to Students

Video: https://youtu.be/3b8y_eKH2Dw

How to Transfer Student Data from Google Forms to Your Grade Book (from beginner to intermediate):

Part 1: 0:05 Getting Answers from Google Forms and Preparing the Data

Part 2: 7:16 Getting the Data into Your Grade Book Correctly

Video: https://youtu.be/Eq6kxuZmewU

How to Get Sharable Links from Google Drive (beginner):

Video: https://youtu.be/8a9po-AQMtc

How to use Google Sheets App Script* to Create a Speaking Homework Assignment:

Video: https://youtu.be/77uM8zhKb94

*This script is my original work, if you use it for research, please cite appropriately (see my "Code & Misc." page).