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
Step by step
Solved in 3 steps with 2 images