Answer To: One screenshot is the assignment instructions. The other assignment is assignment example of an MS...
Rahul answered on Apr 08 2021
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 Izaguirre 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
Kerry 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 Izaguirre\n4. Cheryl Backer\n5. Tori Ginyard\n6. Danelle Seawood\n7. Taisha Bearden\n8. Nicolle Cardamone\n9. Kerry 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 correct 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 Izaguirre\n4. Cheryl Backer\n5. Tori Ginyard\n6. Danelle Seawood\n7. Taisha Bearden\n8. Nicolle Cardamone\n9. Kerry 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...