Teacher Dashboard and Reports

Teacher Dashboard and Reports

by Lana Endersby -
Number of replies: 4

Hello from the Gold Coast, Australia.

This is my first post to Moodle in English and as become more proficient I will be able to find the ideal place to collaborate on experience and ideas.  (Admin - please feel free to repost to the relevant location).

We are The French Beauty Academy using Moodle 3.8 Classic.  I am redeveloping the Teacher Experience and Usability to find a quick dashboard/ report solution for the following:

1. What are my current classes at a glance.

2. Have I got any outstanding assessment items for those classes?

3. Have I got students who have not logged in for "x" about of days?

4. How many students do I have missed an assessment deadline?

This will then be developed out into a Manager Report and an Academy Principal Report.  I'm sure there are many of you who have already solved this and would love your guidance and expertise.

Many thanks,

Lana

Average of ratings: -
In reply to Lana Endersby

Re: Teacher Dashboard and Reports

by Rick Jerz -
Picture of Particularly helpful Moodlers Picture of Testers
Hi Lana, and welcome.

As a "side project" I have been working on this issue of "Student Activity" over the last year or so. Somewhat coincidentally, I have hit it much harder over the last two days. I have been working on an SQL query that can produce what you find if in the "Complete Report" for a student, with more detail, and eventually "graphics." I am real close to having the SQL complete. So, let me ask you some questions:

1) How do you define current classes, given your Moodle?
2) How do you define "outstanding assessments?" I assume, also, that you mean Moodle quizzes. Or do you include other Moodle activities?
3) Okay. I understand this one.
4) This might be similar to #2. I think that you mean either a score of 0, or a no-activity, meaning never touched.

As you explore your questions, you should realize (you probably do) that Moodle is a relational database and that you can write whatever SQL you wish to write. Consider browsing List of SQL Contributed reports for examples.  Many can be modified to suit your needs.

I should mention that a lot of this is generic, but then a lot depends upon how your school is using Moodle.  For example, in my Moodle, I use a course shortname like so: MSCI2800-Su20-M-OL.  You might notice the "Su20" in it.  By doing so, I can then create a query to access this semester's students, like show down below.  But this query would only work for you if your school had the same course shortname convention.  But you see, if you know what you want from your Moodle, you can help yourself along by setting things up to support your needs.  Incidentally, I don't set course start dates or end dates, which someone might want to you for this purpose.  But maybe I should?  I just have not.  Also, in my Moodle, I don't have studentIDs, so I use this field in my own way.  A "99999" means that this person in my course is not a regular student.  You will see me exclude this 99999 from the query shown below.  Again, this is an example of how I use Moodle that might not match others.

I can share with you one of my MoodleMoot presentations on a topic that might help, as reference.  
MoodleMoot2018 (Spain), "Using Tableau with Moodle for Visual Analytics"


Here's the query:

# Students enrolled in this semester courses

SELECT c.shortname,

       c.idnumber AS Course_number,

       u.firstname,

       u.lastname

FROM prefix_course AS c

JOIN prefix_enrol AS en ON en.courseid = c.id

JOIN prefix_user_enrolments AS ue ON ue.enrolid = en.id

JOIN prefix_user u ON u.id = ue.userid

JOIN prefix_role_assignments AS asg ON u.id = asg.userid

JOIN prefix_context AS con ON asg.contextid = con.id

WHERE ue.status = 0

  AND asg.roleid = 5

  AND en.courseid = con.instanceid

  AND u.idnumber <> 99999

  AND substring_index(substring_index(shortname, "-", 2),"-",-1) =

    (SELECT substring_index(substring_index(shortname, "-", 2),"-",-1)

     FROM prefix_course

     WHERE idnumber IN

         (SELECT max(idnumber)

          FROM prefix_course))

ORDER BY c.idnumber DESC, u.lastname asc, u.firstname asc




Average of ratings: -
In reply to Rick Jerz

Re: Teacher Dashboard and Reports

by Lana Endersby -

Thank you Rick,

You sound like an expert in this field and as I learn more and begin to bring things together I'd love to stay in touch.  I'm a huge believer in learning and collaborating with experts and as a newbie I can tell I've got a lot to learn.  We have been researching the SQL Plug In options to drill into logs and reporting.  Rather than getting super technical straight away, do you recommend any specific reports/ logs and/or reporting plug ins that you recommend to empower Educators to monitor student progress, and manage their marking?  

Average of ratings: -
In reply to Lana Endersby

Re: Teacher Dashboard and Reports

by Rick Jerz -
Picture of Particularly helpful Moodlers Picture of Testers
I didn't intend to fool you that I am an expert. Actually, I am just a professor (of Business Analytics) and wonder what kinds of analytics we might want to get from LMSs.

There are a number of plugins that one can use to help manage your SQL queries. The one that I have been using is Contributed Reports. The others are fine, too.

The most simple and best reports, and a great place to start is to click on a student's name, then pick the Complete Report. The Online report is more condensed, which is why I usually pick Complete Report first. Moodle's Complete Report far surpasses what you get in other LMSs, like Blackboard and Canvas.  Actually, what I am interested in doing is getting even more detail than what Complete Report provides, for all students, and then look at this data by using Tableau.  Once I "see it" I will then know if I hit a brick wall, or opened an interesting door.

There is another plugin that is popular, but I don't use. Let me think a moment... either Completion Progress or Progress bar, as I recall. I put "progress" into the search textbox for plugins. Some of these are tied to using "Activity Completion" which I do have available for students to use, but since I allow students to optionally check-off what they do, some students do not check-off, so these plugins are less useful to me. If you are willing to spend some money, investigate IntelliBoard. Some nice folks are at that company, and their products might satisfy some administration desires. But in my case, their statistics, although interesting, don't get to what I seek. But someday they might.

In my courses, I have regular due dates that can't be missed, so I don't need any tools to tell me what I haven't marked. As an active professor, I just know (just like I know to read your post.) You might tell your educators to review students' grade books at least once a week, that's a good start. Also, make sure to tell educators to reply to students' posts and emails. Hmmm, let's see... tell educators that they must be active instructors, don't fall asleep, and spend more time on teaching instead of research. That's about all that I can think about for now.

What is it that your educators what to know?

Okay, let me try this more directly.  Remember, I teach college-age students, so my techniques might not apply to other grade levels.

1. What are my current classes at a glance. So, some instructors really don't know what they are currently teaching?

2. Have I got any outstanding assessment items for those classes?  Look at the grade book.  Sort by quiz grade.  Those with a zero have not been attempted.

3. Have I got students who have not logged in for "x" about of days?  If an assignment is not due for a week, does it really matter if a student logs in on Monday versus Wednesday?  For me, when I see a student missing assignments, I go to the participant list and see if this student has logged in.  Recently, I had a student who was missing assignments frequently, and I awarded this student 0's.  But the odd thing was that this student logged in regularly as if someone told the student "login regularly and the instructor will think you are active."  Quite honesty, this is the kind of "activity" that is curious to me.

4. How many students do I have missed an assessment deadline? The grade book will show this, if kept up to date.

I hope that some of this helps.
Average of ratings: -
In reply to Lana Endersby

Re: Teacher Dashboard and Reports

by Dave Sherwin -

Lana

There are some simple reports already built in Moodle that may answer the solutions you a asking about. Some appear to either be student or teacher specific

  1. What are my current classes at a glance.
    Either for the teacher or student when they are on their Dashboard there is generally a Course overview that displays their courses and their current progress.

  2. Have I got any outstanding assessment items for those classes?
    The Course overview also displays what percentage that the student has completed. Plus if the assessments have a date indicating when it starts/ends there is an Upcoming events block that displays when activities are due. We use Completion tracking which you can incorparate the Completion Progress Bar Block that displays for both teachers and students to track progress through a course

  3. Have I got students who have not logged in for "x" about of days?
    Generally this is a teacher function and is as easy as clicking on participates and sorting the groups by date attended. There is also a filter to search for a group of users who have not access a course in "x" amount of days.
    Of course there is a Participation report that can generate a list of who has participated in a given activity and how many times.
  4. How many students do I have missed an assessment deadline?
    Teacher can simply look at an assessment that have deadline and when their looking at the results will see which students have missed or nor submitted their quiz answers.
Not sure these will be useful, but there are many ways to communicate and gather data in Moodle with some basic functionality.
Average of ratings: Useful (2)