Archive

Posts Tagged ‘quiz.dot’

Spanish movie subtitles exercise project

  1. objective:
    1. To facilitate lesson delivery and student interaction in our Language Resource Center I have programmed a VBA- and MS-Word- based cloze quiz template with batch creation based on a simple markup language and rich autocorrecting functions that use string metric algorithms (Damerau-Levenshtein). image001The template supports typical activities in the digital language lab: digital audio- and video-based  listening comprehensions, e.g. Quiz Template with Chanson Lyrics, image003 and speaking and dialoguing activities for language learning or other examples): 
    2. Teachers can use them as exercise-generating engines: the templates allow copy/paste of their own exercises into this template. To also automatically create language teaching materials with the required markup in French, German, Italian and Spanish (mostly based on movie subtitles) for this template, I wrote a C#-program that applies an expanding library of regular expressions which can match typical language learner tasks:
      1. function words, image002e.g for Spanish Movie Subtitling Exercise Creation, image005
      2. affixes/infixes
        1. and lexical subsets taken from corpus linguistic research on word-frequency (SUBTLEX, Opensubtitles)).
    3. This template support the learner by strengthening learner autonomy and providing immediate corrective feedback and – in conjunction with the grouping facilities of the Center’s classroom management system infrastructure – allow for custom-tailored instruction based on the immediately available outcome of formative assessments, and also automated summative feedback: image004 
    4. A Spanish TA can provide meaningful vocabulary and grammar questions as input for cloze listening comprehension exercises that  I will create on the basis of subtitles  I have for Spanish movies being used in (= put on reserve for viewing in the LRC by) the Spanish program  consistent exercises that students can take while watching the movie in class adapted meaningfully to technical possibilities of template
    5. Screencasts Demos:
      1. making of template exercises
        1. manually marked up: Part II to minute 4, Part III
        2. alternatively, markup can be generated by regular expressions which we will try to develop:
      2. use of template exercises : Part II, from minute 4
        1. overview of sample exercises (German)
        2. sample application (exam setting)
      3. materials
        1. source texts:subtitle files for proof reading
            1. Amores Perros
            2. Pedro Almodovar – Mujeres al borde de un ataque de nervios
            3. Pedro Almodovar – Hable Con Ella
        2. ideas for exercise needs that fit into this cloze format

          1. grammar
            1. function words
            2. affixes
          2. vocabulary
            1. frequency-based wordlists from corpus linguistics
            2. word lists from current textbook
      4. Deliverables: combos of

        1. materials
        2. exercise ideas

Examples of Quizzes based on MS-Word template

2011/03/02 2 comments

You can view a series of examples for formative assessments, used during face-to-face teaching (German) settings,  in this screencast.

Categories: e-languages Tags: , ,

How to use the MS-Word Quiz Template (and the MS-Excel subtitles spreadsheet)

2011/03/02 1 comment

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

0,00

Working with subtitle material from the source: time coding is not correct

1,40

spreadsheet formulae can fix the subtitle time codes

2,00

why using DVD chapters as learning units

2,20

filtering on chapters in the DVD

3,00

ready to copy paste the filtered learning unit text data into 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

0,00

start quiz from word template (on file share)

0,35

paste text data, e.g. for listening comprehension, e.g. from target language movie subtitles

1,15

create markup from pedagogy

3,14

generate  quiz from markup : parenthesis 1 {helpful hint}, parenthesis 2 [correct answer]

3,35

closing and saving the quiz, receiving a summary

3,55

create a  backup

4,00

open the quiz to test the quiz from student perspective

4,30

what opening information the student receives

5,00

how the student inputs answers  and receives feedback

5,20

language learning lookup menu , after pausing the quiz

6,30

or double-click words to look them up in the default dictionary for the set language

7,10

how the student resumes the quiz

7,20

how the student closes the quiz

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

0,15

open the quiz, enable macros

0,30

unprotect the quiz

0,45

office 2003: tools / macros / macros

1,00

now you can edit your pedagogical markup

1,10

regenerated the altered quiz

Using the MS-Word Quiz Template (and the MS-Excel subtitles spreadsheet)

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

0,00

Working with subtitle material from the source: time coding is not correct

1,40

spreadsheet formulae can fix the subtitle time codes

2,00

why using DVD chapters as learning units

2,20

filtering on chapters in the DVD

3,00

ready to copy paste the filtered learning unit text data into 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

0,00

start quiz from word template (on file share)

0,35

paste text data, e.g. for listening comprehension, e.g. from target language movie subtitles

1,15

create markup from pedagogy

3,14

generate  quiz from markup : parenthesis 1 {helpful hint}, parenthesis 2 [correct answer]

3,35

closing and saving the quiz, receiving a summary

3,55

create a  backup

4,00

open the quiz to test the quiz from student perspective

4,30

what opening information the student receives

5,00

how the student inputs answers  and receives feedback

5,20

language learning lookup menu , after pausing the quiz

6,30

or double-click words to look them up in the default dictionary for the set language

7,10

how the student resumes the quiz

7,20

how the student closes the quiz

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

0,15

open the quiz, enable macros

0,30

unprotect the quiz

0,45

office 2003: tools / macros / macros

1,00

now you can edit your pedagogical markup

1,10

regenerated the altered quiz

Sanako Lab300 Final exam: Movie listening comprehension with grammar, vocabulary cloze

2010/12/04 1 comment

Here is a raw (unedited) video of a final exam in a German 202 class.

It was delivered with Sanako Lab 300 in a synchronous face-to-face teaching environment.

Students (re)viewed a movie (Lola rennt), while doing target language subtitle-based with self-developed (MS-Word templates using VBA) fill-in-the-gap exercises on grammar and vocabulary – listening comprehension.

Apart from the teacher managing the exam distribution on the Sanako Lab 300 Teacher computer, you can see the teacher watching the students taking the exams – each thumbnail with subtitle text in the Sanako Mosaic window represents one student computer.

The students get the benefit of AI:  lookup of internet resources (which is enabled through VBA with double-click on words in a subtitle which leads to the default dictionary, in this case set to http://dict.leo.org), as well as a dropdown menu with more advanced Dictionaries and Encyclopedia.

The students also get the benefit  of immediate AI feedback to their input – better basis for learning than receiving a corrected homework or exam in a, time-wise, complete disconnect from the learning activity (and the feedback is faster than if it were web-based, since it is local to the client computer).

The teacher gets the benefit of an easy overview of students learning, of routine corrections being performed by AI in the exercise template, and, where s/he finds additional guidance is needed – even if not in this outcome exam situation, then during similar preparatory face-to-face activities – , can  – with the help of the Sanako audio and student computer remote control system – immediately connect  to a student for additional instruction at “teachable moments” (Example here).

del.icio.us Tags: ,,