Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesEducation & LearningClassroom ManagementTeacher Gradebook

SpreadsheetClassroom ManagementFree

Teacher Gradebook

Weighted grades for assignments, quizzes and exams with automatic letter grades.

Shown with sample data

Colour

Teacher Gradebook

Weighted grades for assignments, quizzes and exams with automatic letter grades.

Class average
80.6
Percent
A grades
3
At risk (D/F)
2
Highest score
96.8
Final % by student
  • Chloe Nguyen96.8
  • Ava Johnson91.1
  • Grace Lee90.2
  • Ella Fischer85.2
  • Ben Carter75.1
  • Diego Alvarez66.9
  • Finn O’Brien58.7

How to use it

  1. 1Set category weights on the Weights sheet (they should total 100%).
  2. 2Enter each student’s average score per category (0–100).
  3. 3Final percentage and letter grade calculate automatically.
  4. 4Use the class average to spot units that need re-teaching.

In this workbook

  • About
  • What’s included
  • How to use
  • Related resources

About this template

A weighted gradebook that does the maths for you. Enter scores for homework, quizzes, projects and exams; category averages are weighted by the percentages on the Weights sheet to produce a final percentage and letter grade for every student.

Who it’s for

  • K-12 and college teachers
  • Tutors tracking progress
  • Preparing report cards

What’s included

  • Weights sheet: Category weights.
  • Grades sheet: Student scores and final grades.

How to use it

  1. 1Set category weights on the Weights sheet (they should total 100%).
  2. 2Enter each student’s average score per category (0–100).
  3. 3Final percentage and letter grade calculate automatically.
  4. 4Use the class average to spot units that need re-teaching.

Tips

  • Change the letter grade boundaries in the Final grade formula to match your school.
Related searchesgradebookgradesteacherweighted gradesreport card

Details

Format
Spreadsheet
Category
Classroom Management
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetClassroom ManagementFree

Teacher Gradebook

Weighted grades for assignments, quizzes and exams with automatic letter grades.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Classroom Management
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More classroom management templates

View all

Scholarship Application Form

Apply for the [Name] Scholarship of [$2,500] for students starting college or vocational training in [Fall 2027]. Deadline: [March 1, 2027].

Full name *

Email *

Phone *

Submit application
FormClassroom Management

Scholarship Application Form

A fair, complete scholarship application: applicant and academic details, financial need, activities, essay, references and certification.

10 min setupPreview
Classroom Seating Chart2 sheets

Students

24

Seated

23

Seating issues

4

ABCD
1StudentSeatFront seat neededSupport plan
2Ava ThompsonR1-1YesNone
3Liam NguyenR1-2NoEnglish learner
4Sofia MartinezR1-3NoNone
5Noah WilliamsR1-4YesIEP
Roster
SpreadsheetClassroom Management

Classroom Seating Chart

Assign seats from your class roster and see the room laid out, with checks for front-seat needs, support plans and double-booked seats.

15 min setupPreview

Lincoln Elementary School · Room 12 · Address · School phone

August 20, 2027

Dear Families of Room 12,

Welcome to fourth grade! My name is Ms. Elena Rivera, and I am so excited to be your child’s teacher this year. This is my ninth year teaching and my fourth at Lincoln Elementary. When I am not in the classroom,

Fourth grade is a big year. In reading, we will move from learning to read to reading to learn, with novels, nonfiction and lots of discussion. In math, we will master multi-digit multiplication and division and dive int

DocumentClassroom Management

Teacher Welcome Letter to Parents

A warm back-to-school letter introducing you, the year ahead, communication, routines, homework and how families can help.

15 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ