Custom reports - marketing pieces and utilities I have created in my moodle....

This post is primarily for my new co-worker, collaborator Mike.  Shirley, whom I have worked with for almost 15 years, is retiring soon.  Good for her.  Mike will now be working with me supporting the moodle sites.  This is a *documentation post.

Summary of reports and utilities build in moodle

1 - Enrollment report

Access report in moodle here

Site Admin - Reports - Student enrollment report

Location in moodle "where is the code?"

moodleroot\report\enrollment

Description

Enrollment report.  sortable, records LIFO, includes status, which is a link to a form to update the status.  Status = active, completed or dropped.  link to course access history for each student.  Filter options by status.  total # of enrollments by status.

Audience "who can access the report"

Moodle administrators

View of report

2 - Progress report

Access report in moodle here

Course admin - Grades - Progress Report

Location in moodle "where is the code?"

moodleroot\grade\report\progress

Description

includes all enrolled students, their status, enrollment date, projected completion date, grade, % course items completed, time in seat - time on the site for the week and total, last access date, link to course history by student.

Audience "who can access the report"

Administrators, teachers

View of report 

3- User report

Access report in moodle here

Course admin - Grades - User report

Location in moodle "where is the code?"

moodleroot\grade\report\user

Description

This is a native moodle report that I have changed.  I added a select menu of the enrolled students, including their enrollment status.  The students in the select menu are ordered by active enrollments, then completed or dropped.

Audience "who can access the report"

Admins, teachers

View of report 

4 - Tardy course access report

Access report in moodle here

Site administration - Reports - Tardy Course access 

Location in moodle "where is the code?"

moodleroot\report\tardy

Description

shows active (enrollment status = active) students who have not accessed their course in over 6 days.  sortable by student, by length of time since last access.  includes link to contact student, last date they accessed the course.  includes district, course name and teacher.

Audience "who can access the report"

Site admins.

View of report

5 - Student Advisor Report

Access report in moodle here

Site administration - Reports - Student Advisors

Location in moodle "where is the code?"

moodleroot\report\advisor

Description

shows student accounts and any advisor role that has been added to it.  this is a little tricky native moodle functionality.  also shows the accounts that are in the advisor role.  I created a custom role called advisor in course. this is so advisors, not teachers, can view the their students progress in a course.  their role can see student activity data in the course.

Audience "who can access the report"

Site admins.

View of report

6 - Messages report

Access report in moodle here

Site administration - Reports - Messaging

Location in moodle "where is the code?"

moodleroot\report\messaging

Description

shows all messages communication between a student account.  includes a select menu. this is a quick way to see a summary of messaging communication that has taken place between a teacher and student.  Mike is the one who asked for this - not avail. to the teacher role. includes date of message and subject and context.

Audience "who can access the report"

Site admins.

View of report 

 

Utilities to assist in course preparation "mainly"

  7 - Course script-er

Access report in moodle here

Site URL \ local \ coursePrep.php - note, need to be logged in as admin to see this page.

Location in moodle "where is the code?"

moodleroot\local\coursePrep.php

Description

This utility formats vendor courses to our specifications. Details about what are listed in the php file. in concept - this utility can be ran more than once on a course but should only be run on course masters .  courses deployed to teacher categories would be formatted as they derived from a course master.  When in doubt, run the script.  All of the updating accomplished by this script can be completed in the native moodle course.  select a course from the dropdown, click Run script.  There is a checkmark next to each course in the list indicating if the course has been scripted already.  Also a checkbox to trigger different quiz settings if course is MOD.

Most of the formatting deals with 

1) quiz
2) assignment
3) gradebook
4) forums
5) completion tracking 

Audience "who can access the report"

Site admins.

View of utility

8) Gradebook item sorter


Access report in moodle here

Site URL \ local \ sortUtil.php - note, need to be logged in as admin to see this page.

Location in moodle "where is the code?"

moodleroot\local\sortUtil.php

Description

This utility will sort the items as they appear in the gradebook.  The gradebook items do not always match the course home page listing.  This utility will sort the items in the gradebook to match the order of the items on the course home page.

this util page will get all the courses in a moodle db that have enrollments
loop over the course
   extract the courseid
      get the gradable items for the course
      loop over the gradable items
      update the sortorder or the gradable item
    get the next courseid
end loop

Audience "who can access the report"

Site admins.

View of utility
 

  9- Deployed course pacer report

Access report in moodle here

Site URL \ local \ pacer.php - note, need to be logged in as admin to see this page.

Location in moodle "where is the code?"

moodleroot\local\pacer.php

Description

This utility will list *deployed courses - copies of masters - in LIFO order.  included in the report is a link to the edit mode of the course and a individual count of gradable items; forums, assignments, quizzes.  Also a total pacer # - which should match what is displayed in Genius.

Audience "who can access the report"

Site admins.

View of utility

Marketing space.  I almost forgot about this

10) Marketing space


Access report in moodle here

Site URL \ local \ sortUtil.php - note, need to be logged in as admin to see this page.

Location in moodle "where is the code?"

moodleroot\portal\

Description

A marketing / informational space.  Includes information about the program, courses, teachers, enrollment info.  Kinda like the old Genius system.  Good fun php development here following some solid MVC design patterns.

Audience "who can access the report"

Public

View of home portal space