Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Download the Macro-enabled Excel file, which is uploaded on the E-learning portal, and then write a VB program that calculates the total mark and letter

image text in transcribed
image text in transcribed
Download the Macro-enabled Excel file, which is uploaded on the E-learning portal, and then 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 CA 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 >=50 otherwise Fail 3. Average is the sum of all total marks divided by number of students. D End of the Exam Good Luck E To Final 34 20 17 34 35 10 30 A B C 4 Total Mark Average: 5 STD ID STD Name Assignments Midterm 6 2020152 Ahmad 15 22 7 2020415 Salam 16 8 2020566 Khalid 28 27 9 2020323 Omar 30 28 10 2020147 Sara 6. 4 11 2020014 Lana 20 10 12 2020853 Sawsan 23 24 13 2020475 Laith 10 16 14 2020121 Hamza 30 29 15 2020965 Sara 12 13 16 2020339 Ruba 20 30 17 2020755 Salam 20 20 18 2020440 Salma 18 19 19 2020777 Wesam 25 25 20 2020222 Sona 24 16 21 2020111 Reem 10 9 22 2020333 Sondos 29 28 23 2020700 Mohmmad 25 25 24 2020666 Rami 20 25 37 30 20 22 28 30 30 10 35 33 14 BR

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

Accounting And Auditing Research And Databases Practitioner's Desk Reference

Authors: Thomas R. Weirich, Natalie Tatiana Churyk, Thomas C. Pearson

1st Edition

1118334426, 978-1118334423

More Books

Students also viewed these Databases questions

Question

Differentiate the function. r(z) = 2-8 - 21/2 r'(z) =

Answered: 1 week ago

Question

LO5 Describe job analysis and the stages in the process.

Answered: 1 week ago