FreeSheets

Grade Book Template for Teachers (Excel)

Last updated June 2026

Thirty students down the rows, ten assignments across the columns — the Grades sheet is sized for a real class roster. Type each assignment's points possible in row 4 and enter raw scores as they come in; the Total, Percent, and Letter columns grade themselves while a class-average row watches the whole group. A free one-sheet .xlsx for teachers.

Grade Book Template for Teachers (Excel)

grade-book.xlsx · free · no signup

Download free template

Works in Excel, LibreOffice Calc, and Google Sheets (File → Import).

SHA-256: 06d75c3b2a5d51672315ed0ef3cd1b137c88857ee45cb67dc6e4124a78ef9086

M6=IF(L6="","",L6/SUM($B$4:$K$4))
ABCDEFGH
StudentA1A2A3A4TotalPercentLetter
Avery Chen1010201017898.9%A
Marcus Bell651149050.0%F
Sofia Martinez9817815183.9%B
Liam O'Connor871512770.6%C
Priya Nair7814713273.3%C
Student rows from the Grades sheet (assignments A5–A10 scroll off to the right). Percent divides each Total by the sum of every points-possible value in row 4.

What's inside

Sheets

  • GradesEverything lives here: a points-possible row, a 30-student roster, 10 assignment columns, and the Total, Percent, and Letter columns that grade each student. A class-average row sits below the roster.

Columns

  • StudentOne row per student in column A — 30 rows are ready (rows 6–35). Type or paste your roster.
  • A1–A10Ten assignment columns, B through K. Put each assignment's points possible in row 4, then enter raw scores below. Leave a cell blank for a missing assignment — blanks are ignored, not counted as zero.
  • TotalColumn L sums a student's 10 scores, skipping blank assignments. It stays empty until at least one score is entered.
  • PercentColumn M divides the Total by the sum of all points possible in row 4, formatted as 0.0%.
  • LetterColumn N converts the percent to a letter on a standard 90/80/70/60 scale. Edit the thresholds in the formula to match your school's scale.

Formulas that do the work

=IF(COUNT(B6:K6)=0,"",SUM(B6:K6))

The Total cell L6 sums the 10 assignment scores, but stays blank until a row has at least one entry — so empty student rows don't show a misleading 0. It's copied down to L35.

=IF(L6="","",L6/SUM($B$4:$K$4))

The Percent cell M6 divides the Total by the total points possible (the locked $B$4:$K$4 range in row 4), then displays it in percent format. Change a points-possible value and every percent updates.

=IF(M6="","",IF(M6>=0.9,"A",IF(M6>=0.8,"B",IF(M6>=0.7,"C",IF(M6>=0.6,"D","F")))))

The Letter cell N6 walks the standard cut-offs from the top down: 90% and up is an A, 80% a B, and so on. To switch to a different scale, edit these threshold numbers — the guide on nested IF logic shows the pattern.

=IFERROR(AVERAGE(L6:L35),"")

The class-average row uses IFERROR so the cell shows nothing instead of #DIV/0! before any grades are entered. L37 averages the totals; M37 averages the percents.

How to use it

  1. Name the class and the assignments

    Type your class name in B2. In row 4 (B4:K4), enter the points possible for each of your 10 assignments — the samples are 10, 10, 20, 10, 25, and so on. Rename the A1–A10 headers in row 5 to your real assignment names.

  2. Enter your roster

    Replace the five sample students in column A (rows 6 onward) with your own. Paste a list straight from your records — the sheet holds 30 students by default in rows 6–35.

  3. Type the scores

    Fill in each student's raw points under the assignment columns. Leave a cell blank for a missing or excused assignment; blanks are skipped, so they don't drag the total down to zero.

  4. Read the results

    The Total, Percent, and Letter columns fill in automatically as you type. Percents below 60% turn red, and every A in the Letter column turns green, so the roster reads at a glance.

  5. Match your grading scale

    The note in P4 points you to the Letter formula in column N — that's where the 90/80/70/60 cut-offs live. Edit the threshold numbers there to use plus/minus grades or a different curve.

Compatibility

  • Microsoft Excel. Excel for Microsoft 365, Excel 2016 and later (Windows and Mac).
  • LibreOffice Calc. Opens directly — formulas, validation lists, and formatting carry over.
  • Google Sheets. Upload via File → Import → Upload, or drag the file into Drive and open with Sheets.

The red below-60% and green-A highlighting are conditional-formatting rules that survive a Google Sheets import. Row 5 is frozen at B6, so headers and the Student column stay put as you scroll a long roster.

Frequently asked questions

How do I change the grading scale?
Open any Letter cell in column N, for example N6, and edit the threshold numbers in the formula — 0.9 for A, 0.8 for B, and so on. Then copy that cell down the column so every student uses the new scale.
Why does a blank assignment not count as a zero?
The Total formula uses SUM, which ignores empty cells, and the row only grades once COUNT finds at least one score. A blank means "not graded yet," so it never lowers the percentage until you enter an actual 0.
Can I add more than 10 assignments or 30 students?
Yes. Insert columns before column L for more assignments, then widen the SUM(B6:K6) and SUM($B$4:$K$4) ranges. For more students, copy the last filled row down past row 35 to extend the totals.
How are the class averages calculated?
The row labeled "Class average" uses =IFERROR(AVERAGE(L6:L35),"") for points and the same for percent. IFERROR keeps the cell blank instead of showing a #DIV/0! error before you've entered any grades.
Does this grade book work in Google Sheets?
Yes. Use File → Import → Upload to bring in the .xlsx file. The IF and AVERAGE formulas, the percent formatting, and the red and green conditional formatting all carry over unchanged.

Related guides

More planning & organization templates →