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

由JULIETA DIANA RIVERO發表於
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

由Dan Marsden發表於
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

由JULIETA DIANA RIVERO發表於
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

由Rick Jerz發表於
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

由Dan Marsden發表於
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
評比平均分數： -