Hi everyone
I'm currently learning a new language and I already use a method, but it doesn't really suit me. I would therefore like to use a new method which would be based on the percentage of success. However, I don't really know how to go about it. If you don't have an answerto all my problems, that's fine
If you have a look at the table below it will be directly easier for you understand I think.
Note that I use the OneDrive online version of Excel.
Let me explain it to you :
Each new word added starts with a percentage of 50%. This percentage will be visible in the "Percentage" column. For each good translation the percentage increases by +25%. For each bad translation the percentage decreases by -25%. For each semi-good translation the percentage increases by +25%, and from 75% only good translations will increase by +25%. The final percentage/result cannot go in the negative (less than 0%) nor exceed the maximum (more than 100%).
There would be a column with the correct translation that I could hide by pressing a single button
In the "Percentage" column there would be a spin button to adjust the percentage myself.
The background color would adapt depending on the final percentage obtained: 100%- 75% -50% - 25% - 0%
For the most knowledgeable among you: be able to adapt the color of the word entered in the "To translate" column according to the number of correct letters. It would help me to improve and autocorrect myself. For example more than half of the letters are correct = yellow, less than half = red, all of the words = green. Or a similar method if you got one
Thanksss alot !
I'm currently learning a new language and I already use a method, but it doesn't really suit me. I would therefore like to use a new method which would be based on the percentage of success. However, I don't really know how to go about it. If you don't have an answerto all my problems, that's fine
If you have a look at the table below it will be directly easier for you understand I think.
Note that I use the OneDrive online version of Excel.
Let me explain it to you :
Each new word added starts with a percentage of 50%. This percentage will be visible in the "Percentage" column. For each good translation the percentage increases by +25%. For each bad translation the percentage decreases by -25%. For each semi-good translation the percentage increases by +25%, and from 75% only good translations will increase by +25%. The final percentage/result cannot go in the negative (less than 0%) nor exceed the maximum (more than 100%).
There would be a column with the correct translation that I could hide by pressing a single button
In the "Percentage" column there would be a spin button to adjust the percentage myself.
The background color would adapt depending on the final percentage obtained: 100%- 75% -50% - 25% - 0%
For the most knowledgeable among you: be able to adapt the color of the word entered in the "To translate" column according to the number of correct letters. It would help me to improve and autocorrect myself. For example more than half of the letters are correct = yellow, less than half = red, all of the words = green. Or a similar method if you got one
Thanksss alot !
