I have written an Excel workbook to help university students, school pupils and the rest of us to organise, learn and test knowledge of vocabulary and phrases in sixteen languages. It sits alongside its sister workbooks Memorise It and Revision Aid (for more information about the suite of workbooks, see here).
Here is the blurb:
Vocab Book is a powerful, fully-featured, Excel-based vocabulary organiser with six different built in tests including multiple choice, transcription of dictated phrases and pronunciation practice.
Train yourself in all four key areas of language acquisition: listening, speaking, reading and writing.With Vocab Book you can improve your vocabulary, your listening skills and your pronunciation in sixteen different languages, safely archiving words and phrases as you get to know them so that your list contains only the items you have yet to learn.
You can keep track of all your new vocabulary and create your own Mp3 and paper-based vocab lists to test yourself when you are away from your computer.
Supported languages are Arabic, Basque, Catalan, Chinese, Dutch, English, Farsi, French, German, Hindi, Indonesian, Italian, Japanese, Korean, Latin, Spanish and Ukranian.
And here is a flavour of what Vocab Book can do…
Quick start guide:
Test from English into target language:
Test from target language into English:
Pronunciation test:
Test with spoken questions:
Multiple choice test:
Dictation test:
Create an Mp3 of your whole vocab book:
Produce a paper vocab book of your vocabulary list:
I offer Vocab Book “as is”. It has undergone a limited amount of beta testing (thank you Sarah Pasfield-Neofitou, Cathy Sell, Jessica Chakowa and Nadine Normand-Marconnet!) and should be relatively robust in windows 7, 8 and 10 environments running Excel 2010 onwards. For any other variations, no-one has told me how volatile Vocab Book is yet. Let me know!
You need to have Google’s Chrome browser installed to use many of the features of Vocab Book.
You can purchase Vocab Book securely through PayPal (it’s $5 Australian) by following this link. If you aren’t sure whether to take the plunge and spend a whole $5 on Vocab Book, you might want to download and try Vocab Book Lite, a limited version with only three built-in tests and no facility to create an Mp3 or printed book of your vocab list. You’ll also be reassured to know that I’m happy to provide a no quibbles 14-day refund to anyone who purchases Vocab Book only to find it doesn’t work on their machine.
It’s a project I’ve been working on in my spare time so I’m afraid I can’t provide technical support, but if you would like to offer any feedback (bugs, features you’d like to see…) do feel free to email me at [email protected]. I hope you find Vocab Book useful, and that you have half as much fun using it as I have had in getting the project to this point.
I’ve also written a memorisation tool called Memorise It, with a built in cloze test.
21 Comments
Comments are closed.
[…] a spin-off to Vocab Book I have written a memorisation aid called Memorise It. Here is the […]
[…] a spin-off to Vocab Book I have written a memorisation aid called Memorise It. Here is the […]
I tried to use multiple choice test sheet but it didn’t work. It says that the sheet is protected. Is it free vocab test?
Hi Rachel! Yes, it’s completely free. Which version were you using? If you were using the Excel 2010 version, have a go with the default version. Is it just the multiple choice test that gives you the error message? I’ll have a look and see if I can work out what’s going on for you.
[…] thanks to those who have been using and testing Vocab Book. I have ironed out a couple of minor bugs and uploaded the new versions to the dropbox link at […]
“COMPILE ERROR IN HIDDEN MODULE: SHEET1”
there seems to be a specific x64 problem with VBA in your sheets, if you give me the PW for the sheets, i could look into it myself..
Thanks Jabba, that’s a kind offer. Send me an email to chris dot watkin at monash dot edu and I’ll forward you the password. Cheers, Chris
This is *amazing*. I used to use Excel Japanese (the site to download it no longer works) but it was buggy so I gave up on it. This program is like Excel Japanese except a billion times better! I can’t wait to use it and try out all the different test modes ^_^
Thanks Caitlyn; I hope you find it useful, and all the best with learning Japanese!
Hello. Is there a way to change which site the lookup button goes to? I’m also studying Japanese and I mainly use http://jisho.org/ when I need to look up words xD
Hi samuihasu,
Thanks for your question. I’ve made a version that uses jisho here: https://www.dropbox.com/s/lef88rsv1qrmp1g/Vocab%20Book%20version%201%2C592%20with%20Jisho.xlsm?dl=0
It’s tricky to make it so that the user chooses the lookup site for her- or himself, so I hope this version is OK for now. Cheers, Chris
Oh thank you 😀
Don’t mention it.
Since my native language is italian and I am studying japanese, is it there a way to change the site where to look up words?
It depends on the URL syntax of the site. Is there a particular site you were wanting to use? I might be able to make a special version of the workbook that uses your site.
I was looking for a good site which could translate from Italian to Japanese and I found none as good as Jisho. Thank you for answering so quickly but I think I will stick with english.
No worries splikie, I hope the workbook helps you learn vocab more easily.
Is their a way that I can use it on excel for macOS? apparently doesnt work for now!
THANKS
Thanks for your message! Sorry to hear it’s not working. I don’t have a Mac myself so can’t test it. Have you tried both downloadable versions?
I just happen to come across this and I think this is amazing and exactly what I’ve been looking for. Unforunately, the language (Danish) I’m learning isn’t listed. Will there be any chance that you will add more languages? I would love to use this.
Hi. It’s kind of magical to see what you can do with an excel file. Can you help me for some issues:
1. I cant change the path to Google Chrome in many sheets except for Vocablist.
2. Can you just put vietnamese in the list too? I am from VN and my target is English.
Thank you for such great job!