Itamar Tzadok

I don't have this module so I don't know what exactly the export xls contains. But suppose the data you export is columns A-K (Fig 3). In the xls template you leave these columns empty. Then you add to cell L2 the formula =J2-1 and to cell M2 the formula =K2-1 and copy these two cells down to 999 or whatever number that suits your needs (if you prefer the copying may be done in the xls instance rather than the template). Set the background of these cells to grey so as to mark them as calculated. Now you open a new instance of the template, then you copy from the downloaded questionnaire data columns A-K and paste them into columns A-K in the xls report. Columns L and M will display the shifted values. All that remains is to do the statistics on columns M and L rather than J and K (of course you can also implement the statistics in the xls template so that as soon as you paste the data you get the statistics). Hope this helps.

Why not? What's the fundamental difference between 0-10 and 1-11? After all, these are just numbers and what should matter is what qualities they capture, if they capture any.

If the results go to Excel (Fig 3) you should be able to use formulas to shift the numbers from 1-11 to 0-10 and adjust any corresponding calculations (until a real solution becomes available, that it). So if you have an Excel template with proper formulas you can copy the data from the exported Excel into the template.

I wonder if it should be courses rather than teachers that should be evaluated by students. But it may just be a terminological issue and in any case beside the point.

Perhaps the approach suggested in this post may work for you. The quiz may serve as the flag if you normalize it by round((||Quiz||/100)+0.49,0).

Problem with this "Clean Word HTML" control is that it also "cleans" some non-junk spaces. I think this unfortunate effect is reduced by toggling to HTML source and back before cleaning.