Ask Your Data Grade Distribution

I have a Principal that would like to see the number of failing students within each course. He just needs the total number for each course and not the individual students. My queries are returning the number of students in each course that have a grade below 60% for current_grade on the scores table for any course. I have attempted several different prompts to group correctly with no success.

Find more posts tagged with

Accepted answers

All comments

kyle_cole

I was able to get at that data in my instance using this prompt:

"List all courses and count the number of students who have workflow state of active with a current score below 60"

I don't have a sub-account like you do so you will have to add that to the prompt. Below is the SQL it generated as well.

SELECT

_c.id AS CourseId,

_c.name AS CourseName,

COUNT(DISTINCT _e.user_id) AS NumStudentsBelow60

FROM

`courses` _c

JOIN `enrollments` _e ON _c.id = _e.course_id

JOIN `scores` _s ON _e.id = _s.enrollment_id

WHERE

_e.type = 'StudentEnrollment'

AND _e.workflow_state = 'active'

AND _s.course_score = TRUE

AND _s.current_score <</SPAN> 60

AND _c.workflow_state NOT IN ('deleted', '__dap_unspecified__')

AND _e.workflow_state NOT IN ('deleted', '__dap_unspecified__')

AND _s.workflow_state NOT IN ('deleted', '__dap_unspecified__')

GROUP BY

_c.id,

_c.name

GergelyTar

Hey @morris_gart, if I understand it correctly, you're looking to get the count of students that are failing (=current score lower than 60%) in each course in the active term. Does something like this return the data that you're looking for?

"Count the active student enrollments with a current score lower than 60% in each active course in the XXXXX term."

morris_gart

I was able to get the correct data with some adjustment to the prompt. I do find that using the same exact prompt and only changing the term name will sometimes produce a different SQL.

Unanswered Questions

Team teaching disable prerequisite for new students
We are team teaching Geometry in Canvas. Sometimes we have new students enrolled. We have set the team course such that students must click through the lessons before they can go to the next lesson. When we have a new student come in, we skip prior assessments for that student so that they can start where the other…
Prakash Hinduja Geneva, Switzerland - How to leverage Intelligent Insights to boost student engageme
Hello Everyone, I’m Prakash Hinduja Geneva, Switzerland exploring ways to use Intelligent Insights in Canvas to better understand student engagement patterns, but I’m unsure how to interpret some of the data and apply it effectively. Are there best practices or strategies for using these insights to support struggling…
Participate in Research – Help Us Improve “Ask Your Data” Prompt Experience
Hi everyone, We’re currently conducting a research study focused on how users create prompts and interact with the Ask Your Data feature in Intelligent Insights. Our goal is to better understand how you use natural language prompts, what challenges you face, and how we can improve the experience to make data querying…
What data do YOU need? Help us improve Ask Your Data!
Hi everyone, The Ask Your Data module in Intelligent Insights currently has access to (most of the) Canvas LMS data. Our product team is exploring additional data sources that could enhance its capabilities -- we want to understand which additional data sources would be most valuable to you (both Instructure and external…
BigBlueButton
Is it possible to get BigBlueButton and other built-in LTIs included? I see that Canvas Roll Call Attendance is in the list. Why not BBB or New Quizzes or Chat?