![phraseexpress export as csv file phraseexpress export as csv file](https://www.macrorecorder.com/site/assets/files/1576/mr2_pex15_mr.png)
The main reason I prefer the equation editor for this particular question bank is aesthetic - I think that the formatting looks better and is easier to read. I did consider using plain text, and I found the infinity alt code. Thank you for the suggestion, I will look into the spreadsheet approach. I should probably do a write-up about this as a blog post, but hopefully it will give you enough information to get moving. If you get an error that the CSV file can't be read, you might need to close the Excel file first. Then in Respondus, I did the CSV import as HTML. I did minimal HTML entity escaping, although it looks like the only thing that had to be escaped were the ampersand the quote mark.įunction CanvasEquation(t As String) As String I didn't have to add img as a separate variable, but I did just in case I wanted to do something else with it later. It's not pretty, but it works for the elementary stuff.
#Phraseexpress export as csv file full
Go back to the full file before doing more editing. Save the whole spreadsheet and then save just the first sheet as a CSV. Don't make the mistake of only saving the CSV, you'll lose all your formulas. Then, when you save the file, be sure to save it as an. To use the code, Press Alt-F11 in Excel, then go to Insert > Module and paste the code. I wrote a helper function called CanvasEquation using VBA to generate the image link. Here are the formulas for some of the key spotsĮ2: ="(x"&IF(A2Where does the graph of the rational function "&CanvasEquation(I2)&" cross the x-axis?" I can't have extra stuff on the sheet exported as a CSV. The question and choices are copied from another sheet where I did my scratch work. Here's a mostly useless snapshot of what I imported as a CSV. Below are some of the details.Īnd here is what it looks like when you're editing the question. It is possible to generate a quiz question involving equations using Excel, bring it into Respondus, and then export it into Canvas. I hoped that it might be an easier way to create multiple questions like this, but since it also uses an equation editor for equation objects, I doubt that it will be much of a time/effort savings.Īs a followup - we have moved from the realm of theoretical into proof of concept.
#Phraseexpress export as csv file how to
We do have a campus license for Respondus, which I just recently downloaded and haven't really learned how to use yet. I have a feeling there is no breezy way to accomplish what I'm trying to do here. If there were a way to export the questions into some kind of text format, edit the text (even if it means editing the html for the equation objects?) using copy and paste, etc, and then import it BACK into Canvas, it would be SO much easier.Īlternatively, if there were a way to use variables inside equation objects (the way we can for formula questions), AND then use those same variables in multiple choice answer options, this would be a BREEZE.
![phraseexpress export as csv file phraseexpress export as csv file](https://barcodetopc.com/wp-content/uploads/import_csv_4.png)
Since all of the items that need to be edited are inside equation objects, I don't know if there is an easier way to do this.
![phraseexpress export as csv file phraseexpress export as csv file](https://www.phraseexpress.com/site/assets/files/1352/pex_dyn_folder.png)
move the questions from the temporary bank back to the "real" bank edit EVERY equation in each of the 4 questions and answers (approximately 28 edits, just for one new "set" of 4 questions)ģ.
![phraseexpress export as csv file phraseexpress export as csv file](https://www.geckoandfly.com/wp-content/uploads/2019/04/autohotkey.jpg)
copy each question into a temporary new bank (since I can't just "duplicate" a question in the same bank)Ģ. The only way I know how to do this is to:ġ. Now, I want to load up the question bank with several more versions, where I just change the 7 to other numbers e.g., duplicate these 4 questions maybe another 5-8 times. All of the expressions, both in the question and the answer, are done with equation editor. The first two versions have 8 identical answer choices (6 of which are sets involving a "7"), and the last 2 have the same answer choices, but with closed intervals instead of open. I have 4 similar multiple choice questions, e.g.: "What is the solution set to the inequality: |x|>7" and then additional versions that use |x|=7. As an example, I am working on a question bank with absolute value inequality questions. The best way to ask this question is to explain what I'm trying to do.