The above data are stored in an Excel file $($named scores.xls$),$ which can be downloaded from the Assignment page of the course moodle site.$(18$ points$)$ Consider the following table that contains the midterm and final exam marks of a

group of students and their student IDs:

The above data are stored in an Excel file $($named scores.xls$),$ which can be downloaded

from the Assignment page of the course moodle site.

All term tests and final marks are out of $100.$ The total mark of a student is a weighted sum of

the student's term tests and final marks. The weights of Test $1,$ Test $2,$ and Final are $25\%,$

$30\%,$ and $45\%$ respectively.

Write a MATLAB program that does all of the following in the specified order:

a$)$ Read the student IDs, Test $1,$ Test $2$ and Final marks in the scores.xls file into a

matrix $($named M$)$ in MATLAB. Note that you are not allowed to type the values into

a matrix.

b$)$ Compute the total score of each student using the weighted sum of the student's term

tests and final marks as described above. Then display all the marks in the command

window as follows:

All term tests and final marks are out of $100.$ The total mark of a student is a weighted sum of the student$$s term tests and final marks. The weights of Test $1,$ Test $2,$ and Final are $25\%,30\%,$ and $45\%$ respectively.

Write a MATLAB program that does all of the following in the specified order:

a$)$

Read the student IDs, Test $1,$ Test $2$ and Final marks in the scores.xls file into a matrix $($named M$)$ in MATLAB. Note that you are not allowed to type the values into a matrix.

b$)$

Compute the total score of each student using the weighted sum of the student$$s term tests and final marks as described above. Then display all the marks in the command window as follows: