I love using Google Classroom. It solves the sharing permissions problem when using Google Docs and makes it so easy for me to find all student work in one convenient place in Google Drive. When I have a specific wish for Google Classroom I use Google Apps Script to create a custom solution.
Keep a Roster
Many of my scripts require that you have a roster of your students and their email addresses. I suggest you keep a Google spreadsheet with this information as a template you can copy and paste from. In any Google Classroom assignment, from the assignment grading screen, click on the settings wheel to “Download these grades as CSV.” This gives you a list of student names and email addresses. (The “all grades” option does not include email addresses). Upload the CSV file to Google Drive and right click to open in Google Sheets. Save this as a template to reference frequently!
Create a spreadsheet that assigns each student a tab.
Attach the spreadsheet in Google Classroom as “Students can edit file.” Each student locates their named tab to do their work. This gives the teacher one document to open to review student work.
Click Here for RosterTab blog post.
Create a spreadsheet to facilitate a classroom discussion.
Create a list of discussion topics on the first sheet. A sheet for each question will be created. Tip to rename long tab names. Attach the spreadsheet in Google Classroom as “Students can edit file.” Use the spreadsheet to let all students give initial thoughts on a topic.
Click Here for DiscussionTab blog post.
3. PDF My Folder
Create a PDF of each students submission to Google Classroom. Helpful if you need to print student work.
While my first question is… why do you want to print? Putting student work on the wall is a good thing to do. You can also use this script to freeze submissions at a certain point in time.
Click Here for PDF my Folder blog post.
4. Grade the Folder
My favorite!! Providing high-quality feedback to students takes some time. Use this script to facilitate the process.
This script extracts all of the submitted student work from a Google Classroom assignment folder to a Google Sheets spreadsheet.
Optionally you can randomize the submissions to give each student a chance to get feedback first.
Grade the Folder lets you rename the student documents to let you know the grading status.
I first set everyone’s status as “FB needed.”
As I provide feedback, I change the status on the spreadsheet to “graded” or “FB given.” Running the script renames the documents to let you and the students know that the document has been reviewed.
Click Here for Grade the Folder blog post.
5. Group Maker
Easily assign students to groups and post them to Google Classroom.
Group maker randomly assigns your roster to groups. Manually edit after the script has run if group adjustments need to be made. Attach the spreadsheet in Google Classroom as “Students can view file.” Students can check the spreadsheet to see what group they are in.
Click Here for the Group Maker blog post.
6. Group Document Maker
Assign a Google Doc template to each group.
This script builds on the group maker script. Assign students to random groups or set your own groups. The script creates a copy of a template you create to allow groups to work together on the same document. Each group member is added as an editor to the document. Other groups can not view other group documents. Attach the spreadsheet in Google Classroom as “Students can view file” to allow students to easily locate their group and their document.
Click Here for the Group Document Maker blog post.
7. List Docs
Create a list of all of the documents submitted to a Google Classroom class. If documents have been returned, sort by student to see what they have turned in.
Use the Google Classroom class folder ID to create a list of everything attached to every assignment in Google Classroom. List Docs creates a single list. Show Docs creates a sheet per assignment. This script is not dynamic so new submissions are not updated to the sheet. However, it can be handy to have submissions in a spreadsheet to allow you to make notes or sort and filter.
Click Here for the List Docs blog post.
Classroom works with Google Docs, Google Drive, and Gmail so teachers can assign work to students. Teachers can attach materials—documents, links, images—to the assignment. All activity is online using a computer or a mobile device.
Students sign in to Classroom, see their upcoming work, and complete it online. When a student turns it in, the teacher sees immediately in the class stream that the work is turned in.
How the assignment flow works
Teacher creates an assignment and attaches files.
|Students attach materials or edit files from the teacher and turn in their work. |
Teacher grades the students' assignments.
Students see their grades and can edit their work.
- Teacher creates an assignment or question—The teacher can post to one or more classes or to individual students in a class and set a due date. If the teacher attaches materials, they control access to them until the work is assigned to students. As students work on an assignment, the teacher can view progress, add comments, and make edits in the documents. Also, when attaching a Drive file (document, slides, or sheet), the teacher can choose to:
- Allow students to view the file—All students can read the file, but not edit it.
- Allow students to edit the file—All students share the same file and can make changes to it.
- Make a copy for each student—Students receive an individual copy of the file that they can edit. The student’s name is automatically added to the document title. When a student turns in the assignment, the teacher sees the file labeled with the student’s name.
For details, see Create an assignment or question.
- Student turns in work—The student works on the assignment by either viewing a document, editing a shared document, or editing their individual copy of a document. The student can attach files, links, or images to their work. When completed, the student turns in their work. Before the due date, a student can unsubmit work, make changes, and resubmit it. After the student turns in a file from Google Docs, Sheets, or Slides, only the teacher has edit access and can make any changes to it.
For details, see Submit an assignment.
- Teacher grades work—The teacher can write notes on student work, add a grade and return it to the student with individual feedback to each student. Learn more about grading and returning assignments and writing notes on student work.
Student sees grade—The student sees their grade. If the student’s work includes a Drive file, the student regains edit access to the file and can work on it again, if needed. For details, see View returned work.
View completed or upcoming work
Teachers can easily see who has or hasn’t completed any work that's due.
Students can always see their upcoming and unfinished work.