| 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 % |
| 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) | |||
Threaded Mode
