1. Fill out the Excel Template

24 STEPS


1

Open the Course Template in Excel.

Start a new vocabulary list by typing "List: Unit 01 Lesson 01".

Step 1 image


2

First, type the words in the Known Language. This is the language that your students already speak.

We will use English as an example.

Type "one".

Step 2 image


3

Each vocabulary lesson should have 4 words minimum and 20 words maximum.

Type ten in this cell.

Step 3 image


4

Next, we will add the Learning Language words. This is the language your students will learn.

We will use Spanish as an example. Type uno in this cell.

Step 4 image


5

Once we've translated all the words, we can add comments. A comment tells the student more information about the Learning Language.

Click in column E.

Step 5 image


6

We have added a comment to the vocabulary word "uno". It reads:

Spanish and English numbers seem similar because both languages are in the Indo-European family.

Step 6 image


7

To include an image, type the file name of the image in this column.

Type "uno.jpg".

Step 7 image


8

Whenever you add an image, you need to include copyright information.

Type "public domain".

Step 8 image


9

If you already have a recording of a vocabulary word, put the file name here.

Type "uno.mp3".

Step 9 image


10

Now let's add a new list.

Click two cells below the existing list.

Step 10 image


11

Type "List: Unit 01 Lesson 02".

Step 11 image


12

Now you can add more vocabulary.

Type "name".

Step 12 image


13

Each vocabulary word needs an L1 and L2 translation!

Type "nombre".

Step 13 image


14

You can use scaffolding to teach longer phrases. Scaffolding means starting with short phrases and combining them to make a longer phrase.

Type "my name".

Step 14 image


15

Type "mi nombre".

Step 15 image


16

Type "My name is...".

Step 16 image


17

Type "mi nombre es".

Step 17 image


18

Whenever possible, the punctuation and capitalization should match between L1 and L2.

Doubleclick to correct the Spanish phrase.

Step 18 image


19

Type "Mi nombre es...".

Step 19 image


20

Let's continue.

Type "Your name is...".

Step 20 image


21

Sometimes, the translation of a phrase is ambiguous. Here, we don't know if the Spanish answer should be singular (usted) or plural (ustedes).

Let's add a hint to help the learner. Type "you singular". 

Step 21 image


22

Hints in column C are for the Known Language (English). Hints in column D are for the Learning Language (Spanish).

If you get confused, look at the labels at the top of the spreadsheet! Click to continue.

Step 22 image


23

If you want the computer to accept more than one answer, you can add alternative answers here. Separate each answer with the | symbol.

Type "Me llamo... | Me llama...". 

Step 23 image


24

You're done!

Thanks for taking the tutorial. 

Click anywhere to exit.

Step 24 image

Here's an interactive tutorial for the visual learners

https://www.iorad.com/player/144354/Filling-out-the-Excel-Template

2. Create Vocabulary Files from your Template

Step 1: The first step is to doubleclick BykiLister

Step 1 image

Step 2: Click Multilist

Step 2 image

Step 3: Click Create New Multilist Directory...

Step 3 image

Step 4: Click Desktop

Step 4 image

Step 5: Click Make New Folder

Step 5 image

Step 6: Name the folder b4us

A .b4u is the file type created by Bykilister. We use b4us to hold the data for vocabulary lists.

Step 6 image

Step 7: Click b4us

Step 7 image

Step 8: Click OK

Step 8 image

Step 9: You may see an error message when Bykilister loads. 

It's ok to ignore this message. Click OK

Step 9 image

Step 10: Click File

Step 10 image

Step 11: Click Import...

Step 11 image

Step 12: Select your Excel template

Step 12 image

Step 13: Click Open

Step 13 image

Step 14: Select the Language to Learn

Step 14 image

Step 15: Click Nahuatl for this example

You can also change the Known Language if it isn't English

Step 15 image

Step 16: In List Description, type created by 7000 Languages

Step 16 image

Step 17: In List Creator, type copyright (your organization's name)

Step 17 image

Step 18: Click Import

Step 18 image

Step 19: Click OK

Step 19 image

Step 20: Click Close

Step 20 image

Step 21: Your new b4us will be stored in the folder you created

Click b4us

Step 21 image

Step 22: You should see a folder.xml document and several b4u files.

Step 22 image

Step 23: That's it. You're done.

Step 23 image

Here's an interactive tutorial for the visual learners

https://www.iorad.com/player/147904/Creating-Vocabulary-Lists-from-a-Template

3. Prepare Files for Recording

Step 1: The first step is to doubleclick BykiLister

Step 1 image

Step 2: Click Multilist

Step 2 image

Step 3: Click Open Multilist Directory...

Step 3 image

Step 4: Click b4us

Step 4 image

Step 5: Click OK

Step 5 image

Step 6: You may see an error message. It's ok to ignore this.

Click OK

Step 6 image

Step 7: Click File

Step 7 image

Step 8: Click Export...

Step 8 image

Step 9: Type the name of your course in File Name

Type My Course Name

Step 9 image

Step 10: Select Save as Type:

Step 10 image

Step 11: Choose SDE3000 Files (*.w3k) and click Save

Step 11 image

Step 12: Click Close

Step 12 image

Step 13: Click Close

Step 13 image

Step 14: Three files are generated

The first is a NAHUATL__SND folder. This stores the raw recordings.

Step 14 image

Step 15: The second document is a My Course Name.w3k file.

This file stores the list of words you will record for your course.

Step 15 image

Step 16: The third is a NAHUATL_.d3k file.

This connects the words in your course list (the .w3k file) to the audio recordings (the SND folder).

Step 16 image

Step 17: That's it. You're done.

Step 17 image

Here's an interactive tutorial for the visual learners

https://www.iorad.com/player/147913/Preparing-Files-for-Recording

4. Record Audio

Step 1: The first step is to doubleclick SDE

Step 1 image

Step 2: Click File

Step 2 image

Step 3: Click Open W3K...

Step 3 image

Step 4: Select the w3k for your course.

Click My Course Name.w3k

Step 4 image

Step 5: Click Open

Step 5 image

Step 6: Click File

Step 6 image

Step 7: Click Open dictionary...

Step 7 image

Step 8: Select the dictionary for your course.

Click NAHUATL_.d3k

Step 8 image

Step 9: Click Open

Step 9 image

Step 10: Click the red circle button to begin recording

Step 10 image

Step 11: Click the black square button to stop recording

Step 11 image

Step 12: The waveform (in green) should be close to the lines but NOT outside them

Step 12 image

Step 13: Click on the left to trim extra silence

Step 13 image

Step 14: Right Click on the right to trim extra silence.

Step 14 image

Step 15: Click the green triangle button to check your recording.

You should hear the entire word or phrase with a short pause on both sides.

Step 15 image

Step 16: Click save changes to save your work and move on to the next word.

Step 16 image

Step 17: The first time you record in a dictionary file, you will need to enter Reader Information

Type your name

Step 17 image

Step 18: Type the year you were born

Step 18 image

Step 19: Select your gender

Step 19 image

Step 20: Click OK

Step 20 image

Step 21: Continue recording until you have reached the end of the phrases OR until you need a break

Step 21 image

Step 22: Click File

Step 22 image

Step 23: Make sure your w3k has been saved

Step 23 image

Step 24: Click Close

Step 24 image

Step 25: That's it. You're done.

Step 25 image

Here's an interactive tutorial for the visual learners

https://www.iorad.com/player/147921/Recording-Audio

5. Add Recordings to your Vocabulary Files

Step 1: The first step is to doubleclick SDE

Step 1 image

Step 2: Click File

Step 2 image

Step 3: Click Open W3K...

Step 3 image

Step 4: Select your w3k

Click My Course Name.w3k

Step 4 image

Step 5: Click Open

Step 5 image

Step 6: Click File

Step 6 image

Step 7: Click Open dictionary...

Step 7 image

Step 8: Select your dictionary

Click NAHUATL_.d3k

Step 8 image

Step 9: Click Open

Step 9 image

Step 10: Click the first word in your list

Step 10 image

Step 11: Click the checkbox to choose the current recording for this word

Step 11 image

Step 12: Click the next word or phrase

Step 12 image

Step 13: Click the checkbox to connect the current recording to this phrase.

Step 13 image

Step 14: Continue until you reach the end of the document. 

All words should be pink!

Step 14 image

Step 15: Click File

Step 15 image

Step 16: Click Save W3K

Step 16 image

Step 17: Click Close

Step 17 image

Step 18: Doubleclick BykiLister

Step 18 image

Step 19: Click Multilist

Step 19 image

Step 20: Click Open Multilist Directory...

Step 20 image

Step 21: Open the folder that contains your b4us

Click b4us

Step 21 image

Step 22: Click OK

Step 22 image

Step 23: You may see an error message. You can ignore it.

Click OK

Step 23 image

Step 24: Click Merge

Step 24 image

Step 25: Click Merge Sounds With SDE Doc...

Step 25 image

Step 26: Click Language to Learn

Step 26 image

Step 27: Click Ok

Step 27 image

Step 28: Select the w3k file for your course.

Click My Course Name.w3k

Step 28 image

Step 29: Click Open

Step 29 image

Step 30: Bykilister will suggest a dictionary file for your course.

Make sure it is the correct d3k file.

Click Open

Step 30 image

Step 31: If everything goes correctly, you should see a message like this.

Click OK

Step 31 image

Step 32: Click Close

Step 32 image

Step 33: That's it. You're done.

Step 33 image

Here's an interactive tutorial for the visual learners

https://www.iorad.com/player/147938/Adding-Recordings-to-Your-Vocabulary-Lists

6. Check your Vocabulary Files

Step 1: The first step is to doubleclick BykiLister

Step 1 image

Step 2: Click Multilist

Step 2 image

Step 3: Click Open Multilist Directory...

Step 3 image

Step 4: Click b4us

Step 4 image

Step 5: Click OK

Step 5 image

Step 6: You may see this message when using Bykilister. It's ok to ignore it.

Click OK

Step 6 image

Step 7: Click Edit

Step 7 image

Step 8: Click Do Checks

Step 8 image

Step 9: Click Yes

Step 9 image

Step 10: Click Start

Step 10 image

Step 11: The checks have identified a spelling error.

Click Fix

Step 11 image

Step 12: The checks have identified a capitalization error.

Click Fix

Step 12 image

Step 13: Sometimes, the checks identify errors that are not truly errors. You can click "Find Next" to ignore these.

Click Find Next

Step 13 image

Step 14: Click OK

Step 14 image

Step 15: Click Close

Step 15 image

Step 16: Click Yes to save changes

Step 16 image

Step 17: Click C

Step 17 image

Here's an interactive tutorial for the visual learners

https://www.iorad.com/player/147944/Running-Checks-on-Your-List

7. Hand off your Vocabulary Files

Once you've completed the steps above, you'll send your Vocabulary Files and Recordings to the 7000 Languages team.
We'll publish your course!