How to Make a Gradebook in Google Sheets [2 Ways]

How to make a gradebook in google sheets 18
Key Takeaways: How to Make a Gradebook in Google Sheets

To Make a Gradebook in Google Sheets

  1. Make a column for participants’ names.
  2. Add columns according to the number of subjects.
  3. Add points gained by participants.
  4. Calculate the sum of the obtained points.
  5. Find the average percentage of obtained points.
  6. Find the Grade by applying the IF function.
  7. Drag all formulas over the sheets individually to make an automated Gradebook.

OR

  1. Launch the Google Sheets.
  2. Open template Gallery.
  3. Select the Gradebook template.
  4. Customize the template according to your data.

Hello, welcome back. Today I will teach you how to make a gradebook in Google Sheets. Google Sheets is very familiar to users with multi-function tools and features. Using Google Sheets for your Gradebook is free, and it can help you stay organized and quickly calculate grades. If you also want to make your own Gradebook template in Google Sheets, then here is a detailed guide on How to make a Gradebook in Google Sheets.

Advantages of making a Gradebook in Google Sheets

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.

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.

  1. Make a Gradebook in Google Sheets manually
  2. Make a Gradebook in Google Sheets by template

1. Make a Gradebook in Google Sheets Manually

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.

How to make a gradebook in google sheets 1

Step 2

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

How to make a gradebook in google sheets 2

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.

How to make a gradebook in google sheets 3

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.

How to make a gradebook in google sheets 4

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.

How to make a gradebook in google sheets 5

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.

How to make a gradebook in google sheets 6

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.

How to make a gradebook in google sheets 7

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.

How to make a gradebook in google sheets 8

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.

How to make a gradebook in google sheets 9

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.

How to make a gradebook in google sheets 10

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.

How to make a gradebook in google sheets 11

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.

How to make a gradebook in google sheets 12

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.

How to make a gradebook in google sheets 13

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.

How to make a gradebook in google sheets 14

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.

How to make a gradebook in google sheets 15

2. Make a Gradebook in Google Sheets by using the Template

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.

How to make a gradebook in google sheets 16

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.

How to make a gradebook in google sheets 17

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.

How to make a gradebook in google sheets 18

Step 4

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

How to make a gradebook in google sheets 19

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.

How to make a gradebook in google sheets 20

Frequently Asked Questions

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.

How do you download a Gradebook in Google Sheets?

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.

How to make a gradebook in google sheets 21

Step 2

When you click on the “File” tab from the menu bar, a drop-down menu will open where you will see a “Download” option, clicking on this “Download” button will give you another menu where you will have different kinds of file format, select the format in which you have to download your file.

How to make a gradebook in google sheets 22

How do you print a Gradebook in Google Sheets?

If you have created a Gradebook in Google Sheets and want to present it to your higher authorities in a hardcopy then you may need to print your Gradebook in Google Sheets so, don’t worry follow the following steps to print your Gradebook in Google sheets.

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.

How to make a gradebook in google sheets 23

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.

How to make a gradebook in google sheets 24

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.

How to make a gradebook in google sheets 25

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.

How to make a gradebook in google sheets 26

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.

How to make a gradebook in google sheets 27

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.

Content Protection by DMCA.com

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/

OfficeDemy.com
Logo
Enable registration in settings - general