OnDemand – Removing a broken question

This page explains how to remove a broken question from an OnDemand exam. This process cannot be done natively in OnDemand so requires a CSV output with all responses.

Ensure you create

  • A Results export CSV
    • Ignore assignment revisions unticked
    • Include item response data ticked

or have given to you

  • A file named [Modulename]_Results_AllResponses.csv

Organising the CSV file

Within the CSV file, there are some unique columns from “Assessment id” to “Answers recorded for this result”. There are then repeating columns per question of

  • Question wording for…
  • Block number for…
  • Answer status for…
  • Answer given for…
  • Score for…
  • Correct answer for…
  • Max item score for…
  • Participant comments for…
  • Time taken (item) for…
  • Topic for…

Creating new columns

Create a new column to the right of “Total score” called

Revised total score

Create a new column to the right of “Percentage score” called

Revised percentage score

Create a new column to the right of “Max assessment score” called

Revised max assessment score

Excel headings Total score Revised total score Percentage score Revised percentage score Max assessment score Revised max assessment score

Noting column names

Make a note of the column names for (my examples in brackets)

  • Total score (AJ)
  • Revised total score (AK)
  • Percentage score (AL)
  • Revised percentage score (AM)
  • Max assessment score (AN)
  • Revised max assessment score (AO)
  • The broken question’s Score for… (IX)
  • The broken question’s Max item score for… (IZ)

Excel headings Question, block number,

Calculating revised score

In the first row (should be row 2) for Revised total score write

=[Total score]2 – [The broken question’s Score for…]2

e.g.

=AJ2-IX2

For Revised percentage write

=([Revised total score]2 / [Revised max assessment score]2) * 100

e.g.

=(AK2/AO2)*100

For Revised max assessment score write the calculation

=[Max assessment score]2 – [The broken questions Max item score for…]2

e.g.

=AN2-IZ2

If, for some reason, you are not working in row 2, change the 2 to the actual row number.

Copy the formula to all cells in the column by highlighting your formula and double-clicking on the auto fill corner (highlighted below, your cursor will change to a plus sign) for each of the three columns.

Excel with cell corner highlighted

Your excel sheet now has the score, maximum score and new percentage without your broken question.