Quiz: Excel Differential Equations

Main.ExcelQuiz5 History

Hide minor edits - Show changes to markup

May 05, 2022, at 03:42 PM by 10.37.6.74 -
Added lines 1-73:

(:title Quiz: Excel Differential Equations:) (:keywords quiz, test, Python, variable, ODE, differential, Euler, expression, introduction, course:) (:description Learning assessment on Excel solution for differential equations with explicit Euler's method.:)

1. How does the length of the time step (difference in time between successive steps) influence the accuracy of Euler's method?

A. Increasing the time step (larger steps) makes the solution more accurate
(:toggle hide q1a button show="Select":)

(:div id=q1a:)

Incorrect. Increasing the time steps makes the solution less accurate

(:divend:)

B. Increasing the time step (larger steps) makes the solution less accurate​
(:toggle hide q1b button show="Select":)

(:div id=q1b:)

Correct.

(:divend:)

C. Increasing the time step (larger steps) does not change the solution
(:toggle hide q1c button show="Select":)

(:div id=q1c:)

Incorrect. Numerical solutions are affected by the time-step length.

(:divend:)

2. A differential equation has at least one term that contains the derivative of a variable (such as temperature, concentration, or velocity) with respect to another variable (such as time or distance). One example is: dx/dt = v where x is position, t is time, and v is velocity.

A. True
(:toggle hide q2a button show="Select":)

(:div id=q2a:)

Correct.

(:divend:)

B. False
(:toggle hide q2b button show="Select":)

(:div id=q2b:)

Incorrect.

(:divend:)

3. What does it mean to discretize a differential equation? (Select two correct answers)

A. It is the process of selecting specific points to seek a solution to an otherwise continuous problem.
(:toggle hide q3a button show="Select":)

(:div id=q3a:)

Correct. Discrete time points are a sampling of values along a continuous range.

(:divend:)

B. It gives an analytic (exact) solution to the differential equation once solved.​
(:toggle hide q3b button show="Select":)

(:div id=q3b:)

Incorrect. Numerical (discrete) solutions have calculation error that analytic solutions do not have.

(:divend:)

C. Time steps are chosen to calculate a solution.
(:toggle hide q3c button show="Select":)

(:div id=q3c:)

Correct. Numerical solutions require discretization where the solution is obtained at specific time points.

(:divend:)

Restore