Weighted Averages For Grades. But, no score for the final yet. How can I calc?

Question

10% for Participation 10% for Workbooks 10% for Quizzes 40% for Tests 30% for Final Test.

Students are asking for their current grade but I thought since one column is blank (final test, not taken) I could not calc it out. Instead of 100% it is 70% and the numbers are abit strange. Can someone help me calc a current grade without a input for Final Test?

Thanks

Answer 1

To get their current grade, just add up the weighted results of each of the things currently recorded, then divide by the total weight. So, here assigning the variables P for participation, W for workbook, Q for quiz, and T for test, the current average would be $\frac {.1P+.1W+.1Q+.4T} {.7}$