Spreadsheet question (beta) – Ans

error_outline This option is available through beta features, read more about beta features here.

lightbulb_outline This question type can be used in a digital test only. This question type is not compatible with iPads.

A spreadsheet 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 (by right-clicking on them and selecting 'Disable editing'). All participants see a predefined answer when they start 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.

Questions can be created either in a question bank exercise or from within a course assignment. The video below demonstrates creating the questions from the question bank exercise.

Create a spreadsheet question

To create a spreadsheet question, follow the steps below.

Navigate to your question bank or your course 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_vert-icon 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.
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. An example can be found in the figure below.

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 or question bank exercise.
Go to the question for which you want to set the grading scheme.
Click the more_horiz-icon and click Edit.
Click the dropdown menu Grading method* and choose your method.
Click the more_vert-icon 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 points-per-criteria 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.

Related articles