Have you always wanted to learn a language, but weren’t sure which one? (or are you looking to learn a new language but aren’t sure which one?) Are you reluctant to invest time studying if you’re not going to follow it through?
I have asked myself the same question and have come up with a way that may help you form a decision.
1. Make a list
To start of with I opened up Excel (or Mac Numbers) and made a list in a table of all the languages that I have some interest in studying:
2. Advance/Effort Column
I then inserted another column titled Advance/Effort.. Now in this column I wrote down a number between for each language, which I thought would be how much I would advance for the amount of effort I would have to put in. I chose a number between 0 and 5. 5 would be if I were to advance more quickly (with perhaps less effort), 0 would be if I were to advance more slowly (with perhaps a lot of effort). The numbers I entered in were the following:
As you see Japanese and Mandarin have got an Advance/Effort number of 1, this is because I have estimated that I would get a low advancement (or little progress), for the amount of effort that I would put in. Whereas for example with Italian I have put in an Advance/Effort number of 4, this is because I think that I will be able to progress relatively quickly for the amount of effort that I would have to put in.
These numbers for Advance/Effort have been chosen based on my own way of learning and taking into account the languages that I already know and the amounts of knowledge that I have in these other languages.
If I was to approximate the amount of Advance/Effort for someone who only knows English I would estimate them to be:
(In the above table I have also inserted Spanish)
3. I then added another three columns, Total Reward, Financial Reward and Personal Reward.
The Total Reward is the total of the Financial Reward and the Personal Reward. The Financial Reward and the Personal Reward are both on a scale of 0 to 5.
The Financial Reward is your increase in potential earnings which would result from knowing this language. So for example if you didn’t speak English but wanted to work in an industry where English is valued then the potential financial reward would be high. If on the other hand you were considering learning Latin, and think that there would be very little chance of getting any financial benefits from this then this rating would be low. Much of the financial rating depends on where you might work and what type of work you would be looking for, there also exists the possibility that a lesser spoken language which appears to have very little financial potential could actually lead to considerable work, precisely because so few other people have learnt it. However to give us a guide it is a good idea to approximate, based on where you will be working and what you want to do.
The Personal Reward is what you will gain from learning the language on a personal level, this can be any of a large range of factors. So for example you may have a spouse whose mother tongue is, let’s say, French, and all his or her family speak French, you frequently visit them and they all speak French. You would therefore get a huge personal reward from learning to speak French as you will be able to understand and communicate with them on these visits, as well as getting to know another side of your partner.
Another example is if you have always been fascinated by the culture of, let’s say, Japan, you don’t know what it is but you’ve always been drawn towards the writing system, or the manga, or the way the people behave.
You could have an interest in the origins of languages or ancient history, if so then perhaps Latin would have a higher personal reward.
For the personal reward, as well as the financial reward, I have given them a rating between 0 and 5.
The Total Reward, can now be found by adding the Financial Reward and the Personal Reward, so in the top row we can write =(D2 + E2)/2 , where D2 and E2 are the cells of the relevant Financial Reward and Personal Reward respectively. I have inserted the brackets and the “divide by 2” so that the Total Reward will be out of 5, and so will have a similar relative value as the Advance/Effort value. You can then replicate this formula in the rest of the cells in the column by clicking on this top cell and then clicking and dragging the bottom right hand corner of the cell so that values underneath are filled in using the relevant values.
4. Weighting the Total Reward:
We may be more or less inclined to chose a language for either financial reasons or for personal reasons. If so, we can weight the Total Reward so that it favours our preferred motivations. For example, I have chosen to put a larger weight towards the potential Financial Reward by a scale of 4 to 1, hence I have written in the first column =(4*D2 + 1*E2)/5. I have divided by 5 so that the Total Reward will be on a scale of 0 to 5 again. In general you would divide by the sum of the two numbers used in your weighting, so if you use 3:1, then you would divide by 4, 1:2 then by 3.
Putting these together, this then gave me the following table:
|Language||Advance/Effort||Total Reward||Financial Reward||Personal Reward|
5. The Language Focus Value:
This is then a number that you can get, using your values for Advance/Effort, Total Reward and your Weighting for the Total Reward, to give you more information about which language you should learn or focus on. I got it by multiplying the Advance/Effort value by the Total Reward, using the formula =.4*B2*C2 . (I have multiplied it by .4 to get a value between 0 and 10.) You can now copy this formula down into the rest of the cells of the column in the same way as you did for the Total Reward.
This will then give you the following table:
|Language||Advance/Effort||Total Reward||Financial Reward||Personal Reward||Language Focus Value|
The higher the number in the Language Focus Value column, the more priority should be given to this language.
6. These results can perhaps be seen more clearly in a Language Focus Graph:
If you select the all the data cells of the two columns Advance/Effort and Total Reward, then Insert > Chart > Scatter, we should get a graph that looks like the following:
Advance/Effort is on the x-axis (along the bottom) and Total Reward is on the y-axis (going up on the left hand side). The closer to the top right hand corner the point is, the more focus should be put into that language. You can find out which language the point belongs to by reading off the Advance/Effort value (and the Total Reward value if necessary) and looking them up on the table. (Unfortunately Mac Numbers or Excel don’t let you label the points plotted on a scatter chart very easily but it’s not too difficult to work out which is which.)
The two languages at the top right hand corner are French (slightly higher), then Italian (slightly lower and to the right). As can be seen from the table above the Language Focus Value of these points are both 6.3, the next closest are Portuguese (4.0) and German (3.7) which are the next two closest points to the top right hand corner.
You can then experiment with the weighting in the Total Reward column (remembering to copy any changes throughout the column) or modify some of the values you’ve given for Advance/Effort, Financial Reward, or Personal Reward and see if this makes any significant changes.
I hope this has been of help and please leave your own highest Language Focus Value(s) in the comments below.