The Export function for Cornerstone creates one Excel file per Group of Questions, plus an extra file containing all the questions.
By default, the created files are CSOD Edge files that you can import on CSOD. You can select the option to create legacy CSOD files.
All files are created on the sub-folder “IR_quiz_editor_export”.
Exported files name convention: CSOD_Edge_[sheetname].xlsx
Exported file for all questions: CSOD_Edge_QuestionsOfAllGroups_Concatenated.xlsx
During the export process for Edge CSOD the tool asks you to enter the CSOD category IDs. Some of you do not know them so leave the fields empty. But other persons know in advance the Edge CSOD IDs and may want to enter them directly once and for all on a cell for each group of questions. There is a specific cell in each questions sheet that is reserved to contain the CSOD category Id. This cell is located in Q1. In any case, that cell will be filled by the tool if you specify the ID during the export process itself.
Columns of excel file created by the tool :
Question Reference Number |
Question number : a string generated by the tool |
Question Text |
Question stem |
Question Type |
Value |
Correct Answer |
Keys |
Category Id |
Value |
Default Language |
en-US |
Active |
True |
Randomize Answer Choices |
True |
Answer Explanation |
Value |
# of Answer Choices |
Value |
All of the Above |
Empty |
None of the Above |
Empty |
Answer 1..Answer 10 |
Value |
Image Filename |
File name of questions’s illustration |
Answer Coordinates |
Empty |
Apply partial scoring |
Empty |