Excel Grade Mapper

版本 3.0.0.0 (9.1 KB) 作者: Marko Neitola
Map your grading system into an Excel-function
35.0 次下载
更新时间 2017/5/16

查看许可证

For teachers with a need to convert exam points to grades in Excel.
Maps your grading system into an Excel-function, which will be
copy-pasted into an Excel sheet.
Optionally, you can obtain the grades.
USAGE:
excelfun = excel_grade(grtab)
excelfun = excel_grade(grtab,mycell)
excelfun = excel_grade(grtab,mycell,failgr)
[excelfun,grades] = excel_grade(grtab,points)
grades = excel_grade(grtab,points)
[...] = excel_grade(grtab,mycell,points)
[...] = excel_grade(grtab,mycell,failgr,points)
[...] = excel_grade(grtab,mycell,failgr,points,delta)
INPUTS:
grtab: A matrix: Numerical or a cell-object.
The grading system as a table.
An N-by-2 matrix containing each grade and the corresponding
minimum points. A numerical example:
grtab=[1 6;2 8.5; 3 10;4 11;5 11.5];
- the grade is 1 for minimum 6 points
- the grade is 2 for minimum 8.5 points
- and so on, until best grade is 5 for minimum 11.5 points
- Less than 6 points is failed
- Max points are not given (it was 12 in this example)
You may replace some points by nan (not a number) to perform
numerical interpolation. If so, the minimum and maximum points
have to be included, e.g. grtab=[1 6;2 nan; 3 nan;4 nan;5 11.5]
Alternately, grtab can be a cell-object, which enables grades
as a string: grtab={'D-',6;'D',8.5;'C',10;'B',11;'A',11.5}
A cell object has to be a full grading table (no interpolation)
(Optional inputs)
mycell: A string. Your Excel cell, where the points begin.
For instance, you will paste the output variable excelfun right
next to 'H4', where H4 contains points for the first student.
Default 'A1'.
failgr: A string. The failing grade, e.g. 'F'. Default is zero ('0').
points: A numerical vector of points, case you want the grades in
MATLAB.
delta: Minimum step for points in case there will be interpolation.
Example: 7.1312 points will be rounded to 7.25 if delta=0.25.
Default: delta=0.25.
You need to match delta with your grading system even if there
is no interpolation: delta is used to calculate precision in
your excel function.

OUTPUTS:
excelfun: The excel function that maps points to grades.
grades : The grades that correspond to points. If points are provided
and if there is only one output variable, the output will be
grades.

引用格式

Marko Neitola (2024). Excel Grade Mapper (https://www.mathworks.com/matlabcentral/fileexchange/62868-excel-grade-mapper), MATLAB Central File Exchange. 检索时间: .

MATLAB 版本兼容性
创建方式 R2016b
兼容任何版本
平台兼容性
Windows macOS Linux
类别
Help CenterMATLAB Answers 中查找有关 Dynamic System Models 的更多信息
标签 添加标签

Community Treasure Hunt

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

Start Hunting!
版本 已发布 发行说明
3.0.0.0

Bugfix: Excel-function's numerical precision is now controllable.

2.0.0.0

May 15th 2017: Fixed a bug regarding the output parameters

1.0.0.0