Hi,
I had been using Moodle 3.8 in creating Formulas question for Structural Engineering Technology courses since Fall and would still consider myself new to this process. I am just wondering if Moodle has something similar to a Vlookup function in Excel or sort of an algorithm. The question I am working on involves getting values from a table in a design handbook. I would gladly appreciate any help.
Carisa Blancas
Hello Carisa,
The Formulas question is ideal for this kind of problem. For my course, I use the properties of many shapes from the Handbook of Steel Construction, which allows each student to have a different shape for his/her quiz. To locate elements in an array, all you have to do is use the indices. It is very simple.
You can drop a short and simple example question here, in Moodle XML format, and surely someone can help you.
Thanks for getting back so quickly, Dominique.
I have the question I am working on below. I have tried using the following algorithm but it didn't work. Kr is 2.9, so it should get a rho=0.98 but it was giving 50000. I would be happy to learn how to use the indices.
Kr=ceil(Kr/0.1)*0.1;
rho=(Kr==2.7?0.90Kr==2.8?0.94
Kr==2.9?0.98
Kr==3.0?1.02
Kr==3.1?1.06:50000)))));
Carisa
Hi Dominique,
Thanks for the suggestion.
I am just wondering how to create the following formula question using an algorithm similar to a vlook-up function where one of the variables will be a string variable. Students would be referring to a table of Lumber Species with given unit weights. I was trying the statement - D=(W=="Cedar"?3400W=="D.Fir-Larch"?4800
W=="Spruce-Pine-Fir"?4100:1000); but it didn't work.
Any help would be most appreciated.
All the best,
Carisa Blancas
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]}
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
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.
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
