Thread: grade book
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve in Columbia[_2_] Steve in Columbia[_2_] is offline
external usenet poster
 
Posts: 1
Default grade book

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 %