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.

** Note: **

- 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.

## Comments

0 comments

Please sign in to leave a comment.