From the Assessment setup page or the Settings page, you may export the assessment’s entire comment library or comments from a specific question to a CSV file. This file can be used for analysis or imported to other assessments in Crowdmark.
To import and export comments from a CSV navigate to the Assessment setup page, or the Settings page.
Exporting comments
- From your Assessment setup page, click Manage comment library in the Comment Library panel found at the bottom right hand side.
- Select which question(s) you would like to export the comments from, or select Export library. If there are no comments existing, you may click Export library to export a blank CSV containing the necessary column headers.
- Click the Export question button to download a CSV file.
The comment library export file will contain the following headings:
- Label: The question label that the comment is associated with.
- Version: Which version of the question this comment applies to. This column will only appear if there are randomized question versions in use. Duplicate comments across versions will appear as separate, but will be linked in the comment library to preserve the bulk-edit option. Comments from any version are available across all versions.
- Comment: The comment text.
- Points: Points associated with the comment or blank if no points are associated.
- Shared: “true” if the comment has been shared with the team or “false” if not.
- Times used: The number of times the comment has been used by all graders in the assessment.
Comments CSV without randomized question versions
Comments CSV with randomized question versions
Importing a library of comments
Note: All comments with the Shared column set to “true” will be shared with your grading team. The Times used column of the CSV file is not required and will be ignored when importing the file.
- Open your CSV file of comments and change the question labels in the Label column to match the question labels in your assessment, if needed. Crowdmark needs the correct labels to know which question each comment is associated with.
- From your Assessment setup page, click Manage comment library in the Comment Library panel found at the bottom right hand side.
- Ensure that All questions (entire library) is selected. Click the Import library from CSV file button.
- Select your CSV file. You will see a message with the number of comments that were detected in the file.
- If the filename and number of comments looks correct, click the Yes, import comments to library button
- You will see a message confirming the number of comments uploaded to each question.
Importing comments to a specific question
Note: All comments with the Shared column set to “true” will be shared with your grading team. The Label and Times used columns of the CSV file are not required and will be ignored when importing the file.
- From your Assessment setup page, click Manage comment library in the Comment Library panel found at the bottom right hand side.
- Select which question you would like to import the comments to, and click the Import question from CSV file button.
- Select your CSV file. You will see a message with the number of comments that were detected in the file.
- If the filename and number of comments looks correct, click the Yes, import comments to question button.
- You will see a message confirming the number of comments uploaded.
Deleting unused comments
If you make a mistake or upload the wrong file, you can click the Delete all unused comments button. This will remove comments that have not been placed on student work, including any comments that you or your graders have created through the comment library but have not used.
Troubleshooting import issues
Your CSV file must include the Label (if importing an entire library) and Comments columns. If any data is missing or if there is an issue with the file the import will not work until the issues are resolved.
You may encounter the following errors:
- The file must be in .csv format: If you are uploading an Excel or similar file, please save it as a CSV.
- Row 1 is missing data for Comment: This error appears if a row is missing some required information (Comment text, Label, etc.)
- The file is missing a Comment column: The specified column is either missing or incorrectly named. If the column name looks correct, ensure that there are no extra spaces in or around the text.
- Unknown error: This error appears if one of your question labels is incorrect or if there is a connection issue.
