Instead of using a formula or equation to calculate the marks, a table can be inserted by which marks will be determined.
- Sign in to Ans
- Click on your course or use the search bar in the Courses-section.
- Click on your assignment or use the search bar.
- Click on Settings in the menu at the top.
- Click on Result options in the menu on the left.
- Click the drop-down button Grade calculation and choose Formula, Table or None.
Grading with a formula
- Fill in the grading formula.
- Select the options Grade lower bound, Grade upper bound and Guess correction if desired.
- Click the drop-down button Rounding and choose the rounding method.
- Fill in a passing grade. Standard, the formula is [1 + 9 * points / total], where points is the number of points obtained by a student and total is the total amount of points a student can obtain. Options that are available for this formula:
- Math operators: + , - , * , / , ^
- Logic functions: IF, AND, OR
- Comparison operators: <, >, <=, >=, !=, =
- Numeric functions: MIN, MAX, ROUND, ROUNDUP, ROUNDDOWN
- Explanation: The following formula gives an answer of 1 if no points are gathered and increases as a polynomial.
Code: 1 + 0.026984127 * points + 0.002050265 * points ^ 2
- Explanation: If total number of points is lower than 45, use (points / 9) + 1 as marking formula. If total number of points is equal or larger than 45, use (4 * points / 45)+2 as marking formula.
Code: IF(points < 45, (points / 9) + 1, (4 * points / 45)+2)
- Explanation: The maximum of 0 and points minus 28 are compared and subsequently multiplied by 4 and divided by the total minus 28. Next, two things are added to this number: the minimum of 28 and points multiplied by 5 and divided by 28 and one (so a student will not get a mark lower than 1).
Code: MAX(0, points - 28) * 4 / (total - 28) + MIN(28, points) * 5 / 28 + 1
- Click on Update.
Grading with a table
- Click Add row and fill in a number of points, a grade and if desired a letter grade.
- Click Save.
- Repeat this for all scores.
- It is also possible to import a table using the button Import. This table should be an Excel- or .CSV-file and should have two columns, one with points and one with the marks. If letter grades are used, the file should contain three columns.
- Ans calculates a grade for closed questions and a grade for open questions. When these grades are calculated, these will be summed up by making use of the ratio closed:open questions.
- When a student gets a number of points in between of two data points from the table, so for example 22,0 points, the grade will be of the data point in the nearest vicinity. A number of points exactly in the middle is rounded of downwards.