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

1 answer below »
One screenshot is the assignment instructions. The other assignment is assignment example of an MS Excel sheet.
Answered 2 days AfterApr 06, 2021

Answer To: One screenshot is the assignment instructions. The other assignment is assignment example of an MS...

Rahul answered on Apr 08 2021
143 Votes
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...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here