Question Using Excel spreadsheet to manage your grades. This spreadsheet was tar
ID: 3681035 • Letter: Q
Question
Question Using Excel spreadsheet to manage your grades. This spreadsheet was targeted to help you understand where you currently stand in the class and what the effects of changing one, two, or more grades are. Now, you are going to write a MATLAB program to read in an Excel spreadsheet and compute your average grade based on all grades that you know thus far. The spreadsheet will be called “MyGrades.xlsx” and it will have 6 columns. Column A will contain homework scores and there will be 42 rows worth of data (representing 42 homework grades). Column B will contain quiz scores and there will be 16 rows worth of data (representing 16 quiz grades). Column C will contain test scores and there will be 3 rows worth of data. Column D will contain the final exam score and there is only one of that. Column E will contain the semester project score and there will only be one of that as well. The last column, Column F, will contain your attendance grade and there will be only one row of data in this column as well. There will be no column headers in the Excel file, just numbers representing grades. Also, you cannot specify a path for your Excel file; it must be saved in your current MATLAB folder. Your MATLAB code needs to read this data in and then compute your average in the course. It also needs to ask the user their name and then display a statement similar to the following if the user’s name is Kevin: Kevin, your current grade in the class is 97.
Explanation / Answer
#matlab file to read data from excel file and printing total grade of student
name = input(prompt , 's');# asking user name here
file = 'MyGrades.xlsx';#excel file name of the student
filedata = xlsread(file);#read total data from given file
filedata# displaying file data
col1 = xlsread(file,'A:A');#taking first column data
col2 = xlsread(file,'B:B');#taking second column data
col3 = xlsread(file,'C:C');#taking third column data
col4 = xlsread(file,'D:D');#taking fourth column data
col5 = xlsread(file,'E:E');#taking fifth column data
col6 = xlsread(file,'F:F');#taking sixth column data
clo11avg = mean(col1);#calculating average of first column data
clo12avg = mean(col2);#calculating average of second column data
clo13avg = mean(col3);#calculating average of third column data
totalgrade = [clo11avg clo12avg clo13avg col4 col5 col6 ];
totavggrade = mean(totalgrade);#calculating final average
fprintf(' %s, your current grade in the cass is %s. ',name,num2str(totavggrade));#displaying current grade
#sample output of above code is:
Jhon
filedata =
45 67 23 45 12 48
45 67 23
45 67 23
67 89
67 89
67 89
67 89
67 89
67 89
67 89
67 89
67 89
67 89
67 89
67 89
67 89
87
87
87
87
87
87
87
87
87
87
87
87
87
87
87
87
87
87
87
87
87
87
87
87
87
87
, your current grade in the cass is 76.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.