The values/order in the standard letter scale appear to be reversed (as in F=11, D=10, ...A+=1). I've searched in the tracker and the forums and don't see anyone else reporting this. And I can't find where I would reverse the order.
Any advice greatly appreciated.
Meg
To work around this scale you can define your own custom letter scale (with the correct order) and use it in your course. hth
It's Susan (I work at Cap and we met at the IT4BC event).
Sounds like someone with Admin capabilities created this scale? A "Teacher" does not have the capability to create a Standard scale - unless you guys modified your role.
From what I can see you can only delete a custom or standard scale if no one is using it so why don't you try doing some sort of db query to find out who is using it, or better yet, who might have created it (do you have many users with this capability??)
And then, get them to remove it from their activities and then you should be able to delete it.
Sounds a bit convoluted but can't think of anything else...
Hi Susan,
I just read your post about doing a db query on trying to find who uses a particular scale that we want to get rid of. Any suggestions on how to do that db query are much appreciated.
-Martha
The db queries I used in mysql on moodle 2.2+ follows:
1. find the id of the scale in the mdl_scale table:
mysql> select * from moodle.mdl_scale;
2. For example let's say the id of the scale is 10, in the forum activity it is referred to as -10. Why there is a negative sign I have no idea. So to list the specific courses and forum posts that use a scale:
mysql> select course,name,scale from moodle.mdl_forum where scale = -10;
+--------+--------------------------+-------+
| course | name | scale |
+--------+--------------------------+-------+
| 372 | Forum name | -10 |
+--------+--------------------------+-------+
1 row in set (0.05 sec)
3. In the moodle site as admin, I use the course id (372) in the end of my course site url to find the course. Find the "forum name" in that course and change the scale, so I can delete the used standard scale.
There may be a general SQL query to find all the activities using a particular scale, but I've not tried one yet.
Thanks for clarifying this for me.
Cheers
