1. The best way to make a Gradebook in Google Sheets: Make a column for participants’ names > add columns according to the number of subjects > add points gained by participants > calculate the sum of obtained points > find the average percentage of obtained points > find the Grade by applying the IF function > drag all formulas over the sheets individually to make an automated Gradebook.

2. Another way to make a Gradebook in Google Sheets using a template: Launch the Google Sheets > open template Gallery > select the Gradebook template > Customize the template according to your data.

If you are a school teacher and have hundreds of students then making a Gradebook manually can cost so much time and effort while you can make it simple by making an automated Gradebook in Google Sheets so that you will not have to make calculations for an individual student just put the points, Google will automatically give you the results. So, let’s go through the tutorial on how to make a Gradebook in Google Sheets.

In this tutorial, I will give you a complete guide on making a Gradebook in Google Sheets manually, moreover, we will also see, how can we get a Gradebook template in Google Sheets.

In this method, we will make a Gradebook step-by-step manually in Google Sheets and will tell you how you can make an automated Gradebook in Google Sheets. In this tutorial, we will discuss basic and compulsory principles regarding a Gradebook, although you can add or remove any part from the following steps.

Step 1

Here, I have added some headings of Name, Grade, percentage, points, assignments quiz, etc. As you can see in the following picture, I have added some names in the Names column.

Step 2

After writing students’ names, I will add their progress regarding marks or points in different subjects as written below.

Step 3

Now, I am applying the sum formula in the entire row till the end to calculate all added points even those that will be added later by giving the following range as mentioned below.

Step 4

Once you have got one result, then you can drag the formula over the cells to get the other results as I have gotten in the following example.

Step 5

In the above formula, we have also found the total numbers through which we will calculate the average progress percentage made by the student by simply dividing obtained points by total points.

Step 6

As we are calculating the average progress in percentage, we will multiply the resultant number by 100 to get the result in percentage as mentioned below.

Step 7

Here, you can see the result in the following picture, as highlighted below, we have gotten the average progress percentage for all these students by simply dragging the formula.

Step 8

Now the work for getting grades has started, to apply the Grade formula, we will use the “IF” function in Google Sheets where I will give the criteria “If percentage is greater than or equal to 90” in the following pattern as highlighted below.

Step 9

After giving the logical expression, we will specify the value in the result so that if the percentage is greater than or equal to 90 then give it an “A+” grade.

Step 10

Don’t close the formula, continue it by separating the comma symbol and giving the criteria for all the percentage stages as highlighted in the following picture.

Step 11

In the last criteria, we will use less than sign for all rest of the fewer values that will all fail as specified in the following screenshot.

Step 12

Once you are done with specifying all the criteria for the percentages then you will have to close all the brackets that you opened in the syntax.

Note: If you miss opening or closing any bracket and use comma symbols and quotation signs where needed, then your formula will not work, so be careful while applying the formula.

Step 13

Now just press the Enter key and get the result, You can also simply drag the formula over the other cells as highlighted below.

Step 14

This Gradebook is automatic, if make changes with any point in the book, it will automatically impact all the results. Even, if you add another assignment or subject, Google Sheets will automatically calculate the added subject as you can see in the following example.

Step 15

Not only in points you can make variations but also add more people to your grade book if needed, As you can see the result is in the following animation.

Fortunately, Google Sheets has a pre-made template for Gradebook in its template gallery, if you want to prevent such a long process and making calculations then you can access a Gradebook template by following the steps.

Step 1

When you open the Google Sheets web page, you will see a “Template Gallery” option in front of you as highlighted below. Click on it to open Template Gallery.

Step 2

When you open Template Gallery, at the end by scrolling down, you will find a template for “Grade Book” as can be seen in the following picture.

Step 3

By just clicking on this, you can access a Grade book in Google Sheets. When you open this Gradebook template, it will consist of two or three tabs. On the first tab, you will see an overview of the student’s report.

Step 4

While on the second tab, you will see the actual student’s points, percentages, and grades.

Step 5

If you want to make changes to this data, you can do so through the following tab, You can also add more participants to this template.

Can I Use the Assignment Tracker Method for Creating a Gradebook in Google Sheets?

Yes, you can use the google sheets assignment tracker method for creating a gradebook. By utilizing the functionalities of Google Sheets, such as formulas, conditional formatting, and data validation, you can effectively track and manage assignments while keeping an organized and efficient gradebook. The google sheets assignment tracker simplifies the process, allowing you to easily enter grades, calculate totals, and generate reports.

Once you have completed a presentation on making a Gradebook in Google Sheets, then in many scenarios you may need to download your file, like sharing, record keeping, printing, making a PDF, etc. If you don’t know how to download a file in Google Sheets, then the following guide is for you.

Step 1

Once you have created a Gradebook in Google Sheets, then go into the “File” tab from the menu bar of Google Sheets, located at the left top corner of the window as highlighted below.

Step 2

Step 1

To print your Gradebook, first select all your data, then go into the “File” tab from the menu bar of Google Sheets, where you will find the “Print” button. Click on this “Print” button.

Step 2

When you click on the “Print” button, a panel will open at the right side of the window, select the “Selected cells” option first.

Step 3

When you click on the “Selected cells” option, Google Sheets will automatically fit all the selected data on one paper, check the print preview before printing.

Step 4

Once you are satisfied with the Print preview simply click on the “Next” button from the print panel as highlighted in the following screenshot.

Step 5

In the next step, you will get the browser print setting, If you don’t want to make any changes then click on the “Print” button to get the printout of your Gradebook.

Conclusion

That’s all about how to make a gradebook in Google Sheets. Now that you know how to make a Gradebook in Google Sheets, hope the above article will be helpful to you. For more related topics keep visiting Office Demy.

M. Shaiq Ansari

Hi, I am Shaiq, I am a highly skilled technical writer working full-time for Office Demy. I am specialized in Google Workspace and Microsoft Office applications. With a background in Software Engineering, I possess a deep understanding of the intricate functionalities and features of these productivity tools. Connect me on Linkedin https://www.linkedin.com/in/shaiq-ansari/

Enable registration in settings - general