Grading Shortcut

Spreadsheets make calculating students’ grades quick and easy. They’re efficient and can be easily updated if anything changes, saving you from redoing all the math. Plus, they help keep everything organized and accurate, reducing mistakes. With a digital backup, your data is safe and easy to share with the school office, making it simple to include grades on report cards. Overall, spreadsheets make grading a breeze!

If you’ve never done this before, here’s a step-by-step guide to creating your custom grading spreadsheet.

1. Set Up the Spreadsheet Header

Open Excel and in Row 1, create the following headers:

A1: Student Name

B1: Test 1

C1: Test 2

D1: Test 3

E1: Test 4

F1: Final Score

G1: Grade

You can adjust the number of assignments/tests to suit your needs.

2. Enter Students’ Scores

In rows 2 and onward, enter data for each student. Example:

A2: Aviva

B2: 85

C2: 90

D2: 88

E2: 92

Do this for each student in rows below.

Formulas to Enter

Average Score (In cell F2)

=AVERAGE(B2:E2)

Copy this formula down column F for all students.

Letter Grade (in cell G2)

=IF(F2>=90,”A”,IF(F2>=80,”B”,IF(F2>=70,”C”,IF(F2>=60,”D”,”F”))))

Copy this down column G for all students.

TIP: to quickly copy formulas down a column: click the cell, then drag the small square at the bottom-right corner downward.

Let’s take this a step further!

Do you want your final grade to reflect classwork, assignments, behavior, and more? For example, if you’ve told your students that assignments will make up 30% of their final grade and tests 70%, you can adjust the spreadsheet like this:

1. Set Up the Spreadsheet Header

In Row 1, create the following headers:

A1: Student Name

B1: Assignment 1

C1: Assignment 2

D1: Test 1

E1: Test 2

F1: Test 3

G1: Final Score

H1: Grade

Again, you can adjust the number of assignments/tests to suit your needs.

2. Enter Students’ Scores

Enter the data for each student. Example:

A2: Aviva

B2: 85

C2: 90

D2: 88

E2: 92

F2: 94

Do this for each student in rows below.

Formulas to Enter

Average Score (In cell F2)

=AVERAGE(B2:C2)*.3 + AVERAGE(D2:F2)*.7

Copy this formula down column F for all students.

Letter Grade (in cell G2)

=IF(F2>=90,”A”,IF(F2>=80,”B”,IF(F2>=70,”C”,IF(F2>=60,”D”,”F”))))

Copy this down column G for all students.

One Response

Rochel S. says:

June 20, 2025 at 11:33 am

This was super helpful! I never was able to figure out how to use a spreadsheet to help calculate their final grades when tests, classwork, homework, and behavior were each counted towards different percentages of their grades. Looking forward to putting this to use and grading will be a breeze! Thank you so much!

Reply

MORE TO EXPLORE

Week 2: Daven for Her

As we continue the K’mayim Sefira Challenge, we return to a place that quietly shapes everything—our פנימיות. Week 2:Daven for Her The Challenge Choose one student to focus on this week. Learn her full name, and say an extra tefilla or a perek of Tehillim for her each day. It can be just a small moment, but one filled with awareness and care. This week’s challenge is to take a moment each day to daven for each of your K’mayim students. It can be a quiet perek of Tehillim, a mention in Shemoneh Esrei, or a simple bakasha from the heart. This is something to do consistently throughout the week—no matter how many times you teach. As you do this, keep in mind: A student may feel like a challenge, or even just “average” in the classroom—but she is someone’s whole world. A child deeply loved, with a

Graduations

End-of-year celebrations in early childhood should feel joyful, simple, and meaningful—for both children and teachers. You don’t need anything overproduced to make it memorable; it’s the milestone itself that makes it special. Here are some ideas that strike that balance: “Little Steps, Big Growth” Ceremony Keep it short and sweet.Each child walks across a small “stage,” and you share one personal sentence about them—a strength, a moment of growth, or something that makes them unique. They receive a certificate, and a soft background song can add a special touch. Themed Performance (Short + Sweet) Choose 2–3 songs with simple motions. Themes that work well: Keep it under 10 minutes—parents appreciate it, and children stay engaged. Individual “Spotlight Moments” Instead of a full performance, give each child a moment to shine.Call them up and say something like:“This is ___, he loves building and is always ready to help his

Week 1: Belief Breeds Success

Welcome to the first week of the K’mayim Sefira Challenge. We begin not with action in the classroom, but with something more foundational: how we see our students on the inside. Week 1:Belief Breeds Success: The Subconscious Connection The Challenge: Write a positive affirmation for each of your K’mayim students. Not a general compliment, but a statement of belief in her potential. “I believe that Hashem has granted this student infinite potential, and she has it in her to become…” For example: Though she seems so strong and opinionated, I can see the softness beneath the surface, and I know that one day she will find the right balance. or Beneath the gashmiyus that defines her surface, I believe that there is a neshama that is thirsty and ready to grow. The focus is not who she is today, but who she can become. As you do this, hold

The K’Mayim Challenge

The K’mayim Sefira Challenge is a 4-week journey designed for teachers across all grades. Each week, you’ll take on one focused, practical challenge—small, intentional shifts that reshape how you think about, relate to, and respond to your students. This is not about adding more to your workload. It’s about infusing what you’re already doing with deeper awareness and purpose. Are You Ready to Begin? Over the coming weeks, you’ll be guided step by step through this process. No complicated systems. Just internal work that leads to real results. Choose your students The Foundation What this looks like 1. Choose your Students Choose 2-4 students who you feel you did not connect with/get through to yet who will become YOUR Kmayim students, and watch the ripple effect take place. Is it the quiet one who is never seen? Do you really know her? Her likes, her challenges, her dreams she