Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Practical Neo4j

Authors: Gregory Jordan

1st Edition

1484200225, 9781484200223

More Books

Students also viewed these Databases questions

Question

dy dx Find the derivative of the function y=(4x+3)5(2x+1)2.

Answered: 1 week ago