4 - Grading and Viewing Results

Exporting Grade Data

You can export student grade data as CSV files. CSV (comma separated value) is a simple file type that can be read by nearly all text editors, spreadsheet, and database programs, including Microsoft Excel and Apple Numbers. You can export grade date in General format or in a format that is ready to upload into your course management system. For details on specific course management systems, please see the related documentation available at iclicker.com.

To export your student grade data:

  1. From the i>grader Home Page, click Export Export Button.
  2. The Export Session Data window appears. Click the checkbox(s) next to all session that you want to export or click Select All to export all session data.

    Export Session Data, Steps 1 and 2 Window
    Export Session Data, steps 1 and 2
  3. In addition to exporting data in the primary output format, you may also choose to export another file formatted for Sapling Learning. See the i>clicker manual export documentation for Sapling Learning for additional details about this option.
  4. If i>grader is configured to output general formatted data, click the Next button and continue with the next steps.
Note

NOTE: If i>grader is configured to output data formatted for a CMS, the button label will read Export. Click this button and you will be shown a confirmation message with the location of your exported file(s). The remaining steps do not apply to CMS-configured outputs. Refer to the i>clicker documentation for your CMS for additional details.

  1. The Export Session Data, step 3 screen appears. Select the Student Data, Session Data (data for each individual session), and Aggregate Data (the combined performance points, participation points, and total point for all the selected sessions) to be exported.

    Export Session Data, step 3
    Export Session Data, step 3
Note

NOTE: The Export Session Data, step 3 options are only available when you are using i>clicker with the General/Non-CMS setting. If you are exporting i>clicker data in a format specific to your campus CMS, you will only be able to export the total points for each individual session and the aggregate points for all or selected sessions.

  1. Click Export.
  2. The Save Export File window appears. Select the filename and folder location in which to save the exported file. (By default, the export file is named UploadFile.csv and is saved in your class folder.
Note

NOTE: By changing the filename each time you save an exported file you can keep a history of your exports. For example, you might choose to add today's date at the end of each export (SessionExport_11_24_10.csv).


Sample Exported Report in Excel
Sample data export in Microsoft Excel

Note

NOTE: Your file may be saved/named slightly differently if you are using i>clicker with your campus course management system (and have followed the steps required to enable i>clicker files to be formatted for your particular course management system).