Cross-referencing vocabulary in Excel after some tidying is applied with IFERROR.

Excel for Polyglots: Comparative audits to keep languages in sync

Duolingo, Memrise, Anki, Microsoft Excel. Huh, wait – Excel? How is that a language learning app?

Well, the Office software has some handy features that just happen to be right up our street as language learners. Namely, the ability to curate and administer lists in table form. And it just happens that this can be particularly useful if you learn more than one language.

One source of frustration as a polyglot learner is the discrepancy of vocabulary level between languages. This can be most obvious with fairly close language pairs. For instance, when practising Icelandic, I often realise that I know a term in Norwegian – but not the language I am trying to speak.

So how best to address these discrepancies?

Language auditing

Getting into the habit of performing a regular language audit, such a revisiting beginner materials is a good strategy for any learner. But one particularly powerful method for multi-language learners is the comparative audit.

In short, a comparative audit is simply taking stock of which words you know in one language, but not the other.

At the very early stages of learning a language, this can be as easy as scanning down a list. But when you get to the point of having hundreds and hundreds of words in your vocab store, the task is mammoth.

Enter Excel, data wizard!

Microsoft Excel and VLOOKUP

Most of us will have used Excel or another spreadsheet program at some point. But like me, you might not have gone beyond basic numerical information and a few simple sum functions.

It turns out that Excel is pretty good at handling textual data too. Are you thinking what I’m thinking? Yes, vocabulary lists! And it has a special function, VLOOKUP, which allows you to compare data between two tables. Sounds just perfect for our comparative audit.

Here’s how to enlist Excel to your polyglot cause in a few simple(-ish) steps.

Step 1: Port your data into Excel

First things first – you have to get your vocabulary data into Excel. The easiest way is to export from your program of choice as a CSV (comma-separated values) or tab-delimited text file. If you use Anki, this is as easy as heading to File > Export and selecting ‘Notes in Plain Text (*.txt).

Ensure that you only export the basic data and no media or tags. Ideally, you should just be exporting a word and definition / translation field. My Norwegian and Icelandic decks, for example, are populated by vocab notes with an English and Target Language field.

Export a separate file for each of the two languages you want to compare. In my case, I end up with two files, norwegian.txt and icelandic.txt.

Exporting data from Anki

Exporting data from Anki

Step 2: Import your vocab into Excel

In Microsoft Excel, create a fresh spreadsheet document, and head to File > Import. Select Text File, hit Import and locate your first exported vocabulary file from above. To preserve accented characters in our Anki list, select Unicode (UTF-8) as the File origin.

Importing vocabulary into Excel

Importing vocabulary into Excel – note that ‘Unicode (UTF-8)’ has been selected as the file origin to make sure accented characters are handled correctly.

Create a second sheet in the same document, and import your other list of vocabulary into that. You should now have a two-sheet spreadsheet document, each sheet showing a list of words in a different language. For clarity, make sure you name your sheets too. Simply double-click on the tab titles “Sheet 1” etc. to do that.

Step 3: Format your lists as tables

In each sheet, click and drag across the table to select your whole vocabulary list as a block. Now, click Format as Table in the Home section of the function ribbon / toolbar. It doesn’t really matter which style you use – I choose the colour I like best!

Once that’s done, change the new column headers to something more meaningful than the default values. I use English and Norwegian in my example below. One caveat – you need to have a column with the same title in both your tables for the VLOOKUP trick to work. Here, English will be my common column between Norwegian and Icelandic.

Vocabulary data formatted as a table in Microsoft Excel

My Norwegian vocabulary data formatted as a table in Microsoft Excel

Now, instantly, these is already more useful to us than static lists. Formatting as a table means you can use the column heading drop-downs to sort and filter your entries. Try it – sort alphabetically on the target language column. You’ve turned your data into a nifty dictionary! Not our primary goal, but a nice trick on the way.

Before we go on, it’s a good idea to name our tables so they are easy to refer to later. To do this, click anywhere in your table, then switch to the Table tab in the ribbon / toolbar. The simpler, the better – below, I just call mine Icelandic.

Naming a table in Excel

Naming a table in Excel

But now it’s the turn of our star, VLOOKUP. This is where the real magic happens.

Step 4: Adding a comparative column

Click on the target language column header of your second table and copy it (CTRL + C). Now, go to your first table, select the cell next to the target language column header (C1 in my example), and paste (CTRL + V). It should add a blank new column within that table. Let’s fill it up!

In the first cell under that new column header, we type in our VLOOKUP formula. This will depend on what you have named your tables and sheets, but mine looks like this:

=VLOOKUP([@English], Icelandic, 2, 0)

Let’s dissect that just now. The first item in the brackets is the column of the first table we’ll use at the lookup – the English entry. The second item, Icelandic, is the table we’ll look for a value in. Remember, we named that table a little earlier. The third item, 2, is the column number we’ll look for that item in, which is the target language column of the Icelandic table. Finally the fourth value, 0, is a flag to Excel that we want exact matches only.

If that boggles, simply start typing =VLOOKUP( in the cell. That calls up Excel’s formula hints and point-and-click formula building, which should help you tie things together accurately.

After doing that, something special happens – suddenly, the whole column is filled with entries. If the English term was found in the Icelandic table, the corresponding Icelandic word is pulled in. If not, we simply get #N/A.

A quick note if that doesn’t work immediately: check that the data type of the cells in that third column are set to format as General, not Text.

A cross-referencing table in Excel using VLOOKUP

Our first step in creating a cross-referencing table in Excel using VLOOKUP.

Not very tidy, is it? That #N/A is simply stating that the lookup resulted in nothing at all.

Step 5: Tying off the loose ends

We can make it all look better by wrapping it in another Excel formula, IFERROR. Change the formula in that first cell to:

=IFERROR(VLOOKUP([@English], Icelandic, 2, 0), "-")

This tells Excel to carry out our VLOOKUP function, but to return a dash if it results in an error (i.e., no data). Suddenly, it’s looking a lot neater.

Cross-referencing vocabulary in Excel after some tidying is applied with IFERROR.

Cross-referencing vocabulary in Excel after some tidying is applied with IFERROR.

Now it is crystal clear where you know a word in one language but not the other. To make things even clearer, click the dropdown on that third column, and filter it to show just the dashed elements. There is your list of words to work on in the second language!

Filtering your vocabulary items in Excel.

Filtering your vocabulary items in Excel.

Alternatively, filter on everything but the dashes to revel in the wealth of words you know in both. Enjoy that moment of pride!

For reference, here’s an example Excel file comparing sample vocabulary in French and Spanish.

Where to go from here?

What you do next is up to you. But now, you have the data in your hands, and data is power: what you know, you can act on. Export the filtered list of gaps to work on learning missing vocabulary in any number of ways.

Clearly, you can take these techniques a lot further, too. Currently, the table only checks one way, such as Icelandic to Norwegian in my example. But you can experiment with the same techniques to create much more complex and comprehensive spreadsheets to interrogate both ways.

Lastly, I’ve used Microsoft Excel in this example, but the same functionality is available in other spreadsheet programs, too. The free alternative Google Sheets, for example, has its own VLOOKUP function that works in an almost identical manner. Play around with the tools available, and you can add that dull old spreadsheet package to your list of exciting, innovative language apps!

Have you given this trick a spin? Have any interesting and useful variations on it? Please share in the comments!

Speaking is like a skyscraper. Aim high, but watch your foundations too! Image by createsima on freeimages.com.

Speaking without foundations (and putting it right)

As I sit at the station tapping away at Anki, I’m impressed at the level of the vocabulary I’ve reached: interactive, futurism, equality… All those lovely advanced words! I enjoy a moment of language learner pride, before I remember that when it comes to everyday speaking, I’ve still got a bit of work to do.

It’s a problem you might recognise yourself, if you’ve tried any of a number of accelerated learning techniques with your languages. For me, it was all about grappling with Icelandic in all its glory immediately. I leapt straight into the language a few years back, working with iTalki tutors in a conversational format and lapping up that wonderful vocab.

The pattern was this: prepare a topic to talk on, and chat about it in the lesson. Some of the themes were challenging even by first language measures: politics, social media, technology. But using an “islands” approach, it seemed to be working out really well. I absorbed and consolidated a huge amount of vocabulary and grammar structures.

Speaking high and dry

For sure, it is a learning strategy that builds a solid level of competency, and fast. It has made me quite adept at prepared chat, a wonderfully useful and transferable skill for other areas of life such as public speaking and work presentations. It’s a technique I still use, too. I recently completed the #30DaySpeakingChallenge in Icelandic, and created a short speech on often quite complex topics for every one of those days.

But it is a very particular type of competency, or fluency, that this technique builds.

The crunch comes when you come to speaking a language in the wild. For me, it became painfully clear on trips to Iceland than I almost completely lacked the basic, practical, and social foundations needed to operate on a day-to-day level in the foreign language. Navigating social situations – even producing the most basic of niceties and stock repsonses – felt like pulling teeth.

Yes, I could rattle on about materialism, propaganda and language learning techniques in wonderful Icelandic. But when it came to ordering a sandwich on Reykjavík’s Laugavegur, I was lost.

That’s great – but can you just order a coffee, please?

Swallow that pride!

The warning signs were there well in advance, of course. For instance, I would haplessly flounder after the social glue at the end of lessons. Phrases such as “have a nice week, see you soon!” got stuck in my mouth like treacle toffee. I could clumsily construct them based on grammatical rules and vocabulary. But they never sounded natural.

Now, there is no shame in recognising these lacks, however late. And this is certainly not to bash accelerated learning techniques – I still use and love them. We all learn in different ways, for different reasons. It was always a source of huge motivation to prepare speaking topics on the things I found most interesting.

But here’s the crucial lesson to take: it’s easy to assume that by learning the high-brow stuff, the everyday stuff follows automatically, almost like a side-effect. Sadly, it doesn’t quite work that way!

Two tiers

Instead, it helps to view language learning as a two-tier process. You can leap straight in with advanced topic-based speaking challenges for speed learning. But, at least alongside that, there needs to be a nod to the social reality (if, that is, you are learning the language to use in a social setting some day – not the case for everyone!).

Some of the best resources for this are perhaps those that budding hyperglots might tend to dismiss as too basic. In fact, foundational primers like Teach Yourself – especially those aimed at more casual learners, like the TY “Get Started” series – are gold for training in social speaking. Yes, they can be light on grammar and more obscure vocabulary. But you do that elsewhere because you love it and seek it out! For the stuff at ground level you are liable to skip, you could do a lot worse than go back to one of these courses.

Their strength is in building social muscle memory for the language. This is the more automatic level of trigger-response in language, operating generally below the level of full consciousness. It’s also how a lot of the social interaction in our first language occurs. Just consider how unthinkingly you fire off “no problem” or “you’re welcome” when somebody thanks you. There is close to zero cogitation going on around how to form a grammatically well-formed sentence!

To this end, I’ve returned to what you might call the ‘baby chapters’ of Teach Yourself Icelandic and Colloquial Icelandic. And it constantly surprises me how much of the little stuff I had missed.

The best thing? It’s never too late to go back and learn it.

Many routes to the same destination – walk them all

Admittedly, speaking without foundations is a human flaw baked into the informal, conversational lesson approach, since it is only natural to seek meaningful chat with tutors. But perhaps we can also find time to squeeze in some ‘real world’ modelled dialogues too, like ordering a coffee or checking in at a hotel.

The crux of it all is that there are many routes to that same destination of fluent speaking, none of them mutually exclusive. Treading several different paths gives you a much more rounded feel for the language than a single one.

Diving right into a language and speaking without foundations is an exhilarating and exciting way to learn. But check out your foundations now and again, too!

An owl - not the Duolingo one, but probably related. Image by Pamela Benn on freeimages.com

Approaching Duolingo : One Way to Catch An Owl

In case you hadn’t noticed, Duolingo released its Scottish Gaelic course early this week. And naturally, I leapt straight in like a pig in mud!

Like many, I had waited patiently and eagerly for this release, not least since I study Gaelic at evening classes in Edinburgh. Despite a resolution not to race ahead, Duolingo’s early Christmas present was a gift too good not to open straight away. As expected, it is a joy of bite-sized vocabulary snacks.

Devouring unit after unit, it struck me that there are many ways to systematically approach a resource like this. The question of how to tackle Duolingo also cropped up recently in discussion with excellent iTalki tutor Marcel, who is running a Duo-challenge WhatsApp group I’m part of. Personally, I prefer a two-wave method. I outline it here in the hope that it helps others who, at first glance, find a huge topic tree a bit overwhelming, and wonder how to tackle it.

The two-wave approach to Duolingo

This method has a lot in common with the forward-loading approach to course books, which is one of my favourite ways to tackle language learning material. It involves an initial, exploratory reccy through the material, combined with a systematic and focused follow-up.

The first wave

When you first open up that course, it is all about getting to know the terrain. Like hacking your way through undergrowth, you need to clear a path first.

Duolingo prevents users from accessing material out of order by locking lessons until the previous one is completed to the first of five XP levels. However, unlocking to this first, blue level is usually just a matter of a few short introductory lessons. So, in the first wave, you simply steam ahead, unlocking topic sections just to level one before opening up the next one. In no time at all, you’ll have blued up a good portion of your tree (or maybe even all of it with a shorter course like Gaelic).

Don’t worry too much about retention at this stage. The aim is to have fun, notice the shapes and sounds of the language, and lay down some passive pre-knowledge before we get serious. Above all, it is the no stress stage. Just explore and enjoy your new language!

The second wave

When you have unlocked a fair few topics, the second wave can begin!

At this stage of your Duolingo attack, you go right back to the very first topic section. Work through slowly and carefully, one by one, hammering each topic to level up fully to gold before moving on to the next.

Note that there is no speed pressure here. You can gold a topic up in a single sitting, or take days to do it. The important thing is that, during this more focused stage, you resist the temptation to move on before a topic is gold.

The second stage is where the deep learning occurs. But thanks to the familiarity you have from the first pass, you already have a ground layer to build on.

A snapshot of my progress through Duolingo Scottish Gaelic, showing how the two-wave approach works.

A golden wave works its way through Duolingo!

Own the vocabulary

Here is the crucial turbo-boost you can engage during the second wave: make the vocabulary your own. Duolingo shouldn’t simply be a passive resource. For long-term learning, you should record all those new words and phrases in your own, separate collection for drilling.

Anki is hard to beat on that score. Every time I meet a new item in the lessons, I look up a detailed definition using a resource like Wiktionary, and add it to an Anki deck. Since Anki will also drip-feed that vocabulary to you using its clever spaced repetition algorithm, you effectively double the learning power of the Duolingo course.

And that’s all there is to the two-wave approach. Familiarise first, study systematically, and make the material your own as you go. A simple but effective way to catch an owl!

How do you approach Duolingo courses? Do you use a different technique? And have you started Gaelic yourself? Let us know in the comments!

Bingo could be good for your speaking, too! Image by Michiel Meulemans on FreeImages.com

Speaking Bingo Sheets for Snappy Active Vocab Recall

When it comes to making vocabulary stick in memory, there are few more effective methods than actively working new material in your speaking practice.

Regularly engaging with new words and phrases in a foreign language is constructive recycling. They gain a salience in the brain beyond words on a page, helping to cement solid neural pathways. Practical use is a sure-fire way to move new material from passive to active knowledge, which is one reason that the Active Recall memory method works so well.

But sometimes, it is not enough to simply hope they come up in conversation. We need a systematic approach to target new vocab.

Polyglot pals, I present to you: speaking bingo sheets!

Speaking bingo sheets

In essence, speaking bingo sheets are simply preparation notes for conversation lessons – with a twist. Instead of a static list of items, they are a dynamic grid of entries that you tick off as you use them. And, like real bingo, you can add in an element of reward (and punishment, if you like!).

To get started, take a 3×3 grid. In each box, add a word or phrase from your recent language learning work. A three-square grid for nine items in total is ample, as more can get unwieldy. My own use of them has evolved from longer checklists to these snappier grilles, and the tighter focus feels much more amenable.

Ideally, all the items should be in a related topic (as it’s easier to fit them into a single conversation then!). As you use them while speaking with your tutor, you tick them off. Simple!

A speaking bingo sheet for Icelandic displayed in Notability for iPad.

Speaking Bingo Sheets needn’t be on paper – here’s one of mine in Icelandic on Notability for iPad.

If you need a bit of extra motivation, you can add a checklist of achievements and rewards below the grid. Your prizes can be as simple or elaborate as you want. A single line? A choccie bar with your coffee. A full house? Allow yourself to buy  that language learning book you’ve been eyeing up for months. You can add punishments too, but just enough to engender a bit of self-discipline. Be kind to yourself – the last thing you need is extra stress in something that should be a joy!

Your teacher can be in on the plan, if you like. But equally, bingo can be for your eyes only. And they’ll be left wondering just why you are so focused in your speaking today!

No lessons? No problem!

I use speaking bingo as part of my regular one-to-one conversation lessons with iTalki tutors. However, they lend themselves to all sorts of other learning situations, too.

If you are practising in situ on holiday, for example, you can set yourself a daily ‘speak sheet’ – nine things that you must try to say to native speakers. They can be as prosaic (“can I have a serviette, please?”) or as whacky (“do you know where I can buy a llama?”) as you like (or are brave enough to say). Unleashing your speaking game in the wild can not only be a bit of silly fun, but also great for building social confidence.

Even if you are nowhere special, with no native speakers within harassing distance, all is not lost. We learn a lot by teaching – or simply explaining – to others. In this case, simply make it your goal to explain each one of those grid items (meaning, pronunciation, etymology etc.) to nine different friends and family members.

However you do it, there is always a way to recycle, recycle, recycle, and move those words from passive to active memory.

Adapting for the classroom

Finally, there are also numerous variations of this you could try with a class of students. At an introductory level, each student could prepare a grid of questions like “what’s your name?“, “how old are you?” and so on. Then, with five minutes to mingle, their objective would be to ask – and record the answer – of every item on their grid. Prizes for a full house!

Structure and flexibility

Speaking bingo sheets are a great framework for using vocabulary and making it stick. They are flexible, in that you can create them from whatever material you choose. But they are also structured, lending some scaffolding to the otherwise very free realm of conversation.

Experiment, adapt and give them a go. And let us know how you get on in the comments!

 

Is the starting point for functional fluency a list of the right core words? Photo by acscom from freeImages.com

300 Words for Functional Fluency : Miss Swanson’s Elucidating Experiment

Decrepit, dusty old language learning books from bygone days are a guilty pleasure of mine. And sometimes, the most obscure, long-forgotten tomes throw up some shining treasures. Leafing through one such volume this week week, I stumbled across a fascinating gem of a tip that promises a helpful shortcut to functional fluency in a language.

The book in question – George McLennan’s “Scots Gaelic – A Brief Introduction – is not one of the oldest I’ve taken a ramble through, seeing its first impression in 1987. But it contains a curious factoid that served as the basis for a whole chapter on essential vocabulary. Let’s join Mr McLennan, and dive into the strange and curious world of the mysterious Miss Elaine Swanson.

Elaine Swanson and the 300 words

Swanson, explains McLennan, was “director of the New York Language Institute” around the 1930s. Now, her existence may well be apocryphal, as I am yet to find any modern reference to her – or the New York Language Institute – online or otherwise. But this mythical Miss Swanson is noted for one particular and exciting theory. She posited that a spoken vocabulary of just 300 words will suffice to get by in a language.

Being a thoroughly practical kind of person, and seeking empirical proof, she took it upon herself to attempt this feat in English for the duration of a whole three months. Apart from undoubtedly bemusing and irritating friends, relatives and colleagues, this exercise allowed her to compile a list of those core 300 words that represent a level of functional fluency.

Thanks to McLennan’s unearthing of her story, we too can benefit from the fruits of that hard work.

Functional fluency list

Here, arranged by the parts of speech. Clearly, a huge nod goes in George McLennan’s direction for printing this list with Gaelic translations in his book. Otherwise, Miss Swanson’s experiment might have been lost forever.

The final list actually comes in at a little under 300 words. Bear in mind that not every language will match up with these English terms exactly, so it will need a little adapting for other languages. McLennan notes that Gaelic, for example, has no single word for no – instead, this is paraphrased.

And one more note before we begin: some categories and inclusions might seem a little eccentric or unusual. Remember that this list was made in and for a very certain place and a very certain time. It manages to be fairly general, but will need some personalisation!

Miss Elaine Swanson’s Core Vocabulary

Prepositions

at, after, for, from, in, on, to, with

Conjunctions

and, or, if, but, so, that

Pronouns

I, he/she, you

Possessives

my, your, their

Interjections

hello, goodbye, oh!

Articles

the

Nature

fire, light, sun

Business

I assume that Mr McLennan has changed the currency words here for a British audience.

bank, pound, penny, money, office, manager, show, size, shop, trouble, way

Travel

boat, car, country, hotel, left, place, right, station, street, ticket, town, train

Objects

bag, book, letter, telephone, thing, story, word, picture, nothing

Days of the Week

Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday

Modifiers

The original list uses “modifiers” as a kind of catch-all for anything descriptive, making this a mixed bag!

again, all, any, big, clean, cold, correct, down, easy, every, expensive, good, happy, here, how?, little, long, many, more, married, much, new, nice, no, not, now, old, one, other, piece, ready, same, slow, some, sorry, that, there, this, too, also, up, warm, very, well, what?, when?, where?, who?, why?

Food

Miss Swanson could almost be the original author of Duolingo’s “Food” topics…

bread, butter, sweets, coffee, egg, fruit, meat, milk, salt, sugar, vegetables, water

Time

day, evening, hour, minute, month, morning, night, time, today, tonight, tomorrow, week, yesterday

House

bath, floor, house, key, room, table

People

boy, brother, doctor, father, friend, girl, man, men, Miss, mother, Mr, Mrs, name, policeman, sister, woman, women

Clothes

cloth, clothes, coat, dress, hat, shoes, stockings, trousers

Colours

black, blue, green, red, white

Were there no yellow things in Miss Swanson’s world?

Verbs (and auxiliaries)

will, won’t, ask, be (am, are, is, was, were), can/can’t/could, come/came, do/does/don’t/did, eat/ate, excuse, gain, get/got, give, go/went, have/has/had, help, know/knew, learn, like, make/made, must, please, put, read, say/said, see/saw, sent, sit/sat, sleep/slept, smoke, start, stop, take/took, thank, think/thought, understand/understood, use, want, work, write/wrote

A critical eye

Evaluating the list for its practicality, the omissions are often more noteworthy than the generally helpful inclusions. Indeed, I end up with more questions than answers. Why no we or they in the pronoun section, for example? One English word frequency list places we above both he and she, so this might seem like something that needs tweaking. And where is the handy it, which sits firmly in the top ten most common English words in the same frequency table?

If frequency word lists were available (presumably Miss Swanson would have had access to these as director of a linguistic institute), why did she not use these to compile a core vocabulary? That said, this was a personal experiment, and – it is fair to say – probably not exactingly scientific. The aim of fluency was on the terms of the author’s everyday, not a one-size-fits-all average person.

Elsewhere, some of the collapsed categories seem tailored quite specifically to English. We can only assume that the inclusion of possessive their is the gender-neutral one to cover he/she more economically with a single word.

Window on a world

A particularly fascinating characteristic of the list is the choice of present/past verb pairs. Only certain past tenses are included (knew, slept etc.), while others verbs are given only in the present / infinitive form. Presumably the choice relates to the kind of polite, daily conversations the protagonist was trying to replicate during the experiment. Again, this fits with a definition of fluency as a working knowledge of language for the protagonist’s everyday – not everyone else’s. On a related note, it might be quite shocking to note the inclusion of the verb ‘smoke’ these days. Of course, such observations are part of the charm of finding personal vocabulary lists like these: their quirkily subjective nature.

Other initial observations relate to the economy of some of the lower-frequency type of vocabulary. You might wonder, like I did, why some terms are included when they might be creatively paraphrased using other items on the list. Personally, I question why “sun” is there, when “big light”, accompanied by pointing at the sky, would do. Slightly paleolithic, admittedly. Miss Swanson sounds much more civilised than that.

Pidgin English

As a guide to speaking a language, the list is clearly missing something. In particular, her conception of vocabulary is of a set of discrete, individual blocks, without any comprehensive reference to the glue holding them together in speech. There are no grammar rules implied in this list method beyond the few verb tense pairs, a couple of declined verb forms (was, does etc.) and the probably unnecessary inclusion of the definite article.

You can get away without grammar, of course, in effect using the vocabulary with your own logic to create a kind of pidgin. Will that make for ‘good’ French, German, Spanish and so on? No, go the purists. But will it be communicative if you need a basic core fast? Absolutely!

Verbs for lift-off

Miss Swanson does give a nod to a certain kind of sentence glue, however. One of the most striking things about this core vocabulary is the preponderance of verbs. They make up a considerable portion of the magic 300. And with good reason: this super-category of words does a colossal amount of heavy lifting in terms of intention and meaning in a sentence.

Now, I’ve always championed the verb as a key fluency factor. In fact, you can just call me the Verb Guy, since I can’t get enough of them (I write apps to drill them in my spare time!). Miss Swanson clearly spotted the communicative power of verbs, and focusing on verb tricks like employing modal sentence frames can really boost your conversational power, too.

A pinch of salt (and a spoonful of sugar)

So there you have it: a recipe for getting by on just a handful of words. Serve with a dollop of gloriously eccentric sugar and a medium-sized pinch of salt.

But even if the Magic 300 needs some tweaking to our individual circumstances, it strikes me that Miss Swanson was most definitely onto something. Her approach lights a pathway towards communicating – fast – in any language. Beyond that, the highly personal, practical nature of her list makes for a charming and intriguing window onto the world of someone in love with language and words. There is something  very familiar about Miss Swanson that is reflected in all of us linguaphiles.

This long-forgotten experiment attracts the extreme linguist in me, I must admit. If functional fluency can be acquired from a carefully selected core vocabulary, then maybe it is that simple to add a third, fourth, fifth language – and the rest!

What would your 300 look like? Could you get away with fewer than 300 words? What would you add or replace to Miss Swanson and Mr McLennan’s lists? And of the languages you know a little of, how many have you reached Swanson’s functional fluency in? Let us know in the comments!

A plastic brain. Image from freeimages.com

Brain dump bonanza : splurge your way to vocabulary mastery!

This week, I’ve been rediscovering a magnificent memory boost from my student days: the brain dump!

This – admittedly indelicately named – technique shares a lot with mind-mapping. It involves taking a blank page, and simply splurging onto it the entire contents of your brain on a particular theme. And it is invaluable for taking stock of your knowledge, as well as recycling, revising and reinforcing material learnt.

As I’ve been dabbling in a bit of Irish lately, it seemed a good time to give it the brain dump treatment. It was a pleasant surprise:

A brain dump of elementary Irish

A brain dump of elementary Irish

That ‘wow!’ effect is one of the greatest things about the humble brain dump. It lays bare just how much you have learnt – something we often fail to realise in the thick of it. And if you are feeling the fight, that could be exactly what you need. What a great confidence boost!

What’s more, brain dumping is a wonderful means of information synthesis. If you learn from several resources – for example, apps, podcasts and various course books – the technique allows all that material to flow out and mix together in a single place. That can only help to make connections and beat any contextual limits on your recall. My Irish splurge above, for example, is the product of a lot of Duolingo, much idle book browsing, a bit of Wiktionary hunting, and a fair few words picked up from 1990s Eurovision hosts!

So what makes for a brilliant brain dump?

Brain dump 101

What really recommends this technique is its absolute ease. You can simply launch straight into the fun with pen and paper.

However, like mind maps, it’s even better to have fun with lots of pens, customising with colours and creative doodles. You can use colours logically, coding for categories of words or topics, or just according to taste. After all, this is your brain we’re talking about. Let your splurge represent the contents of your mind in all its colourful glory. Create a real sense of ownership over all those words and phrases in your head!

Brain dump apps

As no-nonsense as old school is, you can still bring brain dumpage right up-to-date with a bit of technology. Note-taking mobile apps in particular offer a degree of finesse and editability that is difficult to achieve with plain old pen and paper. This is especially handy if you are (like me) fickle and prone to changing your mind about how your creation takes shape, or need several attempts to get it all just right.

I use Notability on the iPad with Apple Pencil to create mine. In use, it offers all the freedom and fun of a pack of coloured pens. But the lasso-cut-paste feature is a godsend if you like moving things around, making room for extra items and are a stickler for precision placement. If you can geek and tweak to your heart’s content, you can more readily create something to be really proud of.

Editing a brain dump in Notability

Editing a brain dump in Notability

There is another helpful advantage to using editable media like a tablet to create a brain dump. If you are a little unsure of a term, write it down regardless. You can always check later, then come back to update your chart with the corrected form. Half-knowing something is still knowledge you can claim as your own. The very process of self-correction will help cement that word in your mind.

Tailor to your level

Of course, brain dumping is perfect for learners at A1/2. Having studied for just a couple of months or so, you can brainstorm all the vocab you know onto a single page. They are the core words that form the foundation of your later proficiency. Displaying them in one place will really help them stick.

But brain dumping is not just for beginners.

If you are more advanced, attempting an outpouring of all your knowledge is a mammoth task. So choose just a single topic instead. Food, travel, politics – a brain dump is an ideal medium for revisiting what you know. And it makes for brilliant prep if you are planning to talk about those topics in a forthcoming class or tutorial.

Want to add an element of challenge? Set yourself a time limit, say, five minutes, and see how much material you can churn out on your given subject.

Cheat sheets

When you’ve filled a page with learnt material, completed brain dump charts make great cheat sheets or reference guides, too.

Here’s one on the psychology of learning I created during exam revision some years ago. It makes a handy at-a-glance guide to refresh my memory even now, years later. Note how much tidier this is, compared with my more rough-and-ready Irish exercise above – it’s a good idea to spend time making them look nice if you plan to use them this way!

A brain dump for the psychology of learning

A brain dump on the psychology of learning – a great refresher sheet years later!

So for confidence, synthesis and recall support, brain dumping can be a simple and effective addition to your learner toolkit. Try building a regular brain dump into your language learning and enjoy the leg-up it gives you to memory mastery. Find natural breaks in your routine where a stocktake makes sense, for example, the end of a chapter or book section, or a section separator in Duolingo.

And stick to the rule that material learnt is never material ‘done with’. To keep it fresh, recycle, recycle, recycle!

Streamers

I Get So Emotional, Bébé : Using Positive Emotion to Improve Vocabulary Recall

That positive emotion enhances learning seems intuitive to us. How much more do we learn feeling motivated and wired, compared to those times we try to cram when feeling flat and uninspired?

Unsurprisingly, there is a heap of research that backs up the intuition. Some investigations, such as this 2017 paper, focus on the exact mechanism operating between emotion and memory. A key factor in enhanced learning, and later recall, appears to be the way positive, heightened emotion focuses the attention tightly on the stimulus – our learning material. The brain attaches a greater salience to the stimulus, encoding the information for readier recall later.

The importance of these “focal enhancements” of emotion on memory has spawned rafts of scientific papers on the subject. Classroom educators are already working these findings into their practice.

So how can it help us language learners?

Once more, with feeling

Firstly, creating happy thoughts at the point of initial memorisation is not always the easiest place to start happying up your learning. It is rather impractical to set up all-singing, all-dancing scenarios during your systematic vocabulary work. Regular, planned drilling with tools like Anki will always be a rather straightforward and plain – though invaluable – technique.

But you can plan to use new material in a way that associates material with a positive emotional response later. This takes a little forward-thinking, and involves setting up occasions where language use triggers smile momentsthose socially rewarding, oxytocin-bound interactions that feed our social reward circuits and give us warm, fuzzy feelings. Precisely those feelings are the ones to give our words and phrases salience within the recording brain.

If you have face-to-face lessons, for example, is there a humorous or colloquial phrase using new vocabulary that you can roll off to your tutor? Quotation archive sites are great to search for these. Similarly, could you Google a joke or pun using some of your recent word additions, and reel it off to your captive audience?

Making a conversation partner smile or laugh with an unexpected aphorism is a wonderful way to unleash that elusive burst of pride / surprise / joy. Chances are that you will recall the associated words or phrases much more readily than otherwise. You will have tied the material to the lived experience of positive feedback.

Anticipated emotion

Setting the scene for future reward leads us to another key link between emotion and learning: anticipation. Looking forward to the fruits of your mental labour is an extremely powerful motivator. Just the expectation of feedback is enough to increase engagement and focus – and through that, memory. For example, one particular research paper concludes that simply anticipating speedy feedback sufficed to increase performance.

The easiest practical lesson to take from this is that we need something to look forward to when learning. Working with a tutor who supplies constructive, regular feedback is one route. But even as a lone learner, there are some simple ways to build anticipation into your positive feedback loop.

Informal test-based feedback, for example, is available in all sorts of languages online. This German self-test on the Goethe Institute site is a great example. On the other hand, if you like your feedback more formalised, cultural institutes frequently offer official exams of proficiency. Many lone learners work towards gaining accreditation such as the Bergenstest in Norwegian, or the JLPT in Japanese. The anticipation of getting solid results can drive a learner forward, especially in the absence of direct teacher or peer feedback. Failing that, even the goal of doing well on a competitive platform like Duolingo can inspire a positive buzz.

Returning to our gregarious friend oxytocin, social anticipation can be the warmest and fuzziest kind. Using your languages socially need not mean a fully-fledged trip abroad, of course. Any kind of interaction, be it at a local language café group, with native speakers at work, or just fellow learners, can be the emotional carrot to your language learning donkey.

Clowning around

Of course, humour is something that works particularly well in these social settings. Getting a laugh from creative, or – let’s joyfully admit it – silly use of language, can be a nice way to make vocabulary stick, too.

The proof of this is written all over the internet, and it starts with Duolingo. The behemoth of online language learning resources famously uses comedic sentences throughout its language modelling. People who find something funny want to talk about it, naturally. And Duolingo users have turned to one particular feed (forgive the name) to share their favourite eccentricities of the platform.

The moral of the tale? Use inane, ridiculous, silly language to practise. Be a clown. Talk about it. Share it with fellow learners and subject your wider family and friends to it. Laugh – and remember.

 

The joy of teaching

Finally, it is hard to underestimate one joy close to the hearts of linguaphiles: the joy of teaching. The fact that teaching others helps our own learning is well documented. But that thrill of seeing something click for someone else plays right along with the positive emotion game.

Bust this myth before you start: you do not have to be an expert to teach something. You just need a bit of knowledge you can share with someone else. If you have a learning buddy, or compliant family member or friend, share with them your most recent observations about your target language. Make your explanation as interesting and illuminating as possible – and enjoy the click when it happens. Remembering the moment you taught the material to another person will be a superb hook to remember the material itself.

Little and often

As the examples show, working positive emotion into your learning routine does not mean maintaining constant jollity. Emotional content need not be dramatic or earth-shattering. In fact, it should not be so. The same research suggests that strong, negative emotional states like stress can have the opposite effect.

What’s more, we clearly cannot sustain an environment of constant emotional excitement. Even if that were possible, it would be counter-productive. Our brains are not so easily tricked. It would simply become our new ‘normal’, and all the salience benefits lost.

Instead, the methods outlined above are some routes to routinely and subtly get happy with your language learning and practice. Stay positive, stay connected, and enjoy all those motivation and memory benefits!

 

A spreadsheet containing German verb information.

Anki custom note types for complex morphology flashcards

If you use Anki, have you ever felt like the the out-of-the-box templates are a little basic?

The default card has just two fields for back and front. Of course, this is instantly relevant for simple vocabulary learning. You can begin adding your target-translation word pairs in straight away. It is intuitive and allows newcomers to get started straight away. Simplicity can be great!

However, as Anki works further and further into your language learning routine, that simple A-B card type can feel lacking. In particular, one single input box can seem a squash for all the extra information you learn alongside the dictionary form of your vocabulary.

Overloaded cards

A good example to illustrate this is the topic of irregular verbs. For example, take the French verb être (to be). It isn’t that useful to have a card that only lists the information “to be = être”. As a learner, you will surely want to add more detail, such as the present tense.

Now, using only the default card type, there are ways to include this detail. You might choose to add it in brackets after the infinitive, like “to be = être (je suis, tu es, il/elle est, nous sommes, vous êtes, ils/elles sont)”. But the problem is becoming obvious – your cards begin to look overloaded and messy.

Adding more info to basic Anki cards soon becomes messy.

Adding more info to basic Anki cards soon becomes messy.

There is a quick fix. When you create your vocab items, you can switch to inputting in HTML. Using HTML tags, you can then add line breaks and other formatting. With a bit of fiddling around, it is possible to separate out that info and at least make it more readable.

Formatting busy entries using HTML in Anki

Formatting busy entries using HTML in Anki

The result of HTML formatting an Anki text input

But still, all that information is jammed into a small input box. What happens when you want to make them more comprehensive, adding other tenses and so on? They will begin to look unwieldy.

And adding all that formatting is hardly economical with your valuable time. It would be better if the formatting were somehow automatically connected to the data itself, rather than completely manual.

Not only that, but there is also a good pedagogical reason for not cramming all that information into one space. During testing, all the material in that input box is bundled together as the answer. That is now a lot of material bound to single English prompt “to be”.

If only there were some way to separate it all out!

Anki custom card types

Well, a huge strength of Anki is how customisable and extensible it is. True, its advanced functionality might be well-hidden under a very plain interface, but you have a great deal of room to adapt and extend its basic workings.

It is Anki’s ability to create custom note types that will help us solve this problem. Custom note types allow you to define the fields for your cards. And they can be as comprehensive as you like, reflecting all the separate morphological parts of each vocabulary item.

It started with a list…

First things first: if you are creating word lists with very detailed, systematic additional info, Anki is probably not be the best place to collate it initially. Spreadsheet programs like Excel, Numbers or Google Sheets are much better geared up to this kind of thing. The format you need to save in is CSV (comma separated values), and all mainstream spreadsheet programs should give this option when saving or exporting.

Simply start adding your items, row by row. Use a column for each piece of information you want to keep separate. There is no need to use column headings. In the German verbs example below, there is a column for the infinitive, English translation, and then each of the six parts of the present tense.

Importing complex vocab items into Anki via CSV file

Importing complex vocab items into Anki via CSV file

Once you are happy with the number of items, you are ready to import it into Anki. And to make a fitting home for your new words, we create a new custom note type matching the fields in your spreadsheet list.

A wee note before we start: you need to be using the desktop program for this, as it is not possible in the mobile app. Before you do so, be sure to sync on all your devices, then sync on the desktop program. This is because the changes we make on the desktop client will require a full resync with Anki, and you don’t want to lose any progress from your devices. Also, to be safe, always back up your Anki decks before performing any major surgery on your precious cards!

Creating a new note type

In Anki, head to Tools > Manage Note Types. Once in the there, click Add, then Add: Basic and OK to select a template to base our new type on. We will use the basic one here, but you can experiment with more complicated types later on, if it takes your fancy!

Importing complex vocab items into Anki via CSV file

Importing complex vocab items into Anki via CSV file

Here, you add the fields that correspond to each column of information in your vocabulary spreadsheet. In the example below, I have also renamed the first two fields to reflect the verb-based example material more appropriately.

Importing complex vocab items into Anki via CSV file

Importing complex vocab items into Anki via CSV file

Now your data has a custom-made container to call home, you are ready to import it. Head to File > Import in your desktop app, and find the CSV file you saved / exported from the spreadsheet.

In the Type field, select the custom note type you just created. Then, select a deck to import it into (you might want to create a brand new one for this first).

Magically, Anki matches up the columns in your spreadsheet to the fields in your custom note type, as indicated in the lower half of that window. You can change how they marry up, but you shouldn’t have to as long as the number of spreadsheet columns and note fields tallies, and the order of them is the same.

Importing complex vocab items into Anki via CSV file

Importing complex vocab items into Anki via CSV file

That’s it! Anki has taken charge of your data, and will now drip-feed it to you daily along with your other cards.

But hold on – something isn’t quite right. None of the new, extra fields show in study mode. Egads! Not to worry – there is just one last step.

Styling your cards

The problem is that the basic type, which we used as a template, only shows the first two fields by default. That’s because it is based on a simple vocab flashcard with a front and back, and just two corresponding pieces of information. We need to style our new card type manually and add in those extra fields.

In the desktop Anki app, open up the Browse window. In the left-hand list of your Anki assets – decks, cards and so on – find the entry for your new note type. Click on it and you should see all your imported items on the right-hand side.

Locating your imported vocabulary via note type in the Anki Browse window

Locating your imported vocabulary via note type in the Anki Browse window

With any of those entries highlighted, you should see a button labelled Cards underneath. Clicking that opens up the card styling window, where you can add in placeholders for those missing items.

On the left, Anki gives you three editing panes. Bear in mind that this window represents a card with two ‘sides’. The first pane represents the front side of each vocab card. Then, there is a window you can use to add styling to both sides. Beneath that is a pane for the flip side. On the right is a preview of how both sides look.

On first opening this view, you will just see the first two fields (in the example below, Infinitive and Translation). Crucially, however, note that they are enclosed in {{double curly braces}}. This is Anki shorthand for a field when creating card templates.

With this knowledge, you are equipped to add in your extra fields. In our verbs example, the extra fields correspond to parts of the verb paradigm. Therefore, the field 1ps (first person singular) from the note type becomes {{1ps}} wherever it should appear on the card in study mode.

You can embed them within basic HTML, too, using divs, headings, paragraphs, line breaks and anything else to make them clear.

Importing complex vocab items into Anki via CSV file

Isn’t that better? Formatted cleanly, with styling applied automatically to every new vocabulary note of that type.

Top of the Anki class

Here’s where this technique can be really powerful. Now your information is separated, you can add in some of Anki’s other testing features to your card templates. If, for instance, you add test: after the first pair of curly brackets, that field becomes a type-in box in study mode.

You can put in as many of these as you want. In our verbs example, you could use type-in boxes to test the whole paradigm, like this:

Building more comprehensive tests using your Anki custom note types

Building more comprehensive tests using your Anki custom note types

Isn’t that a huge improvement on the original, basic A-B flip card? You have turned Anki into a real grammar testing machine. Take a look at the Anki manual for further tips and tricks about styling your cards in this way.

Keep playing

For sure, there is a lot more to this technique than the outline above. Our verbs example uses just a simple, one-sided card as a template, but there are many more options. As with all things Anki, it is well worth playing with the tools available to see what is possible.

After all, personalising your learning is taking charge of it. Have fun with your customisation!

Is your learning on fire? Just check your streak! Image from freeimages.com.

Feel the heat: get a visual grasp on Anki with this natty plug-in

Anki is an incredibly powerful tool with a heap of learning science behind it.

But do you ever feel, as an Anki user, that the process is all a bit of a mystery? That, instead of being passively fed material, you might like to glimpse inside the flashcard box and find out a little more about its electronic, spaced-repetition plans for you?

A chance question from a teacher and polyglot pal this week helped open up that box for me. And it’s worth sharing this little-known secret with anyone who want a bit more data than the all-knowing app is ordinarily willing to provide.

Streak test for gold

It all starts with a streak. A learning streak, that is: a golden motivational corridor in educational gamification.

Streak is the presentation of unbroken, habitual use of the app as an achievement. And it has long been a staple of gamified platforms like Duolingo, which quickly grew on its sticky back. The streak almost becomes an end in itself, powering the language learning along with it. Proud players share their incredible feats with others who hope to reach the same heights.

While Duolingo's streak feature is very popular, Anki does not have one.

On the face of it, streak does seem like an intuitively natural thing to want to know as a learner. How committed am I, in terms of how regularly I study? So it comes across as an odd omission from the standard Anki installation.

It all came to light when language buddy Marcel (so often a source of tips on everything language learning) asked if I knew where to find streak reporting in Anki. Despite the raft of data in the app’s familiar stats section, streak was nowhere to be seen. I was stumped.

Fortunately, a natty little plugin came to the rescue.

Review Heatmap

Review Heatmap adds a panel of information to the summary screens in the desktop version of Anki. Although the extra information seems quite standard, you might otherwise rack your brains to locate it in vain in a vanilla installation.

Although still in Beta for the latest 2.1.x stream of Anki releases (with a version for older versions here), it runs reliably and instantly exposes useful stats on the very first run.

The Review Heatmap plugin for Anki

The Review Heatmap plugin for Anki

Learning how you learn

Along with streak info, you can see a couple of other handy stats that do not feature in Anki’s regular data breakdown, including your average cards-per-day rate. And knowing about your learning is valuable meta-knowledge that can be just as useful as first-level learning material like vocabulary lists.

For example, take a look at the mass of colour in the plug-in display. Each square represents a day of your Anki year. You see the blanks? Those are the days on which you broke your streak. Interrogating the data like this can really help in the quest to learn how you learn.

Is there a pattern to them? Do they happen regularly? And can you use that information to preempt interruptions to your learning, and avoid them in future? In my case, hovering over my streak break blanks confirms what I suspected – they were days when family were visiting. Now I know this, I can try in future to review my Anki decks well in advance when I know I will have people round.

Streaks are not just about fun and pride. They encapsulate knowledge about your learning. And knowledge is power.

Pick a card, Anki card

The power of streaks is only one great way that Review Heatmap can boost your Anki learning. Like many things that just work, the app can be something of a black box. We adds words, Anki feeds them back to us using its clever algorithms. But sometimes, it can be informative to get a grasp on the workings inside that machine.

Exploring the heat map of coloured squares – the visual display style that gives the plug-in its name – can give you a more instinctive feel for how Anki schedules its cards. The darker the colour, the more cards scheduled on that day. By casting an eye over that annual map, you get a sense of the ebb and flow of card reviews, past and future. Hovering over individual squares even yields the exact number of reviews due on that day.

Not only that, but it is oddly satisfying to flick forward to subsequent years, and see reviews getting more and more infrequent. That gradual thinning out of card reviews is something special: it is Anki’s algorithm determining that you have, in accordance with the theory behind the system, memorised those words good and proper.

Obviously, numbers shift and change if you are actively adding cards all the time. But the visual snapshot is a fascinating way to start understanding how the spaced repetition approach plays out in real time.

Review Heatmap in lovely magenta.

Review Heatmap in lovely magenta.

Obviously, it also doesn’t hurt that Review Heatmap looks pretty funky in your Anki app. And there are some gorgeous colour options in the settings, too!

Turn up the heat

If you are ready to turn up the heat on your Anki routine by adding streak info and more, Review Heatmap is an essential add-on. Although it only boosts the desktop program, rather than the mobile apps, its insights can give you a real bird’s eye view over your learning.

As always with plug-ins, be sure to back up your Anki data before giving it a whirl.

 

Printing letters. Image from freeimages.com

Personalise your vocab routine with Tatoeba custom lists

Often, on a learning journey, you find your way back to a trusty old path travelled a while back. And recently, I have found my way back to the mass sentence site Tatoeba in order to solve a very particular language learning problem.

Sourcing specialist vocab in context

The issue to solve was familiar to many of us: a lack of formal learning materials on vocabulary topics of specific interest to us. For me, politics and current affairs are such hot topics, and I enjoy chatting about them. Why not bring that into my conversational sessions?

Here’s the rub: not many language primers cover this material thematically.

Of course, I could dive straight into primary news materials like newspaper websites. But these are frequently well beyond the ‘intermediate improver’ stage I am at with a number of my languages.

The solution? Tatoeba’s vast corpus of searchable sentences taken from all areas of written life, and translated into multiple languages by native speakers.

Curating custom Tatoeba lists

Why is Tatoeba such a perfect platform for sourcing very specific vocabulary for speaking lessons? It is atomised, for a start. The sentences may be lifted from extensive, lengthy, real-world texts online and elsewhere, but they are broken down into single sentences for consumption on the site. As a result, they are much easier to work with.

For example, rather than scouring tvp.info for useful instances of the word rząd (government) in use, I can simply search Tatoeba for sentences containing that word. Not only is it quicker, but the yield is greater too; scores of sentences pop up in an instant. It would take a lot of online scouring to find so many items from scratch.

Creating custom lists

The second big advantage of vocab-hunting on Tatoeba is list curation. With all those useful governmental phrases called up, you simply work your way down the results, clicking the little document icon to add them to a custom list. These lists become you very own personalised vocab learning banks.

Mining Tatoeba for sentences containing the Polish 'rząd' (government).

Mining Tatoeba for sentences containing the Polish ‘rząd’ (government).

A note on quality: for best results, use the advanced search and ensure that you check the owned by a self-identified native option when phrase-chasing. You can even specify whether the entries have audio or not, which may be useful if you are brave enough to play with more complex options for export!

Advanced search options on Tatoeba

Advanced search options on Tatoeba

Once created and populated, your list has its very own page, including a simple text export option. You can also make what you have created publicly available, if you are minded to share.

Curating a custom list from Tatoeba sentences

Curating a custom list from Tatoeba sentences

After you have refined and exported your list, it is an easy final step to add the data to your Anki decks via File > Import. Likewise, importing into Quizlet is hassle-free with the basic tab-delimited format of the exported file.

Then, the real work begins as you start to drill your new vocabulary bank!

Material from Tatoeba imported into an Anki card

Material from Tatoeba
imported into an Anki card

Realistic expectations

A word of caution on importing your sentence cache into Anki: be kind to yourself. The default daily drip rate for new vocab items is ten per day. As these are full sentences, sometimes quite complicated, that can be a stretch. That is true especially if you are running these new sentences alongside your current decks, doubling your daily load.

I reduced my new card rate to five a day for the Polish deck above, which was just challenging enough whilst ensuring that I worked through them at a decent speed.

Back to its best

Tatoeba bounced back from a serious crash in recent months, and is now back to its best as a top tool for vocabulary expansion. It is a very welcome return for anyone hunting  custom source material for language learning.

As for my own progress, so far so good. Slowly but surely, that carefully selected material is making its way into my memory. And since it matches my interests, motivation to learn is high. Not only that: I am so used to drilling single dictionary items in Anki, that the fresh wave of full sentences has made for a helpful change. And it deserves a mention again and again: variety is a fundamental pillar in any successful language learning regime.

Give mass sentences a go if you struggle to find support for the things you want to talk about. There’s nothing like some vocab DIY to revive a tired routine!