I have a faculty teaching an online 100 level grammar course. There are 600 students in the class.
Students in the class need to have submitted X number of assignments while attaining 80% average or higher.
Is there a way to tease out what students have met these requirements?
Course analytics only allows one to sort by "Page Views" and "Participation" NOT "Submissions."
Furthermore, I don't see a way to export that report in a fashion that would then allow us to parse out the data.
What am I missing? Help Canvas Community, you're my only hope.
If you scroll down to the bottom of Course Analytics you will find a table that, among other things, displays the numbers of submissions and final percentages by student. Not sure how useful this would be with a very large course, nor if your professor includes submissions that might not count, nor if by 80% your professor means 80% aggregate or individually for the assignment standard. Also note that "submissions" would include quiz and discussion submissions.See image below.........
Another option would be to download the gradebook as a csv file, and perform some Excel magic to get a count for each student row. As an Excel spread sheet, your professor could delete any columns that don't count (quizes and discussions), and could even set the conditions for the row counts to exclude any the are less than 80%.
I hope this helps.
Hi @kmeeusen ,
That is exactly the table I was looking at. If you check the label headings, it is not sortable by submissions. Which strikes me as lame.
We have already resorted to what you suggest: exporting the grade book and having our data/research guru look into whipping something up that will allow us to pull out the list of students we want. Hopefully, more robust analytics- and the ability to export the results! Will be forthcoming.
Be well, and as always, THANK YOU for your input!
One of our Big Brains wrote a python script to rip the information out of the gradebook CSV file. It's an unsustainable solution for our campus, but, it got us through last semester.