Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

- Home
- Canvas
- Canvas Question Forum
- Using formulas in variable definitions?

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

12-05-2017
07:00 AM

Is it possible to create formulas in the variable definitions for formula questions?

Example: teacher wants to create formula questions for adding multiples of 5.

Ideally, I could enter for [x] "5*0" as my minimum and "5*20" as a maximum so that all of the variables for [x] would be multiple of 5. It doesn't seem to work though. I do see what that doesn't work though, since the software probably doesn't know understand the ranges for two different numbers.

Another way to handle this?

Solved! Go to Solution.

1 Solution

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Not the Solution
- Email to a Friend
- Report Inappropriate Content

12-05-2017
10:35 PM

Is it possible to create formulas in the variable definitions for formula questions?

Not currently. There was a period of time where there was a big push in the Community for improving the random number generation capability of Canvas, but I don't see where any of those rose to the level of making it onto product radar.

The variables can only be random numbers, which you can limit to integers, but you can't use anything other than the randomly generated variables in the question text. Explained another way, you can generate [a], [b], and [c], but if d is a formula based on [a], [b], and/or [c], such as d=5*a, you cannot use [d] in the question text.

Another way to handle this?

Option 1: Don't use formula questions.

I create questions like this in Excel, import them into Respondus, and then export them into Canvas. You can, of course, create them directly in Canvas as well.

Option 2: Change the way you ask the question.

"What is the sum when you start with 5×[a] and add the next [n] multiples of 5?"

Then your answer is 5*n*(n+2*a-1)/2

or

"What is the sum of all the multiples of 5 starting with 5×[a] and ending with 5×[b]?"

Make sure that [a] and [b] cannot overlap and that [b] is definitely greater than [a], but then the answer would be

Then your answer is 5*(b-a+1)*(b+a)/2

3 Replies

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Not the Solution
- Email to a Friend
- Report Inappropriate Content

12-05-2017
10:35 PM

Is it possible to create formulas in the variable definitions for formula questions?

Not currently. There was a period of time where there was a big push in the Community for improving the random number generation capability of Canvas, but I don't see where any of those rose to the level of making it onto product radar.

The variables can only be random numbers, which you can limit to integers, but you can't use anything other than the randomly generated variables in the question text. Explained another way, you can generate [a], [b], and [c], but if d is a formula based on [a], [b], and/or [c], such as d=5*a, you cannot use [d] in the question text.

Another way to handle this?

Option 1: Don't use formula questions.

I create questions like this in Excel, import them into Respondus, and then export them into Canvas. You can, of course, create them directly in Canvas as well.

Option 2: Change the way you ask the question.

"What is the sum when you start with 5×[a] and add the next [n] multiples of 5?"

Then your answer is 5*n*(n+2*a-1)/2

or

"What is the sum of all the multiples of 5 starting with 5×[a] and ending with 5×[b]?"

Make sure that [a] and [b] cannot overlap and that [b] is definitely greater than [a], but then the answer would be

Then your answer is 5*(b-a+1)*(b+a)/2

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Accept as Solution
- Email to a Friend
- Report Inappropriate Content

12-21-2017
06:13 AM

James, how does Excel make creating questions easier?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Accept as Solution
- Email to a Friend
- Report Inappropriate Content

04-01-2020
12:58 PM

Sorry, I missed your question about Excel for over 2 years and just now stumbled across it as I was looking up previous material for another question.

I use Excel to generate the text of the question. Since Excel has calculation capability built in, it can find the correct answer. Respondus can import a CSV file saved from Excel.

Alternatively, you can use Excel to create the question and then copy/paste it into Canvas.

Related Topic

- Related variables in formula questions in Canvas Question Forum
- Canvas Release Archive in Canvas Releases
- Issues with editing a formula question in Canvas - it won't let me take out a variable in Canvas Question Forum
- Variable value in 'insert equation' not displayed in formula question quiz in Canvas Question Forum
- When creating Formula quiz questions, can Canvas generate values for variables in multiples? in Canvas Question Forum

- Reference
- Community Guidelines
- Security
- Developers
- Open Source