9. Data download

This section of the LMS student dashboard will allow learners to download different types of reports.

9.1. 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

9.2. 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.

9.3. 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

9.4. 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

9.5. 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.

9.6. 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

9.7. Other reports

9.7.1. 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

9.7.2. 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