ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   weighted exams, predicting what the final exam needs to be to pass (https://www.excelbanter.com/excel-worksheet-functions/230182-weighted-exams-predicting-what-final-exam-needs-pass.html)

barren13

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!

Gary Brown[_5_]

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!


barren13

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!



All times are GMT +1. The time now is 08:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com