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?

Protected: Students still in wrong time zones in live@edu

2012/02/22 Enter your password to view comments.

This content is password-protected. To view it, please enter the password below.

Farsi phonetic input using Behnevis

  1. Behnevis.com (web form or downloadable Google Chrome browser toolbar) offers transliteration of phonetic input in Roman letters into Farsi and is said to be on a par with Google translate  (which offers no toolbar) and MS-UIME (which has no toolbar, but can be installed in your browser to alter any web page for users lacking a physical Farsi keyboard (or overlay).
  2. Behnevis- easy farsi transliteration (pinglish) editor

LRC student staff start of term training: The PowerPoint

Protected: Moodle streaming video recording assignment glitches 3, 4, 5, 6, 7 & 8: A running log

2012/02/21 Enter your password to view comments.

This content is password-protected. To view it, please enter the password below.

How to display Furigana phonetic guide for Japanese Kanji in MS-Word 2010

2012/02/21 1 comment
  1. Furigana uses Kana (usually Hiragana) to phonetically transcribe Kanji, above (for horizontally written Kanji) or to the right (if in vertical writing mode), for special characters or audiences (children and second language learners).
  2. In MS-Office, if you have a Japanese Input Method Editor selected in MS-Windows, select some Kanji and in the ribbon, under tab: home, section: font; click on the Phonetic guide, to bring up a dialogue that attempts to auto detect the furigana.
  3. You can make adjustments there, click “OK “to insert. Like so:
  4. japanese-furigana

Protected: Moodle-Kaltura webcam recording assignment results

2012/02/20 Enter your password to view comments.

This content is password-protected. To view it, please enter the password below.

How to use Google translate for writing Cyrillic letters with a western keyboard, pronunciation help, and text-to-speech

Go to  Google translate and do like so. Useful for learning, as well as typing when teaching.