iDoceo 8 for iPhone,iPad and Mac now available!

You will find all the details explained here
Welcome, Guest
Username: Password: Remember me

TOPIC: Comment generating

Comment generating 2 months 3 weeks ago #10443

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 months 3 weeks ago by craig.kerwin. Reason: change icon
The administrator has disabled public write access.

Comment generating 2 months 3 weeks ago #10444

  • bert
  • bert's Avatar
  • OFFLINE
  • Admin
  • Posts: 3485
  • Thank you received: 686
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.
Please take a moment to add or update your rating for iDoceo 7 teacher gradebook so that we can continue working on it. Thanks!
Here is the link
apps.apple.com/app/apple-store/id4771209...&action=write-review
The administrator has disabled public write access.
The following user(s) said Thank You: craig.kerwin

Comment generating 2 months 3 weeks ago #10446

  • bert
  • bert's Avatar
  • OFFLINE
  • Admin
  • Posts: 3485
  • Thank you received: 686
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.


Screenshot2022-04-13at09.04.25.png



Screenshot2022-04-13at09.03.51.png
Please take a moment to add or update your rating for iDoceo 7 teacher gradebook so that we can continue working on it. Thanks!
Here is the link
apps.apple.com/app/apple-store/id4771209...&action=write-review
The administrator has disabled public write access.
The following user(s) said Thank You: craig.kerwin

Comment generating 2 months 3 weeks ago #10447

  • bert
  • bert's Avatar
  • OFFLINE
  • Admin
  • Posts: 3485
  • Thank you received: 686
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

Screenshot2022-04-13at09.11.18.png


Screenshot2022-04-13at09.10.57.png


Screenshot2022-04-13at09.10.01.png
Please take a moment to add or update your rating for iDoceo 7 teacher gradebook so that we can continue working on it. Thanks!
Here is the link
apps.apple.com/app/apple-store/id4771209...&action=write-review
The administrator has disabled public write access.
The following user(s) said Thank You: craig.kerwin

Comment generating 2 months 3 weeks ago #10448

  • bert
  • bert's Avatar
  • OFFLINE
  • Admin
  • Posts: 3485
  • Thank you received: 686
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.

Screenshot2022-04-13at09.17.40.png




Screenshot2022-04-13at09.17.27.png


Screenshot2022-04-13at09.16.26.png
Please take a moment to add or update your rating for iDoceo 7 teacher gradebook so that we can continue working on it. Thanks!
Here is the link
apps.apple.com/app/apple-store/id4771209...&action=write-review
Last Edit: 2 months 3 weeks ago by bert.
The administrator has disabled public write access.
The following user(s) said Thank You: craig.kerwin
Time to create page: 0.100 seconds
21 AUG

iDoceo 7 for iPad and Mac now available!

A huge update with tons of new features and a new interface

Read more

6 JUN

Create Multiple-choice tests with iDoceo Connect!

In addition to self-evaluation rubrics, your students can now fill exams online. Supports text and images - in answers and questions - and can easily be imported from an XLS template

Read more

Cookies policy

This website uses cookies to make it easier for you to use the forum. We do not track you for any kind of advertising or statistics. Cookies are only used to keep you logged in the forum in case you would like to post and to keep your language selection in case you use the automatic translation offered by Google. If you continue to use our offer and have activated this technology in your browser, you consent to the use of cookies.