***************
Data download
***************

The **Data Download** section of the LMS instructor dashboard will allow instructors with the right permissions to download different types of reports.

.. note::  Starting in the Juniper version of the open edX platform (2020), this section of the LMS instructor dashboard is only accessible for users that in addition to being staff or admins in the course, explicitly have the **Course Data Researcher** role.   This role can be added to a user in the course from the **Membership** tab.

Each of the reports available will be listed in the **Data download** tab with a short explanation and once selected, it will be generated and presented for being downloaded at the bottom of the page.
Most reports will come in .csv format, which can be easily opened with most spreadsheet processing programs or with any text editor.

Learner profile information
###########################

This is a very useful report that will list all the profile information of learners enrolled in the course. It will contain the following columns:

- id
- username
- name
- email
- language
- location
- year_of_birth
- gender
- level_of_education
- mailing_address
- goals
- enrollment_mode
- verification_status
- last_login
- date_joined
- team
- city
- country


Anonymized Students
######################

This is a very specific report that will list the anonymized learner ids.
It will contain the following columns:

- User ID: Numeric id in the system
- Anonymized User ID:  Which will be the same for a learner across all their courses.
- Course Specific Anonymized User ID:  Which will different for a learner in each one of their courses.


Users who can enroll
####################

This report will list the people that has been invited to the course, but have not yet registered into the platform, so the actual enrollments are still pending. 
It will contain only one column:

- email

CSV of Problem responses
###########################

This is a report that will list all the responses a particular problem has received. It will contain the following columns:

- username
- title
- location
- Answer
- Answer ID
- Correct Answer
- Question
- block_key
- state


Grade report
################

This is key report that will list the main learner profile fields, the total grade and the computed grade for each of the graded subsections in the course.

It will contain the following columns:

- Student ID
- Email
- Username
- Grade: The total computed grade for the learner in the course
- Graded subsection #1: The grade for this graded subsection
- Graded subsection #2: The grade for this graded subsection 
- Graded subsection (Avg): The computed average for all the graded subsections in this assignment type
- Experiment Group (A/B test)
- Team Name
- Enrollment Track
- Verification Status
- Certificate Eligible
- Certificate Delivered
- Certificate Type
- Enrollment Status


Problem grade report
#####################

This is key report that will list the main learner profile fields, the total grade and the learner score in each problem across all graded subsections in the course.

It will contain the following columns:

- Student ID
- Email
- Username
- Enrollment Status
- Grade
- Assignment type 1: Problem type - Problem name (Earned)
- Assignment type 1: Problem type - Problem name (Possible)
- Assignment type 1: Problem type - Problem name2 (Earned)
- Assignment type 1: Problem type - Problem name2 (Possible)

.. note:: For each problem the report will have 2 columns, one with the earned score for each learner and one with the maximum possible number of points a student could gain in said problem.


ORA data report
################

This is report will list the anonymized list of submissions to Open Response Assessment problems and the feedback they collected. 
This report cannot be read in the form of a spreadsheet, as some of the fields will come in the form of a JSON value.
It will contain the following columns:

- Submission ID
- Item ID
- Anonymized Student ID
- Date/Time Response Submitted
- Response
- Assessment Details
- Assessment Scores
- Date/Time Final Score Given
- Final Score Points Earned
- Final Score Points Possible
- Feedback Statements Selected
- Feedback on Peer Assessments


Other reports
################


Certificates issued
********************

This is report will not list the details of the certificates issues, but the aggregated number of certificates only. 

The columns in the report are:

- CourseID
- Certificate Type
- Total Certificates Issued
- Date Report Run


Proctored exams results report
*******************************

This report is only relevant when using Proctored exams and will contain the following columns:

- course_id
- provider
- track
- exam_name
- username
- email
- attempt_code
- allowed_time_limit_mins
- is_sample_attempt
- started_at
- completed_at
- status
- review_status
- Suspicious Count
- Suspicious Comments
- Rules Violation Count
- Rules Violation Comments