students grades, formulae to calculate what grade is needed based.

[mjreisbord]

we have set up a excel sheet to monitor our childrens grades. i would
appreciate the formulae to calculate what grade my child needs to make on the
final to make a 90 in a particular class, if the final is weighted at 55%.
His current grade is 80, as an example.

thanks,

mark

 

[Bob Phillips]

we have set up a excel sheet to monitor our childrens grades. i would
appreciate the formulae to calculate what grade my child needs to make
on the
final to make a 90 in a particular class, if the final is weighted at
55%.
His current grade is 80, as an example.

thanks,

mark

=(target_score-(current_score*(1-final_weight)))/final_weight


in this case

=(90-(80*(1-55%)))/55%

 

[mjreisbord]

Mr. Phillips:

Thanks for your prompt response. Unfortunately, i could not make i
work.

in the worksheet, i have average, weighted grade, final grade, dro
min, and need to make.

i thought one must go from weighted grade, to need to make, an
finally; to final grade???

i hope this offers some clarification, opaque as it were.

thanks,
mar

 

[Lewis Clark]

Could you give some more detail on how the final grade is calculated? For
example: how many assignments are there for each student, and the earned
grade and weight for each assignment. Are you dropping the lowest grade?