Has anyone written script to pull custom reports from grades? We are looking for a way for a building admin to pull all missing assignment data for our high school.
The easiest way I have found to pull this type of report is to use canvas data. Do you know if your school is using this currently?
Not really! I'd love your insight!
On Tue, Dec 11, 2018 at 1:50 PM Brian Neporadny <email@example.com>
Using canvas data the limit to the reports you can create a very vast.
Some reports I have created are reports to show when students submit work late, when instructors haven't graded assignments after a certain number of days past the due date, as well as one to pull students who have missing assignments to name a few.
I would highly recommend looking into using Canvas Data at your institution to help facilitate the reports you will be needing.
One thing to note about Canvas Data is: "For all file downloads, please note that the dates specified do not reflect the actual dates of the data, but instead when the data was finished exporting. The most recent data in a given export is generally 24-36 hours older than the date given. An exception is that the request table is 48 hours behind due to the large amount of data that needs to be processed. All dates are in UTC."
I'm asking for it to been enabled! Thank you for your help! Is there an
extra cost associated with this?
On Tue, Dec 11, 2018 at 2:01 PM stefaniesanders <firstname.lastname@example.org>
How big is your school?
As Brian mentioned, there is a delay with Canvas Data that may make it unsuitable since faculty could have graded time since the snapshot was taken and the time you get around to analyzing it. While the text files that you can download are free, there is a lot of overhead with that -- namely you need to be able to manipulate huge flat text files, or put them into a database and do queries (recommended). They do offer a solution using Amazon's RedShift, but it's not free (it was cost prohibitive for us, but we're a small school and don't use it much). As for enabling Canvas Data or request a price quote, you'll need to contact your CSM.
We're implementing a retention software solution this semester and I had to download all of the assignment data, which would include what was missing. We are small and at the end of this term, we have about 425 courses, 2400 students, 6000 active enrollments, and 152,000 submissions. We only need to pull the grade data for the 425 courses to get the missing assignments report, but it's all wrapped up into one program, so I can't break it out for you. I've optimized the code to make parallel requests and a full load takes < 15 minutes. After the full load, we do full load of everything except for submissions, which are incremental since the last time we fetched. This normally takes < 3 minutes.
We don't have a script written that will pull out missing assignments, but it would be possible to write one. The code isn't ready to share; I don't even have it under revision control yet. I'm throwing this out as an example of things that people have done. It does save the results to a database that, in many ways, duplicates what's available in Canvas Data, but doesn't suffer from the delay issue.
This is exceptionally helpful. We are small (600 in the high school) and
what you describe sounds like our situation. THANK YOU!
In that case, you wouldn't have to save the results to a database, which would make it easier to implement.
I'm over simplifying this, but you start with a list of courses, then you iterate through all of the courses and get all of the assignments for each of those courses. There is an API call available for each of those, but it could all be done in memory and without storing to a database for that size institution. Do you have a programmer available?
How are you planning on using it? To notify the students that they need to turn in grades, or to let the instructors know that they need to fill in the grades or ??? In other words, what needs to be on the report?
Great questions...mostly building principal would like to be able to pull a
"missing assignment" report to better inform our "D/F" list...seeking to
answer the question "what is the cause of the lack of student progress?",
essentially. Teachers have also expressed interest in a similar report.
On Thu, Dec 13, 2018 at 12:37 PM stefaniesanders <email@example.com>
Retrieving data ...