Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Moderating a Twitter Chat: Google Sheets Template

Twitter Chat Moderator Template

Moderating a Twitter Chat: Google Sheets Template

Twitter Chat Moderator Template

Moderating a Twitter Chat

Twitter chats are great ways for educators to connect. Moderating a Twitter chat is definitely rewarding but requires some organization. Since “the answer is always a spreadsheet,” I created a template to facilitate the process for being a Twitter chat moderator.



Chat Information

After making a copy, fill out the first tab “Getting Started” with the chat information.twitter chat moderator spreadsheet template fill in chat details

fill in colored cells

Next Tab

Notice the tabs along the bottom. Each tab sets up different parts of the chat.
use the tabs in the spreadsheet to organize the chat


In column B are some pre-written promotional tweets. You can add additional promotional statements to column B. The hashtag is automatically included in the tweet. Click on the blue link in column D to generate a tweet.
tweet out promotions about the chat

A new tab is opened in the browser that contains the tweet. You need to click on the blue “Tweet” button to send the tweet.
click to tweet the tweet

Control W

Use the keyboard shortcut Control W to close the twitter tab and go back to the spreadsheet.


The opener tab is the tweets you will use to open the chat. Welcoming people to the chat and telling them the format. You can add additional opening messages to column B. Use Column D to click on the blue link and create the tweet.


Prepare your questions in advance on the questions tab. The Q1, Q2, etc… will automatically be appended to your tweet. Omit those from column B. The hashtag is automatically added to the end of your tweet. Simply focus on the question. Click on the blue link in column D to launch the tweet during the chat.
write questions in column B the hashtag and question will automatically be appended.


The closer tab is your statements you say at the end of the chat. Again, use column D to click on the blue link to launch the tweet.

Students Prepare to Present

Help Your Students Prepare to Present

Maximize student success in presentations with ‘Speaker Notes by AliceKeeler,’ the ideal Google Slides add-on. Enhance how students prepare to present with easy transfer of speaker notes to Google Docs, promoting effective communication skills. Dive into the world of engaging, technology-aided presentations and empower students to shine in their academic endeavors. Discover the key to transforming student presentations into interactive, skill-building experiences.

Read More »

Infographic 7 Basic Steps for a Google Form

New to using Google Forms? This tool is essential for teachers to not only save time but to be adaptive to student needs. Use Forms to survey students, play games, personalize instruction, and assessment. This infographic on the 7 basic steps for a Google Form will help you get started.

Read More »

Online Workshop: Get Your Add-on Published

How can you make Google Workspace (Docs/Sheets/Slides) even better? You can create custom Add-ons with Google Apps Script. Wondering How to Get Your Google Workspace Add-on Published? Join Alice Keeler, Google Developer Expert, to learn the steps to get your Add-on officially published.

Read More »

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.