Moodle plugins directory: Monitoring of learning plans | Moodle.org
Monitoring of learning plans
Gilles-Philippe Leblanc, Introduction
The main goal of this plugin is to facilitate the work of learning plan managers. It provides an overview of user learning plan, without leaving the page to get information related to this learning plan (such as rating in courses, user evidence, etc.) It also offers statistics by learning plans and competencies. For learning plan templates with a very large number of learning plans (generated from cohorts), this plugin is the best solution, with its advanced filters, it allows you to filter the learning plans by several criterias.
Plugin configuration
Role and permissions
This plugin can be used in system or category context. The user using this plugin in the category must have these permissions:
- moodle/competency:competencyview
- moodle/competency:coursecompetencyview
- moodle/competency:usercompetencyview
- moodle/competency:competencygrade
- moodle/competency:planview
- moodle/competency:planmanage
- moodle/competency:templateview
Note that planview is always set in user context level. Thus, we must assign a user to a cohort using Site administration/Users/Permissions/Assign user roles to cohort so he will have the "moodle/competency:planview" of every member of that
specific cohort (must wait for the next cron execution to take effect).
Color configuration
To fully benefit from the reports, a color must be associated to each value of the scale. To set the scale values colors, you must have "moodle/competency:competencymanage" permission. Here are the steps :
- Go on "Home / ► Site administration / ► Competencies / ► Competencies scale colors"
- Choose a framework competency
- Choose a scale from framework competency
- Set the colors values using the ColorPicker
- Save the changes
That's it, now the colors are set and ready to be used in the reports pages.
Monitoring of learning plans page
In a category context or system context go on Reports / ► Monitoring of learning plans
Filter
Filtering helps us find a user's learning plan. Here are the steps:
By learning plan template
From a learning plan template, we can filter learning plans.
- Select a template
- From "Student using this template", select a user
- click on "Apply"
You will see the learning plan of the student selected, and you can navigate between learning plan based on that template. If there is no student selected, the first student from the template will be displayed.
By clicking on "show more...", you can have more options to filter learning plans by scales values.
There are two options for using scales values filter
- Filtering learning plans by scale values from competencies rated at course level
- Filtering learning plans by scales values from competencies rated in the plan (Final rating)
When filtering by scales values, the number of rating in the student list will be displayed:
By user
We can choose a particular student by typing his name in the user picker field in order to retrieve his learning plans
Learning plan detail
The details of the learning plan is divided into three blocks:
1.User navigation
This block contain the following informations:
- The learning plan name: link to the learning plan page
- The user full name and a profile picture: link to the user profile page
- The navigation between users that belong to the selected template.
2.Learning plan competencies informations
This block displays the following informations:
- The plan's status and the number of competencies that are rated proficient on the total number of competencies of the plan
- The number competencies that are rated not proficient
- The number of competencies that are not rated
3.List competencies details
This part has three blocks
Total number of rating
It display the number of courses linked to the competency and wherein the user is enrolled. Clicking on the number will trigger a popup containing the list of courses linked to the competency and if the competency was rated in this course or not.
Also, this block displays the number of evidences of prior learning. You can have more details on the list of evidences by clicking on this number
Rating
This block displays the number of rated courses by scale value. Clicking on this number triggers a popup that displays the course name, comments left by the teacher and the final course grade.
Final rating
This block gives us details about the final rating (rating in learning plan) :
- If the competency is proficient, not proficient or not rated
- The rated scale value (if rated)
- A button to rate the competency if the user has the permission
Statistics for learning plans
This page provides statistics for learning plans. It groups statistics by competency for a given template. For each competency we display the total users in template and number of users by scale value. To get this page, go on Reports / ► Statistics for learning plans
Total users
Clicking on the "Total users" number triggers a popup with the list of all the users related to this competency. It shows if each user has been rated.
Number of users by scale value
It displays the number of users rated with a given scale value for the competency.
Monitoring of learning plans for users (students)
This page gives the user the ability to keep track of his learning plans with all the details mentioned above. To get this page go to the user profile page and click on Monitoring of learning plans in the reports block.
To display the report, the user must select a learning plan and click on "Apply"
New features for lpmonitoring v1.3
Allow tagging of learning plans
- Manages tags for learning plans
- Filter by tag
Manage comments directly in the report page
The block comment in the learning plan page (core) is now available in the report page, and we can filter by users having at least one comment.
User list navigation
A collapsible block was added, containing the resulting user list from search and filters, so we can easily navigate between users. That way, we are not limited to the next/previous buttons of the main learning plan bar.
Resetting competencies of a learning plan
We can reset all competencies of a learning plan: this will reset the value of rating but the evidences will be kept.
We can also make a reset on single competency.
Bulk rating in competencies for all users learning plans of learning plan template
This feature allows to rate competencies for all users learning plan of learning plan template.A scale value can be chosen for each competency. Note that rated students won't be impacted : to force ratings, tick "Force rating of users already rated" option. The ratings will take effect in the next passage of the CRON.
Report tab
It shows ratings in courses in a table display, that can be filtered by competency, course name or/and scale value.
New features for lpmonitoring v1.4
Summary tab
It shows ratings in courses in a summarized table display for scale values, where competencies are grouped by parent competency,
Useful links
Screenshots
Contributors
Thank you for you're quick response. By installing I see the next issues:
Stack trace:
line 492 of /lib/dml/moodle_database.php: ddl_change_structure_exception thrown
line 1072 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
line 77 of /lib/ddl/database_manager.php: call to mysqli_native_moodle_database->change_database_structure()
line 425 of /lib/ddl/database_manager.php: call to database_manager->execute_sql_arr()
line 370 of /lib/ddl/database_manager.php: call to database_manager->install_from_xmldb_structure()
line 606 of /lib/upgradelib.php: call to database_manager->install_from_xmldb_file()
line 1869 of /lib/upgradelib.php: call to upgrade_plugins()
line 694 of /admin/index.php: call to upgrade_noncore()
Debug info: Table 'mdl_report_competency_config' already exists
CREATE TABLE mdl_report_competency_config (
id BIGINT(10) NOT NULL auto_increment,
competencyframeworkid BIGINT(10) NOT NULL,
scaleid BIGINT(10) NOT NULL,
scaleconfiguration LONGTEXT COLLATE utf8mb4_general_ci,
timecreated BIGINT(10) NOT NULL,
timemodified BIGINT(10) NOT NULL,
usermodified BIGINT(10),
CONSTRAINT PRIMARY KEY (id)
, UNIQUE KEY mdl_repocompconf_comsca2_uix (competencyframeworkid, scaleid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_general_ci ROW_FORMAT=Compressed
COMMENT='Configuration for scale associated to a framework'
Error code: ddlexecuteerror
We need a separate block because our learning plans are created at the Site level. We do not create Learning plans at the category level. We have been asked to provide access and make it very simple for a new role that wishes to only view all of the learning plans in our system.
Kind Regards
Shirley
I understand your issue, here is what I would try :
- Configure a role at the system level and give it all the necessary permissions (the same as listed on top of this page). You might also have to create a cohort for all students who have learning plans and assign the planview permission.
- Then, create a simple html block and make it available only for the users that have your new role.
- In this block, add a simple html link to report/lpmonitoring/index.php?pagecontextid=1 (you can try directly this url before to make sure all permissions are correct).
I hope this help!
Marie-Eve
P.S. If you have more questions about this, since it is beyond the scope of the plugin, you can contact me in private, or we can start a topic in the forum, others might be able to help you more.
report_lpmonitoring
DDL sql execution error
More information about this error
×Debug info: Table 'mdl_report_competency_config' already exists
CREATE TABLE mdl_report_competency_config (
id BIGINT(10) NOT NULL auto_increment,
competencyframeworkid BIGINT(10) NOT NULL,
scaleid BIGINT(10) NOT NULL,
scaleconfiguration LONGTEXT COLLATE utf8mb4_unicode_ci,
timecreated BIGINT(10) NOT NULL,
timemodified BIGINT(10) NOT NULL,
usermodified BIGINT(10),
CONSTRAINT PRIMARY KEY (id)
, UNIQUE KEY mdl_repocompconf_comsca2_uix (competencyframeworkid, scaleid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='Configuration for scale associated to a framework'
Error code: ddlexecuteerror
×Stack trace:
line 492 of /lib/dml/moodle_database.php: ddl_change_structure_exception thrown
line 1070 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
line 77 of /lib/ddl/database_manager.php: call to mysqli_native_moodle_database->change_database_structure()
line 425 of /lib/ddl/database_manager.php: call to database_manager->execute_sql_arr()
line 370 of /lib/ddl/database_manager.php: call to database_manager->install_from_xmldb_structure()
line 606 of /lib/upgradelib.php: call to database_manager->install_from_xmldb_file()
line 1869 of /lib/upgradelib.php: call to upgrade_plugins()
line 694 of /admin/index.php: call to upgrade_noncore()
Thank you so very much! You provided me with what i needed to resolve my issue.
Kind Regards,
Shirley
I tried to reproduce the problem but I was not able to. Do you know from which version to which version of lpmonitoring you are upgrading?
In the meantime, you can try one of the following "extreme" solutions :
- uninstall and reinstall the plugin
- delete the mdl_report_competency_config table and then reinstall the plugin
Those 2 solutions would DELETE the configuration of your competency scales (the color associated to each scale level) so you will have to configurate them again. I can't say I recommend any of those two solutions, it is not really a good way to do things, but I think it will solve your problem...
Marie-Eve
We are testing this plugin in our institution to see if it suits our needs. For now long, it seems pretty good ! But there's a question that has popped-up in one of our revision meetings: is there any option to filter the reports by cohort? In the filter options it allows to filter by plan template, user, tag and scales, but not by cohort.
Any feedback will be appreciated.
Miguel.
Your plugin is so helpful to better view the students' learning plans. Do you have any plans to create another view that would display all students with a specified competency? I have many competencies that are in several learning plans, but we need to view who is still qualified to perform that task.
Kind Regards,
Shirley
No, there is no "cohort" filter. A workaround would be to create different learning plan templates for each cohort. More than one template could contain the same competencies for the same framework. The only problem is that it would be impossible to view all students from different cohorts at the same time. It would be perfect if you always want to filter by cohort though.
Another possibility is to add a tag on each student learning plan to identify the cohort. But you will have to do this manually, so maybe it is not practical.
Does one of these solutions suits your needs?
Marie-Eve
Unfortunately, I don't think that's possible, neither with the core functionnalities or with lpmonitoring. Everything is based on the learning plan templates.
I know there is something called "Advanced reports" or "Configurable reports" which is a way to have some reports from the result of SQL queries. It would probably be possible to create a report suiting your needs with that tool. I did not try it myself though.
I hope this helps,
Marie-Eve
Nice plugin. Very help.
Do you have update version for moodle 3.7 and 3.8 ?
Because we use 3.6 ourselves, we did not have the time to test it with 3.7 or 3.8. In a couple of months probably...
But, from the stats we can tell that many sites use the plugin with either 3.7 or 3.8 and nobody told us that it does not work. So I guess it should work correctly with those versions also.
Marie-Eve
Additionally, are there any future plans to have export options - to excel for straight data, or word or adobe to maintain the formatting?
Thanks again,
- Sarah