Dynamic Quiz Input/Grading based on previous answers?

magnonk
Community Novice

In a multiple step problem, a quiz would ask for input of values at various stages of the calculation. In grading, we would need to grade the latter portions according to their responses to earlier questions.

Very Simplified example of what we're trying to accomplish, Using students A,B,C to demonstrate:
Q1. Evaluate x, x=3*2

{Correct Answer}=6

{Student A Input}=6  (1/1 pts)

{Student B Input}=5  (0/1 pts) - Incorrect

{Student C Input}=5  (0/1 pts) - Incorrect

Q2. Evaluate y=x*2

{Correct Answer, based on original correct response to Q1}=12

{Student A Input}=12  (1/1)

{Student B Input}=10  (1/1) - Correct math applied in this Q, despite previous error

{Student C Input}=12  (0/1) - Incorrect math applied to the Q, despite having "Correct" answer of 12

This seems to be outside the capability of quizzes on canvas. We have considered a possibility of querying student responses, and downloading the responses and pushing them through an excel sheet which could automatically perform the calculations and determine the points that should be applied, but then we don't know how to re-upload the non-canvas graded feedback via excel or csv. Manual entry of points is not an option for the size of the class.

Any Suggestions?