Get data of students at risk of dropping out from the moodle database

Get data of students at risk of dropping out from the moodle database

{$a->নাম} - {$a->তারিখ} দ্বারা
Number of replies: 5

Hi everyone! I'm working with the moodle analytics especifically with a model for Students at risk of dropping out (Moodle version 3.8)

Does someone know if there is a way I can get the list of students at risk of dropping out from the moodle database?

I've already tried querying the 'mdl_analytics_predictions' table but I can't get the id or any data of the students.

I hope you can help me with this, thanks!

Julieta.




রেটিং এর গড়: -
In reply to JULIETA DIANA RIVERO

Re: Get data of students at risk of dropping out from the moodle database

{$a->নাম} - {$a->তারিখ} দ্বারা
Core developers এর ছবি Particularly helpful Moodlers এর ছবি Peer reviewers এর ছবি Plugin developers এর ছবি Plugins guardians এর ছবি Testers এর ছবি Translators এর ছবি
you'll need something like this:

select ap.*, u.*
FROM {analytics_predictions} ap
JOIN {context} cx on cx.id = ap.contextid
JOIN {course} c on (c.id = cx.instanceid AND cx.contextlevel = 50)
JOIN {user_enrolments} ue on ue.id = ap.sampleid
JOIN {user} u on u.id = ue.userid

You should probably take a close look at what "context" is in Moodle:
https://docs.moodle.org/en/Context
রেটিং এর গড়:Useful (3)
In reply to Dan Marsden

Re: Get data of students at risk of dropping out from the moodle database

{$a->নাম} - {$a->তারিখ} দ্বারা
That's exactly what I was looking for
and you're right, I'll read more about context.
Thanks a lot for your help!
রেটিং এর গড়: -
In reply to JULIETA DIANA RIVERO

Re: Get data of students at risk of dropping out from the moodle database

{$a->নাম} - {$a->তারিখ} দ্বারা
Particularly helpful Moodlers এর ছবি Testers এর ছবি
Your post made me wonder about how you define "at risk?"
রেটিং এর গড়: -
In reply to Rick Jerz

Re: Get data of students at risk of dropping out from the moodle database

{$a->নাম} - {$a->তারিখ} দ্বারা
Core developers এর ছবি Particularly helpful Moodlers এর ছবি Peer reviewers এর ছবি Plugin developers এর ছবি Plugins guardians এর ছবি Testers এর ছবি Translators এর ছবি
It's a core report in moodles analytics machine learning tool:
https://docs.moodle.org/311/en/Students_at_risk_of_dropping_out
রেটিং এর গড়: -