Identify if an assignment counts towards final grade from Canvas Data

Question

I want to identify from Canvas Data if "do not count this assignment towards the final grade" is checked for any assignment, but I don't find this info from assignment_dim/fact tables. Is there anyway to get this information from the data?

Actually this question applies to some other checkboxes in assignment/quiz/module setup stage as well, such as "Show one question at a time" in a quiz setup.

ryucali · Answer

@James Thanks for the timely response! My use case is institutional research which evaluates thousands of courses at once (instead of looking at a few courses/assignments), so the API approach doesn't seem to be efficient. Also we don't have Live Events. Do you think there's an indirect way of inferring this information from different parts of Canvas Data?

James · Answer

@ryucali

There are various sources of information in Canvas (API, Canvas Data, Live Events, GraphQL via the API) and the data coverage is different for each of them. Canvas Data does not contain the information that you want, but you could get it through the API and store it in your own local tables that you could then combine with Canvas Data.

Here is a similar question from a couple of years ago with a little more information: Assignment Counts Towards Final Grade