Sample Gradebook

Here is an example of a simple gradebook. The colums are averaged for the class average. The rows are added up and then divided by the total number of points allowed for the assignments to get the percentage grade.This was all done using formulas, they are the magic of Excel. The formulas are simple. Here are some samples:

Average: =AVERAGE(B8:B21)

Sum: =SUM(B8:K8)

Division: =L20/1000

The cells would change depending on where you insert the formula.Notice the equal sign, that tells Excel that a formula is going to be used. The B8:B21 means to average all the cells in that range, that is, B8, B9, B10....B21. Same with the sum.

The colored cells have the formulas. The rest of the cells are just numbers that the formulas use.

Once again remember, the actual cells for yours will be different. The Basic Excel Tutorial in TaskStream explains how this works.
Subject:                        
                         
Grading Period:                        
                       
Class Roster 1 2 3 4 5 6 7 8 9 10 Total %
Wayne, John 77 79 78 82 79 81 80 80 82 82 800 80%
Nixon, Richard 78 79 80 85 83 82 85 86 85 82 825 83%
Curie, Marie 78 80 80 88 86 89 90 92 85 87 855 86%
Chavez, Caesar 88 85 86 90 89 90 92 97 100 99 916 92%
John Lennon 90 92 94 92 89 94 95 99 100 97 942 94%
Spears, Britney 95 96 97 96 92 95 98 99 95 96 959 96%
Welk, Lawrence 98 97 99 100 98 98 99 100 97 95 981 98%
Hendrix, Jimi 100 100 100 97 98 98 99 100 100 99 991 99%
Redford, Robert 79 77 79 83 86 88 90 92 90 89 853 85%
Hood, Robin 97 98 96 95 98 97 99 100 97 96 973 97%
Douglas, Michael 95 99 97 100 100 99 99 100 98 96 983 98%
Taylor,Elizabeth 93 94 94 100 98 96 97 100 85 90 947 95%
Zapata, Jose 94 95 97 100 98 96 97 90 92 89 948 95%
Johnson, Lyndon 75 77 80 88 87 89 90 100 90 89 865 87%
Class Averages 88.36 89.14 89.79 92.57 91.5 92.29 93.57 95.36 92.57 91.86 917 92%