Discussion Counts Using Excel Instead of Google Sheets

We have been using this great solution by James for counting discussion posts in Canvas. A number of our faculty members like this overview file.

Our school is switching from Google to Microsoft - and I wondered if there was an Excel version of this. Or another way to accomplish the same thing.

@James? Anyone? Thank you.

Find more posts tagged with

Canvas

Accepted answers

All comments

Code-with-Ski

@cgray5

In the Canvas LMS Mods (Basic) Chrome extension I developed, I built some course reports. One of the reports is a Discussion Replies Report. It provides data for all the discussion replies within a course and the data in the table can be downloaded to CSV. At present I don't have the counts included, but I may consider this in a future update. In the meantime, your instructors could open this CSV file in Excel and use formulas and/or Pivot Tables to determine the counts.

Custom Course Reports

AmosLewis

When our team switched to Microsoft, I found myself scrambling for similar solutions too. For counting posts in Excel, you can use formulas like COUNTIF to tally up discussion contributions. Just set up a column for post dates or names, and that formula can pull in the data you need. If you're looking for a more visual approach, consider creating a pivot table. It’s super helpful for summarizing data without diving deep into spreadsheets. If you're new to Excel or need some fresh ideas, the Excel blog from MyExcelOnline Academy has tons of tips and tricks that really helped me when I was figuring things out.

Unanswered Questions

Change Group Assignments to NOT save if no groups are selected
Morning! One of the more frustrating aspects of Canvas are groups and the issues that show up when copying courses that have them. But now we have yet another issue. Most recently we have had instances where people mark an assignment/discussion as a group assignment but then do not link the discussion or assignment to any…
Has anyone experienced the "Empty Course" page for Speedgrader, when there actually are students assigned and active on the assignment?
So, we have encountered a few assignments where the Speedgrader presents the teacher with the "Empty Course" page, even though the course is not empty. I have discovered two New Quizzes in the same course where this has occurred, despite multiple students being assigned (at Module level, which passes the permission down to…
Problems with grading since update
A teacher has expressed concerns with the recent update. Exact concern is as follows: "My Canvas has been acting glitchy since the last "update." For instance, when I grade essays the highlight and cursor tools do not always work. I have to try highlighting several times,or come back later to finish. It's told me I "ran…
Please restore student ability to immediately download submissions to verify them...
A recent change my students have been complaining about is that they now have to wait for Canvas to process submissions so that it can be displayed within the browser before they can check that the submission worked. When the servers are heavily loaded I have seen student need to wait 5 minutes for this. When submitting at…
Monitoring API Activity (in test)
We are testing a third party integration from our college's ERP provider. We have connected it to our test environment. It seems to have very few features and options. So, just wondering if there is a way to monitor API calls. I was able to use the DAPClient in Python to download canvas_logs in our production environment.…