Submit a request
Submit a request

Setting Up a Data Table and Inserting Dynamic Content into a Question

This feature requires the Author API interface. If the Data button does not appear as in the screenshots below, contact support and we will enable the feature for you. 

Adding Dynamic Content

Open a new Item and click on the Settings button on the top right of the Item.


Figure 1: Settings button in the Item.

In the pop-up window, click on the data table icon, and insert the data from a CSV file or a spreadsheet and click Continue.

Note that your data must have column headers that represent the purpose of each column. These column headers will appear as variable names in the UI. In this example, we will use Operand 1, Operand 2, and Result.


Figure 2: Inserting data in the Item.

The pasted content will be transformed into the data table. If you are happy with your data table, click Apply. It will be automatically saved and you will be brought back to Item Edit.

If the data does not appear to your liking, edit the CSV and try again.

Hint: Preview the CSV in a spreadsheet application, like Google Sheets, to see if it matches your expectations.


Figure 3: Data table with a set of variables that represent two Operands and Result.

You can now use the data to create Questions. Add a Question to an Item as normal. We are going to use a Cloze Math question type as an example.

Let's create a simple math expression. Open a new Cloze Math question and add a single zone.


Figure 4: Enter an empty response box inside the Formula template area.

Then under More Options navigate to the Formula template under the Layout section. From the Rich Text Editor in the Formula template area, select the Data option (see Figure 5).


Figure 5: Rich Text Editor panel with Data button.

Choose Operand 1 from the drop-down menu, add a plus sign and then select Operand 2. Add an equals sign and a response box as shown in Figure 5.


Figure 6: Cloze Math formula template with variables.

Then go to the validation section, and from the Value field click on the Data button again. This time select Result. You have now set the expression syntax and the result for each value combination, all in a few clicks.


Figure 7: Added equation with result variable from data to validation.

Now when you preview the Question you will see the Data button with left and right arrows. Click on the arrows to switch between equation combinations you've created, and test the correct response for each of them.


Figure 8: Question with Dynamic Content preview. 



Did you arrive here by accident? If so, learn more about Learnosity by clicking here.