Vlook up Function for Formulas Question

Re: Vlook up Function for Formulas Question

par Dominique Bauer,
Nombre de réponses : 3
Avatar Documentation writers Avatar Particularly helpful Moodlers Avatar Plugin developers

Hello Carisa,

Define a random variable:
    i = {0:3};

Define the global variables:
    specie = ["Cedar","Douglas Fir-Larch","Spruce-Pine-Fir"];
    unit_weight = [3400,4800,4100];

In the calculations, use:
    unit_weight[i]

In the question text, use:
    {=specie[i]}

Moyenne des évaluations Useful (1)
En réponse à Dominique Bauer

Re: Vlook up Function for Formulas Question

par Carisa Blancas,

Hello Dominique,

Thanks a lot for the help. Finally, I was able to make my formula question work without creating different questions for every specie. I'm happy to share what I came up with but I cannot upload the file. It is greater than 2MB. 

I would appreciate any advice.

Carisa

En réponse à Carisa Blancas

Re: Vlook up Function for Formulas Question

par Dominique Bauer,
Avatar Documentation writers Avatar Particularly helpful Moodlers Avatar Plugin developers

Hello Carisa,

The community would certainly appreciate you sharing your solution.

The size of the question is large probably because it contains images. In order to reduce the size, you could remove the images. If they are required for the understanding of the question, you can make their size smaller by lowering their resolution: first reduce the size of the images in an image editor, then replace the images in the question with these reduced images while keeping the original dimensions.

The images will be of lower quality but the question will be lighter so you can upload it.

Moyenne des évaluations Useful (1)
En réponse à Dominique Bauer

Sample Formula Question for Dead Load (Self-weight) Calculations with random Specie of Timber

par Carisa Blancas,

Hi Dominique,

Thanks again for the help. It worked now with the smaller diagram. I'm not sure what subject to categorize it. Please feel free to change. This question also assigns partial marks to students if they miscalculated a value that is needed for subsequent calculations.

All the best,

Carisa