While I want threaded discussions in Google Classroom, I do not want them in the stream. Multiple student responses will clutter up the Google Classroom stream quickly. I always say “the answer is always a spreadsheet” so I created a way to use Google Sheets for a threaded discussion and use it in Google Classroom….
Category: Apps Script
Classroom Discussions with Google Sheets
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…
Making a LOT of Copies of the Same Google Docs
Sometimes I have need to make a lot of copies of a document in my Google Drive. For example, I have a template for creating badges in Google Draw. However, I need a lot of badges for my project. Manually duplicating the template 50 times is tedious. I wrote a script to accomplish this faster…
Google Classroom – Using RubricTab to Assess Students
Previously I created a rubric template that allows you to create a rubric, paste your class roster, and then create a copy of the rubric for each student to make evaluation for your class easy. I have upgraded the script (Add-On) so that it now creates a spreadsheet for each student to share with them…
Math Teachers: Alice’s Guide to LaTex
Do not ask me how to pronounce LaTex, but as a math teacher it is a useful thing to know! In a nutshell LaTex let’s you put pretty print math symbols on the web. If you need fractions and square roots it can be very helpful to know just a little LaTex. Most websites will…
Google Apps Script: You Can Code (part 3)
Google Apps Script is a great way to get started with learning to program. You need to know very little JavaScript and are able to create really useful projects quickly. For this tutorial we will NOT add any new JavaScript techniques. Check out the first tutorial where you changed the name of a Google…
Google Apps Script: Getting Started Part 2
In the first Google Apps Script tutorial you learned a little JavaScript to allow you to change the title of a Google Doc. In this tutorial you will create a document and make multiple copies of the document. Getting Started with Google Apps Script JavaScript Recap Function: A chunk of code that is used perform a particular task….
Webinar: Use FilterRoster on your Google Forms for Individual Student Spreadsheets
This is a webinar that is a result of @edtechchic exclaiming on Twitter how much she loves the Google Sheets formula =importrange(). I told her that if she loved that she might like my script I wrote that creates and individual spreadsheet for each student based on filtered data from a Google Form. The process uses…
Google Apps Script: Getting Started
My new obsession is Google Apps Script. It allows me to add a little code to a Google document to make it do even more magical things! What I was amazed by was how little coding you need to know to be successful at Google Apps Script. My First Project I had created a spreadsheet…
Google Forms: Streamline your Data with FilterRoster Script
If you re-use a Google Form for attendance, turning in homework, daily warm-up, peer evaluation data, or anything where there are multiple rows per student in your Form data my script FilterRoster may be helpful. It creates a tab for EACH student with a filter to show just that students data. Rather than filtering the Google…
Google Sheets: Create Tabs Quickly
If you have ever clicked the plus icon to create a new tab and renamed the tab multiple times you know how tedious this can be when using a spreadsheet. I wrote a script that allows you to take a list and create a tab for each item in the list. I previously posted the…
Google Sheets: Rubric Template
Most teachers need to use a rubric at some point. This template is a 4 point rubric that will help you to score student work against the rubric. Make a copy of the template. Copy and paste your students names onto the roster tab and enter in your rubric information. Run the RubricTab script in…
Google Docs: Mark As Graded
When assessing student work done in Google Docs it can be a challenge to know which student documents you have looked at and which ones you still need to look over. When looking in my Google Drive folder with student work I need a system for looking at the titles of the files in Google…
You must be logged in to post a comment.