I'm using the calculation:
=floor((item1+2)/5)
to convert item1 into a new item with a 1 if the original score is 3 to 5, and 0 if the original score is less than 3. That all works fine.
However, an empty score for a student in item1 leads to an empty score in the calculated item. I want empty scores in item1 to be 0's in the calculated item, without me overriding the empty scores in item1 with 0's. (As I want students to still be able to work on item1 if they haven't already, but see a 0 in the calculated score to motivate them.)
I tried
but that still left empty scores in the calculated item when there were empty scores in [[item1].
Any way for me to do a calculation that puts 0's in for empty scores in the source item, but also does the calculation if there is a score in the source item? Thanks.
keith landa
purchase college suny