| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
weighted exams, predicting what the final exam needs to be to pass
my brain is not working today... we use two exams. the first one counts for
30% of their total grade, the second one counts for 70% of their total grade. they have to have an 80% average overall to pass. i'm making a template for the trainers to use so they can plug in the results for the first exam and see what the student has to score above on the second exam to achieve the 80% overall. help please! :) -- Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
weighted exams, predicting what the final exam needs to be to pass
(80% - (30% x EXAM1)) / 70% = EXAM2
-- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "barren13" wrote: my brain is not working today... we use two exams. the first one counts for 30% of their total grade, the second one counts for 70% of their total grade. they have to have an 80% average overall to pass. i'm making a template for the trainers to use so they can plug in the results for the first exam and see what the student has to score above on the second exam to achieve the 80% overall. help please! :) -- Thanks! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
weighted exams, predicting what the final exam needs to be to
Thank you Gary!!! you are a life-saver!!!!
-- Thanks! "Gary Brown" wrote: (80% - (30% x EXAM1)) / 70% = EXAM2 -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "barren13" wrote: my brain is not working today... we use two exams. the first one counts for 30% of their total grade, the second one counts for 70% of their total grade. they have to have an 80% average overall to pass. i'm making a template for the trainers to use so they can plug in the results for the first exam and see what the student has to score above on the second exam to achieve the 80% overall. help please! :) -- Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate percentage between number of exams total missed exams | Excel Discussion (Misc queries) | |||
| I want to help you pass your Microsoft certification exams. | Excel Worksheet Functions | |||
| Guide you to Pass Microsoft Certificaton Exams in the first try | Excel Discussion (Misc queries) | |||
| $30 Pass4Sure to pass microsoft certification exams. | Excel Worksheet Functions | |||
| $30 Pass4Sure to pass microsoft certification exams. | Excel Discussion (Misc queries) | |||
Linear Mode
