Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 % |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 % |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 % |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 % |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 % |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup variable data on a spreadsheet, and remove duplicates from another | Excel Worksheet Functions | |||
when doing a grade book how do you drop the lowest grade | Excel Worksheet Functions | |||
when doing a grade book how do you drop the lowest grade | Excel Worksheet Functions | |||
How to create spreadsheet that averages up to 10 columns of data | Excel Worksheet Functions | |||
Grade Percentage into letter grade | Excel Discussion (Misc queries) |