How To Create mark Sheet For a Class In MS Excel using vba by following these steps 1) The following algorithm is designed to determine a grade for a course that consists of quizzes, homework and final exam. Write a program to determine final grade of USER DEFINED number of students according to the steps described below. (The number of students should be entered by the user.) Step1: Input number of students and name Step2: Input number of quizes and homeworks Step3: Input weighing factors for quizzes (WQ), homework (WH), and the final exam (WF) (e.g WQ 20%, WH 20% and WF 60%) Step4: Input quiz grades and determine an average quiz grade (AQ) Step5: Input homework grades and determine an average homework grade (AH) Step6: Input a final exam grade (FE) Step7: Determine the average grade AG according to Step8: Report name, quiz and homework grades and overall grade of each student (Report it on the Excel sheet as in the figure below, do not report it as a message box) Step9: Terminate computation
How To Create mark Sheet For a Class In MS Excel using vba by following these steps
1) The following algorithm is designed to determine a grade for a course that consists of quizzes,
homework and final exam. Write a program to determine final grade of USER DEFINED number of
students according to the steps described below. (The number of students should be entered by the
user.)
Step1: Input number of students and name
Step2: Input number of quizes and homeworks
Step3: Input weighing factors for quizzes (WQ), homework (WH), and the final exam (WF)
(e.g WQ 20%, WH 20% and WF 60%)
Step4: Input quiz grades and determine an average quiz grade (AQ)
Step5: Input homework grades and determine an average homework grade (AH)
Step6: Input a final exam grade (FE)
Step7: Determine the average grade AG according to
Step8: Report name, quiz and homework grades and overall grade of each student (Report it on the
Excel sheet as in the figure below, do not report it as a message box)
Step9: Terminate computation
![Clipboard
G19
}
6
7
8
9
I
*
3
Font
fx
New Group
I
Alignment
A
B
E
F
1 Student # Name/Surname Homework 1 Homework 2 Homework n Quiz 1
2
1
3
2
4
3
5
Quiz 2
B
12
H
Quiz n
Number
Final
.000 Formatting
F
Overall Grade
K](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F3aa0095c-60a3-484b-b7ee-e29a06dec24a%2F3a11da56-14cc-4e22-962c-ba68a81df903%2F2yvho28_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 3 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)