> ## Documentation Index
> Fetch the complete documentation index at: https://docs.fermion.app/llms.txt
> Use this file to discover all available pages before exploring further.

# CSV Report

> Export comprehensive student enrollment and progress data as CSV files, including enrollment dates, course completion status, and detailed section-wise progress for assignments, ebooks, videos, and labs.

The CSV Report feature allows you to export detailed student enrollment and progress data in a structured CSV format, making it easy to analyze student performance, track completion rates, and generate custom reports using spreadsheet applications.

## How to access CSV Report

<Steps>
  <Step title="Navigate to Courses">
    Click on the `courses` tab from your instructor dashboard.
    ![step1](https://67d6ad5ef66ee0901532fd2f.storage.fermion.app/public-uncached/object-store-public-files/uploads/24-11-2025/Arc_ki0uTdwbC8.yepsuj.png)
  </Step>

  <Step title="Select the course">
    Click on the course for which you want to export student data.
    ![step2](https://67d6ad5ef66ee0901532fd2f.storage.fermion.app/public-uncached/object-store-public-files/uploads/24-11-2025/Arc_IrEIbG0yCp.hiuiwj.png)
  </Step>

  <Step title="Open the Students tab">
    You will find the `students` tab in the left sidebar of the course page. Click on it to access student management.
    ![step3](https://67d6ad5ef66ee0901532fd2f.storage.fermion.app/public-uncached/object-store-public-files/uploads/24-11-2025/Arc_S34981YOnT.wxrpff.png)
  </Step>

  <Step title="Select Exported reports tab">
    Once you're inside the `students` tab, you'll see three tabs at the top: "Students", "Overall progress", and "Exported reports". Click on the `Exported reports` tab to access CSV export functionality.
    ![step4](https://67d6ad5ef66ee0901532fd2f.storage.fermion.app/public-uncached/object-store-public-files/uploads/24-11-2025/Arc_GSCbwHNN4o.hhyguq.png)
  </Step>
</Steps>

## CSV Report Structure

The exported CSV file contains comprehensive student data organized into the following columns:

### Student Information

* **Student Name**: The student's full name or nickname
* **Student Email**: The student's registered email address
* **Student Phone**: The student's contact phone number (if available)
* **Enrollment Date**: The date when the student enrolled in the course
* **Last Active Date**: Timestamp of the student's last activity on the platform

### Course Completion Overview

* **Total Course Items**: Total number of course items (videos, assignments, labs, ebooks, etc.) in the course
* **Completed Course Items**: Number of course items the student has completed
* **Completion Percentage**: Overall course completion percentage calculated from completed vs. total items

### Section-wise Progress Details

The CSV report includes detailed progress information for each course item, organized by section. Each item follows a structured column naming format: `(Section X) [Y] ITEM_TYPE - DETAIL`, where:

* **X** represents the section number (e.g., Section 1, Section 2)
* **Y** represents the item type identifier (a numeric code that identifies the type of content)
* **ITEM\_TYPE** indicates the type of content (IO LAB, ASSIGNMENT, EBOOK, VIDEO, INTERACTIVE LAB)
* **DETAIL** specifies the type of information (Type, Completed, Score, Completed At, etc.)

<AccordionGroup>
  <Accordion title="IO Labs">
    <ul>
      <li><b>(Section X) \[Y] IO LAB - Type</b>: The type or category of the IO Lab</li>
      <li><b>(Section X) \[Y] IO LAB - Completed</b>: Completion status (Yes/No)</li>
      <li><b>(Section X) \[Y] IO LAB - Score</b>: The score obtained for the IO Lab</li>
      <li><b>(Section X) \[Y] IO LAB - Completed At</b>: Timestamp of when the IO Lab was completed</li>
    </ul>
  </Accordion>

  <Accordion title="Assignments">
    <ul>
      <li><b>(Section X) \[Y] ASSIGNMENT - Type</b>: The type or category of the Assignment</li>
      <li><b>(Section X) \[Y] ASSIGNMENT - Submitted</b>: Submission status (Yes/No)</li>
      <li><b>(Section X) \[Y] ASSIGNMENT - Marks</b>: The marks obtained for the Assignment</li>
      <li><b>(Section X) \[Y] ASSIGNMENT - Submitted At</b>: Timestamp of when the Assignment was submitted</li>
    </ul>
  </Accordion>

  <Accordion title="Ebooks">
    <ul>
      <li><b>(Section X) \[Y] EBOOK - Type</b>: The type or category of the Ebook</li>
      <li><b>(Section X) \[Y] EBOOK - Completed</b>: Completion status (Yes/No)</li>
      <li><b>(Section X) \[Y] EBOOK - Completed At</b>: Timestamp of when the Ebook was completed</li>
    </ul>
  </Accordion>

  <Accordion title="Videos">
    <ul>
      <li><b>(Section X) \[Y] VIDEO - Type</b>: The type or category of the Video</li>
      <li><b>(Section X) \[Y] VIDEO - Duration (seconds)</b>: The total duration of the video in seconds</li>
      <li><b>(Section X) \[Y] VIDEO - Completed</b>: Completion status (Yes/No)</li>
      <li><b>(Section X) \[Y] VIDEO - Completed At</b>: Timestamp of when the Video was completed</li>
    </ul>
  </Accordion>

  <Accordion title="Interactive Labs">
    <ul>
      <li><b>(Section X) \[Y] INTERACTIVE LAB - Type</b>: The type or category of the Interactive Lab</li>
      <li><b>(Section X) \[Y] INTERACTIVE LAB - Completed</b>: Completion status (Yes/No)</li>
      <li><b>(Section X) \[Y] INTERACTIVE LAB - Score</b>: The score obtained for the Interactive Lab</li>
      <li><b>(Section X) \[Y] INTERACTIVE LAB - Completed At</b>: Timestamp of when the Interactive Lab was completed</li>
    </ul>
  </Accordion>
</AccordionGroup>

## Understanding the Data

### Column Naming Convention

The section-wise columns use a consistent format that makes it easy to identify:

* Which section the item belongs to
* The item type identifier (numeric code)
* The type of content (Lab, Assignment, Ebook, Video, etc.)
* The specific metric being tracked (Type, Completed, Score, Duration, etc.)

### Data Values

* **Completion/Submission Status**:
  * **Yes**: The student has completed/submitted the item
  * **No**: The student has not completed/submitted the item

* **Scores and Marks**: Numeric values representing the student's performance on graded items

* **Duration**: For videos, this shows the total video length in seconds

* **Timestamps**: ISO format timestamps (e.g., "2025-11-05T11:55:13.021Z") indicating when an item was completed or submitted

* **Completion Percentage**: A calculated value showing overall course progress as a percentage