Class Grade Calculator: Score Sheet for Your Whole Class

Class grade calculator: the quick answer

A student’s grade is their points earned divided by the points possible, times 100. The class average is the mean of those percentages. The median is the middle percentage once they are sorted. With five students on a 90-point sheet (two 20-point quizzes and a 50-point test), the percentages are 96.67%, 88.89%, 82.22%, 66.67% and 57.78%. The class average is 78.44%, the median is 82.22%, and the class has one A, two Bs, one D and one F. The class grade calculator above does this for up to 60 students and 12 assignments.

How to use the class grade calculator

1. Name each assignment in the column headings and enter its points possible underneath.
2. Type each student’s name, or an initial or ID, and their points earned for each assignment.
3. Use Add a student or Add an assignment when you need more rows or columns.
4. Read each student’s percentage and grade at the end of their row. The class results appear next to the options.
5. Choose how empty scores are treated, set your grading scale, and export the sheet when you are done.

Class grade calculator: paste your scores from a spreadsheet

If your scores already live in Excel or Google Sheets, copy the cells and paste them into the box under the sheet. Row 1 holds the assignment names and row 2 the points possible. Each row after that is one student, with the name first and then the scores. Tabs, as when you copy cells, and commas both work. Pasting replaces the current sheet, and the calculator checks every number, so a typo is flagged instead of silently changing a grade.

Exporting class grade calculator results to CSV

The export button builds a CSV file with one row per student: the name, each score, total points earned, total points possible, the percentage and the grade. It works in your browser, with no upload. If your browser blocks the download, the same text appears in a box you can copy. Names that begin with a symbol such as = or + get a leading apostrophe, so a spreadsheet will not read them as formulas. Student names count as school records, so follow your school’s rules when you save or share the file.

What the class grade calculator shows

For each student, the percentage is exact, not rounded early. The class average is the mean of the student percentages, so every student counts equally whatever number of assignments they have. The median is the middle value, which is less affected by one very high or very low score. The highest and lowest lines name the student, and the distribution table counts the students in each grade. With skip chosen, a student is graded only on assignments with a score. With zero chosen, a missing score counts as 0 and the student is graded on every assignment.

Class grade calculator formulas and a worked example

The letter is the first grade on the scale, counting down from the top, whose minimum is at or below the percentage. A result exactly on a cutoff earns that grade. The full rules are on the grading methodology page.

The percentages add up to 392.22, so the class average is 392.22 ÷ 5 = 78.44%, a C on the standard scale. Sorted, the middle value is 82.22%, so the median is a B. The highest is Cara at 96.67% and the lowest is Dev at 57.78%.

Choosing a grading scale

The standard and plus/minus scales are examples, not rules. If your school uses different cutoffs, choose Custom and enter them, or build and print a chart with the grading scale calculator.

Sources and further reading

Teachers and schools set their own weights, rounding and policies, so follow your own grading policy. For background, see Academic grading in the United States and Median on Wikipedia.

Related tools