Free Online Gradebook

  • Premium Gradebook
  • Start Free Gradebook

Free Online Gradebook

Free Online Gradebook Flexible Grading Options. Distribute Assignments and Collect Homework. Easy to Use.

Start your free gradebook.

Distribute & collect assignments online.

Automatic mass email to students and parents.

Advanced messaging.

Student & parent access.

Choose a free gradebook or ad-free premium gradebook.

Distribute Assignments and Collect Homework. Powerful Messaging. Ideal for Distance Learning.

Gradebook with intuitive interface.

ThinkWave Educator has an intuitive, easy-to-use, interface that can be learned quickly. Multiple classes can be maintained in a single gradebook. There is no need to login multiple times to access different classes.

Easy to Use From All Devices

ThinkWave Educator is completely cloud based which means there is no software to install and teachers can access data from school or home. ThinkWave can be used with Internet Explorer, Firefox and Safari and Chrome on PC, MAC, Linux, iOS and Android devices.

Get the Gradebook That's Right for You

ThinkWave Educator is great for solo teachers who want a basic, free gradebook. ThinkWave Educator Premium is for teachers who want a full-featured gradebook with 100 GB online storage.

Upload Assignments and Handouts Online

Save on paper and toner cartridges. ThinkWave Educator provides the functionality of a learning management system with the ability to upload homework and handouts online. Uploaded files can be up to 25MB each and the Premium gradebook includes 100 GB online storage. Many file formats are supported including .pdf, .doc, picture files, movie files and others. Homework is available for students and parents to download online. The upload function can also be used to organize handouts in one place. No need to email files between home and school -everything is available online from any computer.

Online Portal for Students and Parents

ThinkWave improves communication by providing individual, password-protected accounts for students and parents to access classroom information. Detailed, day-to-day summary of student progress includes overall results, graded assignments and upcoming assignments. Grades Online enables student achievement by improving organization and allowing for early intervention.

Assign and Collect Homework Online

ThinkWave Educator offers the powerful ability to collect homework from students online. Students upload their homework files with an easy-to-use upload function. Files are immediately available to the teacher in the gradebook. Uploaded files are organized for the teacher by assignment and date.

Messaging and Group Emailing

ThinkWave includes ability to post messages and announcements. Messages can be directed to all students and parents, particular groups of students or specific classes. Files can be uploaded with blog posts. Messages can be sent by email to the entire group with one click.

Flexible Grading Options

Use an all-points grading system or a flexible grading system that combines points, letter grades, check, check plus, and custom grades. Create your own assignment types and use assignment type weighting, for example, making Tests 30%, Homework 40%, Projects 15% and Participation 15%.

Powerful Reports

ThinkWave Educator includes powerful report capabilities that generate professionally-formatted, ready-to-print, .pdf documents. Reports can be customized with a logo and header and multiple other customization options.

Frequently Asked Questions

Can all the teachers in my school use the gradebook.

There are several options to provide online gradebooks for teachers in your school. For schools that want to provide pre-populated gradebooks with students and classes already enrolled, the ThinkWave Administrator school management system is the best option. It combines data from all teachers into progress reports, report cards, transcripts, student summaries, and other reports. There is even a tool to upgrade a solo gradebook to a schoolwide version. If there is no need to combine teacher information, options include site licenses for the premium gradebook. Finally, any teacher can always use the gradebook free of charge.

How do I start a new year in the gradebook?

The online gradebook provides a powerful rollover feature, which copies students, classes, custom field data, and more from year to year. This makes it easy to have a fresh start each year, while information from previous years remains readily available. There is even a feature to copy assignments from previous years, simplifying the setup process. For teachers who will be teaching a new set of students during the upcoming year, there is an option to not copy previous-year’s students.

Can I copy assignments from previous years?

Yes, a copy assignments function makes it easy to copy assignments from a teachers gradebook to a different class, term, or year. In the Setup menu, select Copy Assignments, then select the class and specific assignments you want to import.

Can I have different grading options for different classes?

Yes. You first establish default grading options, then customize them for individual classes and even terms. Grades can be calculated using pure points or flexible grading options, which handle letter grades, pass/fail grades, custom grades, assignment-type weighing, and more. Grades can also be calculated by weighting subterms, so for example, the semester grade can be calculated from the quarter grades and final exam.

Can I drop the lowest assignments?

Yes. In the grading options screen for a class, you can drop the lowest scores for any assignment type, such as homeword, projects, tests, or quizzes. These parameters can be set in default grading options, or different classes or terms.

Can I email all the students in a class?

Yes. The messaging function includes email capability, so that when you post a message to students and parents of a class, it can also be sent by email. You can also email reports such as student summary reports or report cards.

Can students and parents access their grades online?

Yes. Every student (and optionally) parent has a personal online account to access grades, assignments, assignment results, messages, and attendance. Each student can have multiple parent accounts, and each parent can see all their students’ data in one view.

Can I send and receive messages from students and parents?

You can post messages to all the students and parents in a class, and enable a public discussion regarding the message. Each assignment can have a class-wide discussion associated with it, and teachers and students and parents can maintain private discussions regarding assignment results.

Am I limited to points-based grading systems?

No. Flexible grading options let you use points, percentage, letter, pass/fail, complete/incomplete, and custom grade scales for assignments, tests, and quizzes. You can use assignment-type weighting, as well as drop lowest assignments. Of course, Pure Points grading scale is also available.

Are there limitations to the number of students, classes, or assignments?

There are no limitations for students, classes, or assignments. There are even instances when an entire school manages all their data using a free gradebook. Of course, the school management system is preferable for schoolwide use, because it combines data from multiple teachers into a consolidated environment. But even so, the free gradebook does not maintain any artificial limitations.

Can the gradebook work for homeschooling?

The gradebook, as well as the student management system , is a perfect solution for a homeschool environment.

Can the gradebook work for college, trade schools, or other environments?

The free solo gradebook is used by teachers and processors in the widest possible range of educational settings. The upgrade to student management software is also used by colleges, trades schools, international schools, parochial schools, foster care environments, and much more.

Can I distribute and collect assignments online?

Yes. The gradebook provides learning management functionality. Teachers can post assignments with rich text and file attachments. Students can submit their work, and teachers can return corrected student work. Public discussions can be associated with assignments, and private discussions between the student and parent are available with each assignment result.

Can I weight grades by assignment type?

Yes. There is the option to use existing or create custom assignment types, as well as the option to calculate the final grade as a weighted average of assignment types.

Can I record custom data in custom fields?

Yes. Custom fields can be defined for students, teachers, parents and classes. Data can optionally be automatically copied to subsequent school years during the year rollover procedure.

Can I import students?

Yes. There are three options to choose from. Simplest is to add students one at a time. Next is a quick add function, which lets you cut and paste a large list of students and import them all at once. There is also an import wizard, which lets you import students from a delimited file, with advanced capabilities including addresses, parent data, and custom field data.

Buy Premium Gradebook

If you received a startup sheet from your school, start here .

Cloud-based School Management Software

Ideal for Distance Learning. Fast to Deploy. Uniquely Easy-to-Use.

Start Your School 30 Days Free

Distribute assignments and collect homework. Powerful messaging.

Start Free Gradebook Does Not Expire

Getting Started in the Gradebook

  • Last modification date Updated On April 25, 2022
  • Categories: Canvas
  • Categories: Getting Started , Grading

Print Friendly, PDF & Email

When you click  Grades  from  Course Navigation , you are taken to the  Gradebook . This page is where you can easily view and enter grades for students. Depending on the Grade display type, grades for each assignment can be viewed as points, percentage, complete or incomplete, GPA scale, or letter grade.

Only graded assignments, graded discussions, graded quizzes, and graded surveys that have been published display in the Gradebook.  Not Graded  assignments and unpublished materials are not included.

The default view in the Gradebook is to view all students at a time, but you can also view students or assignments individually in the Gradebook Individual View .

Find all of Canvas’ guides about the Gradebook .

assignment gradebook

Bulk Grading

Canvas allows for the bulk grading of assignments through the Gradebook. Bulk grading can be applied to all ungraded assignments or all ungraded assignments that are past due in specific Assignment Groups or across a course. “Past due” means that the assignment has a due date that had passed when the assignment was submitted or that the assignment is missing. Assignment submission statuses ( late or missing ) do not affect an assignment’s “past due” status. When an assignment is graded in this manner, late and missing submission policies are ignored. Find out more about bulk grading in the Canvas guide How do I apply scores to ungraded assignments as an instructor? This feature is disabled by default; To enable it, check out  How do I manage new features for a course?

Grade Posting Policies and Visibility

Grade Posting Policies are one of a few settings for a course that are set from the Gradebook (along with the Late Submission Policy and the Missing Submission Policy ). Grade Posting Policies define the default visibility of grades in a course. You can set a Grade Posting Policy for individual activities or across all activities. There are two possible settings for Grade Posting Policies:

  • Automatically Post Grades:  Grades are visible to students and trigger notifications upon entry by default. 
  • Manually Post Grades:  Grades are hidden from students and notifications for grades and submission comments are not sent. Once grades are revealed, they are visible to students and notifications will be sent.

The  Grade Posting Policy  default setting is set for you to  Manually  post grades. You may want to change this for quizzes that rely on automated grading.

When working with grade posting policies and visibility, learn to

  • Select a grade posting policy for an entire course with  How do I select a grade posting policy for a course in the Gradebook?
  • Select a grade posting policy for an activity with  How do I select a grade posting policy for an assignment in the Gradebook?
  • Post grades for an activity with  How do I post grades for an assignment in the Gradebook?
  • Hide already posted grades for an activity with How do I hide grades that were previously posted in the Gradebook? 

Important Notice

  • If you change a hidden grade, the total score will be affected in the instructor’s view, but students will not see a change in their total score until the grade has been released
  • If you would like to review quiz settings with CTI instructional designers, please contact us at  [email protected]  to schedule a consultation.

Grade Display Options

Canvas provides many ways you can change the way you see information in the  Gradebook . You can also make some changes which will affect how information displays to students in the  Grades  page. When changing grade display options, learn to

  • Arrange Gradebook columns with How do I arrange columns in the Gradebook?
  • Use the Total column with How do I use the Total column in the Gradebook?
  • Filter the Gradebook with How do I filter columns and rows in the Gradebook?
  • Use the Notes column with How do I use the Notes column in the Gradebook?
  • Hide/Show Unpublished  assignment columns with How do I view the Unpublished Assignments column in the Gradebook?
  • Identify the icons and colors in the Gradebook with How do I use the icons and colors in the Gradebook?
  • Hide Totals from students with  How do I hide totals in my students’ grade summaries?
  • Hide Grade Distribution Graphs from students with  How do I hide grade distribution scoring details from students?

There is also the option to turn on the Enhanced Gradebook Filters feature . Learn to use enhanced Gradebook filters at How do I create a filter in Enhanced Gradebook Filters?

When using enhanced filters, keep in mind the following about using multiple of each type of filter:

  • Assignment Group – Additive filters. You will see EVERY assignment that is in ANY of the selected assignment groups.
  • Module – Additive filters. You will see EVERY assignment that is in ANY of the selected modules.
  • Section – Only the first filter of this type will show results. Adding a second section filter will not further filter or broaden results.
  • Student Group – Only the first filter of this type will show results. Adding a second student group filter will not further filter or broaden results.
  • Submissions – Additive filters. You can choose to see results with submissions and/or results with ungraded submissions (which all show with submissions anyways).
  • Assignment Group & Module – Restrictive filters. You will ONLY see assignments that are in BOTH a selected module and a selected assignment group.

Additional Resources

  • Canvas Instructor Guide: Gradebook
  • Canvas Student Guide: Gradebook
  • CTI Resource: Grading FAQs
  • CTI Resource: Process Checklist: Grading
  • How do I view assignments or students individually in the Gradebook?
  • How do I apply a Late Submission policy in the Gradebook?
  • How do I apply a Missing Submission policy in the Gradebook?

Creative Commons License

Subscribe By Email

Get a weekly email of all new posts.

Your Email Leave this field blank

This form is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Canvas Basics: Gradebook Setup & Grading

Section menu close, office of academic technology.

  • Instructional Technology
  • Online Course Design
  • Training Opportunities
  • OAT Updates & Tech Tips
  • Copyright & the TEACH Act

Contact Information

Mary Stuart Rogers, MSR 380

Part of the  Canvas Basics  series

Exploring Assignment and Activity Types

Canvas makes a distinction between assignments and activities.  Assignments  are almost always graded.  Activities  still require students to do something, but the task itself will not earn the student any points. 

What is the difference between a Canvas Assignment and a Canvas Activity?

Creating Assignments First

To get started configuring your  Canvas Gradebook , be sure to first create a  Canvas Assignment  for every graded assignment in your course. Assignments can be set to display grades as points, a percentage, complete/incomplete, GPA scale, or letter grade. After creating and publishing a graded assignment, it will appear in the Canvas Gradebook.

Create a new assignment

For an in depth look at each assignment and activity type, visit the help pages for  Assignments ,  Discussions , and  Quizzes .

How do I use the New Gradebook?

Former Blackboard User Tip : Many Blackboard Grade Center setup tasks are addressed in the Assignments area of a Canvas course. 

Grading In-Class or Assignments Without Submissions

Grading of in-class presentations, participation, in-class exams, or assignments submitted as hard copy can be included in your gradebook as non-submission assignments.

Creating an in-class or physical assignment

How do I create assignment columns for non-submission assignments in the Gradebook?

Entering or Updating Grades in the Gradebook

Like an Excel spreadsheet, grades can easily be entered and updated directly within the Canvas Gradebook. Use the keyboard  Enter  and  Arrow Keys  to quickly enter grades. Click on the arrow inside each cell to make comments or change the submission status.

Grading individual cell in Gradebook

How do I enter and edit grades in the New Gradebook?

For assignments where the majority of students are to receive the same grade, use the  Default Grade  option to bulk update each student's grade for an individual assignment. 

Gradebook tools menu with Set Default Grade option selected

How do I set a default grade for an assignment?

Mute  an assignment while you grade, ensuring all students see their grades at the same time. You can also decide to hide the entire gradebook from students.

Gradebook tools menu with Mute Assignment option selected

How do I mute or unmute an assignment in the New Gradebook? How can I hide the gradebook from students?

Gradebook Tools

Grabebook Tools  maximize your productivity when using the Gradebook.  They also make grading in bulk much more straightforward. These tools are found on the top of the student roster.

  • Gradebook:  View all students and assignments.
  • Individual:  View grades and points for a single student at a time with customizable settings.
  • Gradebook History:  ​View previous grades on assignments from yourself or a grader.
  • Arrange  or  Filter  students by different categories.
  • Toogle the visibility for  Notes  and  Unpublished Assignments ​.
  • View the  Statuses ' legend for a color key in the gradebook, along with customizing the colors.
  • The  Actions  dropdown allows you to  Import  or  Export  grades and rosters in the  .csv  file type.
  • The  All Modules  dropdown allows you to view assignments from all modules or a singlular module at a time.
  • The  Search Bar  allows you to quickly find students.
  • Set a default grade for all missing work.
  • Set a customized grade deduction for late work.

Gradebook header area

How do I upload changes to the Gradebook?

Creating Assignment Groups

Assignment Groups  give your gradebook structure, helping students see the major graded components of your course.

Note:  In Canvas, all assignments must be in a group, even if the group will only hold a single assignment or activity.

Creating an assignment group

How do I add an assignment group in a course?

Former Moodle User Tip:  Assignment Groups in Canvas are similar to Categories in the Moodle Gradebook. 

Weighting Assignments by Percentage

Should you choose to grade using weighted assignment categories, first create Assignment Groups. Then give each group a percentage of the total course grade.

Steps to add weights to assignment groups

How do I weight the final course grade based on assignment groups?

Awarding Extra Credit

Canvas handles extra credit in a novel way. Canvas does not provide a dedicated extra credit setting, instead allowing instructors to add extra credit points to any assignment. If you need to create a dedicated extra credit assignment, set the points for the assignment to 0. Later during grading, add however many points the student earned for attempting the extra credit assignment. Those points will function mathematically as 'extra credit'.

How do I give extra credit in a course?

Dropping Lowest Scores

Within an Assignment Group, choose to  drop the lowest scores  within a series of assignments with the same number of points.

Steps to drop a lowest score in a group

How do I create rules for an assignment group?

Using SpeedGrader

Use  SpeedGrader  to enter grades directly within an assignment while providing students written or verbal feedback. 

For an in depth look, visit the help pages for  SpeedGrader . 

Creating a Rubric

Help students see the criteria you will use to grade their assignments.  Rubrics  in Canvas are interactive, permitting an instructor to simply select a cell in the rubric providing points towards a score. 

For an in depth look, visit the help pages for  Rubrics . 

Viewing a Student's Grades

You can view an individual student's grades during office hours or advising by clicking on their name in the Gradebook.

Steps to view a student's graded progress in a course.

How do I view a student's Grades page in a course?

Handling Missing Submissions in Canvas

In Canvas (as in Moodle), any missing submissions, or activities or assignments that have not yet been graded by an instructor will appear as a dash (-) in the Canvas gradebook.  A dash (-) in the gradebook is not the same as a zero (0).  Canvas will NOT calculate a dash (-) into a student's total grade.

Here are two examples of when a dash (-) will appear in your gradebook.

Example 1 : A student did not attempt an online quiz or upload a required assignment in Canvas. For that gradebook item they will have a dash (-) in the gradebook.  A dash (-) in the gradebook is not the same as a zero (0).  

Example 2 : You collected an in-class assignment and manually graded students' assignments. You entered all grades for the assignments you collected. If a student did NOT turn in their assignment, you did nothing. For that gradebook item, a student who did not submit the assignment will have a dash (-) in the gradebook.  A dash (-) in the gradebook is not the same as a zero (0).  

The gradebook example below illustrates the effect of a dash (-) as opposed to entering a zero (0).

Annotated grading page

Changing missing submissions (-) to zero (0) grades

There are 3 suggested ways to update any gradebook items from a dash (-) to a zero (0) so that the student's gradebook total is accurate. 

1. Replace (-) with 0 as you grade with SpeedGrader or Gradebook

Check your Canvas gradebook for any missing submissions from students. Manually change any dashes to zeros so that the gradebook item will count towards their total grade. See the guides below on how to edit grades in Canvas.

How do I enter and edit grades in SpeedGrader?

2. Use the default grade tool to change all missing submissions to zeros

Canvas has a gradebook tool that you can use to change all grades for a specific gradebook column. Once you have entered grades for a submitted assignment, (or the deadline for an online self-graded quiz has passed) Canvas can update existing missing submissions (items that appear as dashes) to a zero. For more information on this process, please see the guide below.

Note:  When using the tool this way, make sure you do NOT select "Overwrite already-entered grades" as this would replace any grades you have already entered.

Default grade window

3. Apply the Missing Submission Policy in the Gradebook

Canvas has a new gradebook tool that allows for grading policies. The missing submissions policy allows an automatic score to apply to missing submissions. The missing label applies to things that are still missing after the due date. By setting this policy to a 0%, missing submissions will automatically receive this score. You can always adjust the score down the line by removing the missing label and modifying the score.

Missing submission policy

How do I apply a Missing Submission policy in the New Gradebook?

What to learn more?

View all Canvas Guides for  Assignments  and  Grades .

Information on this page is adapted from content created by the  Center for Effective Teaching and Learning  at Cal State L.A.

Updated: August 18, 2022

Modal Title

The Center For Learning & Teaching

  • Canvas Tutorials
  • How Do I…
  • Appointments
  • Who To Go To
  • Faculty Central
  • About the CLT

Setting Up Your Gradebook

This article guides you through the process of setting up your Canvas Gradebook using weighted assignment groups. If you are not using weighted assignment groups (for example, if students accumulate points over the course of the semester, a strategy sometimes called “additive grading”), skip the first step and make sure that you assign point values correctly. If all of your assignments are in a single group, make sure it is worth 100% of the grade, not the default 0%.

We provide a video tutorial and written instructions below.

Video Tutorial

Written Instructions

Step 1 – define assignment groups.

Your assignment groups and their percentage values should exactly match the grading breakdown on your syllabus.

Most people choose to base their assignment groups on types of assignments (homework, quizzes, iterative reflections, etc). You may also wish to create a group for a major project that has multiple components. Using point values, you can weight different assignments within a group.

Some special assignment group situations exist:

Extra Credit – The easiest way to give extra credit is to create an assignment group called Extra Credit , and have the assignment group total (shown on your Canvas course’s Syllabus page) be greater than 100 percent. Learn more about ways to manage extra credit .

Attendance – There are two ways to calculate attendance. The first is to use the built in Roll Call feature. The second is to create an assignment group called “Attendance” and create assignments within that group. Roll Call will keep track of student attendance, but is very limited in how it grades attendance. Creating your own attendance assignments gives complete flexibility in grading, but requires that you keep track of attendance outside of Canvas (paper or spreadsheet).

Step 2 – Create Assignments

Most faculty will find that creating assignments in the Assignments screen to be the most intuitive, though you can also do it from the Modules and Calendar views, or from Quizzes and Discussions for those assignment types. Learn more about creating assignments.

If you are using assignment groups, create your assignments within the appropriate group by clicking the “+” icon to the right of the group title. This icon will allow you to quickly create assignment “placeholders”. You can select if you want your assignment to be a quiz, discussion, or another assignment type and set the due date and point value; go back later to edit details like the description. (If you create an assignment using the big blue “+ Assignment” button, you will be able to edit details immediately, but you will not be able to select special formats like a discussion or quiz, and the assignment will not be placed in the group you want. If you use this button or you make an assignment in the wrong group, you can drag and drop it to the correct group.)

An assignment group in Canvas with 30% weight.

If possible, try to create all assignments in their correct groups before the semester starts, even if many or most are simply placeholders until you have time to create descriptions, quiz questions, etc. This helps avoid snafus with the Gradebook later.

We strongly recommend making assignments out of 100 points so that everything within a given assignment group is equally weighted, unless you specifically do not want them to have equal value.

Step 3 – Determine Which Assignments to Collect Online

You can choose whether an assignment will be collected online, on paper, or not at all (“no submission”, typically used for participation). Open and edit an assignment to see its detailed view and change the submission type to “Online”. Learn more about adding assignment details , including point values, submission type, due dates, and descriptions.

Consider enabling Turnitin. It is fully integrated with Canvas and only requires a simple checkbox in the assignment settings. Learn more about using Turnitin in Canvas.

These three steps will get your Gradebook set up to the minimum standard. We strongly recommend proceeding with steps four and five as well for a robust experience with assignments.

Step 4 – Add Assignment Details

Adding a complete assignment description is highly recommended, and adding a due date is nearly essential! Students benefit greatly from clarity about expectations and deadlines. You can add these details by editing the assignment via the same path you use to set the submission type above.

Assignment descriptions/instructions can be as brief or detailed as necessary. If assignment instructions are already written in Word or PDF documents, it is easy to attach them to the assignment description. For Canvas discussions, make sure the student’s expectations are clearly defined. These expectations should include length of writing as well as other requirements for participation.

Step 5 – Mute Assignments (Grade Posting Policy)

The feature previously known as assignment grade “muting” is now controlled by changing an assignment’s grade posting policy. You can set an assignment so students cannot see their grades until you manually release all grades for that assignment (a good option if you want all students to receive their grades at once). The grade posting policy is controlled from the Gradebook rather than from the assignment itself. You can set a policy for a specific assignment , or you can set a policy for the entire course .

Was this article helpful?

About the author.

' src=

Josh Blumberg

Related articles.

  • Views/Eye icon 169
  • Views/Eye icon 166
  • Upvote hand icon 0
  • Views/Eye icon 278
  • Views/Eye icon 441
  • Views/Eye icon 348
  • Upvote hand icon 3
  • Views/Eye icon 799

Facebook Icon

  • Student Life
  • Career Success
  • Champlain College Online
  • About Champlain College
  • Centers of Experience
  • Media Inquiries
  • Contact Champlain
  • Maps & Directions
  • Consumer Information

Logo for Pressbooks

Want to create or adapt books like this? Learn more about how Pressbooks supports open publishing practices.

Getting Started with the Semester

Setting up your assignments and gradebook

assignment gradebook

your gradebook is created by your assignments.

The term “assignments” here also includes graded Canvas quizzes, discussions, and activities using Canvas-linked tools such as Top Hat or Quick Check. The act of creating an assignment is what makes the column appear in the Canvas Grades tool. The Grades tool does not have an option to add columns independent of an assignment.

Since assignments create your gradebook, it is to your advantage to only create assignments that you will actually grade. If you will not grade “reading a chapter,” then while you are assigning the reading to students, you would not create a Canvas assignment for it. If you want to give students reminders about reading deadlines, Canvas Calendar Events will put those deadlines in students’ Canvas To-Do list. For more on using the Canvas Calendar tool, see the Canvas Guide “ How do I use the Calendar as an instructor? ” (You can also add reminders for class sessions by adding an event for the class meeting and duplicating to the end of the semester .)

Set up Your Assignments

There are several different types of graded assignments you can use in your course. The three main ones are Assignments, Quizzes, and Discussions and they each have their own tool in Canvas. You can create each type of assignment in its own Canvas tool or in a Module. Every graded quiz and discussion will appear in both their own tool and the Canvas Assignment tool.

Click on each item below to learn about the different types.

If you would like to include extra credit in, or in addition to, any of your assignments, see the Canvas Guide “ How do I give extra credit in a course? “

Set up Assignment Groups – Optional

If you want to weight grades without worrying about calculating proportional points for each assignment, you’ll want to set up Assignment Groups in the Assignments tool. They are especially important if you prefer to grade with percentages only (every assignment is worth 100%) or a combination of percents and points. Even if you’re not weighting grades, if you have a larger number of assignments, assignment groups can help you organize assignments and make them easier to find in the gradebook using filters.

The following Canvas Guides explain setting up assignment groups and weighting them.

  • How do I add an assignment group in a course?
  • How do I weight the final course grade based on assignment groups?
  • How do I create rules for an assignment group? (i.e. dropping the lowest grade in an assignment group)

Questions? Talk to your campus teaching and learning center !

Click “Next” below at the bottom right to continue.

A Canvas Semester Checklist Copyright © by Trustees of Indiana University is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License , except where otherwise noted.

Free Gradebook Template

This free Gradebook Template for Excel started out as a very basic grade book spreadsheet, but it has evolved into something that is very useful, flexible, and powerful (and still free). We now have a few different types of grade books that can handle most of the major grading systems used in high school and colleges.

For new teachers : I've included a lot of information on this page about how to use the grade book. There are some details that I wish I would have known my first time.

Some of the features that make this template particularly useful are the ability to mark excused assignments , hide/show names or IDs , apply different weighting to homework and exams, apply a simple curve to the final grades, and make adjustments to the grading scale . In addition, because the gradebook is in Excel rather than an online gradebook system, you can add cell comments and format cells to highlight specific grades.

You may also want to check out the Class Attendance Tracking template.

Gradebook Template : Percentage System

This system is commonly used in high schools and for courses that involve more subjective grading like art and literature. On each assignment, the grade is recorded as a percentage. The percentage might be a calculation, such as earning 25 out of 30 points. Or, the percentage might be recorded based on performance or a subjective letter grade. The nice thing about this system is that you can use whatever method makes sense for a particular assignment. If you are unsure what template to use, I would suggest using the percentage-based version.

Excel Gradebook Template (% System)

Watch Demo Video

License : Educational Use (not for distribution or resale)

Weighting Factors vs. Points : If you use total points for the weighting factors, then the percentage system is almost exactly the same as the point-based system, except that you are recording grades as percentages, and doing the calculations for each assignment by hand.

Converting Letter Grades to Percentages : The grading scale is used to define the minimums for each grade. However, when recording an "A-" you would reference a different conversion chart. For example, instead of recording an A- as a 90% (the minimum), you might record it as a 92%.

Extra Credit - Giving extra credit using this system requires assigning the extra credit to specific assignments (such as giving a score of 110%).

Gradebook Template : Point System

In this version, the grading scale is percentage-based (A>=90%, B>=80%, etc.), but in the Gradebook worksheet you enter the number of points earned on each assignment or exam. This system is often used college courses such as science, math, and engineering.

Extra Credit : The values listed in the Points row in the Gradebook worksheet do not necessarily represent "maximum possible" points. For an extra credit assignment, you would enter a "0" in the Points row. Or, if you allow extra credit on a specific assignment, the student might earn a higher score than the one listed in the Points row.

Excel Gradebook Template

Weighted Assignment Types

See below: Weighted Assignment Types

Important! (11/24/2015) - Version 1.3.0 of the file gradebook_points_weighted.xlsx should be considered a BETA version (i.e. higher than normal probability of containing errors). Versions downloaded prior to 11/24/2015 contained errors in the weighting for different assignment types and this version was designed to fix that. Make sure you are using the latest version (at least 1.3.0) and let me know if you find any problems.

Gradebook Template : GPA System

In this version, both the grade scale and the recorded grades are based on a 4.0 grade point system. This type of system might be used by a class in which all grades are subjective and the grading on each assignment is by letter grade. I would have liked to make the template work so that you enter the actual letter grades, but that turned out to be too complex, so instead, the grades are recorded by converting the letter grade to the equivalent point value.

Recording Failing Grades : Unlike the percentage grade scale where failing grades are entered as 50% or half the points, a failing grade is entered as a 0, because the scale is set up so that F=0 and A=4 averages to a C=2.

Excel Gradebook Template (0-4 GPA system)

Important Tip

Have you ever lost all your grades because of a corrupted spreadsheet or lost file? Well, it rarely happens but it does happen, so follow this tip:

How to Use the Grade Book Template

Although some help information is included in the worksheets, I've included additional information about how to use the templates below. The items below are listed generally in the order that you would need to perform the various actions. Regardless of the system you use for grading, remember that grades you give should be Fair and Defendable (see [1] below).

1. Define a Grading Scale

Grading Scale Worksheet - Thumbnail

To avoid confusion or possibly complete chaos, teachers should be very clear about how students will be graded. The grading scale is often outlined in the course syllabus, depending on how structured the course is. College students will usually want to know how many assignments and exams there will be as well the points or weighting associated with the home work and exams.

Each of the spreadsheets contains a worksheet for defining the Grading Scale , depending on the chosen grading method (see below).

2. Add/remove students in the Names and Gradebook worksheets

The grade book template is designed to make it easy to customize the spreadsheet for the size of your class. In the Names worksheet as well as the Gradebook worksheets, when inserting or removing students, you should insert or remove the entire row (right-click on the row number to bring up options).

3. Displaying Student Name vs. ID

It is important to allow students to see their progress. However, students usually like to keep their grades private to avoid heckling from other classmates. So, I've built into the spreadsheet a checkbox for switching between student names (for the teacher's convenience while recording grades) and custom student IDs (to maintain some privacy when displaying the grades to students).

Creating Random IDs : First, enter the Names of the students in the Names worksheet. Second, assign random (but unique) numeric IDs. Then, select all the Names and IDs and use the Excel sort feature to sort the list by ID.

4. Add/remove assignments

You can add or remove assignments by simply copying the entire column for an existing assignment and then pasting that column somewhere between the first and last assignment column. It is important that you do not paste the new column AFTER the last assignment because if you do that, the formulas will not automatically stretch to include the new column.

5. Weighting homework/quizzes/exams

It is fairly common, especially in college courses, to make the exams, quizzes, homework, the final, and class participation each a specific percentage of the final grade. For example, the breakdown might be homework=25% of the grade, midterm=25%, quizzes=15%, and the final=35%.

In favor of simplicity and flexibility in my spreadsheets, instead of calculating each of these totals separately then combining them to get the final grade, each assignment is given either a number of points or a weighting factor. See Weighted Mean on wikipedia.com for a mathematical description.

Example 1 : Relative Weighting - If you wanted an exam to be equivalent to 5 homework assignments, in the Gradebook worksheet you could set the weighting factors on the homework to 1 and the weighting factor for the exam to 5. Or, using the point system, the exam would be worth 5 times as many points as a homework assignment.

Example 2 : Using Total Points - The number of points for each assignment can be used as the weighting for determining what percentage of the overall course grade comes from homework, exams, quizzes, etc. For example, if a typical homework assignment is 25 points and you have 10 of them, the total points for homework is 250. To make the exams worth 50% of the grade, you just need to make the total points for the exams equal to 250, also.

6. Recording grades in the Gradebook worksheet

Excused Assignments : To record an incomplete assignment as excused, you can either leave it blank or enter an "E" or "e" (not case sensitive).

Adding Comments : One nice thing about using Excel is that if you need to include any comments about specific assignments, you can add a comment to the cell (right-click on the cell and select Insert Comment). This comment won't get printed, but it can be useful for you as the instructor. For example, you might want to include a comment about why a particular assignment was excused for a student.

Dropping Low Grades - If your policy is to take the best of 3 exam grades, then this can be handled easily by changing the lowest exam grade to an "E" for "excused". You should probably add a comment so you can keep a record of the actual score earned on that exam.

Guideline for Failing Grades : If you are using the Percentage or Point based grading system, a failing grade is typically less than 60%. However, if a student misses an assignment or scores less than 50%, you should record the grade as 50% or half the points for that assignment. Why? On a typical 4-point GPA scale, F=0 and A=4, so the average between an F and an A is a C=2. If you are using a percentage or point based grading scale, is the average between a 0% (F) and 100% (A) also a C? No, the average would be 50%=F. An Exception : Teachers might choose to give a 0% in order to penalize students for not turning in assignments and to discourage laziness. This would also distinguish a student who didn't do anything from one who struggles but only scores a 50%.

7. Final Adjustments to the Grading Scale

At the end of the course, the teacher usually looks at the grades for the entire class and might make adjustments to the grading scale depending on the class average and distribution of grades. Adjustments are normally only made to raise low grades . Lowering higher grades just makes students angry. The histogram of grades and class average come in handy at this point. When making adjustments, it is vital to remember to make the grades Fair and Defendable - meaning that you as the teacher can defend the grades you give when hounded by students, parents, the department head, or the school board.

Simple Curving : Instead of (or in addition to) making adjustments to the grading scale, you can use the Curve field in the Gradebook worksheet to increase all the final grades by a certain percentage. If you are aiming for a target class average, you can use goal seek to set the Mean percentage to the target value by changing the curve percentage. The curve field is not included in the GPA-based spreadsheet.

Example 1 : If a student's overall percentage was 79.9%, but the cutoff for a B- is 80%, the teacher might decide to change the minimum percent for a B- to 79.9%. To be fair, the teacher might want to shift all minimums down 0.1% in this case (this would also make the changes more defendable).

Example 2 : The policy in department X is to allow 15% of the grades to be A's (including A-, A, and A+). You can determine the minimum score for an A- by calculating the 85th Percentile and then shift the grading scale.

8. Assigning Final Letter Grades

The assignment of the final letter grade in the Gradebook worksheet is done automatically based on the grading scale defined in the Grades worksheet. For the formulas to work correctly, the Grading Scale must be ordered from lowest to highest.

Grading on a Curve

These gradebooks are not designed to automatically grade on a curve. However, what I have described above in "final adjustments to grading scale" is one method for adjusting grades based on a curve.

A Little Background : A common approach to grading on a curve is to first order all the final grades from highest to lowest. Then, you assign A's to the top 10%, B's to the next 23.5%, C's to the next 33%, D's to the next 23.5%, and F's to the lower 10%. These percentages represent a symmetric bell curve for the ABCDF grading system with a C average, but the values will depend on how many A's you are allowed to assign and whether or not the distribution is symmetric. For example, if you can give 10 A's, do you really want to give 10 F's?

The bins for each grade will be different widths. For example, in a 100-point scoring system, the A's may span from 80 to 100, while the B's might be 77 to 79.9 and C's might be 60 to 76.9.

An alternative to ordering the grades (something that the gradebook template doesn't do for you) is to determine the cutoff scores by calculating percentiles and altering the grading scale accordingly.

Using Percentiles : A Percentile is defined as a value below which a certain percent of values fall. For example, 90% of the students score less than the 90th Percentile value.

Let's say that you can assign A's to 10% of the students (including A-, A, and A+). To find the minimum score for an A-, you calculate the 90th percentile using the following Excel formula, where final_scores is the range of cells containing the final student scores.

Plus and Minus Grades (Chromatic Variants): When grading on a curve, the cutoff scores for the plus and minus grades (A-, B+, B-, etc) might be subjective or you might use the system where the minus scores make up the lower 30% of the letter grade and the plus scores make up the upper 40% of the letter grade to correspond with the GPA system. I have built these formulas into grading scale table in the template. However, you can manually enter your own cutoffs.

Applying Weighting to Different Assignment Types

Teachers may sometimes want to make different types of assignments worth a certain percentage of the final grade, such as Homework=30%, Exams=50%, and Attendance=20%. The file gradebook_points_weighted.xlsx has been designed for this purpose.

Final Grade : The final grade is calculated by multiplying the category weight times the category score and adding the results for each category. For example, if the weighting is Homework=60% and Exams=40% and a student's scores are 80% for homework and 75% for exams, then the final grade is 60%*80%+40%*75%=78%.

Extra Credit : In theory, extra credit can be earned by giving a student more points on an assignment than are available for that assignment, although the weight of that type of extra credit is difficult to determine. Defining specific extra credit assignments makes it easier to define the weight of the extra credit on the final grade. For example, if extra credit assignment #1 can increase your final grade by 2%, and a student earned 50/100 of the points possible, their final grade would be increased by 1%.

Scores per Category : The percentage score for each category is calculated by dividing the total points earned by the total points available for that category. Ungraded, excused, or dropped assignments are not included in these totals. Assignments within a category can be given different weights by giving each each assignment and different number of points possible (such as a final worth 150 points and a mid-term worth 100 points).

Dropping Lowest Scores

Dropping the lowest exam score or quiz score is a popular way to make students happy, but weighting factors can complicate this. If you give 3 exams and allow the lowest score to be dropped, it is easy to figure out which one to drop IF all exams are worth the same number of possible points - you drop the assignment with the lowest % score (or lowest points earned - it will be the same).

What if the exams have different weights, how do you know which one has the largest negative effect on the grade? Consider the following scenario in which the overall exam score is calculated as the Total Points Earned divided by the Total Points Possible:

  • Exam A scored 15/20 = 75% (-5 points)
  • Exam B scored 38/50 = 76% (-12 points)
  • Exam C scored 85/100 = 85% ( -15 points )

The overall exam score is (15+38+85)/(20+50+100)=81.2%.

Which one do you think should be dropped, the lowest % score (Exam A) or the score with the largest point loss (Exam C)? Trick question. The answer is B (for this specific scenario).

  • Drop Exam A: (38+85)/(50+100) = 82%
  • Drop Exam B: (15+85)/(20+100) = 83.3%
  • Drop Exam C: (15+38)/(20+50) = 75.7%

The point is ... if you are going to drop a score, keep things simple by making each of the assignments worth the same number of points.

References and Resources

  • [1] "Beginner's Guide to Figuring Your Grades" by Scott Mandel, Ph.D., originally found on educationoasis.com
  • [2] Grading on a Curve at wikipedia.com
  • Grading Systems at wikipedia.com
  • TeacherPlanBook - Paul Shuster from TeacherPlanBook.com helped me figure out a bug in Excel for Mac that was affecting the weighted gradebook. I also created the Google Sheets versions at his request.

Follow Us On ...

Budget Templates by Vertex42.com

Education Templates

Popular templates.

  • Teaching and Learning Technologies

The Canvas Post

  • Tips & Tricks

Time-Saving Tip: Searching and Sorting your Canvas Gradebook

Posted February 4, 2022 by Abby Rosensweig

This article is part of the Canvas Minute’s Time-Saving Tips article series. Read the previous articles on setting up appointment groups in your Canvas calendar , managing your course at the end of the term , and bringing existing course content into a new course .

As your gradebook grows over the course of the quarter, you may find yourself looking for ways to more effectively manage and work within your Canvas gradebook. Read on for ideas on how to search, sort, and set up your Canvas course gradebook.

Search for Students and Assignments

Canvas has several search and sort functions to help you locate information quickly.

screenshot of Canvas gradebook with student and assignment fields highlighted

Student and assignment search fields in Canvas gradebook.

Student Names

You can search by first name or last name to filter your gradebook down to the student (or students) whose grades you want to see. To select multiple students for your filter, click on the name of one student in your search bar then start typing the name of the next student in the search bar next to the selected student’s name.

Assignment Names

You can display specific assignments in your gradebook by searching and selecting an assignment in the Assignment Names field. Like the Student Names field, the Assignment Names field allows the selection of one or multiple assignments.

The student and assignment filters can be used together to allow you to easily find the gradebook entry for a specific student’s assignment.

Did you know?

You can now view student names in separate columns for first name and last name. In the View menu at the top of the gradebook, there is an option to “Split Student Names.” This can be helpful for gradebook exports (possible in the Actions menu at the top of the gradebook) where student names should be separated. It is not possible to sort the gradebook alphabetically by first name in Canvas.

Sorting the Gradebook

screenshot of gradebook sort options from the View menu

The View menu in the gradebook gives a number of sorting options for assignments.

By default, your gradebook will list students alphabetically by their last name and will list assignments in the order in which they appear in your Assignments tab in Canvas (including quizzes and graded discussions, all of which will appear in Assignments). However, you can change your gradebook’s display through the following actions:

  • “View” drop-down menu (at the top of the gradebook) – allows changes to the order/view of assignments
  • Drag-and-drop assignments – you can reorder the assignments in your gradebook by dragging the column headers (assignment name) into the preferred order. This will not change the order of assignments in the Assignments tab of your Canvas course.
  • “Sort by” function in assignment menu – hover over an assignment’s name (in the column header of the gradebook) to reveal the three-dot menu to the right of the assignment name. In this menu, you have several sorting options, including assignment grade, missing submissions, and late submissions.

You can use the “Message Students Who” function in the assignment options (three-dot) menu to send a message to all students who scored above/below a specific grade or students whose assignment hasn’t been graded.

Grade Posting Policy

Canvas is built to share information with students but sometimes you will want to control the sharing of grade information. You can set your gradebook posting policy to determine whether grades will be available to students immediately student-by-student during the grading process or at the moment you manually post grades to all students.

Automatically Post Grades

Canvas defaults to automatically posting grades. When you input a grade or comment in Speedgrader or the gradebook, that grade or comment is immediately released to the student. If you do not want the grade to be immediately available to students, you will need to turn on the Manual Grade Posting Policy.

Manually Post Grades

In the upper right corner of your Canvas course’s gradebook, there is a gear icon that produces a slide-out menu when clicked. In this menu, you can set grade calculation policies for missing and late work and, in the right hand tab of the menu, set your grade posting policy. This allows you to complete your grading of an assignment (or allow all quiz submissions to be received), review the grades, and then post to all students when you are ready for the grades to be visible. Step-by-step instructions for setting your course’s grade posting policy can be found here: https://community.canvaslms.com/t5/Instructor-Guide/How-do-I-select-a-grade-posting-policy-for-a-course-in-the/ta-p/588

When you are ready to post the grades, follow these steps: https://community.canvaslms.com/t5/Instructor-Guide/How-do-I-post-grades-for-an-assignment-in-the-Gradebook/ta-p/576

Speedgrader and Assignment Status

screenshot of slideout assignment status menu in Canvas gradebook

Slide-out assignment status menu in the Canvas gradebook

From the gradebook, you can launch Speedgrader to grade student submissions of assignments, graded discussions, or quizzes. To access assignment information from the gradebook, click on the student’s score or submission for the given assignment in the gradebook to produce a right-pointing arrow icon. Then click on that icon to see a slide-out menu on the right side of the screen that shows the assignment score, the status of the assignment, a comment box, and a link to Speedgrader for grading the assignment.

For more help with using your Canvas gradebook, reach out to the Teaching & Learning Technologies team or schedule a consultation .

Categories: Beyond Basics , Tips & Tricks

Tags: time-saving tips

Instructional Technology Blog

ITG supports faculty use of technology for teaching and learning at Emerson College

A banner image of a laptop, plant, and water bottle on a desk.

  • by Isobel Rounovski
  • October 17, 2023 August 21, 2023

Gradebook Features You Need to Know!

Isobel's Sandbox course's gradebook

The gradebook is one of the trickiest things to figure out in Canvas. But, once you understand how it works and all it can do, it can be a really powerful tool. Read on for the gradebook features and capabilities you should know about!

Before we dive in, remember that anything that is graded in your course should be built as a graded assignment in your course. Creating a graded assignment is the only way to create a new column in your gradebook. Be sure to see our Gradebook Guide for more information on setting up your gradebook and other gradebook basics.

Late and missing policies

For any late submission in Canvas, you can set a deduction of a number or percentage of points for each hour or day that an assignment is late. Remember, for a submission to be considered late in Canvas, it needs to have been submitted after the due date you set. 

A missing submission policy allows you to set a grade that is applied automatically to any missing submissions. For an assignment to be considered missing for a student, it needs to be past the due date you set for the assignment with no submission submitted.

We recommend going over these policies in your syllabus so that students are aware of them from the start of the class. 

Set Default Grade As

This feature can help you grade more easily and more quickly, depending on the type of assignment you’re grading. When you set a default grade , you’re in effect telling Canvas to give everyone the same grade for a particular assignment. A use case example is if you’re grading an assignment on the complete/incomplete scale and you know everyone should be marked “complete”, you can set the default grade to “complete” so that you don’t need to enter in each grade one-by-one. Note that if this feature is used, the default grade will be applied for all students for the chosen assignment regardless of submission status, but you can override the default grade for individual students if necessary.

Use filters or the search to easily find assignments and students

Do you ever find yourself scrolling and scrolling through your Gradebook, struggling to locate the particular assignment you’re looking for? Thanks to the several options available to reduce the sheer size of your Gradebook, those days of endless scrolling are over. 

One of those options is to use the filters in the Gradebook. You can filter by:

  • Assignment Groups
  • Student groups (does not filter by assignments/columns; only filters students/rows)
  • Sections (for cross-listed courses only which have been merged by ITG)
  • Submission status (late, excused, missing, etc.)
  • Submissions (has submissions, has no submissions, has ungraded submissions, or has unposted grades)
  • Assignment start & end dates

To enable these filters, or to create your own filter , click Apply Filters from the top of your Gradebook and choose one of the filtering options:

Screenshot of filter options in gradebook

You can then view the currently-selected filters at the top of the gradebook; click X on any filter to remove it:

Enabled filters at the top of the gradebook

Another option that can help you easily find assignments or people is to use the search bars at the top of your gradebook to search by assignment, by student, or both:

Search bars at top of gradebook

Individual view

Few people may realize that there’s another version of the gradebook called the individual view . With the individual view, you can assign and view grades for one student and one assignment at a time. To switch to individual view, navigate to your gradebook, then click the Gradebook drop-down menu at the top left and select Individual View . To switch back to the regular view, click the drop-down menu at the top right and select Gradebook . 

Access SpeedGrader from the Gradebook

There are a couple ways you can access the SpeedGrader for an assignment: you can click into a graded assignment and select SpeedGrader on the right hand side, but there’s also a convenient way to access it from the gradebook . In the gradebook, simply locate the assignment you want to view in the SpeedGrader, then click the vertical ellipses in the header of the column for that assignment. From the menu that appears select SpeedGrader .

Excuse a student from an assignment

If you need to excuse a student from an assignment for any reason, there’s a way to reflect that in Canvas in such a way that the student will not be penalized for not submitting the assignment. To change the submission status of an assignment to “excused” for a student, locate the assignment in the gradebook, then locate the cell in the assignment column corresponding to the student. Click the small arrow, then select Excused in the right side panel.

Grade Posting Policies

One of the best features of the gradebook is the ability to use grade posting policies to control when students are able to view their assignment grades and feedback. There are two posting policies:

  • Manual Posting Policy : allows you to release grades/feedback only when you are ready to release them
  • Automatic Posting Policy : allows for grades and feedback to be released to students automatically and immediately as soon as the assignment is graded

By default, gradebooks are on the Automatic Posting Policy, but you can change the policy either for your entire gradebook or on an assignment-by-assignment basis .

Grade an assignment that’s been resubmitted

By default, unlimited attempts are allowed on assignments, meaning that your students will be able to submit to an assignment as many times as they’d like. If you grade an assignment for a student, then the student later re-submits to the same assignment, you’ll need to regrade the assignment via the SpeedGrader (re-grading from the Gradebook will not work). 

In the SpeedGrader, you’ll see that you can either enter a new grade for the new submission, or click Use this same grade for the resubmission to use the same grade for the second submission as you did for the first:

Screenshot of the "use same grade for resubmission" button in the speedgrader

Related gradebook tip: A green cell in your gradebook indicates that the assignment has been resubmitted. 

Need more gradebook help?

Reach out to us at [email protected] or 617-824-8090 if you need help with setting up or using your gradebook in Canvas.

Related Posts

assignment gradebook

Setting Up Extra Credit in Canvas

Understanding Links in Canvas

Do you DIG it?

Univeristy of Pittsburgh - Home Page

University Center for Teaching and Learning

How to use the gradebook to enter and calculate grades in canvas.

  • Quick Start
  • Instructor Help
  • Student Help

Using the Gradebook

Are you looking for instructions on how to import your Canvas final grades into PeopleSoft? Instructions are available from the Office of the Registrar here .

This page covers:

  • Interaction between the Assignments page and the Grades page, and
  • Using the gradebook, including calculating grades.

Assignments Page

Before getting into the grades page proper, let us explore some additional features on the assignments page that manage parts of your grading in Canvas.

Annotated screenshot illustrating parts of the assignments page discussed here.

  • (B) Create new assignment groups with the +Group button.
  • (C) Options for your assignments page overall are behind the top-right most button.
  • (D) If your course has weighted scoring enabled, you can easily see the value for each assignment group.
  • (E) If any assignment group rules apply, you can see them like shown here. Pointing at this for a moment will remind you which rules are applied.
  • (F) This button give you options for the given assignment group.

Assignment Groups

Assignment groups are how you can organize your assignments in Canvas. They function on the assignments page similar to how modules work for your course. You can use assignment groups only for organization if you would prefer (such as all sub-parts of a large semester-long assessment belonging to one group, or all reflection papers being organized together), but using assignment groups also adds the following features:

  • The Grades page can show the subtotal for each assignment group as its own column.
  • Assignment groups can be set to drop certain scores, such the common “drop lowest quiz”.
  • Weighted scoring can be applied to the groups, such that all of the assignments in a group constitute a certain percentage of your course’s final grade.

Note : All courses start with and must have at least one assignment group.

Organizing Assignment Groups

Options icon in Canvas.

Assignments and assignment groups will default to appearing in your Grades page in the same order as they appear on the Assignments page.

Assignment Group Rules (Dropping Lowest)

Using assignment groups, you can instruct Canvas to keep only the highest or lowest assignments in a group.

  • Navigate to your course’s Assignments page.
  • Click on the edit button to the right of the assignment group to modify. (F) in the above screenshot.
  • Click edit.
  • Enter the number of highest or lowest scores to ignore within a group.
  • If any assignments be more important than others that they should not be dropped, click the Add Assignment link under Never Drop to add them to a list of assignments that are always kept.

Screenshot of Edit Assignment Group panel.

View the full documentation for assignment group rules.

Weighted Final Grades

You can easily use Canvas to calculate your final scores for your course based on weighted percentages.

  • Click on the edit button in the top right of the page. (C) in the above screenshot.
  • Click Assignment Groups Weight.
  • Check “Weight final grade…”
  • Assign the percentage for each group. Canvas will show you the total shown. Any groups not contributing to the final score can be weighted to zero. Refer to the full documentation (linked below) to see what Canvas will do if your total is higher or lower than 100%.
  • Click Save.

Screenshot of the assignment group weights panel.

Note : Assignments preserve their relative weight (based on points) within an assignment group. An assignment worth more points than another in the same assignment group will contribute more to that group’s value. Canvas does not have equal distribution of all assignments within an assignment group unless all assignments have the same point value.

View the full documentation for weighted final scores.

Important note: Anything that is to appear in your gradebook needs to be an assignment in your course. To “add a column” to your gradebook, you must create an assignment. Learn more about creating assignments . You can create assignments that are of type “no submission” or “on paper” to handle assignments such as class participation or an in-class exam where the student does not directly submit something in Canvas for grading.

Gradebook Overview

Key parts of the Gradebook are indicated below.

Annotated screenshot labeling the parts of the Grades page.

  • (A) The hamburger button shows or hides the course navigation menu . When you go to the gradebook, Canvas defaults to hiding this menu. Click on this to reveal it so you can return to other parts of your course.
  • (B) The table in the center of the gradebook is the main part of content. Each row represents a student in your course, and each column an assignment. (Some columns represent calculated subtotals for assignment groups, or the final score for the course.)
  • (C) Notice the horizontal scroll bar at the bottom of the page. The gradebook often gets quite wide as assignments are added.
  • A “-” grade means the assignment is currently exempted and is the default grade. If an unsubmitted assignment should count against a student’s grades, make sure to enter a score of “0”. See the common tasks below for bulk filling blank.
  • Note: A dark gray cell indicates that the assignment was not assigned to that student. A column with a lot of dark gray entries indicates either that the assignment was not published, or that there might be an issue with the Assign To box on that assignment’s settings.
  • The column header also conveys additional information, including: its point value, whether or not the assignment grades are hidden (an eyeball in the left corner), if the assignment is unpublished, or that assignment’s grade posting policy. Clicking on the title in a column header takes you you to that assignment.
  • (F) You can build filters with the filters button . Clicking the filters button will open a menu on the right to build and save filters for your gradebook. You can add conditions, name the filter set, and save it. In the future, just click the Apply Conditions switch to turn on or off all filters in that filter set at once. Only one filter set can be enabled at a time. An example of what you can do with filters would be “show me all the quizzes for students in my Tuesday section”.
  • (G) The settings gear in the top right of the gradebook allows you to set grade policies for your course, such as late grade policies. You can also change view settings here, including changing the colors of the gradebook or disabling subtotal columns from appearing for you.
  • (H) The gradebook view selection above the gradebook table allows you to choose which gradebook you want to view. Options include the standard gradebook, an individual view, or the gradebook history for your course where you can audit changes over time. Depending on some course options enabled, you may have additional options enabled here.
  • (I) Use the Import and Export buttons to download or upload data from/to Canvas. Exporting your gradebook will create a CSV file for you to download. Import will request a CSV file to upload. When working with CSV files (such as in Excel), please make sure you do not sort the header columns or rows that Canvas provided.
  • (J) Use the quick search boxes to filter your gradebook quickly to find a particular student or assignment. Just click into the box and start typ ing.

Common Tasks

Here are short descriptions of how the most common tasks are performed in the Canvas gradebook.

Verifying Online Submissions

Scroll horizontally (C) until you find the column for the assignment column. Then scroll vertically (if necessary) to see who has and has not submitted. Tip: Try tying in the Search Assignments and/or student name quick search (J) above to filter rather than scrolling.

Grading Online Submissions

Please see the Grade Assessments using SpeedGrader page for this.

Entering Grades

Either utilize the SpeedGrader, or scroll to cell (assignment column and student row) to enter the grade. Click in it, and type the score. You can move down a column by pressing enter. See the Student Information area below to learn how to mark exemptions.

Bulk Grading (and filling in zeroes)

If you have an assignment you want to enter a bulk grade for (such as “everyone gets 5 points for this extra credit assignment”), click on the options button for that column header and choose set default grade, type the score and click Set Default Grade. If you do this process with a grade of 0, and do not check to override, this will let you easily replace all “-” or missing assignments with a zero.

If you click the options button for the header of the total column at the end of the gradebook, you can choose Apply Score to Ungraded. This will let you tell Canvas to fill in a zero for all missing assignments in the gradebook. You might want to look at Gradebook History (discussed below) after using bulk grading options to verify what changes were made.

Checking Totals

Scroll to the rightmost column of the gradebook. Canvas displays the student’s score according to the available data. The total score is the overall course score, and subtotals are displayed for each assignment group. For more about weighted grades or dropping scores, see the above discussion about assignment groups.

Note: A grade of – (including future assignments) is usually not counted against a student’s score. Make sure to fill in grades for a complete gradebook. You can set late and missing submission polices. See Gradebook Settings below. You can also set grading schemas (number-to-letter grade values; check Related links on the Instructor Help tab).

Message Students

You can choose “Message Students Who” from any the options button for any assignment column to send messages to a filtered list of students in your course. Selecting this will allow you to choose to email students who have not yet submitted, have not yet been graded (but did submit), or scored greater than or less than a score you specify. After selecting your filter, you will get a list of the students who will be sent an Inbox message. You can X any of them to omit them from the list. Type your message and click send.

To send a message to a specific student, see Student Information below to learn about the Context Card.

Show or Hide Total or Subtotal Columns

To hide totals or subtotals from your view , click on the gear (G), change to View Options, and check the boxes to hide Totals or Subtotals. Click Apply at the bottom right. To hide totals and subtotals from your students’ views , go to Course Settings, and, at the bottom of Course Details, click More Options. Check or uncheck “Hide totals in student grades summary” and click Update Course Settings.

Changing the Gradebook View

Filter the gradebook.

To filter your gradebook, click the Filters button and click Create New Filter. Add Condition(s) and values and click the Apply Conditions toggle to use the filter. Only one filter set can be used at a time. You can give the current (new) filter a name and save it for easy use later. Use the trash can icon to remove any conditions or saved filters.

Sort the Gradebook

Gradebook history.

Select Gradebook History from the Gradebook menu. This will show you a register of every change in your gradebook, including before and after changes to grades, and who made the change. This data is preserved here even if you delete an assignment, or a student is removed from your course. Filter the list with the menus above the chart. To return to your gradebook, just select Grades again from the course navigation menu.

Individual View

Select Individual View from the Gradebook menu. You can use this view to focus on one student at a time, including the checkbox to hide student names as you review grading patterns. Once you select global settings, you select a student in the content selection area to see the breakdown of that student’s grades. Or select an assignment to see some statistics about it. (Or both be taken to that submission.) Individual view has links to other functionality discussed elsewhere on this page, such as Message Students Who. Return to the normal gradebook view by selecting Gradebook from the dropdown menu in the top right corner.

As an alternative to the Gradebook Individual View, try the Grades button from the student context card discussed later in this document. That view will show you the grades for each assignment in your course for that student in an easy-to-review format.

Student Information

Click on a student’s name in the first column of the gradebook, and a context card will pop up on the right of your view. This is a quick way to get an idea of the student’s performance information in your class. This shows information about the student you clicked on as seen in the screenshot below. You can see the, the student’s information, grades and recent assignments (the quantity varies by your screen size), and relative activity. The stars at the bottom show the student’s relative activity to others in your course. Clicking on the name views their profile page, the mail icon sends an inbox message, Grades takes you to viewing their individual grades page, and Analytics takes you to analytics for your course filtered by that student. (You can learn more about analytics, and what Canvas counts as participation on the help page for New Analytics .)

Screenshot of the panel that appears when a name is selected.

If you click on a cell in the gradebook, and click on the icon (appears like a door with an arrow) that appears in that cell, the grade detail tray will open on the on the right. This allows you to set the status of the assignment (such as to excuse the assignment, excluding it from grade calculations), or exchange comments with the student about the assignment. This pane also has arrows to go between students or assignments, and has a link to SpeedGrader, where it will take you directly to the submission for this cell.

Screenshot of the side panel that appears when clicking on a gradebook cell.

Gradebook Policy Settings

Clicking the gear in the top right of the gradebook will open the menu as shown in the screenshot below. Here you can set course grade policies.

Screenshot of the late policies panel.

Late Policies

Note : The some of policies set here apply retroactively, so be careful with changing it after you already have grades in your course.

The “grade for missing submissions” setting allows you to apply a grade to assignments marked as missing. To count a missing assignment as zero, check this and fill in 0. Note that assignments without a due date are never missing unless you manually mark them as such.

The “deduction for late submissions” allows you to deduct a percentage from the grade per hour or day the assignment is late, and allows you to set a minimum grade (effectively a maximum late deduction). Note that assignments without a due date are never late unless you mark them as such.

Grade Posting Policy

On the Grade Posting Policy tab, you choose whether grades for assignments are set to be posted manually, or automatically. The default of automatic is that as soon as you enter a grade for a student, they can see it. You can override this on a per-assignment basis by clicking on that options button in that assignment from its column header. For any assignments that are set to a manual posting policy, students do not see any grades or feedback until you post them by clicking on the options button for that assignment. Additional information about this, including a useful flow chart, can be found on the Instructor Help tab.

Note: Comments can still be visible to the student before this, so be cautious what you enter as a comment in SpeedGrader or the Grade Detail Tray. Also, assignments created before setting this policy may not toggle. If you change this after you have already created assignments, verify individual assignments say manual in their column header.

Gradebook Help for Instructors

Video overview.

  • How do I use the Gradebook?
  • How do I create assignment columns for non-submission assignments in the Gradebook?
  • How do I enter and edit grades in the Gradebook?
  • How do I enter grades for an individual assignment as a specific grading type in the Gradebook?
  • How do I apply scores to ungraded assignments?
  • How do I change the status of a submission in the Gradebook?
  • How do I post grades for an assignment in the Gradebook?
  • How do I hide grades that were previously posted in the Gradebook?
  • How do I use the Notes column in the Gradebook?
  • How do I use the Total column in the Gradebook?
  • How do I override a student’s final grade in the Gradebook?
  • How do I use the icons and colors in the Gradebook?
  • How do I change the color for a grading status in the Gradebook?
  • How do I sort an individual assignment column in the Gradebook?
  • How do I arrange columns in the Gradebook?
  • How do I create a filter in Enhanced Gradebook Filter?
  • How do I sort and display student data in the Gradebook?
  • How do I view assignments or students individually in the Gradebook?
  • How do I view a student’s Grades page in a course from the Gradebook?
  • How do I view the history of all grading changes in the Gradebook?
  • How do I view the Unpublished Assignments column in the Gradebook?

Tools and Communication

  • How do I view a context card for a student in a course?
  • How do I leave comments for students in the Gradebook?
  • How do I send a message to students from the Gradebook?
  • How do I export grades in the Gradebook?
  • How do I import grades in the Gradebook?
  • How do I download all student submissions for an assignment in the Gradebook?
  • How do I upload all student submissions for an assignment in the Gradebook?
  • How do I curve grades in the Gradebook?
  • How do I edit the Roll Call Attendance assignment?
  • How do I take roll call using the Attendance tool?
  • How do I use the Roll Call Attendance tool in a course?

Assignment Groups (Categories/Weighting)

  • How do I create rules for an assignment group?
  • How do I weight the final course grade based on assignment groups?
  • How do I use posting policies in a course?
  • How do I select a grade posting policy for a course in the Gradebook?
  • How do I select a grade posting policy for an assignment in the Gradebook?
  • How do I apply a Late Submission policy in the Gradebook?
  • How do I apply a Missing Submission policy in the Gradebook?
  • How do I set a default grade for an assignment in the Gradebook?
  • How do I import my final grades from Canvas to PeopleSoft/Faculty Center?
  • How do I enable a grading scheme for a course?
  • How do I add a grading scheme in a course?
  • How do I use grading schemes in a course?
  • How do I view grading schemes in a course?
  • How do I get to SpeedGrader from the Gradebook?
  • How do I use the Learning Mastery Gradebook to view outcome results in a course from the Gradebook?
  • How do I view outcomes or student results individually in the Learning Mastery Gradebook from the Gradebook?

Gradebook Help for Students

  • How do I view my grades in a current course?
  • How do I use the icons and colors in the Grades page?
  • How do I approximate my assignment scores using the What-If Grades feature?
  • How do I view my grades in a concluded course?

Assignments

  • How do I know when my instructor has graded my assignment?
  • How do I view assignment comments from my instructor?
  • How do I view my assessment results as a student in New Quizzes?
  • How do I view quiz results as a student?
  • How do I view quiz comments from my instructor?
  • Where can I find my peers’ feedback for peer reviewed assignments?
  • How do I view my Roll Call Attendance report as a student?
  • How do I view my Learning Mastery scores in the Grades page?
  • How do I download assignment submissions from all my courses?
  • Generative AI Resources for Faculty
  • Innovation in Education Awards
  • Midterm Course Surveys
  • 1-on-1 Teaching Consultations
  • Canvas and Ed Tech Support
  • Reporting a classroom problem
  • Requesting equipment for your classroom
  • Not sure what you need?
  • Accessibility
  • Center for Mentoring
  • Creating and Using Video
  • Diversity, Equity and Inclusion
  • General Pedagogy
  • Graduate Student/TA Resources
  • Remote Learning
  • Syllabus Checklist
  • Student Communication and Engagement
  • Technology and Equipment
  • Classroom & Event Services
  • Assessment of Teaching
  • Classroom Technology
  • Custom Workshops
  • Open Lab Makerspace
  • Pedagogy, Practice, & Assessment
  • Need something else? Contact Us
  • Educational Software Consulting
  • Learning Communities
  • Makerspaces and Emerging Technology
  • Mentoring Support
  • Online Programs
  • Teaching Surveys
  • Testing Services
  • Video/Media Services
  • Assessment and Teaching Conference
  • Diversity Institute
  • New Faculty Orientation
  • New TA Orientation
  • Teaching Center Newsletter
  • Meet Our Team
  • About the Executive Director
  • Award Nomination Form
  • Award Recipients
  • About the Teaching Center
  • Annual Report
  • Join Our Team
  • PRO Courses Guides New Tech Help Pro Expert Videos About wikiHow Pro Upgrade Sign In
  • EDIT Edit this Article
  • EXPLORE Tech Help Pro About Us Random Article Quizzes Request a New Article Community Dashboard This Or That Game Popular Categories Arts and Entertainment Artwork Books Movies Computers and Electronics Computers Phone Skills Technology Hacks Health Men's Health Mental Health Women's Health Relationships Dating Love Relationship Issues Hobbies and Crafts Crafts Drawing Games Education & Communication Communication Skills Personal Development Studying Personal Care and Style Fashion Hair Care Personal Hygiene Youth Personal Care School Stuff Dating All Categories Arts and Entertainment Finance and Business Home and Garden Relationship Quizzes Cars & Other Vehicles Food and Entertaining Personal Care and Style Sports and Fitness Computers and Electronics Health Pets and Animals Travel Education & Communication Hobbies and Crafts Philosophy and Religion Work World Family Life Holidays and Traditions Relationships Youth
  • Browse Articles
  • Learn Something New
  • Quizzes Hot
  • This Or That Game New
  • Train Your Brain
  • Explore More
  • Support wikiHow
  • About wikiHow
  • Log in / Sign up
  • Computers and Electronics
  • Spreadsheets
  • Microsoft Excel

Create a Gradebook on Microsoft Excel: Make a Weighted Points Grade Sheet

A simple way to record your students’ grades

Last Updated: September 27, 2023 Fact Checked

Create a New Workbook

Create the layout, calculate grades with formulas, assign letter grades, weight assignments, expert q&a, things you'll need.

This article was co-authored by wikiHow staff writer, Kyle Smith . Kyle Smith is a wikiHow Technology Writer, learning and sharing information about the latest technology. He has presented his research at multiple engineering conferences and is the writer and editor of hundreds of online electronics repair guides. Kyle received a BS in Industrial Engineering from Cal Poly, San Luis Obispo. This article has been fact-checked, ensuring the accuracy of any cited facts and confirming the authority of its sources. This article has been viewed 223,630 times. Learn more...

Microsoft Excel is a great program for creating simple grade books! Using a spreadsheet (and a couple formulas) will reduce the time it takes to record and calculate grades. You don’t need to be familiar with Excel to follow our quickstart guide. This wikiHow article will walkthrough how to create a point-based grade book on Microsoft Excel.

Things You Should Know

  • Create columns for student names, assignment grades, total points, possible points, numeric grade, and letter grade.
  • Use the SUM function to add each student’s assignment points, then use the “/” division operator to divide their total earned points by the total possible points.
  • Weight assignments by assigning more or less points.

Step 1 Start a new workbook in Excel.

  • Alternatively, there are free templates for grade books online! Click More templates on the home page to search for “grade book” templates. You may see different templates depending on what version of Excel you’re using.
  • The web app version of Excel has two grade book templates, one for points-based grading and another for percentage-based grading.

Step 2 Add general information.

  • For more general spreadsheet info, check out our guide on making a spreadsheet in Excel .

Step 3 Name the grade book sheet.

  • Double click "Sheet1" at the bottom window. "Sheet1" should be highlighted.
  • Type a name for the sheet. For example, “Section 1.”
  • Press Enter .

Step 4 Add class information to your first sheet.

  • Click cell A1 to select it.
  • Type the instructor’s name and press Enter . This will move your selection to A2.
  • Type the class name in A3. For example, “World Geography.”
  • Type the section number and meeting time in A4.
  • Enter the term in A5. For example, “Fall 2022”

Step 1 Start creating the grade book layout.

  • This guide will cover one way to arrange your grade book. However, there are infinite ways to format an Excel spreadsheet . Try different templates and formats to find what works best for you!

Step 2 Enter the numbers of the section’s students.

  • Select A7 and type “Student Number.” Row 7 will contain the column headers for each type of information you have in your grade book.
  • Select A8 and type the number 1. Press Enter to enter the number in the cell and move down one.
  • Type the number 2 in A9.
  • Click and drag the cursor from A8 to A9. Both cells should be highlighted with a box around them.
  • Hover your cursor over the lower right corner of the box until the cursor becomes a plus + (this is called the fill handle).
  • Click and drag until you have a list of numbers for each student in your section.

Step 3 Enter the names of the section’s students.

  • Select B7 and type the column header “First Name.”
  • Select C7 and type the column header “Last Name.”
  • Type in the students’ first and last names in columns B and C.

Step 4 Create assignment columns.

  • You’ll insert the students’ assignment grades under each column.
  • Note: For this guide, we’ll use a point-based grading structure, meaning each assignment is worth a certain amount of points.

Step 1 We’ll use the SUM function to find each students’ total points.

  • Note: Make sure to check your spreadsheet calculations by doing a few calculations by hand. This is a great way to catch any errors in your spreadsheet.
  • Read more about the SUM function in our complete guide.

Step 2 Create a “total” column header.

  • Alternatively, you can type in the range instead.
  • For example, if you have 5 assignments in columns D through H and the student names start on row 8, you’ll enter D8:H8

Step 4 Press Enter to confirm the formula.

  • Select the cell with the total summation formula. Click and drag the fill handle (the square in the bottom-right of the selection) down to the last student to automatically apply the sum formula to each row.
  • Using our earlier five-assignment example, let’s say there are 10 students. The second student summation should now have a range of D9:H9, the third student D10:H10, down to the last student with D17:H17.

Step 6 Create a “possible points” column directly to the right of the “total” column.

  • Enter the possible points in each cell below the header.
  • For example, if each assignment is out of 10 points, and there are five assignments, the possible points will be 50.

Step 7 Create a “grade” column directly to the right of the “possible points” column.

  • The “/” symbol will divide the total cell by the possible points cell, giving you the student’s grade as a value under 1.
  • For example, if a student earned 45 total points out of 50 possible points, their grade will be 0.90 (90 percent).

Step 9 Duplicate this formula.

  • You can change the grades to percentages by selecting the grade values and changing the data type to “percentage.” Find this by navigating to Fields tab > Properties group > Data Type .

Step 1 Create a “letter” column directly to the right of the “grade” column.

  • Compare the student’s grade to your grading structure.
  • Insert the letter associated with that student’s grade.
  • For example, if an “A” is 89 to 100 percent and a student scores a grade of 93, place an “A” in the “letter” column.

Step 1 To weight assignments, change the possible points for each assignment.

  • For example, a 20-point assignments has double the weighting of a 10-point assignment.
  • To weight entire categories, make their points add to the percentage of the total grade you want the category to represent.
  • For example, if your course has 100 total points and you want five quizzes to represent 20 percent of the total grade, each quiz should be worth 4 points.

Kyle Smith

  • Always give your grade-book a title, by clicking on the "file" tab, choose "Save As", in the Save As window, choose a location and type a name for your document. Press "Save" when ready to save. Thanks Helpful 0 Not Helpful 0
  • Refer to Excel's extensive "Help" menu when in need. It offers tools on creating statistics of data. Thanks Helpful 0 Not Helpful 0
  • To find out what operating system your PC has, press "Start", right click on "Computer", scroll down and click on "Properties", a system dialog box will appear with basic information about your computer. Thanks Helpful 0 Not Helpful 0

assignment gradebook

  • Be sure to confirm that the equations you created for your grade book are calculating correctly. Thanks Helpful 4 Not Helpful 1
  • Make sure you save your progress throughout to prevent losing information as you work. Thanks Helpful 2 Not Helpful 1
  • Always save a backup of your grade book and maintain hard copies. Thanks Helpful 1 Not Helpful 2
  • Computer with Windows 7, XP, or Vista
  • Microsoft Office Excel 2010

You Might Also Like

Recover a Corrupt Excel File

About This Article

Kyle Smith

  • Send fan mail to authors

Is this article up to date?

Am I a Narcissist or an Empath Quiz

Featured Articles

Deal with Friendship Problems at School

Trending Articles

Everything You Need to Know to Rock the Corporate Goth Aesthetic

Watch Articles

Cook Fresh Cauliflower

  • Terms of Use
  • Privacy Policy
  • Do Not Sell or Share My Info
  • Not Selling Info

wikiHow Tech Help Pro:

Level up your tech skills and stay ahead of the curve

Brightspace Support

Brightspace Support

Linking your Assignment to the Gradebook

When you create an Assignment in Brightspace, you may want to link it to the Grades tool. This guide will explain how to link your assignment to a  grade item that has already been created, as well as provide other important information about associations .

Association or Link – these words are used to describe when an activity in Brightspace ( ex. Assignment, Quiz, Discussion response ) is connected to a Grade item in the Grades tool. When the activity is assessed by the instructor, the grade will automatically transfer into the Brightspace gradebook.

  • Link an Assignment to a new Grade Item

Link an Assignment to an existing Grade Item

  • Change or remove a gradebook association

What if I don’t want the assignment to affect the final grade?

Created Fall 2020

Link an Assignment to a New Grade Item

Unlike Brightspace’s previous Assignment tool, creating a new assignment will automatically create a grade item unless you manually link it to an existing one.

To do this, give your assignment a point value but do not make a gradebook selection.

assignment gradebook

  • In this example, the gradebook ( Course Admin -> Grades ) already has a Homework Category  and two Homework assignment Grade Items .

assignment gradebook

  • Now, you should go to the Assignments page. Begin a new assignment, or go to edit your already existing assignment. Give it the same title as your Grade Item , and give it a corresponding point value. These should match your gradebook. In this case, “Assignment 1” is worth 10 points.

assignment gradebook

  • Click on Not in Gradebook  and select Edit or Link to Existing .
  • A small window will open asking you to either Create a new grade item or Link to an existing grade item . Choose the Link to an existing grade item option, then select the Grade Item you want to link with your assignment. Make your selections, click OK , and click Save and Close on the Edit Assignment screen. The assignment and Grade Item are now linked.

edit or link to existing grade item

Change or Remove a Gradebook Association

You can change or remove a previous association with the same tool you used before.

  • Choose a different Grade Item
  • Remove the association, so the assignment is no longer linked to the gradebook at all.

assignment gradebook

If you want to grade an assignment, but don’t want it included in the final grade there are two options.

  • Remove the association from the gradebook as described above. In this case, the student can see their grade in the Assignments area, but not in the gradebook.
  • Keep the association, but select Exclude from Final Grade Calculation when editing the Grade Item. Students will see the grade in both the Assignments area and the gradebook.
  • Make an ungraded assignment. Students will not receive a grade for their work, but can read any feedback you may have provided.

Grade Calculator

Use this calculator to find out the grade of a course based on weighted averages. This calculator accepts both numerical as well as letter grades. It also can calculate the grade needed for the remaining assignments in order to get a desired grade for an ongoing course.

assignment gradebook

Final Grade Calculator

Use this calculator to find out the grade needed on the final exam in order to get a desired grade in a course. It accepts letter grades, percentage grades, and other numerical inputs.

Related GPA Calculator

The calculators above use the following letter grades and their typical corresponding numerical equivalents based on grade points.

Brief history of different grading systems

In 1785, students at Yale were ranked based on "optimi" being the highest rank, followed by second optimi, inferiore (lower), and pejores (worse). At William and Mary, students were ranked as either No. 1, or No. 2, where No. 1 represented students that were first in their class, while No. 2 represented those who were "orderly, correct and attentive." Meanwhile at Harvard, students were graded based on a numerical system from 1-200 (except for math and philosophy where 1-100 was used). Later, shortly after 1883, Harvard used a system of "Classes" where students were either Class I, II, III, IV, or V, with V representing a failing grade. All of these examples show the subjective, arbitrary, and inconsistent nature with which different institutions graded their students, demonstrating the need for a more standardized, albeit equally arbitrary grading system.

In 1887, Mount Holyoke College became the first college to use letter grades similar to those commonly used today. The college used a grading scale with the letters A, B, C, D, and E, where E represented a failing grade. This grading system however, was far stricter than those commonly used today, with a failing grade being defined as anything below 75%. The college later re-defined their grading system, adding the letter F for a failing grade (still below 75%). This system of using a letter grading scale became increasingly popular within colleges and high schools, eventually leading to the letter grading systems typically used today. However, there is still significant variation regarding what may constitute an A, or whether a system uses plusses or minuses (i.e. A+ or B-), among other differences.

An alternative to the letter grading system

Letter grades provide an easy means to generalize a student's performance. They can be more effective than qualitative evaluations in situations where "right" or "wrong" answers can be easily quantified, such as an algebra exam, but alone may not provide a student with enough feedback in regards to an assessment like a written paper (which is much more subjective).

Although a written analysis of each individual student's work may be a more effective form of feedback, there exists the argument that students and parents are unlikely to read the feedback, and that teachers do not have the time to write such an analysis. There is precedence for this type of evaluation system however, in Saint Ann's School in New York City, an arts-oriented private school that does not have a letter grading system. Instead, teachers write anecdotal reports for each student. This method of evaluation focuses on promoting learning and improvement, rather than the pursuit of a certain letter grade in a course. For better or for worse however, these types of programs constitute a minority in the United States, and though the experience may be better for the student, most institutions still use a fairly standard letter grading system that students will have to adjust to. The time investment that this type of evaluation method requires of teachers/professors is likely not viable on university campuses with hundreds of students per course. As such, although there are other high schools such as Sanborn High School that approach grading in a more qualitative way, it remains to be seen whether such grading methods can be scalable. Until then, more generalized forms of grading like the letter grading system are unlikely to be entirely replaced. However, many educators already try to create an environment that limits the role that grades play in motivating students. One could argue that a combination of these two systems would likely be the most realistic, and effective way to provide a more standardized evaluation of students, while promoting learning.

Instructure Logo

You're signed out

Sign in to ask questions, follow content, and engage with the Community

  • Canvas Instructor
  • Instructor Guide

How do I arrange columns in the Gradebook?

  • Subscribe to RSS Feed
  • Printer Friendly Page
  • Report Inappropriate Content

in Instructor Guide

Note: You can only embed guides in Canvas courses. Embedding on other sites is not supported.

Community Help

View our top guides and resources:.

To participate in the Instructurer Community, you need to sign up or log in:

IMAGES

  1. Assignment Gradebook ORION Downloadable eTextbook CALCULATOR FULL SCREEN PRINTER VERSION BACK

    assignment gradebook

  2. Using the gradebook

    assignment gradebook

  3. Solved ctice Assignment Gradebook ORION Downloadable

    assignment gradebook

  4. Solved ctice Assignment Gradebook ORION Downloadable

    assignment gradebook

  5. Gradebook overview

    assignment gradebook

  6. Solved "ractice Assignment Gradebook ORION Downloadable

    assignment gradebook

VIDEO

  1. Gradebook Setting up a Graded Item

  2. GRADEBOOK PART 2

  3. Gradebook: Access Sem1

  4. GRADEBOOK PART 4

  5. Grading an eClass Assignment

  6. B.Ed 1ST YEAR ASSIGNMENT SOCIAL SCIENCE

COMMENTS

  1. Organizing the Canvas Gradebook

    The Canvas Gradebook helps instructors easily view and enter grades for students. Depending on the Grade display type, grades for each assignment can be viewed as points, percentage, complete or incomplete, GPA scale, or letter grade. Only graded assignments, graded discussions, graded quizzes, and graded surveys that have been published display in the Gradebook. Not . . .

  2. Free Online Gradebook

    Student & parent access. Choose a free gradebook or ad-free premium gradebook. Distribute Assignments and Collect Homework. Powerful Messaging. Ideal for Distance Learning. Gradebook with Intuitive Interface ThinkWave Educator has an intuitive, easy-to-use, interface that can be learned quickly.

  3. What are Grades and the Gradebook?

    What is the Gradebook? The Gradebook helps instructors easily input and distribute grades for students. Grades for each assignment can be calculated as points, percentages, complete or incomplete, pass or fail, GPA scale, and letter grades, and assignments can be organized into groups for weighting as well.

  4. Getting Started in the Gradebook

    Getting Started, Grading. When you click Grades from Course Navigation, you are taken to the Gradebook. This page is where you can easily view and enter grades for students. Depending on the Grade display type, grades for each assignment can be viewed as points, percentage, complete or incomplete, GPA scale, or letter grade.

  5. How do I use the Gradebook?

    The Traditional Gradebook allows you to see all students, assignments, and grades. In the Gradebook menu, you also switch between several options as available: Learning Mastery Gradebook [1] displays the Learning Mastery Gradebook, which assesses outcome standards being used in Canvas courses. This gradebook is a course-level feature option.

  6. The 5 Best Free Online Gradebook Tools for Teachers

    In order to start with your gradebook, you'll need to add an assignment to grade and a class roster. To add an assignment, click the "Add Assignment" button, type in an assignment title, type, points possible, due date, and State Standards if you choose.

  7. Canvas How-To: Gradebook Setup and Grading

    The Grades page contains the data and calculations of the grade book - the scores. When you create any graded activity in Canvas, an item appears on the Assignments page and a column is automatically present in the Grades. Using assignment groups on the Assignments page also contributes to the structure of what you see in the Grades page.

  8. Grading in Canvas

    The Canvas Gradebook is robust and customizable with several advanced options you can select to meet your needs. Some of the more advanced grading options are described below. Drop Lowest or Highest Grades. You can set rules to assignment groups in Canvas regarding how many low or high grades to drop or which assignments should never be dropped.

  9. Canvas Basics: Gradebook Setup & Grading

    Assignments can be set to display grades as points, a percentage, complete/incomplete, GPA scale, or letter grade. After creating and publishing a graded assignment, it will appear in the Canvas Gradebook. Click the "New Assignment" button on the Assignments home page. Assignments are arranged in columns on the Grades page of the course.

  10. Setting Up Your Gradebook

    Step 5 - Mute Assignments (Grade Posting Policy) The feature previously known as assignment grade "muting" is now controlled by changing an assignment's grade posting policy. You can set an assignment so students cannot see their grades until you manually release all grades for that assignment (a good option if you want all students to ...

  11. Setting up your assignments and gradebook

    your gradebook is created by your assignments. The term "assignments" here also includes graded Canvas quizzes, discussions, and activities using Canvas-linked tools such as Top Hat or Quick Check. The act of creating an assignment is what makes the column appear in the Canvas Grades tool.

  12. Gradebook Template for Excel

    Gradebook Template : Percentage System This system is commonly used in high schools and for courses that involve more subjective grading like art and literature. On each assignment, the grade is recorded as a percentage. The percentage might be a calculation, such as earning 25 out of 30 points.

  13. Time-Saving Tip: Searching and Sorting your Canvas Gradebook

    To access assignment information from the gradebook, click on the student's score or submission for the given assignment in the gradebook to produce a right-pointing arrow icon. Then click on that icon to see a slide-out menu on the right side of the screen that shows the assignment score, the status of the assignment, a comment box, and a ...

  14. Gradebook Overview (Instructors)

    The course Gradebook view displays a list of all students and assignments in your course. At the top of the Gradebook you can also access global sorting options, open the keyboard shortcuts menu, utilize the search function, and open gradebook settings.

  15. Gradebook Features You Need to Know!

    Creating a graded assignment is the only way to create a new column in your gradebook. Be sure to see our Gradebook Guide for more information on setting up your gradebook and other gradebook basics. Late and missing policies

  16. How to Use the Gradebook to Enter and Calculate Grades in Canvas

    This will let you tell Canvas to fill in a zero for all missing assignments in the gradebook. You might want to look at Gradebook History (discussed below) after using bulk grading options to verify what changes were made. Checking Totals. Scroll to the rightmost column of the gradebook. Canvas displays the student's score according to the ...

  17. Create a Gradebook on Microsoft Excel: Easily Track Grades

    Create columns for student names, assignment grades, total points, possible points, numeric grade, and letter grade. Use the SUM function to add each student's assignment points, then use the "/" division operator to divide their total earned points by the total possible points. Weight assignments by assigning more or less points.

  18. Assignment Grades

    Go to Ultra Course View page. Where are my assignment grades? You can review the grades and feedback on your My Grades page. You can also access the assignment's Review Submission History page and review the grade and feedback in context. Assignments aren't graded automatically. Your instructor must grade each assignment. More on the My Grades page

  19. Create and Edit Assignments

    When you create an assignment, a gradebook item is created automatically. After you post assignment grades, students can view their scores on their grades pages or in the activity stream. They can also access an assignment, their submissions, your feedback, rubrics, and their grades from the assignment link on the Course Content page.

  20. Linking your Assignment to the Gradebook

    Linking your Assignment to the Gradebook When you create an Assignment in Brightspace, you may want to link it to the Grades tool. This guide will explain how to link your assignment to a grade item that has already been created, as well as provide other important information about associations.

  21. Gradebook

    Customize grade output With Gradebook, you can add manual grades, change graded assignments, and mark lessons, topics, and quizzes incomplete. You can also override the calculated component grades. LEARN MORE. Get to know Gradebook. Learn why tracking metrics is the secret to your course's success.

  22. Grade Calculator

    It also can calculate the grade needed for the remaining assignments in order to get a desired grade for an ongoing course. Final Grade Calculator Use this calculator to find out the grade needed on the final exam in order to get a desired grade in a course. It accepts letter grades, percentage grades, and other numerical inputs.

  23. 𝑨-𝒍𝒆𝒗𝒆𝒍 𝒉𝒆𝒍𝒑 ☁️ on Instagram: "students who struggle with time

    375 likes, 1 comments - alevelhelp.32 on February 18, 2024: "students who struggle with time management need to know about this #eisenhowermatrix #..."

  24. How do I view assignments or students individually in the Gradebook?

    The Gradebook Individual View allows instructors to assess one student and one assignment at a time. Fully accessible to screen readers, this Gradebook view allows instructors to sort by section and assignment and contains many of the same settings that are available in the Gradebook. Late policies,...

  25. How do I arrange columns in the Gradebook?

    Open Gradebook Settings Click the Settings icon. Arrange Columns Click the View Options tab [1], then click the Arrange By drop-down menu [2]. The default order is the order set in the Assignments page. Arrange by Assignment Name To arrange columns by assignment name, select the Assignment Name - A-Z option or Assignment Name - Z-A option.