Archive
Learning materials management: Online_resources.xls I: Intranet (2003-2009)
Language labs tend to have many multimedia files (audio and video) on network shares – still more flexible than the web-based interfaces we are given (1 user operation does a batch on many files versus multiple clicks are needed for an operation on 1 file).
As a variation on the spreadsheet for multimedia file collections, I created a cataloging spreadsheet that imports lists of audio and video files, including metadata which gets preserved when windows media center records commercial digital TV, from a language center network share – you can find sample code on MS-Excel lists. You can see the import code in action in this screen cast.
Unfortunately, no recursion into subfolders and once more meant to move the files off the network and store on DVDs, for lack of space. Here at least the fields are less and the search relies more on regular expressions.
The current quick and dirty incarnation of self-made source material for interpreting exercises is here:
Learning materials management: Textbook exercises (2000-2008)
Textbook exercise management is a rapidly evolving field, with more textbook becoming digital and online resources and more metadata getting added and AI getting implemented to enable personalized (data-driven, feedback-based) learning paths.
German.xls was an attempt to be able to sort, search, filter the exercises of some bigger textbooks in the American college market, each containing thousands of exercises (how many? why does it take a sumif() to find out?):

Subtitles.xls converted text files with movie subtitles which can be extracted from DVDs or found into spreadsheet for post-processing (search, filter, sort – and assign different show times, for DVD editions differ).
online,
Auralog Tell me more 7 is a language program that allegedly comes with “more than five times the amount of content than other language programs” – but strangely not with a table of contents of its exercises. Automation extracted the exercises first into the file system for full text search with Windows Desktop Search, then converted the extracted files into links in the Auralog Content XLS.
Learning materials management: Links (1998-2004)
Originally implemented for a series of Canadian universities teaching Wirtschaftsdeutsch, then continually expanded into all of German for Queen’ s University, and multiple languages, including non-western, for university of Michigan-Dearborn and Drake university.
Was based on an open source software project by Gossamer Threads popular for web 2.0 precursors of collaborative links collections, whose Perl-CGI code needed only minor modification to facilitate the “”commenting”” on instructor-“posted” ( i.e. assigned links) by students.
The model was Yahoo’s human-edited web-catalogue. the data structure was the tree (nested folders, unidirectional graph). For managing, I implemented a secondary branch mirroring the primary under the root “old links” for, using Perl regex, automatically moving links which a batch link-checking management script in the open source had identified and logged as “broken” (404 and a few other similarly bad http return codes) into.
The original layout of the “ontology” first introduced me to the complexity of such a task. The basic content division was between 2 branches.
- web-based ready-made teaching materials for commenting (recommending, categorizing) by instructors and self-access by students (no feedback of student data to the instructor mostly, except by email, and outside of the application, in those days).
- the other content branch consisted of not teaching-related “”authentic materials””: the early day web applications, sometimes multimedia (maps, audio and video collections, news), often times also self-service database interfaces (online shopping and public services) whose language-wise rather restricted interface and topical focus (think Wirtschaftsdeutsch) lent themselves to capstone exercises at the end of textbook chapters (our “Friday in the lab””, not even a language lab then. Geek bonus points: one of these Fridays, a future queens university educated engineer asking me whether i had written all these pages they browsed through in the searchable catalogue of eventually 1500 links. Well, dynamic web pages were not common at all in education in those days, and the credit goes to Gossamer Threads.).
While there was hope to collect a comprehensive teaching resource through collaboration, “der Weg war das Ziel”, having students interact with and review foreign language web content. The links database remained definitely, as it grow in bursts revolving around the topics of our chapters. I had a lot of fun finding instructional ways to having students review all those fancy web applications in which endless amounts of money were poured before the first bubble in this millennium burst. E.g. the first early online city maps for “Wegbeschreibung” in German 102. as well web 2.0 like developments, like grassroots web cams (Germans allowing the world to spy on their surroundings 24/7, including remote camera panning – you could go all kinds of places, “”Wie heißt der bürgermeister von Wesel? was macht das wetter in der Schweizzzzzz?” but alas, the time lag, especially during winter term.
A couple of screen casts for instructor training are here and here.
Blackboard VLE Training Videos Overview
|
2006 |
Video |
|
|
2006 |
Video |
|
|
2007 |
Video |
|
|
2007 |
Video |
|
|
2007 |
Video |
|
|
How to do a language lab recording exercise as Blackboard assignment |
2007 |
Video |
| Blackboard controlpanel_export_import_course_or_parts.wmv | 2008 |
Video |
| Blackboard dropbox_sort_filter.wmv | 2008 |
Video |
|
Blackboard Content System: Add a content item instead of attaching a file |
2009 |
Video |
|
2010 |
Video |
|
|
2010 |
Video |
|
|
2010 |
Video |
|
|
2010 |
Video |
Help with playing videos
- Some videos require special codecs to display properly/ at all.
- Here is info on the H.264 codec.
- Often, it is best to try, instead of Windows Media Player (which may be the default player that opens when you (double)click on a video, but not be able to display it without manual configuration),
- the free VLC player which you can download here, if you must, and install, if you are permitted. Then right-click video, “open with”, “VLC media player”, like here:

Classroom management software Vendors at BETT 2009
I visited a number of more generic classroom management systems (NETSUPPORT, Synchroneyes).
These have limited audio (no recording) support, but provide all the essentials for computer use in class at a much lower cost. Could be a temporary solution, if we add some customizing through in-house programming.
Print to PDF with PDF Creator
For creating PDFs, we now have PDFCreator installed in Moorgate. It appears as a printer driver, so print whatever document you want converted, and choose “PdfCreator” as the printer.
Test
A dialogue will come up which will allow you to change some settings for the pdf file you are going to create.
The next dialogue will ask you where you want to save your pdf file.
Here is the result file:
And here it is opened with Acrobat Reader:
PdfCreator has limitations, like it does not create hot links. Once Office 2007 is installed in Moorgate, I would recommend using its built-in “Save as PDF” feature instead.















