Archive

Archive for the ‘Screencasts’ Category

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

 

Plagwitz – eLearning Papers presented

Language Lab Web Portal, University of Michigan – Dearborn

For lack of even an LMS – which in post-secondary language lab environments in the US in the “noughties” commonly has had to double as CMS and Groupware -, the lab web portal in the post title had to fulfill many functions.

While the technically most advanced features probably was full text search against both database and file system (uploaded documents) – which I could relatively easily implement thanks to MS-SQL-Server and a limited number of database tables –, I liked best the collaborative building of a bank of language learning exercises using authentic materials, i.e. interactive websites from the target culture.

A few sample illustrations of the use in both language lab and affiliated computerized classrooms you can see here:

The list below links to a series screencasts of the Language Lab Web Portal that I made for training and demonstration purposes. They show the language lab web portal software in action:

basics_intro_roles
basics_usagestatistics
Class_presentation_Fruehstuecksbueffet
content_headlines
content_search
How_to_add_a_links_assignment_in_90secs
How_To_Add_Pages_And_Modules_fast
How_to_get_Help_LinksExample
How_to_operate_the_wireless_keyboard
How_to_provide_Help_PrinterExample_short
How_to_record_streaming_media
inventorydb
ocr_to_word_fast
perl_links_moveunverified
portal_search
portal_search portal_search program search staff_tab_short userinput

Data cleansing and ETL with Perl to remove broken links

Video Library: Scheduling for Reserve Desk and Viewings

Lab staff instruction for editing the video-reserves spreadsheet H:\LLC\scheduling\video-reserves&mh441b-showing\video-reserves.xls:

  1. Lab supervisors build the spreadsheet for the reserve desk and viewing: video-reserves-reservedonthisday-unfold-schedule-viewing.wmv, video-reserves-viewing-selecting-timeslots&venues.wmv
  2. Lab assistants read the spreadsheet and handle the actual media (i.e. update the reserve desk and show the videos): video-reserves-reservedonthisday-filter-viewing-or-reserve.wmv

Sanako Lab300 Oral-exam-question-response-recording-cycle

A 6-minute screen-cast explaining the sanako-lab300-oral-exam-question-response-recording-cycle.wmv

Please consult the transcript for a table of contents:

 

0,00

Here we are administering an oral exam. we are going to play pre-recorded teacher-questions to multiple students, we are going to record their responses and, at the end, we are going to collect their recordings in a batch:

0,12

for this, we have all seats where a student is present added to group a, and have set the program source for group a to media file

0,22

we monitor the situation on the student computers by accessing menu: other / thumbnail of group, 

the screen sharing is slow here, has been improved somewhat by installing more memory, the crowded screen situation has also been improved by installing a secondary monitor, use it for viewing the thumbnail window

0,59

in the group a pane, we use the button: duo launch, and ok the dialogue, to open th estudent recorder on the student computers

1,07

in the section:media source, button: file open, we access our pre-recorded question file

1,13

in the meantime, the duo has launched on the student computers – as you can see in the classroom layout from the squares on the student seats, as well as on the mosaic thumbnail screens

1,35

we double-click on a single thumbnail to demo to the students on the screen projector how to adjust the volume

1,43

we click button:transfer to play the volume test file to the students

we have the students record their name at the end of the sound test, to check all recorders, and to be able to identify the speaker in the actual exam file (which will be saved with only the student number in lab 300)

we stop the button:transfer and go to menu:test:response recording

in the pane:”response recording”, in section:”collect”, we click button:”start”

we save the recording in a subdirectory with a meaningful name of our choice

we ok the dialogue that informs us of the response recording

in the window:mosaic, the encoding activity window briefly flashes on the student screens

we browse to the student collect folder, where all subdirectories are saved

we check the folder visibly for the right number (use select all), size or duration of audio files –

it would be even safer, even though more time consuming, to open all the test recordings with audacity, especially on a slow computer, and check the volume graph – open audacity and drag and drop all files onto it

4,07

the soundtest is a complete recording cycle. Simply repeat for the actual exam, but

first  close the pane:response recording, to go back to your pane:group,

in section:program transfer, click button:group control, click icon:file/new, to flush the prior test out of the student recorders,

in the dialogue:”save changes”, click no

and this time load the actual exam audio file

once the sound check is done, we could use button:lock for the students to prevent them from interfering with the computers during the exam

Create a PowerPoint slide with a timer from template for a timed audio recording exercise

If you require an audio recording exercise, where you allot to students a longer period of time for a free-form response, possibly to a visual cue, here is a demo screencast, based on the teacher.pot powerpoint template collection: powerpoint-timer-slide.wmv.