-Complete Guide for Grading book Using Google Classroom and Sheets

Introduction #

This guide provides a step-by-step process for teachers to effectively manage grading in Google Classroom using Google Sheets.

Step 1: Google Classroom Preparation (Teacher’s Side) #

As a teacher, you need to configure each Google Classroom class for the semester. For instance, if you teach 20 classes this semester, you must repeat the following steps 20 times.

Configure Google Classroom Grading #

1. Open one of your classes in Google Classroom and navigate to the class settings.
2. Scroll down to the Grading section and apply the following settings:
   • Enable Automatically apply a draft grade to missing assignments.
   • For Overall grade calculation, select Weighted by category.
   • Optionally, choose to Show overall grade to students.
3. In the Grade Categories, add all the category names and their corresponding percentages as provided by your academic supervisor or school management. For example:
   • Classwork: 25%
   • Midterm: 25%
   • Homework: 20%
   • Final: 30%
   • Ensure that the total equals 100%.
4. Click Save to apply these settings.

Add Class Content #

Before you can enter students’ grades, you must add class content (assignments, classwork, quizzes, exams) that you will grade. To do this:

1. Open the same class in Google Classroom and go to the Classwork tab.
2. Click the Create (+) button to add any content type (Assignment, Quiz, Question).
3. In the content creation page, fill in the details such as title and description. From the side panel under Grade Category, select the appropriate category for this content. All previously created categories will appear in a dropdown list.
4. Enter the points for this content. If you want to make this content ungraded, select Ungraded so it will not appear in the gradebook.
5. Click Assign to share the content with your students.

Repeat this process for different types of classwork, assignments, or quizzes, ensuring you select the correct grading category for each.

Enter Students’ Grades #

If you have created an assignment or homework that students completed online, their grades will be automatically recorded, and you will only need to review them. If you have assigned content that requires manual grading (e.g., paper-based assignments), follow these steps:

1. Open Google Classroom, select the desired classroom and go to the Grades tab.
2. In the Grades tab, you’ll see a list of all students along with the content you added, categorized accordingly.
3. Start by reviewing the automatically recorded grades or manually entering marks for each student.
4. To grade all students at once, click the three dots and select Grade All to enter a grade, which you can adjust as needed.
5. Repeat this process for each column of classwork.

Once you have finished entering or reviewing the grades, click the three dots at the top of the column and select Return All to send the grades back to the students.

You can also edit or delete grades in bulk by clicking the three dots and choosing Edit or Delete.

Make sure to use Return All at the top of each column to save the grades.

Step 2: Moving Grades from Google Classroom Gradebook to a Consolidated Sheet (Reviewer) #