Course completion report Excel download should include BOM to ensure correct character encoding

Prerequisites

You will need access to Microsoft Excel. The version available in Office 365 is suitable.

Steps

1. Create a course.
2. Add an activity to the course for example a quiz called "Quiz 1".
3. In the course:
   1. Select the ⚙ menu (Actions) and select Course completion.
   2. Under Condition: Activity completion select the activity created in step 2 and click Save changes.
4. Add a user:
   1. Username: yuri
   2. First name: Юрий (copy and paste this text if needed)
   3. Surname: Гагарин (copy and paste this text if needed)
   4. Email address: yuri@example.com
5. Enrol user yuri on the course.
6. In the course:
   1. Select the ⚙ menu (Actions) and select More....
   2. Under Reports select Course completion.
   3. Click the link Download in Excel-compatible format (.csv) and save the file.
7. Open the downloaded CSV file in Microsoft Excel.

Expected results

In Excel ensure the Name column contains "Юрий Гагарин".