Spreadsheet question (beta)

Create a spreadsheet question

To create a spreadsheet question, follow the steps below.

1. Navigate to your question bank or your course assignment. 
2. Click New exercise, fill in a name and click Create.
3. Click + New question and select Spreadsheet.
4. Formulate the question in the question content field.
5. Fill in the number of points the question is worth.
6. Optionally, enter the model answer.
7. Select the scoring method:
   • Criteria: Grade by selecting each applicable criterion.
   • Rubric: Grade by selecting on criterion per set.
   • Slider: Grade by manually entering a score.
8. Add the Evaluation criteria. This option is not relevant for the scoring method 'Slider'. 
   Click on Add criteria to add a criterion. Optionally, click Add group, to add a group. More information can be found here.
9. Optionally, add learning objectives in the 'Objectives' field.
10. Click Create.

Add a grading scheme to a spreadsheet question

All options mentioned below for the grading scheme can also be added or adjusted from the exercise tab when creating a file upload question. However, it is only possible to adjust the grading scheme from the grading scheme tab if the assignment has been taken.

To add a grading scheme to a spreadsheet question, follow the steps below.

1. Click the Grading scheme tab at the top of the assignment or question bank exercise.
2. Go to the question for which you want to set the grading scheme.
3. Click the edit-icon. 
4. Fill in or adjust the amount of points the question is worth.
5. Optionally, fill in a model answer. 
6. Select or adjust the scoring method:
   • Criteria: Grade by selecting each applicable criterion
   • Rubric: Grade by selecting on criterion per set.
   • Slider: Grade my manually entering a score.
7. Optionally, add or adjust the learning objectives in the 'Objectives' field.
8. Click Update.

Options for a spreadsheet question

For additional options, click the settings-icon. You will see the following:

• Bonus
  This marks the question as a bonus question, which means that its points are not included in the maximum amount of points achievable for that assignment. If a student answers the question incorrectly, this will not be detracted from the number of points and the mark. However, when awarding points, it is possible to achieve more points that the maximum points achievable for the assignment.
   
• 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. 
  It is also possible to disable the editing of certain cells. This can be done by right clicking on the cells, and selecting 'Disable editing'. Participants will not be able to edit these cells when constructing their answer.