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

icon
Related questions
Question

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
Transcribed Image Text: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
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer