Is a Report Card Coming?

Is a Report Card Coming?

by J m -
Number of replies: 16
I get requests for report cards type functionality.  I'd write a report in SQL and print it out if I knew what to do....Anyone know if a report card is in the works?  I use moodle at a k - 12 school.  Thanks.
In reply to J m

Re: Is a Report Card Coming?

by Tim Hunt -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers
For those of us who don't work in a k - 12 school, can you give us a rough idea what one looks like?

(And for the benefit of people who don't know the US education system, k - 12 stands for Kindergarten to 12th Grade, and is the term those in the ed. biz. there refer collectively to all types of school. I had to ask when I was at the Albuquerque Moodle Mood in February.)
In reply to Tim Hunt

Re: Is a Report Card Coming?

by Bob Scheele -

A report card is a one page view of all of the courses that a student is (or has been) enrolled in and gives all of their course grades as well as overall combined grade from addign up the courses.

Ex:

Student: Joe Shmoe

#1 Class: Organic Chemistry

Asnmt 1     Asgnmt 2           Course Result:

  50%         100%                   75%

#2 Class: French

Asnmt 1     Asgnmt 2     Asgnmt 3     Course Result:

  100%         100%              100%          100%

#3 Class: History

Asnmt 1     Asgnmt 2           Course Result:

  0%             0%                   0%

Combined Report Result:  58.33%

In reply to Tim Hunt

Re: Is a Report Card Coming?

by J m -

It would keep the students from having to drill down to each class to see their grades.  All the grades in one place is what they are asking me for.  Sounds like a simple report for someone the knew the system, but I don't. 

Thanks.

In reply to J m

Re: Is a Report Card Coming?

by Ger Tielemans -

Yes, for a programmer it is just:

  1.  collect the couses of student X
    (like in his course overview screen on my page)
  2. show the grades of these courses in one table
    (the code for showing the grades of one course is already there..)
In reply to Tim Hunt

Re: Is a Report Card Coming?

by Brian Pool -
We use Moodle in our High School and are moving to a 100% compliance for next semester. The idea is to have grades and assignments available to parents on a daily basis. The only thing I am looking for to make this perfect is a way to see all grades at one location. I am hoping someone can help write the code to do one of the following.

1. A "Report Card" page that would shows all enrolled courses, cumulative percentage grades, and letter grades.

2. A way to have the overall grade show up next to the course on the "My Moodle" page.

3. Something like a "ReportCard Block" that could be added to the left or right side to show percentages and letter grades of all enrolled courses in one block.

These all accomplish the same thing. The ability to see all enrolled courses and grades on one screen. Individual assignment grades would not be required (or desired) as they can be viewed at the individual course pages if parents or students need more detail.

If anyone is working on something like this I would love to know!

Brian
In reply to Brian Pool

Re: Is a Report Card Coming?

by Anthony Borrow -
Picture of Core developers Picture of Plugin developers Picture of Testers
Brian - Having something that resembles a report card would be great under the User Profile/View Grades option or as you propose in My Courses. Perhaps you would like to comment on MDL-6976 which while not a request specifically for Report Card for multiple courses could be developed into that. Please feel free to vote for MDL-6976 as I think it would be a step closer to what you are asking for and if it is not already in the tracker please feel free to add a feature request to it. Peace - Anthony
In reply to Anthony Borrow

Re: Is a Report Card Coming?

by Brian Pool -

Thanks...I am almost done making a modification to GBV2 that saves the gradebook info in a new table.  I am planning on making it display on the My Moodle Page as well as making a "Interims Report" for our 5th-12th Grade students.  It will alleviate the need for our teachers to transcribe grades to send home to parents.  I didn't have it done for this 9 weeks but I have promised to have it done by the next 9 weeks interims.  I will be posting it when I am done.  I hope the few required changes to GBV2 will be incorporated in that module so I don't end up with too much of an offshoot.

Brian

PS Found a great PHP 5 book from the Visual Series to get me started!

In reply to Brian Pool

Re: Is a Report Card Coming?

by Anthony Borrow -
Picture of Core developers Picture of Plugin developers Picture of Testers
Brian - Thanks for your work on improving the GBPv2 patch. Please keep in mind that the goal is that the GBPv2 patch will be obsolete in Moodle 1.9. I have posted a set of SQL queries that could be used in the hopes of getting the data from GBPv2 to Moodle 1.9. With the hope of GBPv2 being obsolete, I am not planning on doing much to improve it as I feel that rather than improving it my time is better spent looking ahead. Continue to play and when you get things working feel free to post the code and we will consider it but my bias at this point is to let GBPv2 die a natural death. But I can always be persuaded if there is sufficient demand/desire from the masses. I'm not sure how big of a group with GBPv2 folks are. Peace - Anthony
In reply to Brian Pool

Re: Is a Report Card Coming?

by Martin Dougiamas -
Picture of Core developers Picture of Documentation writers Picture of Moodle HQ Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers
If you look at the beta version of Moodle 1.9, you'll see an "Overview report" that does exactly this. It's very simple currently, just a table of course name, total grade and ranking, but it's easy to extend with features either in the core version of Moodle (give us suggestions!) or in your own reports (because they are plugins now).
In reply to Martin Dougiamas

Re: Is a Report Card Coming?

by Richard Ingalls -
Martin - I use v1.9 in a corporate setting and I have setup the Parent role and added the Mentees block. I would love for my Parents (supervisors, really) to see a report card type view of their "children" (employees) that is exactly like the User's Overview Report. Do you know how I can do this?

Thank you!
In reply to Richard Ingalls

Re: Is a Report Card Coming?

by Anthony Borrow -
Picture of Core developers Picture of Plugin developers Picture of Testers
Richard - The idea of a report card seems to imply final grades which is something I believe is being worked on for Moodle 2.0. However, it should not be too difficult to get the desired report from the User's Overview Report to be visible by the parent role. Unfortunately thought I'm confused by which report you mean. Could you provide a screen shot or URL for the report you are speaking of. I had no problem making the grades available to the parent. I suspect there will be multiple ways that you can allow the supervisors to monitor the progress of their employees depending on the particular needs you have. Peace - Anthony
In reply to Anthony Borrow

Re: Is a Report Card Coming?

by Richard Ingalls -
Anthony - Thanks for the help. Here is a url...
http://tinyurl.com/6olae7

I logged in as a "test" student > clicked on an enrolled course > clicked on Grades in the Administration block > Chose an action "View Overview report" ...

You see the results (if the tinyurl link works). This student is enrolled in 2 courses and has taken 2 quizzes (one in Moodle, the other a SCORM from Adobe Captivate).

I would love this overview report to show up, when I am logged in as a "Parent" role and use the Mentees block to view the grades of my "Children".

This is how the majority of the supervisors at my organization will want to use Moodle - to get a quick overview of the courses their employees have passed.

Thanks for any help you can provide!
In reply to Brian Pool

Re: Is a Report Card Coming?

by Andrew Chow -
Hi, Brian,

if I understand your post correctly, you would like to see the cumulative grades next to the course names in a block. Would it look something like this for a student?
|=======================|
| My Courses: |
| Calculus 101: 90% |
| French 200: 80% |
| Geography 100: 75% |
| etc. |
|------------------------------|
| Overall Average: 83.2% |
|=======================|

The cumulative grades will be dynamically updated as new assignments and quizzes are completed.

I think I can adapt the Completion Report that I am working on to display this in the block for students, and a different list for Administrators or Teachers, e.g. a list of students with their cumulative grade for a selected course.

|=======================|
| Course: Calculus 101 |
| John Smith: 90% |
| Linda Jones: 80% |
| Kevin Bacon: 75% |
| etc. |
|=======================|

Would this be useful?

Andrew
In reply to Andrew Chow

Re: Is a Report Card Coming?

by Brian Pool -
If we could have the current % for each course listed next to the course name on the My Moodle Page that would be perfect. The current letter grade would be great too. We just want a way for parents to easily see the current progress of their students.

If they need more info (ie the grade is bad) then they can always look into the course itself for more data.

So I guess the first option you listed above would be great, but the Overall Average is somethings we personally don't need.

Thanks for looking at this.

Brian
In reply to Andrew Chow

Re: Is a Report Card Coming?

by Brian Pool -
Andrew,

I have a question for you, which may be best offline...but...is the cumulative grade that Moodle displays in the gradebook actually stored anywhere or is it recomputed each time someone goes to the gradebook?

I can't seem to find it. I have done extensive DB programming but not PHP, so I am delving into this for the first time now.

If it is recomputed ... couldn't the information just be stored in a new table that consists of...

ID, COURSE, USERID, CUMGRADE, LETGRADE

...the course ID, student ID, percentage, and letter grade?

The percentage would be based on either percent or weighted percent (depending on which field the particular gradebook is setup to compute the letter grade on in preferences)

Then the "My Moodle" page could just pull the name, and then the grades when it is displaying the initial course headers.

That would seem to require only the gradebook and the my/lib.php module be altered.

I realize that the grade would be off slightly if the instructor entered new grades without going to the gradebook, but that is unlikely as most use it to crosscheck their entries. Plus, as soon as a student checked...their grades would be updated as well.

We are using GBv2 so many of our instructors add their grades right there anyway.

If I knew PHP it seems so simple. I guess I am off to Waldens huh?

Thanks for the sounding board...Brian
In reply to J m

Re: Is a Report Card Coming?

by Dan Jeffries -
Hi

We are really looking forward to someone developing this feature too for our network of colleges. Can't wait.

One query though.

Rather than using percentages, we use Pass, Merit and Distinction.

Would there be a way for Moodle to 'calculate' an average of these grades and provide the information into the Overview Report? Or could a teacher even do this manually?

We don't use %'s and only use the Scale system. Would it be a case of using %'s but having this scale linked to the percentages? (Does that make sense?)

Hope someone can help! smile