Discussion Tab


One of my favorite classroom tools is to use a spreadsheet to facilitate discussions. Yesterday I added a couple of new features to my DiscussionTab template. You can now more easily delete a tab and the cell with the question is now protected to keep students from typing over it.

What DiscussionTab does is allows you to create a list of discussion topics on the first sheet of the spreadsheet. Running the DiscussionTab script creates a tab for each question, places the question on the sheet and locks the question down so students can not edit the question. Students can then respond to the discussion question collaboratively.


The template is located at http://alicekeeler.com/discussiontab


Create a copy of the template.

Create a List

On the first tab write your list of questions you want to dicuss with students.
List of Discussion Topics

Run the Script

After typing your discussion questions into column A you will want to run the script. You can click on the button or use the “DiscussionTab” menu along the top.
Run Script

Run DiscussionTab menu

Delete the first Tab

Before you share the spreadsheet with students you’ll want to delete the first tab (named Roster). The run script button will create the tabs again when the button is pressed.

Delete Tabs

Especially if you accidentally run the script twice you may need to delete tabs. You can click on the tab and choose “Delete” from the menu. However, deleting a tab this way asks you to confirm the delete. Instead you can use the DiscussionTab menu to choose “Run DeleteTab.” This will delete the tab you are looking at. If you make a mistake and delete a tab you did not want to delete you can use Control Z to undo.

Share Spreadsheet

Make sure you click on the blue share button and change the sharing settings so the spreadsheet is no private. Best is to distribute through Google Classroom as “Students can edit file.”
Students can edit

Direct students to the tabs at the bottom of the spreadsheet. Each tab is labeled with the discussion question and the discussion question is placed on each sheet. The question should be locked down on the sheet so students can not edit it. Students can then find a blank cell and contribute their answer to the discussion question. Use this to start a class discussion. When you are ready for the next discussion question tell students to “Go to the next tab!”

Running DiscussionTab



Digiprove sealCopyright secured by Digiprove © 2015