Design the following student assignment grading template on your computer using MS Excel. Fill the cells with student name, student Reg. no and teacher name. Assume the term starts, term ends and assignment due dates yourself. But the assignment due dates should lie within the term duration. Assume the Marks (total) for all assignments yourself. (Note: write down the formulae for each part of question and Paste the complete image of filled excel sheet using snipping tool in your answer sheet)

a) Calculate the sum of Marks (total) and Marks scored against the field of Marks to date using formula.

b) Determine the Subject total (%) in percentage form for all subjects using formula.

c) Find the overall marks (%) in percentage using formula.

d) Refer the following table for grade allocation using formula.

Grade Marks (%)

A 88% - 100%

B+ 81% - 87%

B 74% - 80%

C+ 67% - 73%

C 60% - 66%

F Below 60%