Comment generating

More
2 years 5 months ago - 2 years 5 months ago #10443 by craig.kerwin
Comment generating was created by craig.kerwin
Is it possible to have a column that generates a text comment based on the result in another column?

For example, a result column might feature either a manual result or a calculated result ... based on that result the comment column generates the appropriate column ...

- if 5 in column X, then Comment Column is "Great job"
- if 4 in column X, then Comment Column is "Keep going"
etc

I can do it in Excel using an IF formula but hadn't yet tried in iDoceo.

I actually want to use it with a Rubric - while I get rubrics already have text which is based on the level for each part of the rubric, sometimes the language of the rubric is intimidating for a younger student - so ultimately I want to build a comment based on the numerical values of the rubric using language that is more child friendly but also a single comment.

This might be out of iDoceo's capacity.
Last edit: 2 years 5 months ago by craig.kerwin. Reason: change icon
More
2 years 5 months ago #10444 by bert
Replied by bert on topic Comment generating
Hi Craig,
You can do it in many ways in iDoceo.
Choosing one or the other depends on the number of times you plan on doing this and in the number of variations you will use (i.e. the texts will always be the same).
I'll add a post for each with a brief introduction so you can choose.
The following user(s) said Thank You: craig.kerwin
More
2 years 5 months ago #10446 by bert
Replied by bert on topic Comment generating
I'll start with a formula which may be the method you are most familiar with.
It consists of a list of conditions and then the text you plan on showing if the condition matches.

This method is only recommended if you need very few texts since the formula easily gets out of hand and is impossible to maintain on multiple columns. The next solutions are far more elegant, easier to configure (and better than Excel :) ). Please check them out.[/i]

Our target formula is called 'Test'
Add column > Calculation > Formula.





Attachments:
The following user(s) said Thank You: craig.kerwin
More
2 years 5 months ago #10447 by bert
Replied by bert on topic Comment generating
The following methods are variations on the same.
These are all valid methods and will let you convert any column into texts and even perform calculations/average between text results.

The first step, define your texts in a text based grade type: Menu > Grade types > Add > Text
If your texts will usually be the same and will be shown under the same conditions, pay attention to the percentages you assign here.
This is a one time only configuration and will work with any column (hence the use of percentages)
As a bonus, you can assign colors.
We will call this grade type "Score to Our texts"

To use this grade type: Add column > Calculation > Weighted average > Tap on the column you'd like to take into account (Test in our example) and then in the column's properties select 'Score to Our texts' as the result's grade type





Attachments:
The following user(s) said Thank You: craig.kerwin
More
2 years 5 months ago - 2 years 5 months ago #10448 by bert
Replied by bert on topic Comment generating
Our next method works with what we call a 'Conversion'
It needs the 'Score to Our texts' grade type we've used before but you can then assign the resulting text with more finesse.

Menu > Grade type > Add > Conversion > Input score (the score you want to work with, in our example 0-100) and the result grade type "Score to our texts"
This method will let you change the scores at which the text will be shown (despite the percentages assigne previously) but will only work with the selected input score.
The bonus of this method is that the text will be shown on the very same cell. No additional columns required and works with colors as well.

To work with this conversion (we call it 0-100 to text) double tap on the sample column's header > Grade type > and select our conversion.







Attachments:
Last edit: 2 years 5 months ago by bert.
The following user(s) said Thank You: craig.kerwin