Need a spreadsheet for variable grade averages
 

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%

Joe Student 95 50 100 100 87 gives you %

Need a spreadsheet for variable grade averages
 

Question asked and answered in excel.programming newsgroup. Please do not
double-post.

"Steve in Columbia" wrote in
message ...
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%

Joe Student 95 50 100 100 87 gives you %

Need a spreadsheet for variable grade averages
 

Sorry - I thought I was in the wrong category (ie: visual basic) and reposted
before I got replies. Steve

"Zone" wrote:

Question asked and answered in excel.programming newsgroup. Please do not
double-post.

"Steve in Columbia" wrote in
message ...
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%

Joe Student 95 50 100 100 87 gives you %

Need a spreadsheet for variable grade averages
 

Okay, you get a pass this time. ;)
"Steve in Columbia" wrote in
message ...
Sorry - I thought I was in the wrong category (ie: visual basic) and
reposted
before I got replies. Steve

"Zone" wrote:

Question asked and answered in excel.programming newsgroup. Please do
not
double-post.

"Steve in Columbia" wrote in
message ...
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%

Joe Student 95 50 100 100 87 gives you %

Need a spreadsheet for variable grade averages
 

I have a work sheet that will handle up to 40 students. It will allow you to
weigh the individual assignments separately as well as weigh groups of items
so that if you have up to 80 assignments, each assignment can be weighed a
certain amount. Further it will allow you to weigh the value of the
assignments as a whole. It will allow you to do the same with quizzes(16),
tests(16) Oral and Written Presentations(4 each), A midterm (actually 4
grades) and a final exam(4 grades). These can all be entered on the fly
meaning that it will take into account the number of each of these items
held. It will also allow you to put a weight for each category Assignments,
Quizzes, Written and Oral Presentations, Tests, Mid-term and Final Exam. If
you chose not to have one of these areas that is fine too. If this sounds
like it will meet your needs contact me at .


"Steve in Columbia" wrote:

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%

Joe Student 95 50 100 100 87 gives you %