Moodle course completion table. If nothing is happening please use the continue link below.
Moodle course completion table The Course completion report will display a table showing all students down the left hand-side and all selected course completion criteria along the top. . Here is some SQL to get you going. SCORM packages may also be added by selecting the Single activity course format when setting up a course, and then uploading or dragging/dropping the package. CreateLog in to Jira to see this work item Sep 3, 2024 · The activity completion shows what activities each student has completed, based on the completion conditions that have been set for the activity. Nov 10, 2020 · The course completion report is especially useful to assess your students’ participation in your courses. Teachers can mark activities complete on behalf of students by clicking into the relevant completion boxes. Click Save changes. Role Reset Custom reports The Custom reports feature enables you to create and share custom reports. Apr 25, 2012 · Moodle Database Tables How are Moodle tables constructed? One of the most important components of Moodle is its database. If you unlock course completion, please keep in mind that completion dates will be changed. The criteria can include meeting an activity's grade level or a manual checking "complete" by either the student and/or teacher. Under the currently enrolment methods, Choose Add method > Course completed Enrolment. Ordering can be Aug 18, 2025 · Introduction Like a Moodle course, each SCORM package will vary with the modules used in its construction by the teacher and by the SCORM activity settings established by the teacher. Any person with teacher (editing) access can set up the course completion options. Please refer to Student activity completion for details. Aside from the user interface makeover, Workplace 4 features custom reports that enable users to create advanced reports with a responsive layout effortlessly. I have tried to search to see if it was already answered, but if it has been I was searching on the wrong keywords. php. The report is a list of all the enrolled users with course completion status. Course completion can be used in many ways. It is displayed as a link on course lists on the Front page and on the Dashboard and in reports. 2. If nothing is happening please use the continue link below. The table data shows a series of check-boxes; ticked if the criterion has been met, unticked if not. Short name Many institutions have a shorthand way of referring to a course Nov 10, 2020 · The course completion report is especially useful to assess your students’ participation in your courses. Jan 21, 2021 · Moodle itself also comes with completion tracking functionality, but that functionality provides the bare minimum details regarding the completion of your courses. The Course Completions Data Source is located in the Public folder in the Zoola™ Repository. but i found mdl_course_modules_completion table would be used. It visually shows what activities/resources a student is supposed to interact with in a course. 1 Manually rating course competencies 4 Activity competencies 4. Apr 20, 2012 · See how progress can be set and/or tracked using the new Conditional activities, Activity completion and Course completion. 1. This data can be reported on by using the Report builder report source "Course completion from datastore". For the course The report_modulecompletion plugin is an essential tool for Moodle users who want to monitor the progress of their students. May 25, 2022 · a context is a scope in Moodle, for example the whole system, a course, a particular activity. 11 to be incorporated to this page. Short name Many institutions have a shorthand way of referring to a course Description Course completion is set for tracking, gradebook looks only at this specific scorm activity and completion requirement is based on this scorm acitivy results. A restrict access section will then appear for teachers on the Activity settings screen, with an 'Add restriction' button. Teacher view of Course completion status block This block shows the status for each student. Why It Matters Course completion tracking in Moodle helps organisations create For example core_user_get_users_by_id is listed in the table, but the online documentation says "DEPRECATED: this deprecated function will be removed in a future version. edu, by calling 405-682-7574, or by stopping by the Center For Learning and Teaching (SEM 2G3, across from the Math Lab) 8-5, Monday through Friday. About This format was created by Davo Smith of Synergy Learning, on behalf of Landesmedienzentrum Baden-Württemberg. The links below the image will provide more information about creating, organising and managing courses. Objective / Added value: When your Moodle courses include videos as a pedagogical activity, it makes sense to be sure students watch a significant part of the whole video duration. 9. 5 days ago · Courses are the spaces on Moodle where teachers add learning materials and activities for their students. At the course level, Completion tracking must then be enabled for each course, in Course navigation > Settings> Enable completion tracking and then Course completion should be enabled from Apr 3, 2023 · Note: The course completion report is different from the Activity completion report. Expect a soapbox on this in the Open edX section. course_completion_crit_compl table relationships Close relationships within degrees of separation One Two degrees One implied Two implied Feb 27, 2024 · The way the current recompletion task works is to look at the course_completions table and (based on the recompletion interval) send recompletion notifications to users. When doing a course reset where activity completion and course completion are enabled, reset erase attempts and completion data for activities except for SCORM. You can't complete the course completion options until all the required activities and resources are added to the Moodle course with activity completion activated. The feature is based on the Moodle Workplace™ feature Report builder. This article aims to describe the tables of the database. If you need to manually complete an activity, you should do this from the Activity completion report. How to do that? What happens when you delete a user from Moodle-Samis? Mar 3, 2023 · 1 The activity completion is in a table called mdl_course_modules_completion This SQL narrows the completion down to scorm activities Also a check to see if a user is enrolled in any way - note that a user can be enrolled more than once on a course May 9, 2018 · Learn how to streamline performance tracking and analyze learning trends on Moodle LMS. Learners/students must meet the course completion requirements. These are used only in some situations. 'Complete another course' isn't performing enough sanity checks, resulting in broken database records and an inability to view the completion report. Any admin user with good SQL knowledge can dive in to Moodle Database to extract different reports out of Moodle database. Feb 8, 2019 · If you set completion rules for each activity/module, but not for the overall course, and then a student completes all the modules successfully, you can end up with data in your course_modules_completions table but no data in your course_completions table. It is colour-coded so students can quickly see what they have and have not completed/viewed. This section applies to all activities and Jul 23, 2013 · Having investigated the database schema I can get the information via SQL and aggregating the mdl_module_course_completion data, still a course can be marked as completed in Moodle with a failure grade in one of the quizzes. How do I enable course completion in Moodle? Use Site administration > Advanced features > Enable completion tracking (check enabled) in order to allow completion tracking on your site. This plugin adds course level settings for recompletion - clearing all course and activity completion for a user based on the duration set notifying the student they need to return to the course and recomplete it. Completion states and conditions Completion state is stored per-user for every activity. May 3, 2024 · Summary A course module (often abbreviated 'cm') represents each of the activities and resources found in a course. course_completion_criteria table columns Showing 1 to 10 of 10 entries Table contained -1 rows Apr 3, 2023 · If you need to manually complete an activity, you should do this from the Activity completion report. 4, lets students see their progress through their Moodle course through the use of checkboxes on th Completion states and conditions Completion state is stored per-user for every activity. If you have questions please contact Moodle Support by email at online@occc. 1. The names in CAPITALS are the PHP constants, found in /lib/completionlib. i can get activities completion form Jul 27, 2023 · How do I enable course completion? At the site level, Completion tracking must be enabled in Site administration > Advanced features > Enable completion tracking for it to be available for use in courses. Main point is to be sure student has Jul 4, 2012 · This course format, based on the 'Topics' standard format, allows a teacher to specify the foreground and background colours for each course section. Course completion tracking is a particularly valuable feature that helps ensure learners stay on track and achieve their goals. Extended activity completion support In one Sentence: Require the student to watch the video for a certain duration and/or until a certain point to complete the activity. Responsive Display and Troubleshooting Due to Moodle's use of iframes, some SCORM packages may not display well on smaller screens, resulting in horizontal scrollbars or cut-off content. The criterion might be viewing, receiving a certain score or a student marking it as complete. Parameters Dec 13, 2024 · Moodle, one of the world’s most popular open source learning management systems, offers a range of tools to help educators and administrators manage and monitor learner progress. Moodle 3. Teachers can then add the content and re-organise them according to their own needs. It contains information about which course and section the activity / resource is displayed on, as well as details about the visibility, group and completion status of the activity. Feb 28, 2023 · iam fresher to moodle so i have no idea. I will investigate each table, and comment on the contents. Dec 5, 2022 · Moodle Administrators are often tasked to get different reports out of Moodle. Hi, User has been deleted through Moodle after course completion but in Database user info still exist in table: mdl_user as deleted=1. The users don't appear enrolled in the course, neither the grades are kept, only the completion data. Mar 4, 2022 · Dear Moodle Experts, On the ad-hoc contributed reports page - this lovely report exist - Enrolment count in each Course Shows the total number of enroled users of all roles in each course. - Categories reports, with information regarding categories. Courses and programs to develop your skills as a Moodle educator, administrator, designer or developer. The block relies on completion settings of activities/resources in the course and when they should be completed by. With editing turned on, add the course completion block to the Moodle course homepage, so students (and their tutors) can see their progress. Nov 22, 2017 · The course completion overview report is a simple reporting tool based on the existing course completion report. Mar 20, 2025 · You can set a new Course Start Date for the freshly reset course, delete all Calendar events, comments, course AND activity completion data and user notes attached to the course. It doesn't take into accoun course_completion_aggr_methd table relationships Close relationships within degrees of separation Apr 25, 2025 · Unlock Moodle's hidden features & essential plugins! Boost engagement, improve course management, & optimize your eLearning platform. Nov 21, 2022 · Enabling course completion If not already enabled, an administrator should enable activity completion for the site by ticking the 'Enable completion tracking' checkbox in Administration > Site administration > Advanced features if it is not already enabled. The user with the role allowed to manually complete the course on behalf of Entries in the course_completion_items, course_completion_aggregation_methods, and course_completion_notify tables for the course should also be included in the backup. The main lib. This function is called when activity completion status is updated for single user. Visual representation of activities to be completed Colour-coded for quick reference Overview for teachers, identify students at risk Combined progress on Dashboard page The block shows activities with activity completion settings. Snapshots are expected to be an exact snapshot of the database table at the instance when the event was triggered. The course completion overview report is a simple reporting tool based on the existing course completion report. If manual self completion or manual completion by others is enabled, then those columns will appear in the course completion report. If more than one access restriction is set for an activity, students see a Show more/less dropdown. php files are only lightly modified from those found within the standard format_topics, the rest is This block is a Moodle custom reports builder. A basic setup To setup course completion enrolment, navigate to the course page: Navigate to the to the More drop down menu from the Course Navigation tabs and select Course completion from the drop down menu options. Here are the rules: Grade visible Features The Completion Progress is a time-management tool for students. While course completion will not lock a student out of another course, it will allow a teacher to see if a student has completed the recommended prerequisite courses. A video explaining this is also available at the bottom of the screen Course completion allows students and teachers to track progress through required elements. Jul 13, 2025 · Aggregate courses completions. Also when regular completion task runs it aggregates completions for all courses and users. 1 when compared to Moodle 3. Note: The course completion status block will only appear if completion tracking is enabled in the course and then criteria set for course completion. php and formats. Aug 26, 2020 · When activities are completed that are part of course completion criteria, Moodle and Totara both update a timecompleted field in the course_completion_criteria_compl table. Nov 4, 2015 · After I completely delete some user, the data for course completions of the user is still in the table mdl_course_completions. Apr 21, 2024 · In Moodle, course completion is defined by specific criteria set by the course administrators, which may include completing all required activities, achieving a minimum score on quizzes, or participating in forums. How do I assign a course to a user in Moodle? Method 1Go to Settings Aug 10, 2024 · Simplify course delivery with Moodle LTI Integration. 1 build 20120213: Set up in a site with completion and conditional subsystems enabled, create a course and enable completion This allows a user to manually mark activities as complete when using Activity completion This capability is allowed for the default authenticated user role This page should automatically redirect. FREE Download - Top 10 Admin Tasks that you must know for Moodle Administrators One of the clever Jan 9, 2018 · Would you like to enable your students to track their progress and manage their time for the courses they are enrolled in? Good news! Activity completion or completion tracking, available in Moodle 3. The Completion Progress block is a time-management tool for students. It is defined as a time-management tool for students. A student can see a summary of their progress through the course completion status block on the course. Main point is to be sure student has Using the activity completion settings is a great way to keep track of your progress in the course. The same settings apply. This plugin allows the Moodle Admin and system level Managers to view course completion tracking information from a centralised location rather than having to access each course individually. That is the correct table for activity completion - mdl_course_modules_completion. Activity Reports Course Mar 15, 2022 · When designing a course site for students, whether online or in person, have you ever wondered what resources on Moodle your students were utilizing? In this article, I would like to describe two Moodle features I use together to keep track of my student participation (Activity Completion) and to create a roadmap through the course for them (Restrict Access). Jul 3, 2019 · Not getting values in 'timestarted' and 'timecompleted' of mdl_course_completion table while completing a course Mar 15, 2024 · In conclusion, identifying the completion state data and ensuring proper relationships between the tables are crucial for integrating learning analytics in Power BI with the Moodle database schema. Web service functions Naming convention All functions should be named as {fullcomponent}_ {methodname} - example: core_user_get_user_preferences where {fullcomponent} is the full frankenstyle name or the component such as core_user here {methodname} is the name of the method in the form of {verb}_ {noun} such as get_user_preferences here {verb} - preferably one of get, create, delete, update The course completion overview report is a simple reporting tool based on the existing course completion report. Sep 16, 2024 · If you have an activity at the end of the course that all users must do regardless of whether they did the original SCORM activity or the new SCORM activity, this culminating activity can be the ideal activity to use for course completion settings. This plugin is designed to track the progression of students in all of their courses for a given period. Is there a way to set up a course as completed only when all grade items are passed, with grade items accessed in any order? Dec 4, 2018 · Hello All, Currently using Moodle 3. You can set Completion tracking as On or Off in new courses as a course default in Site administration > Courses > Course default settings. Custom reports The Custom reports feature enables you to create and share custom reports. There is another option in the local_recompletion plugin configuration, that we can select to archive the course_completion_defaults table relationships Close relationships within degrees of separation One Two degrees One implied Two implied The Course completion report will display a table showing all students down the left hand-side and all selected course completion criteria along the top. Mobile notifications require a Moodle app subscription. An example of what you might see in the activity completion report. Oct 1, 2025 · New features list Manage your site Add users Add courses Change the look and feel Install plugins More for administrators Moodle app View app features Keep up-to-date with notifications Create mobile-friendly courses Add more app features More about the Moodle app From Moodle: "Course completion shows if a course has been completed. The capability moodle/course:changefullname controls whether a user can edit the course full name. Nov 11, 2019 · I am using a Moodle ad-hoc query to fetch the report data I want to generate a completion report. Nov 13, 2025 · After completion of a course, the student is automatically enrolled in one or more other courses. Note that course logs are not deleted (See MDL-43274) NOTE: If you set a new course start date, then all course dates will be shifted by the same amount. In this post, we will see how you can setup the Completion Progress block and use it in your Moodle course. There are four states: Not completed [default – not stored in database] Completed (pass/fail unspecified) Completed, passed Completed, failed The final two states only apply when completion is based on a specific grade result. 5 days ago · By default, web and email are both enabled, although email will only work of course if the site has been properly configured to deliver email. According to negotiation, we have to delete users and user info completely from everywhere after complete their course. Sep 26, 2025 · This articles explains how instructors can export or save course data and content to process, organize or store outside of Moodle. Choose the enrolment duration or start date and end date for the enrolment. Jan 23, 2016 · Settings→Course administration→Edit settings Completion tracking → 'Disabled, not shown in activity settings' Database (DB): table 'mdl_course' field 'enablecompletion' is 0 This page explores in more detail the settings for the SCORM activity once you have added it to your course and also covers the Site administration settings. Keep an eye on the course and generate a range of learning and activity reports. For details, see Moodle app notifications. You can create custom reports without SQL knowledge. The built-in record snapshot support in events allows developers to attach more auxiliary information when triggering events, it may be for example course record, some record that was just deleted, etc. The completion requirements display progressively depending on what the teacher selects and what the Sep 22, 2022 · There are changes to the completion API introduced in Moodle 3. course_completion_aggr_methd table relationships Close relationships within degrees of separation Jan 8, 2024 · This blog post aims to assist users to better understand the new improvements made to the activity completion settings for SCORM packages in Moodle 4. Dec 15, 2015 · Entries in the course_completion_items, course_completion_aggregation_methods, and course_completion_notify tables for the course should also be included in the backup. Regardless of where or how a learner completes a module or test, their performance data is always up to date and readily accessible for trainers, educators, or the learners Feb 28, 2025 · It is common to use a SCORM package developed by a 3rd party, these instructions show how to determine the best settings for accurate completion tracking. Description Stores the completion state (completed or not completed, etc) of each user on each activity. By clicking on 'more details' the student can get more detail about the activities that need to be completed and what they have Course Completion: Can not find data record in database table course What is data synchronization? Data synchronization ensures that all data related to users, course content and course access, course completion, and achievements is consistent across multiple platforms and devices. However, after 5 years the certificates must be invalid, so I'm using the local_recompletion plugin to reset the course and delete the certificates. Continue Jul 27, 2023 · Under Condition: Manual completion by others: select Tutor and Course Administrator to enable staff to mark activities as complete on behalf of a student. Completion seems to be a little different due to being a "course" item, so look in these five tables course_completions table columns Related columns Constraint Showing 1 to 7 of 7 entries Table contained -1 rows Dec 12, 2024 · Activity completion allows the teacher to set completion criteria in a specific activity's settings. It can show the progress a student is making towards finishing the course according to specific criteria. The best way to prevent Moodle’s completion system addresses something that is very wrong with completion in Open edX - we have no way to support manual completion, no way for staff to mark things complete for learners, no custom completion conditions, and no concept of course completion besides certificates. Nov 30, 2017 · Restricting Access based on activity completion: Restrict access to course activities is another feature in Moodle which enables the teachers to restrict the availability of any activity or even a complete course section, according to certain conditions such as dates, grade obtained, group or activity completion. Entries in the course_completion_items, course_completion_aggregation_methods, and course_completion_notify tables for the course should also be included in the backup. Sorted by course name. Description Course completion is set for tracking, gradebook looks only at this specific scorm activity and completion requirement is based on this scorm acitivy results. Aug 9, 2022 · I already set my cron (scheduled every minute) activity completion ( i only have one activity on my course ) and course completion settings but my course completion table is still not updating! I just want to see the learners on course_completion table so I can know if they are in progress, not yet started or completed . any suggestions why? I want to get course completion states in a moodle i enable the completion for site and for course and activities and set conditions to it. Jul 25, 2025 · Description Table of contents A number of Course reports are available to the teacher in their course to help them track the progress of their students. When our students look at the Moodle Dashboard, it currently shows the percentage completed of a course. Feb 3, 2023 · Completion Progress Block is one of the most popular Moodle plugins in the official plugins directory. For SCORM, only attempts are deleted while activity completion data is kept. The criteria can include meeting an activity's grade level or manually checking 'complete' by either the student and/or teacher. If not already enabled in their course, a teacher can then enable activity completion (completion tracking) for their course from Course course table relationships Close relationships within degrees of separation Two degrees One implied Two implied Jun 28, 2022 · Typically, the Moodle database tables are listed in alphabetical order when viewed with programs such as phpMyAdmin. Oct 20, 2025 · General Course full name This is the name of the course. " 1 What are competencies? 2 How is it set up? 3 Course competencies 3. 5 and I have a question. Read this guide and improve teaching efficiency and learning outcomes! Oct 13, 2017 · Use Moodle reports to access powerful tool that tell you how your learners are progressing in your course. Activity Completion Every year I Jul 31, 2024 · Accessed from the main site navigation at the top of the screen, the My courses page displays a course overview of courses a user is enrolled in. Course completion If the current user has the 'tool/datastore:uploadcoursecompletion' capability, they can upload course completion data to be stored in the Data store for users who belong to the same tenant as themselves. It is important to remember that this feature is only a reporting feature. Courses may be created by admins, course creators or managers. A courses report can be embedded in this type of report. Jul 9, 2024 · I have a moodle platform that needs to issue certificates using customcert plugin. What type of reports can I create? - Courses reports, with information regarding courses. SMS and mobile notifications are off by default and need to be configured first. Here are the rules: Grade visible The Course Completions Data Source is a curated selection of LMS data that enables you to create Reports on who has or has not completed courses. 1 Example of Activity completion with Activity competencies 5 Backing up and restoring competencies 6 Statistics 7 See also 10 FREE HTML codes to help you display your content responsively in Moodle using Bootstrap. 1 What is SCORM? 2 Should I make my Moodle courses as SCORM or use Moodle's features? 3 SCORM Information 4 SCORM Package Contents 5 AICC Package Contents 6 Basic Troubleshooting 7 Does Moodle Generate SCORM Content? 8 Can I add a password for access to my SCORM package? 9 Supported Versions 10 Asking for Help in the SCORM Forum 11 Debugging 12 What does the debugging log mean? 13 SCORM The course completion overview report is a simple reporting tool based on the existing course completion report. Aug 18, 2025 · Enabling the use of restrict access sitewide To use the restrict access feature, it must be enabled by an administrator by checking the "Enable restricted access" box in Administration > Site administration > Advanced features. To locate the Data Source in Jun 23, 2025 · An administrator or manager (or other user with the capability moodle/my:configsyspages) can set the default blocks for all users from Administration > Site administration > Appearance > Default Dashboard page. Database tables The data for the course module is stored in the database table 'mdl_course_modules Activity settings Depending on the type of activity, there are different completion requirements. The best way to prevent Jul 27, 2023 · Under Condition: Manual completion by others: select Tutor and Course Administrator to enable staff to mark activities as complete on behalf of a student. The plugin is particularly useful for teachers and other educators who need to keep track of student progress and identify areas where students may be struggling. It is also used in the browser title bar when the course is viewed. . But it is also possible to give a user another role in the same course when he/she completes the course. Mar 22, 2023 · Moodle Workplace 4 features a freshly redesigned interface, specifically made to be simple and intuitive. Aug 1, 2023 · Uploading historical course completion data can be particularly helpful when certification and/or recertification is being used in Moodle Workplace. It's a tool suitable for admins or teachers. To reproduce in Moodle 2. A good reporting plugin helps you keep a tab on courses as your learners complete them so that you know which courses they will be working on next. While many of our professors are using activity completion within their courses, rarely does it seem to add up to The restrict access feature enables teachers to restrict the availability of any activity or even a course section according to certain conditions such as dates, grade obtained, group or activity completion. As long as a student gets above passing grade in this scorm activity, course is marked as completed and a certificate is issued. - Users reports, with information regarding 1 What is SCORM? 2 Should I make my Moodle courses as SCORM or use Moodle's features? 3 SCORM Information 4 SCORM Package Contents 5 AICC Package Contents 6 Basic Troubleshooting 7 Does Moodle Generate SCORM Content? 8 Can I add a password for access to my SCORM package? 9 Supported Versions 10 Asking for Help in the SCORM Forum 11 Debugging 12 What does the debugging log mean? 13 SCORM The course completion overview report is a simple reporting tool based on the existing course completion report. Learn how to use a variety of grading and other evaluation tools like Scales, Outcomes. Oct 2, 2025 · Activity completion info can be viewed by managers, teachers and non-editing teachers (and any other users with the capability report/progress:view) from Course navigation > More and selecting Reports > Activity completion. In addition to the Activity and Course Completion reports mentioned in a previous book, there are also Activity Reports, Participation Reports and Course Logs. The type is given by contextlevel, and depending on context level, instanceid points to one of a number of different tables. It is also the place where the teacher (or others) can mark the course as complete. Relevant items in this Data Source include the Status, Date Started, Date Enrolled, and Date Completed of users in courses. However you need to understand how to write the SQL queries for Moodle database. Learn how to seamlessly connect external tools and enhance teaching with our step-by-step guide. For example, a Page might have the requirement to require view; a Quiz might have the requirement to require grade while a Forum might have the requirement to require posts/discussions/replies. tmufumiucslzredwhsdtsejzjrwqkcouychwowtihgsszdabqiadvizqtoqevidoghbcrrmgdwmamweaysaubvp