Archive

Posts Tagged ‘debugging’

How to identify graded participants in Moodle Course Activity Reports using Vlookup

  1. Having a chart of full names, Moodle id # and usernames would be useful (e.g. for debugging with the Activity Reports that in some cases do not resolve Moodle id# so Excel vlookup has to rescue the day once again…)
  2. The Moodle “Participants” affords the instructor a convenient list, with paging, sort, filter (by role), and different detail-level views.
  3. However, the overview does link course and student id #, but not institutional username while the detail view contain the username as part of the email, but is not truly tabular (consists of an array of tables, each containing one user; at least you can avoid the paging).
  4. Enter grepwin to extract the emails:

    grep-emails

  5. and copy paste them into the Excel created from the tabular overview:
  6. lookupIs there an easier way?