Details

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

      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.

        Issue Links

          Activity

          Hide
          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
          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
          Dan Poltawski added a comment -
          Show
          Dan Poltawski added a comment - I created this 'Standard' scale: http://clone.moodle.org/grade/edit/scale/edit.php?courseid=0&id=107
          Hide
          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
          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
          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
          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
          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
          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
          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
          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
          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
          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
          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
          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
          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
          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
          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
          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:

                Development