Need a spreadsheet for variable grade averages

[Guest]

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 %

 

[Zone]

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

 

[Guest]

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

 

[Zone]

Okay, you get a pass this time.

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

 

[Guest]

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 (e-mail address removed).