Archive
Student attendance metering: present signin.xls and perspectives
We are working on replacing the old attendance meter which is still down:
As you will remember, we have been recording attendance last term and made this data available to you on our new network share: H:\llc\people\Sign_In_Sheet.xls. To summarize your students attendance, you can filter this data, using standard excel features.
New this term: To help you with this, we added an hard-coded MS-Excel auto-filter (see down-arrows in column headers): filter by course language, then number, then teacher, then the student in question , to summarize during assessment.
We expanded the data validation, so that we get the computer help us processing the data (sort, filter, search…).
Per your request, we added the course number, section and teacher columns to the sign-in sheet (to be manually updated at every term start – a poor man’s integration into the campus information system which had better not be done even by central services, but rather only purchased by them):
Individual teachers can use the built-in filters to drill down to their classes/students for advising/grading.
Individual student can be tracked, together with their time spent in the LLC:
Students enter in the green columns, mostly having to access only built-in shortcuts and selection boxes, while the other columns get updated completely automatically.
To enable students inputting their information directly, we have hacked together a dual screen system in the LLC entrance area.
We will also use this dual screen system for improving other LLC services, by hooking into central services. We will ask students with less than clear requests (“My professor wants me to do my homework here, where is it?”) to load their syllabus from blackboard and share their screen with the lab assistant, to assist with (not solve: that would need library resources, meaning professional library catalogue, library professional staff and library professional network and procedures) locating movies and other assigned learning materials.
For the attendance meter, this means: students can enter this information themselves; lab assistants still supervise, and collect the student ID to double check and prevent the cheating that I was approached about to fix with the prior system: signing in for friends, especially with passwords separate from university-wide passwords which there is no reason to keep secret.
Please note that this home-brew spreadsheet-based system is still severely limited in its functionality.
We could POSSIBLY (this would need setup and coordination with various central offices) automate this more, given time for the initial investment.
I have experimented with hooking into the swipe card system. However, students would have to be asked to swipe out also. For other reporting purposes, I have already managed to retrieve this data in this form: 
I have experimented with recording log-in (but no log-off) data on the LLC computers (another hack) in a centrally available spreadsheet, in this format:
I have inquired about using Microsoft’s SCCM (a generic software management application not meant for monitoring learning or language learning): We could gather statistics on two LLC-specific programs: the SANAKO media player and the webbrowser.exe (both, however, are likely, but not required to be used for language learning if a student prefers to do the learning in other applications). Neither would record actual files being opened.
All of these approaches, while preventing the most blatant cheating, still would not record actual language learning activity. They do not prevent students from spending their time in the LLC doing unrelated activities (like browsing sports news or playing online games) while they can do their assigned Blackboard and Quia homework from the convenience of their residence.
It is the professional systems that have been programmed with the resources from of revenue of literally thousands of campus-wide installations that can record these language learning activities.
The Sanako language lab software contains a webbrowser.exe which can not only be remote controlled by the teacher, but also be configured to allow only browsing certain (partial) urls or disallow browsing certain urls. it is also possible to apply different policies in different situations. this facility, while part of the package your purchased with the lab, has not been set up as of yet.
It would require developing policies and implementing them. E.g. one could during non-class use of the LLC only allow browsing publisher websites, including Quia.com, and Blackboard.loyola.edu and Loyola.edu (a radical approach).
One could also explicitly preventing certain websites, like Facebook (this would be more effective during face-to-face session in the LLC).
Then there are the facilities within your textbook websites (Quia) and within your course management (Blackboard, keywords for free tools being: Course Statistics, Statistics Tracking with activity_accumulator, Performance Dashboard, Early Warning System Rules, Adaptive Release rules for content, project ASTRO which is an acronym for Advanced System Tracking and Reporting Online), or as an add-on (Provost Pulse).
With the impetus being on ubiquity these days, it will have to be seen whether there are tools for Blackboard or Quia that can help enforcing that students use specific computers (maybe via IP address of computer?).
Beyond these solutions, there is an entire research area for, and software market revolving around, student retention management which also covers attendance tracking. Notable players include Hobsons EMT® Retain and Starfish Early-alert (which is run by a former Blackboard VP and can be integrated with Blackboard student data system as a building block).
I suggest we invest our limited local resources into finding better ways to integrate and train on these existing central facilities that provide information on learning (which we then can use to refine our teaching). Given current circumstances, I would recommend exploring the tracking systems in Quia and Blackboard (not restricted to being used on the LLC computers) and tracking learning outcomes (like student language recordings which the LLC can help with – not as much with the digital recording technology which is being commoditized, but rather with providing a language learning shared/collaborative/meeintg space).
Blackboard: Rolling over courses between terms
In your old course, go to CONTROL PANEL > COURSE COPY”.
Choose: “Copy Course Materials into an Existing Course” (assuming your new course shell has been created for you by your IT admin).
Click button:“Browse” and in the opening window, choose your existing current course, by the term identifier:
Check all items you want to copy. What is safest to avoid errors? Everything, except enrollments?
Click “Submit”/“OK” until done.
The course copy operation will be queued up, and you will be notified when the operation is finished.
Then go to your new course. This operation also copied the content items, including the content management system items.
Blackboard: Discussion board: Unread posts
- The Blackboard discussion board is designed for busy people keeping track of large constituencies – some classes have 1 instructor, 100s of participants and discussion board assignments….
- One of the most useful features is when you enter the discussion board, there is a shortcut to the “Unread Posts”, like marked here:

- If you click on this number of unread posts, you are taken to an overview page (sorted counter-chronologically be default; not threaded, but you have plenty of other display and management options), which you can skim for new developments, as well as use to manage your posts:

- Examine the top menu for options. You can either for individual posts click “mark as read”, as you read each one. Or you can use the “select all” tool and the “mark all as read” button in the top menu to clean up your board. Once you leave, your discussion board home page should look like this:

How to use your office computer in the classroom
How-to:
- Click
, click
, type “mstsc”, click
. - In the field of the upcoming window, enter your office computer’s IP number (you have to do this only once, the teacher computer will remember the number).

- This will connect you to your office PC, and if you run mstsc (Microsoft Terminal Services Client) in full-screen, it appears pretty much like working on your office computer.
- To find out your office IP number, on your office pc, Click
, click
, type “cmd”, click
. cmd. On the command line, type “ipconfig”, your “IP address” appears . - Problems? Tell OTS with a link to this post.
Benefits:
- use your local configuration with which you are most familiar also in class (e.g. US-international keyboard);
- prepare windows for classes in your office at leisure (windows will show in the state you left them in the office), saving class time;
- use the computer in class more, saving class time.
Risks:
- does not work well with multimedia. Workaround: switch mstsc to window mode and play multimedia from the local desktop of the classroom PC:

- make sure you do not have any windows open in the office which you do not want to display in the classroom
- set your online status to “busy” in Office Communicator and other instant messaging applications, or else others might send disrupting text message pop-ups while you teach
- possible screen size incompatibilities (mstsc can automatically accommodate for differences, within limits)
- always test before going live.
How to distribute learning materials using the Blackboard Content System
I needed to make a large set of textbook mp3 files accessible to myself in the classroom, as well as to students and myself from dorm/home.
The Blackboard Content System makes this easy, while observing copyright restrictions.
Below is a 6-minute narrated screencast on how to set up and use the Blackboard Content System to easily (work on batches of files on the web, just like on your computer, access from office, classrooms or home office) and securely (allow access only to qualified students) handle multimedia files
The example involves numerous mp3 files from a Textbook Audio CD previously only accessible from the LLC computers)).
This would work as well with your self-created teaching materials, from text handouts to video recordings.
If you need better management (many files, reuse across terms) than the standard course document upload can provide.
See the video file name for a brief table of contents:
If the teaching material item is already in the content collection, to publish it to a new course:
An outline of the MS-Word Cloze Quiz, MS-PowerPoint Multiple Choice Quiz and Internet Lookup tools for
- To facilitate lesson delivery and student interaction in our language lab and computerized classrooms, I am programming two MS-Office templates with interactive lookup and quiz functions and create new/convert traditional language teaching materials in French, German and Spanish with them.
- These templates support the learner by strengthening learner autonomy and providing immediate corrective feedback and – in conjunction with the grouping facilities of the centre’s infrastructure – allow for custom-tailored instruction based on the immediately available outcome of formative assessments.
- MS-Word-Template
- The student can be given additional hints when tabbing into a form entry field.
- The student can easily look up words and terms in internet-based reference works and collections.
- Double clicking on a word opens a browser window with the corresponding entry in a dictionary of the corresponding foreign language.
- Selecting a word or phrase and clicking on a menu item in the lookup menu a browser window with the corresponding entry of various reference works and databases (Figure 3: Look up Internet Reference Works, Figure 4: Look up Internet Illustrations).
- The student will receive instant feedback when tabbing out of an entry field.
- During quiz-taking, the screen will be formatted (font face, size, spacing, colors) so that the teacher keeps easily informed, whether through a computer lab management system / screen monitoring tool or by a more “pedestrian” approach for student monitoring.
- After collection and before correction by the teacher and reviewing by the student, the screen will be re-formatted to facilitate reading outside of the classroom setting.
- The template can be used for a wide variety of typical foreign language teaching exercises:
- Instructors have requested fuzzy matching for fill-in-the-blank exercises, which I am planning to implement by integrating an existing COM add-in that can make available the Levenshtein Distance Metric to MS-Word.
- Upgrade of Templates from Sanako Lab300 to better integrate with the new Sanako Study1200 software features.
- Teaching Content Creation:
- Making subtitles for foreign language movie digitally available;
- Programming regular expressions ins VS.Net that match function words (example: demonstrative pronouns in Spanish) to run over these templates in order to batch create fill-in-the-blank exercises;
- Importing them into the templates and creating grammar and listening comprehension exercises
- Support: Implementing an Error Logging Application
- MS-PowerPoint-Template
- The teacher can easily lookup words and terms in internet-based reference works and collections
- Currently implementing additional lookup options (NLP and Corpus Linguistics (ACORN, BNC, Sketchup), Dictionaries (Visurwords, Wiktionary, Google Define).
- A number of templated custom-animated exercises can be used for
- presenting students with guiding questions before watching/listening to a target language segment
- Revealing correct answers after the segment.
- A number of templated interactive exercises can be used for revealing correct answers (word lists) depending on students’ responses.
- The templates support typical activities in the digital language lab (interactive presentations with multimedia, listening comprehensions, speaking and dialoguing activities for language learning, view usage examples in my Templates Eurocall Presentation video of September 2007). Teachers can use them as exercise-generating engines: they allow copy/paste of their own exercises into these templates. These templates have the advantage of being able to hook into the rich infrastructure that MS-Office provides for language teaching; they work with all Western Languages (but have been thoroughly tested only with ESL, French, German, Italian and Spanish so far). These templates that are better geared than VLE and other CALL resources for daily use in a computerized classroom environment: easy to author, take and monitor and either multimedia-heavy or focused on human interaction. These templates support the instructor by relieving of routine tasks in favor of well-informed, well-focused non-routine intervention, and extend the centre’s screen-sharing and VOIP infrastructure to provide the instructor with an unprecedented control of the learning of an entire class.
- APP delivery format:
- MS-PowerPoint: 1 template-file (.pot) and 1 addin (.ppa)
- MS-Word: 1 template (.dot – incorporates Lookup application) and 1 COM application (fuzzy matching)
- Apart from the templates themselves, there is
- Explanation: documentation of the tool
- see Figure 4: Template Documentation,
- Figure 8: PowerPoint Exercise Templates,
- sample materials which illustrate the practical exploitation of a tool the development of a skill or the response to an issue
- see Figure 3: Quiz Template with Chanson Lyrics
- Figure 9: PowerPoint-Exercises for German History Documentary,
- Sample Exercise material: hands-on activities for materials development, skills training or discussion
- Figure 9: PowerPoint-Exercises for German History Documentary)
- Explanation: documentation of the tool
- Since January 2008, the templates have been adapted for use in the Aston university Study1200 lab and a series of 3 teacher training workshops has been delivered in May/June of 2008. During that time, the implementation of the distance metrics within the templates has been started also which is currently still in the debugging state (see following slide below.)
Figure 1: Look up Internet Reference Works
Figure 2: Look up Internet Illustrations
Figure 3: Quiz Template with Chanson Lyrics
Figure 4: Template Documentation
Figure 5: Quiz Result Summary
Figure 6: Spanish Movie Subtitling Exercise Creation
Figure 7: Information Gap Dialogues (Language Lab Example)
Introductory Screencast for WebLearn VLE
I would like to advertise some Weblearn introductory videos made be the Business School a copy of which I put on our network share. On campus, students can click
, click
, paste “\\lgu.ac.uk\lgu$\londonmet departments\Humanities arts and languages (HAL)\Language_services\docu\weblearn\”, click
. Double-click the EXE files to play the video (with sound, you need speakers).












