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.

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%

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

The request includes the design of an assignment grading template in MS Excel and the instructions for using Excel formulae but also asks to paste an ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!