grade book

[Steve in Columbia]

Does anyone have a template or grade book that allows me to weight each test
as I go without knowing all the tests that will be given for the quarterly
grade? GradeKeeper does this, but I want to continue using Excel. All
Quizes are 25% and all Tests are 65% and all completed homework assignments
are 10%. Maybe I'd need a table that showed the weights?

Example:

Student Test1 Quiz1 Quiz2 HW1 Test2
Final %
65% 25% 25% 10% 65%
100%

Joe Student 95 50 100 100 87
gives you %

 

[Gary''s Student]

Hi Steve:

Do you score an individual homework assignment as 0 thru 100
or just
complete / not_complete ?

 

[Steve in Columbia]

Hi! I assign scores to each homework assignment. I'd like to score
everything in terms of percentages and then weight them differently, so
tests, quizzes, and homework would always be out of 100, but homework would
be weighted only 10% of the total average. Does that make sense? Steve

 

[Gary''s Student]

Yes...perfect...check back later

 

[barnabel]

you could use the formula =SUMPRODUCT(B$2:G$2,B4:G4)/SUM(B$2:G$2) to produce
a weighted average grade if you have the weightings in row 2 and the students
grades in row 4

Peter Richardson

 

[Gary''s Student]

Let's use a tab for each student (we can change this later).
In column A starting in ROW 2 put the test scores
In column B starting in ROW 2 put the quiz scores
In column C starting in ROW 2 put the homework scores

In A1 enter:
=SUM(A2:A1000)*0.65

In B1 enter:
=SUM(B2:B1000)*0.25

In C1 enter:
=SUM(C2:C1000)*0.1


A1, B1, and C1 are the weighted sums of tests, quizes, and homework. Adding
A1+B1+C1 will give us a large number that must be compared with the largest
possible score for the same set of graded items. In cell D1 enter:

=(A1+B1+C1)/(COUNTA(A2:A1000)*0.65+COUNTA(B2:B1000)*0.25+COUNTA(C2:C1000)*0.1)


For example, consider Penelope Perfect:

650 125 90 100
100 100 100
100 100 100
100 100 100
100 100 100
100 100 100
100 100
100 100
100 100
100 100
100


how about Dwight Dumb:

422.5 81.25 58.5 65
65 65 65
65 65 65
65 65 65
65 65 65
65 65 65
65 65
65 65
65 65
65 65
65

and finally Albert Average:

498.55 104.75 59.1 76.57803468
83 81 57
87 80 80
72 86 51
68 83 69
70 89 55
69 84
88 65
83 55
73 75
74

 

[Steve in Columbia]

Thanks Gary's Student! I'll give that a try! I appreciate your taking the
time.
Steve

 

[Steve in Columbia]

Thanks Barnabel! I saw an example of sumproduct used in a similar
application. I'll definitely check that out! I appreciate your time. -
Steve