Question: write a VB program that calculates the total mark and letter grade for each student in the marks sheet. Also, your program should find the

 write a VB program that calculates the total mark and letter
write a VB program that calculates the total mark and letter grade for each student in the marks sheet. Also, your program should find the highest and lowest total mark in addition to the average of total marks in the cells C2, C3 and C4 respectively. Take into consideration the following rules:
1. Total mark is the sum of assignments, midterm and final
2. Letter grade is based on the following criteria: Total Mark Letter Grade
>=90
A
>=80
B
>=70
C
>=50
D
otherwise
Fail
3. Average is the sum of all total marks divided by number of students.

Total Mark Letter G 30 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 Total Mark Average: STD_ID STD_Name Assignments Midterm 2E+06 Ahmad 15 22 2E+06 Salam 16 17 2E+06 Khalid 28 27 2E+06 Omar 28 2E+06 Sara 6 4 2E+06 Lana 20 10 2E+06 Sawsan 23 24 2E+06 Laith 10 16 2E+06 Hamza 30 29 2E+06 Sara 12 2E+06 Ruba 20 30 2E+06 Salam 20 20 2E+06 Salma 18 19 2E+06 Wesam 25 25 2E+06 Sona 24 16 2E+06 Reem 10 9 2E+06 Sondos 29 28 2E+06 Mohmmad 25 25 2E+06 Rami 20 9 Final 34 20 34 35 10 30 30 20 37 30 20 22 28 30 30 13 10 35 33 14 marks

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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!