Overview of Assessment Export .CSV File

The assessment .CSV file provides information related to both the students and the specific assessment scores listed with a Completed tab. You will need to make modifications to the format in order prepare the file for upload/import to your campus LMS. You can quickly scan for at-risk students or problematic topics by filtering Assessment Title fields.

The following student info is provided:

1. First Name
2. Last Name
3. Student ID
4. Total Points Earned and Possible
5. Completed Assessment Info:
   1. Assessment Title
   2. Point Value
   3. Point Awarded
   4. Date of Assessment

Quick Tips and Tricks:

How to Identify Problematic Assessments Quickly with Filters

• STEP 1: Cut and Paste your Title fields down on top of the scores and add Filters
  • Click here for Microsoft Excel
  • Click here for Google Sheets
• STEP 2: Highlight the assessment column scores and apply the Excel Conditional Formatting tool shown below

How to Find At-Risk Student Using a Heatmap (Same Tool as Above)

• STEP 1: Cut and Paste your Title fields down on top of the scores and add Filters
  • Click here for Microsoft Excel
  • Click here for Google Sheets
• STEP 2: Highlight the assessment column scores and apply the Excel Conditional Formatting tool shown below