General plugins

I just made a new admin report

 
 
Picture of Derek Runions
Re: I just made a new admin report
 

Hi guys,

I've been looking for something like this for a while as I am needing to make a "Report Card" section for my site.

Using Jason Hollowel's code I've been able to generate a list that shows EVERY students final grades, but this leads to a glaring privacy concern.

This is Jason's code that I've been using, I'm wondering if we can change it to suit my needs.

SELECT
prefix_course.fullname AS "Course",
ROUND(prefix_grade_grades.finalgrade, 2) AS "Final Grade",
prefix_user.firstname AS "First Name",
prefix_user.lastname AS "Last Name",
prefix_user.username AS "Username"
FROM
prefix_grade_grades
INNER JOIN prefix_user ON prefix_grade_grades.userid = prefix_user.id
INNER JOIN prefix_grade_items ON prefix_grade_grades.itemid = prefix_grade_items.id
INNER JOIN prefix_course ON prefix_grade_items.courseid = prefix_course.id
WHERE prefix_grade_items.id = prefix_grade_grades.itemid
AND (prefix_grade_items.courseid = prefix_course.id)
AND (prefix_grade_grades.finalgrade > 0)
AND (prefix_user.deleted = 0)
AND (prefix_grade_grades.timecreated IS NULL)
AND prefix_grade_items.itemtype = 'course'
ORDER BY prefix_course.id, prefix_user.id

 

I need to have something that a student can click on "Report Card" and they will be taken to a list that shows them all of their final grades in all of the courses they are enrolled in (but only their own grades).  This also needs to be organized by Course Category (Each year/cohort has three terms so it looks like "Year 1"(category) -> "Term 1"(sub-category) -> "Science"(course)

I'd love it to look like this (or at least have this information) when a student clicks on Report Card.  I dont know or understand SQL at all so any help would be wonderful!

Joe Student Term 1 English 90%
Joe Student Term 1 Math 90%
Joe Student Term 1 Science 90%
Joe Student Term 2 English 80%
Joe Student Term 2 Math 80%
Joe Student Term 2 Science 80%

Thanks so much for helping out!!!

 
Average of ratings: -
Picture of Ajeet Kumar
How to get report of course completion
 

I need sql query to list all user who completed course


 
Average of ratings: -
Me at the Moodle Moot NZ11
Re: How to get report of course completion
Group Particularly helpful Moodlers

You will need to find the column in the database table that holds the final course completion value.

 
Average of ratings: -
Womble
Re: How to get report of course completion
 

I would like a report that lets me see who has done what on a course and when but will also let me pull the department field from the user account.  I think we may use the Town field for this rather than create our own fields.

 

Is this possible?

 

Thanks

 

Michelle

 
Average of ratings: -