Insert a column after the Assg2 column and two columns after the Final Exam column. Name the new inserted columns as CW, Final Mark and Grade respectively.
others
Description
Objective:
1. To practice your skill on using IF formula
2. To learn COUNTIF formula for counting values of cells
Using the template given (lab3template.xls), try out the following:
2. Insert a column after the Assg2 column and two columns after the Final Exam column. Name
the new inserted columns as CW, Final Mark and Grade respectively.
3. Calculate :
a. CW column. Note that CW must be normalized to 100 and you must round every CW to an Integer (use ROUND function). CW is composed of Lab 20% Test 10% Assg1 15% Assg2 15%
b. Final Mark column.
