MATLAB letter grade from Excel file

3 次查看（过去 30 天）
Victor
Victor 2023-10-17
评论： Voss 2023-10-18
I am trying convert the percentage grade I calulcated into letter grades and I do not know how to?
%a) Read the student's information into MATLAB using buil-in function
%readmatirx
data = readmatrix("ITEC2600_Sample_Grades.xls");
%b Create an anoymous fucntion to calculate the studet's final make
Final_Grade = @(data)max(data(:,2:3),[],2)*0.10 +data(:,4)*0.20+data(:,5)*0.20+data(:,6)*0.50;
Final= Final_Grade(data)
%c) find the letter for each grade level
  2 个评论
Voss
Voss 2023-10-17
Your percentage grade calculation is weighting the Project at 0.7 and the Final at 0:
Final_Grade = @(data)max(data(:,2:3),[],2)*0.10 +data(:,4)*0.20+data(:,5)*0.20+data(:,5)*0.50;
% ^ Project ^ Project again
I guess that should be Project at 0.2 and Final at 0.5:
Final_Grade = @(data)max(data(:,2:3),[],2)*0.10 +data(:,4)*0.20+data(:,5)*0.20+data(:,6)*0.50;
% ^ Final is column 6

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Voss
Voss 2023-10-17
Ran in:
You need to define which numeric grades map to which letter grades. For example:
letters = 'F':-1:'A';
letters(letters == 'E') = ''
letters = 'FDCBA'
thresholds = [0, 60:10:100]
thresholds = 1×6
0 60 70 80 90 100
Once you do that you may be able to use discretize as follows:
% read file:
data = readmatrix("ITEC2600_Sample_Grades.xls");
% calculate numeric grades:
Final_Grade = max(data(:,2:3),[],2)*0.10 +data(:,4)*0.20+data(:,5)*0.20+data(:,6)*0.50
Final_Grade = 56×1
74.3910 85.1200 86.6620 61.9830 64.3490 55.5670 71.5370 64.9400 85.3990 91.9400
% discretize numeric grades to indices in thresholds, then index into
% letters with those indices:
Final_Letter_Grades = letters(discretize(Final_Grade,thresholds))
Final_Letter_Grades = 'CBBDDFCDBACFCBCDACBBDDDDBCCDFCDCFCBCBCDCCDCCFCDDCCBFCCCD'
  2 个评论
Victor
Victor 2023-10-17
I am new at this, but like is there a way to do this using switch or if statements?
Voss
Voss 2023-10-18
Sure.
% if statements:
N = numel(Final_Grade);
Final_Letter_Grades = char(zeros(1,N));
for ii = 1:N
if Final_Grade(ii) >= 90
Final_Letter_Grades(ii) = 'A';
elseif Final_Grade(ii) >= 80
Final_Letter_Grades(ii) = 'B';
elseif % etc.
% ...
else
% ...
end
end
% switch:
N = numel(Final_Grade);
Final_Letter_Grades = char(zeros(1,N));
for ii = 1:N
switch true
case Final_Grade(ii) >= 90
Final_Letter_Grades(ii) = 'A';
case Final_Grade(ii) >= 80
Final_Letter_Grades(ii) = 'B';
case % etc.
% ...
otherwise
% ...
end
end

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Historical Contests 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by