Answer to Question #163949 in Programming & Computer Science for hania

Question

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%

Answer 1

Dear hania , your question requires a lot of work, which neither of our experts is ready to perform for free. We advise you to convert it to a fully qualified order and we will try to help you. Please click the link below to proceed: Submit order