# Teacher weighted gradebook (Excel) (free Excel)

> A class gradebook with editable category weights (homework, quizzes, projects, final): weighted total, percentage, grade, rank, statistics and an at-risk list.

Source: https://softwiro.com/templates/teacher-weighted-gradebook
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Teacher weighted gradebook (Excel)

A free Excel weighted gradebook for teachers. You enter the four assessment categories (homework, quizzes, projects and final), each category's weight and maximum mark, then each student's mark in each category. The sheet calculates the weighted total, percentage, grade and rank, classifies each student (safe, borderline or at risk of failing), and shows class statistics, the average of each category, the grade distribution, and a list of students at risk of failing sorted from the lowest.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-teacher-weighted-gradebook.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-teacher-weighted-gradebook-blank.xlsx)

Excel file (.xlsx) · 64 KB · 6 tabs · works in Excel and Google Sheets · no sign-up

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

## Try the sheet here, on the example

The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.

## Example from the sheet

| رقم الطالب | اسم الطالب | درجة الفئة 1 | درجة الفئة 2 | درجة الفئة 3 | درجة الفئة 4 | المجموع المرجّح | النسبة | التقدير | الحالة |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| 1 | أحمد سمير | 18 | 27 | 17 | 52 | 87.67 | 87.7% | ممتاز | آمن |
| 2 | سارة عادل | 15 | 24 | 16 | 45 | 77.00 | 77.0% | جيد جدًا | آمن |
| 3 | محمد حسن | 12 | 18 | 14 | 36 | 62.00 | 62.0% | مقبول | آمن |
| 4 | مريم خالد | 20 | 30 | 20 | 58 | 98.67 | 98.7% | ممتاز | آمن |
| 5 | خالد محمود | 8 | 12 | 10 | 24 | 42.00 | 42.0% | راسب | معرّض للرسوب |
| 6 | هدى علي | 14 | 21 | 12 | 30 | 60.00 | 60.0% | مقبول | آمن |
| 7 | يوسف نبيل | 10 | 15 | 12 | 31 | 52.67 | 52.7% | مقبول | على الحافة |
| 8 | نور الدين | 16 | 24 | 18 |  | 50.00 | 83.3% | جيد جدًا | آمن |

Example from the “الدرجات” tab (Arabic), with the numbers and formulas that are in the file.

## What is inside

- الإعدادات: The subject and class, the four assessment categories with their weights and maximum marks (all editable), the total of the weights, the pass percentage and warning margin, and a table of grade boundaries. The grade boundaries shown are examples only that you edit to match your school.
- الدرجات: Each row is a student: number, name and mark in each of the four categories. The sheet calculates the categories recorded, the weighted total, the weight recorded, the percentage, the grade, the status, a note (missing marks or a mark out of range), the student's rank and the risk rank. It holds up to 200 students.
- المعرّضون: A list of students at risk of failing or borderline, sorted from the lowest percentage, with student number, name, percentage, grade, status and note. It holds the first 40 students.
- الإحصائيات: The number of students and how many have a percentage, the average, highest and lowest percentage, the number of students in each status, the average of each category and its percentage of the category maximum, the weakest category, and the number of students in each grade.
- ابدأ هنا: How to use the sheet, what the colors mean and notes on the calculation.
- لماذا ما زلت على إكسل؟: A short comparison between the sheet and a custom program built around the way you work.

The file opens on a start tab (“ابدأ هنا”, Start here) that explains how to use it.

## What makes it different

At the end of the term you do not need to work out each category's weight for each student on a calculator. You enter the marks as you recorded them and the sheet does the rest. Open the "المعرّضون" (At risk) tab to see who you need to talk to first, and the "الإحصائيات" (Statistics) tab to see which category had the weakest class average.

## How to use it

1. In the "الإعدادات" (Settings) tab, enter the subject and class, then the names of the four assessment categories, each category's weight and its maximum mark.
2. Enter the pass percentage and the warning margin, and edit the grade boundaries if they differ from your school's (the boundaries shown are examples).
3. In the "الدرجات" (Grades) tab, enter each student's number, name and mark in each category. Leave the cell empty if the mark has not been recorded yet.
4. The sheet calculates the weighted total, percentage, grade, status and rank for each student, and the "ملاحظة" (note) cell warns you about a missing mark or one outside the allowed range.
5. Open the "المعرّضون" (At risk) tab to find the students whose percentage is below the pass mark or close to it, sorted from the lowest.
6. Check the "الإحصائيات" (Statistics) tab for the class average, highest and lowest percentage, the average of each category and the grade distribution.

**Before you start:**

- The recommended total of the weights is 100, but the sheet always calculates the percentage from the total weights of the categories that have recorded marks, so the calculation holds even if the total differs.
- Weighted total = for each category (mark / maximum x category weight), then the categories are added up. Percentage = weighted total / the total weights of the recorded categories.
- For a student without all categories recorded, the percentage is calculated from the recorded categories only and the note "درجات ناقصة" (missing marks) appears. If no category is recorded, no percentage is shown.
- Student status: "معرّض للرسوب" (at risk of failing) if the percentage is below the pass percentage, "على الحافة" (borderline) if it is below the pass percentage plus the warning margin, and otherwise "آمن" (safe).
- The grade boundaries and their names in Settings are an example only, not an official rule. Enter your school's boundaries, ordered from lowest to highest.
- The sheet holds up to 200 students, and the at-risk list shows the first 40. The names and marks in the example are fictional and for illustration.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-teacher-weighted-gradebook.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-teacher-weighted-gradebook-blank.xlsx)

Excel file (.xlsx) · 64 KB · 6 tabs · works in Excel and Google Sheets · no sign-up

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

## Free cheat sheet for this field

Terms, abbreviations, tables and diagrams over several pages, in Arabic and English. Download it as a PDF or images, including a phone-size version.

[![Cheat sheet: teacher weighted gradebook (1/3)](https://softwiro.com/uploads/cheatsheets/teacher-weighted-gradebook/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/teacher-weighted-gradebook/en-1.jpg)[![Cheat sheet: teacher weighted gradebook (2/3)](https://softwiro.com/uploads/cheatsheets/teacher-weighted-gradebook/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/teacher-weighted-gradebook/en-2.jpg)[![Cheat sheet: teacher weighted gradebook (3/3)](https://softwiro.com/uploads/cheatsheets/teacher-weighted-gradebook/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/teacher-weighted-gradebook/en-3.jpg)

0 downloads · 3 pages

## Still running this on Excel?

This sheet suits a start and a limited amount of data. If your way of working grows, or you need more than one person working on it at the same time, Softwiro can build you a program that fits the way you work.

| In this sheet | In Custom Software from Softwiro |
| --- | --- |
| One file that one person edits at a time, and copies reach you on WhatsApp. | A program with a login for each user and permissions you define, and everyone sees the same data. |
| You type everything and check the numbers by hand. | We design the screens around your work steps, so each person records only what concerns them. |
| Columns and formulas are fixed as the sheet was designed. | We build what you need: reports, alerts and screens your way. |
| Backups and security are your own responsibility. | The program runs on a secured server with regular backups. |

[See Custom Software from Softwiro](https://softwiro.com/contact) · [Ask for a demo](https://softwiro.com/contact)

## When your work grows: a custom system instead of the sheet

A sheet is a great start. When more than one person works on your data, when it grows, or when you need alerts and reports of your own, we build you a custom system at competitive prices. This is what changes:

| In the sheet | In a custom system |
| --- | --- |
| One file that one person edits at a time, and copies travel by WhatsApp. | A program with a login for each user and permissions you set; everyone sees the same data live. |
| You type and check every number by hand, and one wrong cell breaks the result. | Screens built around your steps: each person records only their part, and the calculations run on their own. |
| Limited size; the file slows down as the data grows. | Holds years of data without slowing down, with instant search and filters. |
| Fixed columns and reports, as the sheet was designed. | Reports, alerts, printing and WhatsApp built around how you work. |
| Backups and security are your own responsibility. | A secured server with automatic backups and a log of who changed what and when. |

### Extra features in the app

- A login for each user with permissions, and a log of who changed what and when
- Automatic reminders and alerts by WhatsApp and email
- Photos, files and documents kept with each record
- Instant search and filters, with reports exported to PDF and Excel
- Works from a phone anywhere, with automatic backups

[Ask for your custom system](https://softwiro.com/contact)

## Frequently asked questions

### How is the weighted total calculated?

For each category: the student's mark / the category's maximum mark x its weight, then the categories are added up. Percentage = weighted total / the total weights of the categories recorded for that student.

### Can I change the weights and categories?

Yes. The four category names, their weights and their maximum marks are in the "الإعدادات" (Settings) tab, and all calculations change as soon as you edit them. You can set the weight of an unused category to zero.

### Are the grade boundaries official?

No. The grade boundaries and their names in Settings are examples only, and you should enter those of your school or institution, ordered from lowest to highest.

### What happens to a student who does not have all marks recorded?

Their percentage is calculated from the recorded categories only, and the note "درجات ناقصة" (missing marks) appears. If no category is recorded for them, no percentage or status is shown.

### Is the template free?

Yes, with no sign-up and no email address. Use it, edit it and share it as you like.

### Does it work in Google Sheets and on mobile?

The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.

### What is the difference between the white and the gray cells?

You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.

### Can I use the sheet from an AI assistant?

Yes. Add our MCP server (URL [https://softwiro.com/api/mcp](https://softwiro.com/api/mcp), no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: [https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html](https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html)

All the templates in this group: [Excel templates for teachers: gradebook, lesson planning and follow-up](https://softwiro.com/templates/for-teachers)

More free templates for: Teachers

## More free templates

- Lesson plan and curriculum coverage tracker for teachers (Excel)
- Parent communication log for teachers (Excel)
- Remedial sessions tracker for teachers (Excel)
- Study groups management sheet for a private teacher
- Charity accounts by fund
- Strength workout log
- Running, cycling and swimming log
- Training load sheet for any sport (session-RPE)
- Athlete nutrition and macros sheet
- Football player match stats sheet
- Basketball player game stats
- Swimming times and personal bests

[All templates](https://softwiro.com/templates) · [Free tools](https://softwiro.com/tools)
