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
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)
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.
Your excel sheet now has the score, maximum score and new percentage without your broken question.