Q1. Write a program that uses the InputBox method to let the user enter 7 exam scores and 7 student names into two separate arrays. The information for each student is stored in the same relative position in each array. For instance, the exam score of strStudentNames(0) is stored in intScores(0). Compute and display the followings:
a) Display each student name and his/her exam score in a list box.
b) Write a function that calculates and returns the average score of the class.
c) Write a function that calculates and returns the range of scores.
d) Write a function that calculates and returns the median score of the class.
e) Let's assume that the passing score is 75. How many students passed the exam?
f) Write a procedure that searches for a student name in the strStudentNames() array. (Note: Let the user enter a name into a TextBox control and click btnFindStudent to begin the search process.)