Your privacy choices

KiwiBee uses optional Google Analytics, Google Ads, and Meta Pixel cookies to understand adult visitors, measure completed sign-ups, and improve campaigns. Essential cookies always stay on. OpenAI’s ChatGPT Ads Pixel also measures page views and completed enquiries after advertising consent, and may use hashed contact details for matching. Privacy policy

Skip to main content
Excel template

Weighted Gradebook

What's inside

A preview of the first rows. The file adds drop-down lists, formulas that fill in by themselves and room for more rows.

Weighted gradebook

Weights: Homework 20%, Quizzes 20%, Project 20%, Midterm 15%, Final exam 25%. Enter every score out of 100. Band: 5 = 90+, 4 = 75-89, 3 = 60-74, 2 = 50-59, 1 = below 50.

Class
Subject
Term
Teacher
No.Student nameHomework (20%)Quizzes (20%)Project (20%)Midterm (15%)Final exam (25%)Weighted totalBand (1-5)Class rank
Example: Mai Tran9285887984

Sheet: Gradebook · 40 rows

How to use it

  1. Write the class, subject and term at the top.
  2. Type the student names, then each score out of 100.
  3. The weighted total uses the percentages in the column headings.
  4. To change the weights, edit the percentages in the headings and the Weighted total formula.

About this document

A weighted gradebook for one class and subject. Enter each student's scores out of 100 and the sheet works out the weighted total, a performance band and the class rank.

Comments

    Weighted Gradebook – Free Excel Template | KiwiBee