please i want to create a summary table activities for each student in moodle
for example for each student i want to know
Number of messages sent to the forum
Number or messages read on the forum
Number of quizzes passed
Number of quizzes failed
Total time used on quizzes
Total time used on forum
how can i do that ?please help me.
The reports you are looking for, or the counts anyway, aren't readily available.
If you have the ability/role to add a plugin, or request one to be added, you may wish to take a look at the Configurable Reports block https://moodle.org/plugins/block_configurable_reports. This block is a tool to create your own reports. The reports you are after would have to be created using SQL queries (from the database).
Here is another page of SQL queries that have been contributed by the community. You may find what you are looking for here, or at least give it a try. Then if one of these queries doesn't work, you can ask for more specific help.
I hope this is a good path for you!
actually am new in moodle thank you for response but i didn't understand very well this plugin (what he can do exactly ??)
and you told me about a list of queries plz where i can find this list ??