One screenshot is the assignment instructions. The other assignment is assignment example of an MS Excel sheet.

Solution/Data.xlsx
Sheet1
                Name        HW1        HW2        HW3        Midterm        Final
                Neta Clouser        95.46        59.01        55        65.23        92.4
                Marietta Burchett        92.19        59.68        54.76        77.42        56.85
                Janna Izagui
e        59.65        69.14        87.35        94.28        56.9
                Cheryl Backer        89.74        95.88        91.29        71.43        54.52
                Tori Ginyard        52.95        68.59        56.01        91.14        78.29
                Danelle Seawood        76.74        98.49        96.72        54.05        74.29
                Taisha Bearden        61.42        72.65        84.67        81.61        56.12
                Nicolle Cardamone        91.82        58.09        89.96        82.3        70.66
                Ke
y Siggers        73.51        90.97        61.49        92.45        64.61
                Corey Riera        72.57        65.4        70.61        54.54        81.32
Sheet2
Sheet3
Solution/Solution of Question a/grade.asv
function a = grade
[name num]=xlsread('Data.xlsx');
prompt='Please enter the number: \n1. Neta Clouser\n2. Marietta Burchett\n3. Janna Izagui
e\n4. Cheryl Backer\n5. Tori Ginyard\n6. Danelle Seawood\n7. Taisha Bearden\n8. Nicolle Cardamone\n9. Ke
y Siggers\n10. Corey Riera\n';
x=input(prompt);
if x==1
b=num(2,1);
name1=cell2mat(b);
a=fprintf(name1);
e=name(1,1);
f=name(1,2);
g=name(1,3);
h=e+g+f;
i=name(1,4);
j=name(1,5);
a=fprintf(' grades in EE 3001:\nHW1 grade:%.2f\nHW2 grade:%.2f\nHW3 grade:%.2f\nTotal HW grade:%.2f\nMide Term Exam grade:%.2f\nFinal Exam grade:%.2f\nFinal grade:\n',e,f,g,h,i,j);
elseif x==2
b=num(3,1);
name1=cell2mat(b);
a=fprintf(name1);
e=name(2,1);
f=name(2,2);
g=name(2,3);
h=e+g+f;
i=name(2,4);
j=name(2,5);
a=fprintf(' grades in EE 3001:\nHW1 grade:%.2f\nHW2 grade:%.2f\nHW3 grade:%.2f\nTotal HW grade:%.2f\nMide Term Exam grade:%.2f\nFinal Exam grade:%.2f\nFinal grade:\n',e,f,g,h,i,j);
elseif x==3
b=num(4,1);
name1=cell2mat(b);
a=fprintf(name1);
e=name(3,1);
f=name(3,2);
g=name(3,3);
h=e+g+f;
i=name(3,4);
j=name(3,5);
a=fprintf(' grades in EE 3001:\nHW1 grade:%.2f\nHW2 grade:%.2f\nHW3 grade:%.2f\nTotal HW grade:%.2f\nMide Term Exam grade:%.2f\nFinal Exam grade:%.2f\nFinal grade:\n',e,f,g,h,i,j);
elseif x==4
b=num(5,1);
name1=cell2mat(b);
a=fprintf(name1);
e=name(4,1);
f=name(4,2);
g=name(4,3);
h=e+g+f;
i=name(4,4);
j=name(4,5);
a=fprintf(' grades in EE 3001:\nHW1 grade:%.2f\nHW2 grade:%.2f\nHW3 grade:%.2f\nTotal HW grade:%.2f\nMide Term Exam grade:%.2f\nFinal Exam grade:%.2f\nFinal grade:\n',e,f,g,h,i,j);
elseif x==5
b=num(6,1);
name1=cell2mat(b);
a=fprintf(name1);
e=name(5,1);
f=name(5,2);
g=name(5,3);
h=e+g+f;
i=name(5,4);
j=name(5,5);
a=fprintf(' grades in EE 3001:\nHW1 grade:%.2f\nHW2 grade:%.2f\nHW3 grade:%.2f\nTotal HW grade:%.2f\nMide Term Exam grade:%.2f\nFinal Exam grade:%.2f\nFinal grade:\n',e,f,g,h,i,j);
elseif x==6
b=num(7,1);
name1=cell2mat(b);
a=fprintf(name1);
e=name(6,1);
f=name(6,2);
g=name(6,3);
h=e+g+f;
i=name(6,4);
j=name(6,5);
a=fprintf(' grades in EE 3001:\nHW1 grade:%.2f\nHW2 grade:%.2f\nHW3 grade:%.2f\nTotal HW grade:%.2f\nMide Term Exam grade:%.2f\nFinal Exam grade:%.2f\nFinal grade:\n',e,f,g,h,i,j);
elseif x==7
b=num(8,1);
name1=cell2mat(b);
a=fprintf(name1);
e=name(7,1);
f=name(7,2);
g=name(7,3);
h=e+g+f;
i=name(7,4);
j=name(7,5);
a=fprintf(' grades in EE 3001:\nHW1 grade:%.2f\nHW2 grade:%.2f\nHW3 grade:%.2f\nTotal HW grade:%.2f\nMide Term Exam grade:%.2f\nFinal Exam grade:%.2f\nFinal grade:\n',e,f,g,h,i,j);
elseif x==8
b=num(2,1);
name1=cell2mat(b);
a=fprintf(name1);
e=name(1,1);
f=name(1,2);
g=name(1,3);
h=e+g+f;
i=name(1,4);
j=name(1,5);
a=fprintf(' grades in EE 3001:\nHW1 grade:%.2f\nHW2 grade:%.2f\nHW3 grade:%.2f\nTotal HW grade:%.2f\nMide Term Exam grade:%.2f\nFinal Exam grade:%.2f\nFinal grade:\n',e,f,g,h,i,j);
elseif x==9
b=num(2,1);
name1=cell2mat(b);
a=fprintf(name1);
e=name(1,1);
f=name(1,2);
g=name(1,3);
h=e+g+f;
i=name(1,4);
j=name(1,5);
a=fprintf(' grades in EE 3001:\nHW1 grade:%.2f\nHW2 grade:%.2f\nHW3 grade:%.2f\nTotal HW grade:%.2f\nMide Term Exam grade:%.2f\nFinal Exam grade:%.2f\nFinal grade:\n',e,f,g,h,i,j);
elseif x==10
b=num(2,1);
name1=cell2mat(b);
a=fprintf(name1);
e=name(1,1);
f=name(1,2);
g=name(1,3);
h=e+g+f;
i=name(1,4);
j=name(1,5);
a=fprintf(' grades in EE 3001:\nHW1 grade:%.2f\nHW2 grade:%.2f\nHW3 grade:%.2f\nTotal HW grade:%.2f\nMide Term Exam grade:%.2f\nFinal Exam grade:%.2f\nFinal grade:\n',e,f,g,h,i,j);
else
fprintf('Please enter co
ect number');
end
end
end
Solution/Solution of Question a/grade.m
function a = grade
[name num]=xlsread('Data.xlsx');
prompt='Please enter the number: \n1. Neta Clouser\n2. Marietta Burchett\n3. Janna Izagui
e\n4. Cheryl Backer\n5. Tori Ginyard\n6. Danelle Seawood\n7. Taisha Bearden\n8. Nicolle Cardamone\n9. Ke
y Siggers\n10. Corey Riera\n';
x=input(prompt);
if x==1
b=num(2,1);
name1=cell2mat(b);
a=fprintf(name1);
e=name(1,1);
f=name(1,2);
g=name(1,3);
h=e+g+f;
i=name(1,4);
j=name(1,5);
a=fprintf(' grades in EE 3001:\nHW1 grade:%.2f\nHW2 grade:%.2f\nHW3 grade:%.2f\nTotal HW grade:%.2f\nMide Term Exam grade:%.2f\nFinal Exam grade:%.2f\nFinal grade:\n',e,f,g,h,i,j);
elseif x==2
b=num(3,1);
name1=cell2mat(b);
a=fprintf(name1);
e=name(2,1);
f=name(2,2);
g=name(2,3);
h=e+g+f;
i=name(2,4);
j=name(2,5);
a=fprintf(' grades in EE 3001:\nHW1 grade:%.2f\nHW2 grade:%.2f\nHW3 grade:%.2f\nTotal HW grade:%.2f\nMide Term Exam grade:%.2f\nFinal Exam grade:%.2f\nFinal grade:\n',e,f,g,h,i,j);
elseif x==3
b=num(4,1);
name1=cell2mat(b);
a=fprintf(name1);
e=name(3,1);
f=name(3,2);
g=name(3,3);
h=e+g+f;
i=name(3,4);
j=name(3,5);
a=fprintf(' grades in EE 3001:\nHW1 grade:%.2f\nHW2 grade:%.2f\nHW3 grade:%.2f\nTotal HW grade:%.2f\nMide Term Exam grade:%.2f\nFinal Exam grade:%.2f\nFinal grade:\n',e,f,g,h,i,j);
elseif x==4
b=num(5,1);
name1=cell2mat(b);
a=fprintf(name1);
e=name(4,1);
f=name(4,2);
g=name(4,3);
h=e+g+f;
i=name(4,4);
j=name(4,5);
a=fprintf(' grades in EE 3001:\nHW1 grade:%.2f\nHW2 grade:%.2f\nHW3 grade:%.2f\nTotal HW grade:%.2f\nMide Term Exam grade:%.2f\nFinal Exam grade:%.2f\nFinal grade:\n',e,f,g,h,i,j);
elseif x==5
b=num(6,1);
name1=cell2mat(b);
a=fprintf(name1);
e=name(5,1);
f=name(5,2);
g=name(5,3);
h=e+g+f;
i=name(5,4);
j=name(5,5);
a=fprintf(' grades in EE 3001:\nHW1 grade:%.2f\nHW2 grade:%.2f\nHW3 grade:%.2f\nTotal HW grade:%.2f\nMide Term Exam grade:%.2f\nFinal Exam grade:%.2f\nFinal grade:\n',e,f,g,h,i,j);
elseif x==6
b=num(7,1);
name1=cell2mat(b);
a=fprintf(name1);
e=name(6,1);
f=name(6,2);
g=name(6,3);
h=e+g+f;
i=name(6,4);
j=name(6,5);
a=fprintf(' grades in EE 3001:\nHW1 grade:%.2f\nHW2 grade:%.2f\nHW3 grade:%.2f\nTotal HW grade:%.2f\nMide Term Exam grade:%.2f\nFinal Exam grade:%.2f\nFinal grade:\n',e,f,g,h,i,j);
elseif x==7
b=num(8,1);
name1=cell2mat(b);
a=fprintf(name1);
e=name(7,1);
f=name(7,2);
g=name(7,3);
h=e+g+f;
i=name(7,4);
j=name(7,5);
a=fprintf(' grades in EE 3001:\nHW1 grade:%.2f\nHW2 grade:%.2f\nHW3 grade:%.2f\nTotal HW grade:%.2f\nMide Term Exam grade:%.2f\nFinal Exam grade:%.2f\nFinal grade:\n',e,f,g,h,i,j);
elseif x==8
b=num(9,1);
name1=cell2mat(b);
a=fprintf(name1);
e=name(8,1);
f=name(8,2);
g=name(8,3);
h=e+g+f;
i=name(8,4);
j=name(8,5);
a=fprintf(' grades in EE 3001:\nHW1 grade:%.2f\nHW2 grade:%.2f\nHW3 grade:%.2f\nTotal HW grade:%.2f\nMide Term Exam grade:%.2f\nFinal Exam grade:%.2f\nFinal grade:\n',e,f,g,h,i,j);
elseif x==9
b=num(10,1);
name1=cell2mat(b);
a=fprintf(name1);
e=name(9,1);
f=name(9,2);
g=name(9,3);
h=e+g+f;
i=name(9,4);
j=name(9,5);
a=fprintf(' grades in EE 3001:\nHW1 grade:%.2f\nHW2 grade:%.2f\nHW3 grade:%.2f\nTotal HW grade:%.2f\nMide...