MasteryConnect Khoros

How do I export assessment data to a CSV File as a Mastery Connect admin?

Updated

As a Mastery Connect admin, you can export formative or benchmark assessment data as a CSV file. Assessment data CSV files include each student's school, teacher, tracker, ID, overall score, overall number of points possible, and item responses for each standard-aligned item. You can also include student demographic information in the downloaded data.

You can export one or more assessments at a time. The exported data downloads as a ZIP file containing a CSV for each assessment.

Open Admin

Open Admin

In the Global Navigation Menu, click the Admin link.

Open Assessment Type

Open Assessment Type

Hover over the Assessments tab [1] and select the type of assessment you want to export.

To export scores for a benchmark assessment, click the Benchmarks link [2]

To export scores for a formative assessment, click the Formative link [3].

Select Assessment

Select Assessment

In the Benchmark or Formative Assessments page, locate the assessment(s) with scores you want to export. To narrow the displayed list of assessments, you can use the available search [1] and filter options [2].

To select an assessment to export scores, click the assessment's checkbox [3]. You can select multiple assessments at one time. To select all displayed items, click the All checkbox [4].

Select Assessment in Grid View

Select Assessment in Grid View

If your Assessments page displays assessments in grid view, you can still select assessments to export. Locate the assessment(s) with scores you want to export. To refine the displayed assessments, use the available search [1] and filter options [2].

Hover over the assessment preview [3]. Then click the Include in Export checkbox [4].

Export Scores as CSV

Download Scores as CSV

Click the Export menu link [1]. Then click the Export to CSV link [2].

Export Scores

Export Scores

In the Export Scores window, enter a name for the export file in the Export Name field [1].

Click the radio button of one of the following export formats:

  • Classic format [2]: export contains standard alignment, points possible, student scores, and student item responses.
  • Expanded format [3]: export contains standard alignment, points possible, student scores, student item responses, and student demographic information.

Click the Export button [4].

Note: Expanded format exports include the following demographic data for benchmark assessments: gender, race, ethnicity (Hispanic or Latino), FRL, IEP, and ELL.

View Data Export Status

View Data Exports

The Data Exports page opens to display the CSV Downloads tab [1]. While the system processes the data export, an Export Progress bar [2] and Queued icon display [3].

Manage Export

Manage Export

When the file is exported and ready for download, the Status displays a Success icon [1].

To download a ZIP file containing the CSV file(s), click the Download icon [2]. The downloaded ZIP file is named in the following format according to the date of the export, time of the export (universal time), and the export name: MM-DD-YYYY_Hour_Min_Sec-[export name].zip.

If an assessment includes new data, you can re-run the data export. Click the Re-Send icon [3].

To remove the CSV download from the CSV Downloads list, click the Delete icon [4].

View CSV Download  

View CSV Download

Open the ZIP file and view the downloaded CSV file for each assessment in the export.

Notes:

  • CSV files contained in the ZIP file are named in the following format according to the name of the assessment, the assessment ID, and date of the export: [assessment name]_[assessment ID]_YYYY-MM-DD.csv.
  • Assessment and export names in the exported files include underscores in place of spaces.
Previous Article How do I export assessment data via SFTP as a Mastery Connect admin?
Next Article How do I view and manage my institution's managed data connections as a Mastery Connect admin?