Prepare the worksheet as shown below and answer questions that follows UNIVERSITY OF GHANA STUDENTS GRADING SYSTEM

Student ID	Name	Interim Assessment 20%	Project work 10%	Exams 70%	Total marks	Grade	Grade point	Remarks
10381882	Gifty Asamoah	12	8	65
10364656	Sekyi Nyarko	10	6	42
10654255	Precious Boateng	15	5	53
10325456	Sandra Boateng	15	8	30
10642658	Martha Darko	16	9	25
10352655	Emefa Nimat	19	9	15
10656564	Gideon Asamoah	18	8	50
10655594	Yaa A. Konadu	5	7	54
10655568	Naomi Nuviedenu	6.5	9	44

a. Determine the total mark of each candidate b. Using the if function/statement, determine the grade, grade point, and remarks for each student based on the following scheme. c. Sort the index numbers in descending order.

Total Mark	Grade	Grade Point	Remark
=>80	A	4.0	Outstanding
75-79	B+	3.50	Very Good
70-74	B	3.00	Good
65-69	C+	2.5	Fairly Good