Thomas' Work Space

See what I mean: Downloading and browsing the full content XML is of course more powerful than this.

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:
   

   ---

   

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

1. Problem: Why is a user opening a spreadsheet in the browser (even if with edit.aspx URL) causing a warning "The spreadsheet is locked by another user" if i try to open it in MS-Excel?  I thought Excel Web App allows multiple uses to edit the spreadsheet at the same time?
2. Solution: Opening the spreadsheet for editing in the browser still locks it for being opened in MS-Excel (and vice versa), but not for opening it for editing in another browser.

1. The Educause ECAR for 2011 Lists among its top actionable survey results: “Nail the basics. Help faculty and administrators support students’ use of core productivity software for academic work.
2. Not a language learning specific result , but a reminder also for the LRC to prioritize:
1. LRC posts on “productivity software”,
2. and most of our students’ “academic work” lives online in Moodle.

(Sorry, no Excel option in the sourcecode formatter on WordPress. Also not sure where I found this in 2005).

1. The LRC lists are built with MS-Excel Web app, one of the new features which came with NINERMAIL (live@edu, try logging into http://skydrive.com .
2. Important benefits of MS-Excel Web app include
   1. sorting: click on column header / down arrow, and choose menu item: “Sort Ascending/Descending”
   2. filtering: click on column header / down arrow, and choose menu item:
      1. either “filter”, , to choose from a condensed overview of all unique items that occur in the column, and e.g. filter out “Blanks” by removing the checkmark in front of it:
      2. or the advanced “number filter” (in columns with numbers) or “textfilter”, , to do more advanced searches, like for all items that contain “camera”:  
      3. sharing beyond viewing: Authorized users can click on an “edit link” below the list display to update the information from their web browser.

1. Let the computer finish its startup tasks:
1. Browsers: both internet Explorer and Firefox will open on relevant pages, since you and your client will have to work in different browsers, ensuring that both your and your client can be logged into different NINERNET accounts.
2. Excel will load a checkin.xlsm. In Excel, under the ribbon, press button:"Enable content". Use this to generate codes that you can paste into users"’ meeting requests when they check in and out LRC equipment. The spreadsheet will not save the codes since your computer is frozen.
3. A program called bginfo will analyze the computer settings and display the results on the desktop
4. ZoomIt: press “ok” on the startup dialogue. You can now press CTRL-2 (thanks Ashley) and drag the left mouse button (ESC to stop) to paint on screen to communicate with client across mirrored screens, and vice versa.
2. Do you have a client at the counter?
1. yes: press CTRL-ALT-F10 to clone/mirror (= show the same screen on) both monitors. You can now collaborate with the client using a computer (e.g. in OWA or in a database)
2. no client: press CTRL-ALT-F11  to extend the desktop. You can now display an informational window on the LRC-facing monitor, while working on your own monitor in privacy.
3. The reception computers use Deepfreeze. You cannot save information on reception desk computers between reboots.
1. All personal information you want to save needs to go to your H: drive.
2. All information you want to share with LRC staff needs to go into LRC Moodle site, UNCC-LRC website or NINERMAIL.

“A game fit for playing at work”? I am game!

Easy to tell after a couple of rounds that this constitutes a nice effort, but…

I wish the Excel Ribbon Hero game would remember – after all, Office 2010 still does, thank you! – the Office 2003 keyboard shortcuts, like for Data / Sort.

Or do you really think I needed a hint to sort a table in Excel?

“Right, but is the game called Excel Keyboard Shortcut Hero?”. Oh well, I earned my points via the context menu, that is not a Ribbon feature either, is it?

How to make formative assessment quizzes for face-to-face teaching settings like in the examples here?

Part I: quiz_dot_create_excel: Watch a screencast on How to ready target language subtitle source material for the quiz template

Part II: Watch a screencast on How you can apply your pedagogy with ease  to a text and transform the same to a quiz, and how the student benefits from both

Part III: Watch a screencast on How you can revise your pedagogy

Part I: quiz_dot_create_excel: Watch a screencast on How to ready target language subtitle source material for the quiz template

Part II: Watch a screencast on How you can apply your pedagogy with ease  to a text and transform the same to a quiz, and how the student benefits from both

Part III: Watch a screencast on How you can revise your pedagogy