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.

Template

alicekeeler.com/tweetmod

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

Promo

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.

Opener

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.

Questions

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.

Closer

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.

© 2024 All Rights Reserved.

❤️ Become a Premium Teacher Tech Member

Discount applies until you cancel!! 
Normally $12 a month, save 58%!! 

Monthly installments of only $4.99 a month.

Exclusive Teacher Tech Content! 
Exclusive Online Courses
Premium Add-ons for Google Workspace
Office Hours with Alice
Weekly Check In Support
Exclusive Webinars
And more! 

Exit this pop up by pressing escape or clicking anywhere off the pop up.

💥 FREE OTIS WORKSHOP

Join Alice Keeler, Thursday Oct24th or register to gain access to the recording.
Create a free OTIS account.

Join Alice Keeler for this session for using FigJam to start every lesson.

Exit this pop up by pressing escape or clicking anywhere off the pop up.