Custom Course Reports

[Code-with-Ski]

The recent update to the Canvas LMS Mods (Basic) Chrome extension, provides some new course level reports.

I have been working on a JavaScript class to handle creating tables that display data with columns that can be sorted and hidden/shown.  I have also been working on allowing the table data to be shown using pagination. The table also includes a Download button to download the data from the table to a CSV file.

I then added on to this by building a JavaScript class to make a report with the custom table that I've developed.  These course level reports are beginning prototypes of what I hope to create and with these classes it should be easier to build new reports.  To go along with this, I have built a JavaScript class to help make Canvas API calls and handle the response.

To access these custom course level reports, you will need to go to the course settings and click "Course Statistics" in the right-hand side.  You can also add "/statistics" to the end of the course home URL to get to it directly (i.e. https://canvas.instructure.com/courses/12345/statistics).

I have built the following reports so far:

• Assignment Details
• Submission Details
• Grading To Do Report
• Missing Rubric Grade
• Grade History Report
• Quiz Details
• Discussion Details
• Discussion Replies Report
• Announcement Details
• Page Details
• Modules Progress Report
• Enrollment Report
• User Access Report

Currently, the only option is to load all the data for each of the reports, but I plan on building on these reports to add more search options.  I also plan on developing a lazy loading option for the reports so you can load an initial set of data and then continue to load more as needed.

[rtamayo2]

Just used this to assist a professor. Thanks!

[dbrace]

Thank you for this extension.  I continue to use it on a daily basis.

I have two questions for "User Access Report":

1. What is your timeline for the ability to use the dropdown menu to see only one student instead of using "Load All" and then manipulating the CSV a spreadsheet application?
2. When reviewing the list (or downloadable CSV file), would it be possible see the dates and times for "Times Viewed" and "Times Participated"?

[Code-with-Ski]

@dbrace 

You're welcome 😀 I'm glad you are finding it useful!

Thank you for letting me know about the issue with the "User Access Report".  I believe I found the issue and released a patch for it.  I'm currently waiting for the newest update to be approved in the Chrome Web Store, but once you see the extension with at least version 5.2.5 it should be resolved.

The endpoint I'm using doesn't include the specific dates and times when it was viewed and participated.  I will need to investigate further to see if there is an endpoint that provides this information without requiring too much loading time.

[dbrace]

Thank you @Code-with-Ski. I will check my version number in a few days and try it out again.

I appreciate you looking into the possibility of showing the days and times that something was accessed and participated with. While the number that appears in the native report is helpful, it is not helpful when trying to investigate at a larger scale.

Thanks again!

[dbrace]

@Code-with-Ski, I have 5.2.5 installed and the "User Access Report" works. Thank you!

[Code-with-Ski]

@dbrace You're welcome. I'm glad to hear it is working for you now!

[s_korber]

Hi. Thank you for this very useful feature. It worked like a breeze when I tried to download submission comments earlier this year. However, when I try it now, it always brings the "Failed to get submitted submissions for all assignments" error message for the Submission Details and Grading To Do Report. Any idea what causes this error? Thanks!

[Code-with-Ski]

@s_korber 

You're welcome 😀  I'm sorry to hear that those reports aren't working for you.  I tried testing in my test courses and it is working for them currently, so I will need to review my code to see what may be triggering an error.  I'll share an update when I know more.  Do you know if it is affecting all your courses or is it just one in particular?

[s_korber]

Thank you. I tested it with an 'old' course where it worked earlier this year, but I also got the same error message. So it seems to be across all my courses. I will check with my local admin people about whether they see anything on their end. 

[Code-with-Ski]

@s_korber Thank you for testing with some of your older courses.  I'm reviewing my code to see if I can find a possible cause of the issue.