$\backslash$table$[[$Mohd Halim,$63],[$Farah Haryani,$100],[$Aznil$,58],[$Najwa$,79],[$Amirul$,86],[$Sumayyah$,60]]$

Design a workable VB interface that must at least have the following control buttons:

$($i$)$ CalculateAverage $-$ Compute and display the average final score for the class to the user.

$($ii$)$ CalculateLowest $-$ Compute and display the student name with lowest score in class to the user.

$($iii$)$ CalculateMedian $-$ Compute and print out the name of student$($s$)$ with a median score. A median score is middle score when the score is sorted in ascending order. If the number of students is even that there are two median scores so you have to print the two names instead of one for odd number of studerits.

$($iv$)$ Exit $-$ To clear and terminate the program.

Write all the necessary VB code to implement this application successfully.

Given a sample of student's name list and their score test as shown in the table below in a Microsoft Excel Worksheet.

$\backslash$table$[[$Student$,$Score$],[$Mohd Halim,$63],[$Farah Haryani,$100],[$Aznil$,58],[$Najwa$,79],[$Amirul$,86],[$Sumayyah$,60]]$

Design a workable VB interface that must at least have the following control buttons:

$($i$)$ CalculateAverage $-$ Compute and display the average final score for the class to the user.

$($ii$)$ CalculateLowest $-$ Compute and display the student name with lowest score in class to the user.

$($iii$)$ CalculateMedian $-$ Compute and print out the name of student$($s$)$ with a median score. A median score is middle score when the score is sorted in ascending order. If the number of students is even that there are two median scores so you have to print the two names instead of one for odd number of students.

$($iv$)$ Exit $-$ To clear and terminate the program.

Write all the necessary VB code to implement this application successfully.