3 | ![]() |
![]() |
![]() |
total =
4*(labs+midsession)*exam/(labs+
midsession+exam)
(this is the harmonic mean of session and exam marks, scaled
up to marks out of 100).
Click in Cell F2 in the Total column, and enter this formula, typing C2 for labs, D2 for midsession, and E2 for exam. Press enter when you have typed the formula. The result, about 94.9052632, should appear in cell F2. This has too many decimal places, so select the whole column from F2 to F27, go to the Number group on the Home tab, and click on the rightmost icon enough times to reduce the number of decimal places to 1. Save the workbook.
If you are having trouble doing this, have a look at the final demo excel workbook posted with lecture notes for week 1. There is a similar example on the sheet named "StuRec_list" of the book except it uses "***" instead of "Yes" and different conditions.
That's the end of subtask 1a. If you are uncertain whether you have done it right, show it to your lab demonstrator now. Otherwise, go on to subtask 1b.