CSV Import in Atomic Assessments

Atomic Assessments allows you to upload CSV files containing question data into the Content Manager. This feature enables batch creation of questions for use in assessments.

Atomic Assessments allows you to upload CSV files containing question data into the Content Manager. This feature enables batch creation of questions for use in assessments. More information can be found here.

How to Upload a CSV File

  1. Navigate to Atomic Assessments and go to the Content Manager tab.
  2. Click the three-dot menu and select Add Content.
  3. Click Select File and choose your CSV file.
  4. Click Upload File to start the import process.
  5. Once the import is complete, navigate to the Items tab to find the newly added questions.

Overwriting Existing Questions

If the Question ID column is set in your CSV file, subsequent imports with the same Question ID will overwrite the existing question in that course. This prevents duplication of questions when the same content is imported multiple times.

Handling Missing Data

Columns that are not included in your CSV file will be skipped during import, but will not prevent the file from being uploaded. Any missing data will not be included in the uploaded questions.


CSV Format and Column Definitions

The CSV file must follow a specific format and needs to be encoded for UTF-8. The only required columns are Question Text, Option A, Option B, and Correct Answer.

Example CSV Data

Question ID

Title

Question Text

Question Type

Option A

Option B

Option C

Correct Answer

Points

101

Sample Question 1

What is 2 + 2?

Multiple choice

3

4

5

B

1


Supported CSV Columns

Column Name

Description

Required

Example

Question ID

External question ID. If omitted, a random ID is generated.

No

101

Title

Item title.

No

Question 1

Question Text

Question stem.

Yes

What is 2 + 2?

Question Type

Currently supports "Multiple choice".

No

Multiple choice

Template

Question type template: 

- Standard

- Block layout

- Multiple response

- Block layout multiple response

- Choice matrix

- Choice matrix inline

- Choice matrix labels 

Default: "Standard"

No

Standard

Correct Answer

Correct response (e.g., "A"). For multiple response questions, use a semicolon separator (e.g., "A;C;D").

Yes

B

Points

Question points.

Default: 1.

No

2

Option A

Text for option A.

Yes

3

Option B

Text for option B.

Yes

4

Option C

Text for option C.

No

5

Option [D-O]

Text for additional options.

No

6

Option A Feedback

Feedback for option A.

No

Incorrect.

Option B Feedback

Feedback for option B.

No

Correct!

Scoring Type

Learnosity scoring type: - Partial Match Per Response- Partial Match- Exact Match Default: "Partial Match Per Response"

No

Exact Match

Shuffle Options

Whether to shuffle answers ("Yes" or "No"). Default: "No".

No

Yes

General Feedback

General feedback.

No

Great job!

Correct Feedback

Feedback for correct responses.

No

You got it!

Incorrect Feedback

Feedback for incorrect responses.

No

Try again.

Distractor Rationale

Explanation for incorrect choices.

No

Option C is a common misconception.

Stimulus Review

Review-only stimulus.

No

Background information

Acknowledgements

Acknowledgements.

No

Source: XYZ

Instructor Stimulus

Instructor-only stimulus.

No

Teaching note

Sample Answer

Example response.

No

4

Description

Item description.

No

Basic math question

Tag: tag_type

Tags for categorization. This column can be repeated with different tag types.

No

Math

Alignment URL

URL for standard alignment tags. Can be repeated. If this is a path it’s converted to a URL internally.

No

"https://example.com/standards/math"

OR

“/standards/math”