Choose your language

Final Score

Intermediate Exercise


Statement

Create an algorithm to access a student's final score. Consider that the final score is a weighted average and that within the semester there are three exams weighting 3, 5 and 7 respectively. Once the algorithm is done, create a macro to display an interface with an Inputbox to insert the student's exam scores and to show if the student was approved or not. Make the macro display an alert if the input is not numeric and end if the input is blank.


Suggested Concepts:

Remember that in most cases there is more than one way to solve the exercise.

Hint: to call a function in one Sub but write its name.


Show Answer

Download exercise Download answer



SuperExcelVBA.com is learning website. Examples might be simplified to improve reading and basic understanding. Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. All Rights Reserved.

Excel ® is a registered trademark of the Microsoft Corporation.

© 2019 SuperExcelVBA | ABOUT

Protected by Copyscape