Assumptions:

• there exists a course, course 1, with completion tracking enabled and a page activity, activity A.
• Course 1 has enrollments for a teacher (Foo) and multiple students (Bar and Baz).
• Tester has access to a program capable of opening Excel-compatible CSV for verification of Excel-compatible functionality (step 6.2)

Scenario 1: Test viewing a single user completion in a user profile.

1. Log in as teacher Foo
2. Go to student Baz's course 1 profile page
   1. From the course front page, go to the Participants list
   2. Find the row with student Baz and click student Baz's username
3. Verify a link to "Activity completion" appears in the Reports section
4. Click the "Activity completion" link in the Reports section
5. Verify the Activity completion report shows only student Baz
6. Verify the CSV download links contain only student Baz
   1. Verify the UTF-8-compatible CSV contains only student Baz
      1. Click the "Download in spreadsheet format (UTF-8 .csv)" link
      2. Download the CSV file, opening it in the editor of your choice
      3. Verify the file from 6.1.2 contains 2 lines: the header line and the line with student Baz
   2. Verify the Excel-compatible CSV contains only student Baz
      1. Click the "Download in Excel-compatible format (.csv)" link
      2. Download the CSV file, opening it in Excel
      3. Verify the file from 6.2.2 contains 2 lines: the header line and the line with student Baz

Scenario 2: Test filter user in the completion report

Setup:

1. Login as admin
2. Go to the completion report
3. filter user on the participant option.

Expected:

1. The filter should filter right the user we have choose in the participant option
2. Verify the UTF-8-compatible CSV contains only student Baz
   1. Click the "Download in spreadsheet format (UTF-8 .csv)" link
   2. Download the CSV file, opening it in the editor of your choice
   3. Verify the file only contains your value of the user data you have selected
3. Verify the Excel-compatible CSV contains only student Baz
   1. Click the "Download in Excel-compatible format (.csv)" link
   2. Download the CSV file, opening it in Excel
   3. Verify the file only contains your value of the user data you have selected

These are effectively the same as the included Behat tests.

UI Expected:
Activity completion report:

 UI profile in Course > participants > profile user

 
 
 

Code verified against automated checks.

Checked MDL-72240 using repository: https://github.com/danghieu1407/moodle

• main (0 errors / 0 warnings) [branch: MDL-72240-master | CI Job]

_{More information about this report}

Built on: Tue Jan 21 02:06:34 AM UTC 2025

Launching automatic jobs for branch MDL-72240-master

• https://ci.moodle.org/view/Testing/job/DEV.02%20-%20Developer-requested%20PHPUnit/17995/ PHPUnit (sqlsrv / complete)
• https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/61473/ Behat (NonJS - boost and classic / complete)
• https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/61474/ Behat (Firefox - boost / complete)
• https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/61475/ Behat (Firefox - classic / complete)
• https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/61476/ App tests (stable app version) / complete) --> unrelated

Built on: Tue Jan 21 02:01:44 AM UTC 2025