Details

    • Type: Sub-task
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Component/s: moodle.org
    • Labels:
      None

      Description

      The one-item useful scale is currently only available in 3 courses - Using Moodle, Moodle en Español and Moodle en français

      e.g. http://moodle.org/grade/edit/scale/edit.php?courseid=5&id=88

      It should available as a custom scale (editable, so that facilitators can translate it) in all courses.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

              Hide
              poltawski Dan Poltawski added a comment -

              mysql> begin;
              Query OK, 0 rows affected (0.00 sec)
              mysql> update scale set scale = 'Useful' where id = 107;
              Query OK, 1 row affected (0.00 sec)
              Rows matched: 1 Changed: 1 Warnings: 0
              mysql> commit;
              Query OK, 0 rows affected (0.01 sec)

              Show
              poltawski Dan Poltawski added a comment - mysql> begin; Query OK, 0 rows affected (0.00 sec) mysql> update scale set scale = 'Useful' where id = 107; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> commit; Query OK, 0 rows affected (0.01 sec)
              Hide
              poltawski Dan Poltawski added a comment -
              Show
              poltawski Dan Poltawski added a comment - I created this 'Standard' scale: http://clone.moodle.org/grade/edit/scale/edit.php?courseid=0&id=107
              Hide
              tsala Helen Foster added a comment -

              Just noting what I mentioned in a chat, that I plan to contact all course facilitators and ask whether they want to use a useful scale in their course, and if so, what word/phrase they want to use i.e. useful translated into their language. Thus it should be possible to create a one-item scale in any course. (Currently if you try to do so, an error message is displayed "Please enter a comma-separated list of values (at least two values required).")

              However, if it's too complicated having the useful scale as a custom scale, perhaps we could come up with a 'Like' icon (as in Facebook)?

              Show
              tsala Helen Foster added a comment - Just noting what I mentioned in a chat, that I plan to contact all course facilitators and ask whether they want to use a useful scale in their course, and if so, what word/phrase they want to use i.e. useful translated into their language. Thus it should be possible to create a one-item scale in any course. (Currently if you try to do so, an error message is displayed "Please enter a comma-separated list of values (at least two values required).") However, if it's too complicated having the useful scale as a custom scale, perhaps we could come up with a 'Like' icon (as in Facebook)?
              Hide
              poltawski Dan Poltawski added a comment -

              Well, I think there are 2 problems here:

              1/ How to create the various scales in the first place.

              • That requirement for at least two values makes it tricky for us to do it manually. Though, we can create the scale in moodle, then modify it to the single item scale in in the DB.
              • But is there a reason to enforce that restriction in Moodle? Should we modify that restriction in Moodle core, so other teachers can create single item scales like this?

              2/ How to identify the single item scales for processing the 'helpful posts'. We only want to look for posts which are rated using this single item scale.

              For 1/ we can have lots of scales, but for 2/ it makes it easier to have only a single global scale across the site.

              Show
              poltawski Dan Poltawski added a comment - Well, I think there are 2 problems here: 1/ How to create the various scales in the first place. That requirement for at least two values makes it tricky for us to do it manually. Though, we can create the scale in moodle, then modify it to the single item scale in in the DB. But is there a reason to enforce that restriction in Moodle? Should we modify that restriction in Moodle core, so other teachers can create single item scales like this? 2/ How to identify the single item scales for processing the 'helpful posts'. We only want to look for posts which are rated using this single item scale. For 1/ we can have lots of scales, but for 2/ it makes it easier to have only a single global scale across the site.
              Hide
              tsala Helen Foster added a comment -

              Just noting a few things from chatting with Dan:

              • Although it makes it a lot more complicated, I think we have to allow for the word 'useful' to be translated
              • Useful ratings and PHM group calculations were offered to all course facilitators previously (in http://moodle.org/mod/forum/discuss.php?d=132809 ) but only French and Spanish wanted them
              • We'll again offer useful ratings etc to course facilitators (and explain about useful posts being displayed on the front page), but we'll not expect every course to make use of the scale
              • We'll need to lookup if a course has a useful scale and use it, otherwise possibly just display recent posts
              • I will contact course facilitators to ask for translations of 'useful' and the scale description then add them to courses using a 2-item scale, which Dan will then edit and remove the extra scale item
              Show
              tsala Helen Foster added a comment - Just noting a few things from chatting with Dan: Although it makes it a lot more complicated, I think we have to allow for the word 'useful' to be translated Useful ratings and PHM group calculations were offered to all course facilitators previously (in http://moodle.org/mod/forum/discuss.php?d=132809 ) but only French and Spanish wanted them We'll again offer useful ratings etc to course facilitators (and explain about useful posts being displayed on the front page), but we'll not expect every course to make use of the scale We'll need to lookup if a course has a useful scale and use it, otherwise possibly just display recent posts I will contact course facilitators to ask for translations of 'useful' and the scale description then add them to courses using a 2-item scale, which Dan will then edit and remove the extra scale item
              Hide
              tsala Helen Foster added a comment -

              Thinking about the easiest way of adding a useful scale to every course on moodle.org, how about if I add a 2-item scale to every course, using google translate to translate the word 'Useful' into the appropriate language. The not-needed scale items can then be deleted in the database.

              I can then announce to course facilitators that we have set up a useful scale in every course which they can enable for forums in their courses, and to let me know if I have got the translation of 'Useful' wrong for their language. (I'm hoping for a high success rate from good old google translate, and thinking it will be easier to fix a few wrong translations than wait for every course facilitator to respond to a request to translate a single word.)

              Also do we really need a description for the 'Useful' scale, as used in the awfully broken rating help popup (see MDL-36387), or can we just remove that help popup on moodle.org? (I'm thinking that rating a post as useful is similar to voting for a tracker issue or liking something on facebook i.e. so obvious that a help popup is not necessary.)

              Show
              tsala Helen Foster added a comment - Thinking about the easiest way of adding a useful scale to every course on moodle.org, how about if I add a 2-item scale to every course, using google translate to translate the word 'Useful' into the appropriate language. The not-needed scale items can then be deleted in the database. I can then announce to course facilitators that we have set up a useful scale in every course which they can enable for forums in their courses, and to let me know if I have got the translation of 'Useful' wrong for their language. (I'm hoping for a high success rate from good old google translate, and thinking it will be easier to fix a few wrong translations than wait for every course facilitator to respond to a request to translate a single word.) Also do we really need a description for the 'Useful' scale, as used in the awfully broken rating help popup (see MDL-36387 ), or can we just remove that help popup on moodle.org? (I'm thinking that rating a post as useful is similar to voting for a tracker issue or liking something on facebook i.e. so obvious that a help popup is not necessary.)
              Hide
              poltawski Dan Poltawski added a comment -

              how about if I add a 2-item scale to every course, using google translate to translate the word 'Useful' into the appropriate language. The not-needed scale items can then be deleted in the database.

              Sounds perfect.

              Also do we really need a description for the 'Useful' scale, as used in the awfully broken rating help popup (see MDL-36387), or can we just remove that help popup on moodle.org?

              I don't think we need it, but I don't know how easy it is to remove..

              Show
              poltawski Dan Poltawski added a comment - how about if I add a 2-item scale to every course, using google translate to translate the word 'Useful' into the appropriate language. The not-needed scale items can then be deleted in the database. Sounds perfect. Also do we really need a description for the 'Useful' scale, as used in the awfully broken rating help popup (see MDL-36387 ), or can we just remove that help popup on moodle.org? I don't think we need it, but I don't know how easy it is to remove..
              Hide
              tsala Helen Foster added a comment -

              Every course on moodle.org now has a 2-item useful scale, so the not-needed scale item can be deleted in the database.

              All the courses in English could make use of a standard useful scale, rather than custom ones, but I couldn't change the useful scale in Using Moodle from custom to standard in the UI, so I just created custom useful scales in all the courses in https://moodle.org/course/category.php?id=1. (Just noting this in case you want to change it in the database, Dan.)

              I left the scale descriptions blank for course facilitators to add their own descriptions if they wish (if we can't get rid of the rating help popup).

              Show
              tsala Helen Foster added a comment - Every course on moodle.org now has a 2-item useful scale, so the not-needed scale item can be deleted in the database. All the courses in English could make use of a standard useful scale, rather than custom ones, but I couldn't change the useful scale in Using Moodle from custom to standard in the UI, so I just created custom useful scales in all the courses in https://moodle.org/course/category.php?id=1 . (Just noting this in case you want to change it in the database, Dan.) I left the scale descriptions blank for course facilitators to add their own descriptions if they wish (if we can't get rid of the rating help popup).
              Hide
              poltawski Dan Poltawski added a comment -

              Hi Helen,

              I've converted them all to one item scales now.

              courseid name scale
              48 Useful Useful
              31 Useful Useful
              43 полезен полезен
              18 Nützlich Nützlich
              17219 מועיל מועיל
              40 Berguna Berguna
              14 便利 便利
              39 Útil Útil
              35 Útil Útil
              24 Útil Útil
              23 Utile Utile
              36 มีประโยชน์ มีประโยชน์
              13 Nuttig Nuttig
              54 Nyttig Nyttig
              22 Użyteczny Użyteczny
              25 полезный полезный
              53 користан користан
              26 Användbar Användbar
              17 yararlı yararlı
              45 hữu ích hữu ích
              16 مفيد مفيد
              1008 مفید مفید
              27 有用 有用
              21 쓸모있는 쓸모있는
              17220 Useful Useful
              42 Erabilgarri Erabilgarri

              The sql for me to remember:

              SELECT * FROM scale WHERE scale LIKE '%,-';
              BEGIN;
              UPDATE scale SET scale = REPLACE(scale, ',-', '') WHERE scale like '%,-';

              Show
              poltawski Dan Poltawski added a comment - Hi Helen, I've converted them all to one item scales now. courseid name scale 48 Useful Useful 31 Useful Useful 43 полезен полезен 18 Nützlich Nützlich 17219 מועיל מועיל 40 Berguna Berguna 14 便利 便利 39 Útil Útil 35 Útil Útil 24 Útil Útil 23 Utile Utile 36 มีประโยชน์ มีประโยชน์ 13 Nuttig Nuttig 54 Nyttig Nyttig 22 Użyteczny Użyteczny 25 полезный полезный 53 користан користан 26 Användbar Användbar 17 yararlı yararlı 45 hữu ích hữu ích 16 مفيد مفيد 1008 مفید مفید 27 有用 有用 21 쓸모있는 쓸모있는 17220 Useful Useful 42 Erabilgarri Erabilgarri The sql for me to remember: SELECT * FROM scale WHERE scale LIKE '%,-'; BEGIN; UPDATE scale SET scale = REPLACE(scale, ',-', '') WHERE scale like '%,-';
              Hide
              poltawski Dan Poltawski added a comment -

              I've converted the useful scale in using moodle to a site wide scale too, so closing this now.

              Show
              poltawski Dan Poltawski added a comment - I've converted the useful scale in using moodle to a site wide scale too, so closing this now.

                People

                • Votes:
                  0 Vote for this issue
                  Watchers:
                  4 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: