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
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 >=80 B >=70 >=50 otherwise 3. Average is the sum of all total marks divided by number of students. D Fail End of the Exam Good Luck 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 >=80 B >=70 >=50 otherwise 3. Average is the sum of all total marks divided by number of students. D Fail End of the Exam Good Luck

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

Expert Oracle9i Database Administration

Authors: Sam R. Alapati

1st Edition

1590590228, 978-1590590225

More Books

Students also viewed these Databases questions

Question

What are some global issues confronting women?

Answered: 1 week ago

Question

Question What are the requirements for a SIMPLE 401(k) plan?

Answered: 1 week ago