From: Michael G. <ga...@ma...> - 2005-07-14 16:39:52
|
Could we get a list of what states are needed for the student score? number -- means the student has achieved this score on this problem 0 -- means the student has tried this problem but hasn't gotten in correct null/ blank -- means that the student hasn't tried the problem. Are there are other states we need? Do we need the state that distinguishes between "hasn't tried the problem" and the one where the score is zero? I think perhaps we do, so that we can warn the student they haven't yet completed an assignment while not bugging them about problems that they haven't successfully completed. any other thoughts on what is needed? Take care, Mike On Jul 14, 2005, at 12:26 PM, John Jones wrote: > This sounds like it is my fault since I changed field types from all > being strings to being types related to what was being stored. What > you suggest is probably the best course of action. I wonder if all > instances of "" should be demoted to NULL, or if it should only be > done for fields with type integer. > > Another possibility would be to revert part of my change so that > integer types would not be used in the future which would avoid the > promotion problem for courses created after that. > > John |