Excel 2010 Flashcard worksheet

Entry screen for Flashcards Excel worksheet

Entry screen for Flashcards Excel worksheet

This site is supposed to be about my creative writing, but lately I’ve been sidetracked with learning German on Duolingo. For a few months now, the Duolingo vocabulary function has been disabled, and that is painful for a left-brainer like me.

So…I decided to design my own spreadsheet that would let me drill vocabulary words, and I thought I would share. It’s not perfect. (I’m not a “real” programer, I only play one on TV.)

It works in Excel 2010. It hasn’t been tested in 2007. If you try it out 2007 and it works, please let me know. It will probably be fine in 2013. Oh, and it contains MACROS. That means your computer will probably give you warnings about potentially unsafe content. Don’t forget to click the “Enable content” button if you get an error message.

So far, this contains words and phrases from six Duolingo lessons. (Three early ones and three later ones.) I have included the article to show gender on all the nouns, and also added the plurals at the same time as I added the singular version, so plurals show up earlier than the actual lesson when they are presented. Also, some words are added twice, like Mann. One German to English prompt reads “gender”, the other reads “husband”. The program isn’t smart enough (yet) to give you points unless you exactly match the answer it is expecting.

One thing I’m on the fence about is that if the German prompt is “das Haus” , the English answer is just “house.” I am reconsidering, because I find myself typing “the” into the English answer, and perhaps its simpler to include it in the first place.

Features include:

  • It is case sensitive, to make sure you capitalize those German nouns!
  • If you get an answer wrong, the correct answer shows up in red on the side.
  • If you get an answer right, the correct answer will also show up, but it’s in normal type.
  • There is a “strength” indicator. It starts at zero, and goes up one point for every right answer, and down one point for every wrong answer
  • You can switch between English and German prompts with a drop down list
  • You can filter the list for a specific lesson. If you leave that blank, all lessons will be presented.
  • You can filter the list to give you words with a strength rating of less than whatever number you choose. If you leave that blank, all strength ratings will be presented.
  • When you click the “Clear and Resort” button, the list will clear out the “Type here”column, apply your filters and randomly resort itself.

If you open up the edit mode, you can do the following things:

  • Clicking “Open Edit Mode” will unprotect the worksheet.
  • Be careful not to change any cells that have formulas in them. (I made these orange in edit mode, so you can see what they are when the worksheet is unprotected.
  • You can change any existing entry or prompt.
  • You can add new entries. Just type them ¬†under the last existing line, and they will automatically be added to the table.
  • You could could change this to another set of languages (or anything else you might want to use flashcards for) by changing the names in “Element 1″ and “Element 2″. (But of course, you would need all new data entries.)
  • You can make multiple selections in the filter for columns by using the dropdown lists in the header row. (For example, you could choose Lesson 1,2 and 3). This kind of change will be erased if you click the “Clear and Resort” button again, though, so clear the answer column before you do something like this.
  • When you are done editing, click the “Close Edit Mode” button to protect the worksheet again, and you are ready to enter stuff.

Anyway, if you would like to try it, here is the link: Flashcards-German

Comments and suggestions appreciated!

This entry was posted in Uncategorized. Bookmark the permalink.

3 Responses to Excel 2010 Flashcard worksheet

  1. Michael Hemphill says:

    Great article! I will definitely have to try this out.

  2. gavink7 says:

    Thank you for sharing that!
    I thought it was very interesting and could be useful for me for language learning.
    By the looks of it, I think you know more about VBA macro programming that you say!
    Cheers!

  3. Marcelo says:

    Hi there! I just would like to offer you a huge thumbs up
    for your great info you’ve got right here on this post.
    I am returning to your web site for more soon.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>