lightbulb_outline This question type can be used in a digital test only. This question type is not compatible with iPads.
A spreadsheet question (formally named worksheet question) is used to ask participants to fill in their answers in a spreadsheet. There is also an option to work with predefined answers, including an option to disable the editing of certain cells. A predefined answer is shown to all participants when they begin with the question.
The spreadsheet supports various formatting options and supports the use of simple formula functions, such as: SUM, AVERAGE, MAX, MIN, IF, AND, OR and CONCAT.
Spreadsheet questions will need to be graded manually. To support you in doing this, you can make use of criteria, rubrics or sliders.
Create a spreadsheet question
To create a spreadsheet question, follow the steps below.
 Click the domain School name in the menu on the left.
 Click on label_important Courses in the menu at the top.
 Select your course or use the search bar.
 Select your assignment or create a new assignment.
 Click New exercise, fill in a name and click Save.
 Click New question and select Spreadsheet.
 Formulate the question in the question content field.
 Fill in the number of points the question is worth.
 Click the more_verticon for more options.
 Click Save.
Options for a spreadsheet question

Bonus
This marks the question as a bonus question, which means the number of points awarded with this question will be counted until the maximum amount of points achievable for this assignment is reached. The points of the bonus question are not included in the maximum amount of points that can be achieved for the assignment If the student answers the question incorrectly, this will not be detracted from the number of points and the mark.

Skippable
You will first need to assign which students are exempted from answering this question within the settings of your course. You can then enable which questions can be skipped by these students. They will see a notification in the test informing them they can skip the question. The number of points for this question will not be counted in their result. It is not possible to change this setting after the test has been taken.

Partial Scoring
Students will receive points when their answer is partly correct. For example, if the total number of points they can receive for a question is 2 and their answer is 50% correct, they will still receive 1 point. Without this option, they can only receive 0 or the maximum number of points.

Predefined answer
Set a predefined answer which students can keep, edit or delete. This will show up in the answer field.
Add a grading scheme to a spreadsheet question
To add a grading scheme to a spreadsheet question, follow the steps below.
 Click the Grading scheme tab at the top of the assignment.
 Go to the question for which you want to set the grading scheme.
 Click the more_horizicon and click Edit.
 Click the dropdown menu Grading method* and choose your method.
 Click the more_verticon for more grading options.
Options for grading a spreadsheet question

Model answer
A solution for the reviewers (and for participants when published). The model answer can be an extensive elaboration, an image, or a file.

Start with zero points (For the pointspercriteria and rubrics grading method only)
If this option is enabled the marking of this question will always start at zero points and the points will be added up when selecting the criteria. When this option is disabled, the marking will start with the maximum amount of points that can be awarded for this question and selecting the criteria will be subtracted from this maximum. This means that the criteria should be added as minus points of the total amount. The reviewer can then select the criteria if the student did not meet this with their answer, so it can be detracted from the total amount of points.

Limit minimum to zero points (For the pointspercriteria grading method only)
With this option enabled, it is impossible to go below zero points when selecting the different criteria. It is still possible to manually adjust the number of points to go below zero with the adjustment option during the reviewing.

Limit maximum to total points(For the pointspercriteria grading method only)
In the grading settings it is possible to set the maximum amount of points achievable with the question, separate from the points per criteria When this number deviates from the maximum amount achievable by adding up the criteria points, this option will cap the maximum amount of points to this manually set number.
Comments
0 comments
Article is closed for comments.