Archive
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.
Automating Auralog Tell-Me-More with AutoIt. Presentation at EUROCALL 2008
Auralog Tell-Me-More is a leading language learning software system which provides a vast amount of content in an advanced technical infrastructure that we found lacking in usability within an higher education language learning environment.
AutoIt is a programming language for GUI automation which I used to better integrate the Auralog software into the higher education language learning process, including
- programmatic
creation of courses and accounts - programmatic extraction and digital repository management for over 30.000 learning units.
- programmatic creation of 10,000s of learning paths,
Results 
were presented (screencast) at EUROCALL 2008: “Automating Auralog (pdf)”:
creates 100s of courses 
, creates 
and enrols 
up to 2,000 student accounts every term,
- content extraction
produces files
for adding search 
and spreadsheet for sort/filter functionality: 
- learning path creation.
More detailed background information here: plagwitz_auralog_accounts_project_pub.pdf, plagwitz_auralog_project_pub.pdf
How to enable your SMEs to collaboratively define and add metadata to learning materials
- We have been asked to manage digital assets (including web links) and enabling incorporating them as learning materials within a series of study programs.
- We researched a number of metadata schemas and controlled vocabularies that have been applied to language and social sciences learning materials before,
- and incorporated those into the below MS-Excel application, to allow for easy marking up of existing assets by SMEs – using collaborative tagging instead of the more familiar, but more easily conflicting, since mutually exclusive folder hierarchy (unidirectional-tree structure).
- In addition, SMEs can expand and develop the controlled vocabulary, by adding tags of their own, as you can see at the end of this demo:
Questions? Read the About. Or just ask me a quick Our Databases: Resources with calendars -- Language learning material Moodle Sites, multimedia files -- films
FAQs for LRC student staff or for students or for teachers. To search our FAQs, in the browser addressbar, add after "https://plagwitz.wordpress.com/feed/?tag=faqs+/" "+TAG1" (from tag cloud below) OR "https://plagwitz.wordpress.com/feed/tag=faqs
&category_name=" "CAT1" (from category hierarchy below). OR search both categories and tags, and multiple TAGs/CATs (connect with "," for OR-search, with "+" for AND-search), like so: https://plagwitz.wordpress.com/feed/?tag=TAG1+TAG2+...TAGn&category_name=CAT1
+CAT2+...CATn"
Other ways to find help
If you cannot find it here, look there: 5,500 Language-Learning Links and Programs for learning or teaching 150 languages
Shortcuts:Our Lists, Our Maps, LRC Staff Moodle Site,LRC Project Moodle Site, 49erexpress, UNCC Moodle, Student Recordings: s:claslcslrcsanakostudent
Learning usage samples: Sanako oral exam, Kaltura webcam presentation, Dictation with speech recognition, Sanako written exam, Chinese and Japanese interactive stroke-order practice
Test the Sanako Installer, Webbrowser Popup Konfigurator for XP, or Windows7, faster LRC TeacherPC Log-in Let MS facilitate diacritics writing by installing for you US-International keyboard layout
This is my personal blog (Google+). The views expressed on these pages are mine alone and not those of my employer. The information in this weblog is provided “AS IS” with no warranties, and confers no rights.
Thomas' Work Space 