Dawei Zhijiage
How I use macros and Excel to learn Chinese characters I use several Microsoft Excel macros together with a program called E-stroke 2.0 to learn Chinese characters: 1. When I open my learn 汉字 spreadsheet, macros run in the background, waiting for me to click on certain cells. 2. Once I click on cell address, Excel VBA automatically pronounces the Chinese character in a native speaker’s voice 3. Finally, Excel copies the character onto the clipboard so that I can paste the character into a program called E-stroke 2.0. I use this program to show me Chinese stroke order and learn which other characters matched the character I had clicked to form new words. How do I get this to work? 1. I downloaded a list of the most frequently used Chinese characters here: http://www.learnchineseez.com/read-write/traditional/index.php?page=5 and pasted them into Excel. 2. I downloaded a Chinese Dictionary here: http://www.mdbg.net/chindict/chindict.php?page=cedict so that I use Vlookup formula to find the Pinyin of the characters. But the Pinyin is hidden for me in order to test myself to see if I had remembered the character. 3. Audio files of Native Speaker pronouncing each Chinese character can be found here: http://www.quickmandarin.com/chinesepinyintable/: (Note: Even though there are more than 11,000 Chinese characters, there are less than 1700 pronunciations, so the same audio file can be used for all characters pronounced shi4.) The cool thing about this macro that I wrote is I can test my ability to hear and disguised the sound in Chinese because let’s face it, a lot of times, we can’t even guess what characters Chinese people are speaking and we also get confused by similar sounding words. I believe this program will help me with that.
Sep 22, 2014 6:32 PM
Corrections · 10
This is really cool. I'd like to learn about macros when I start to learn Japanese.
August 20, 2015
You could find a teacher on italki that's reasonably priced
August 13, 2015
I want travel to china, so a little Chinese mandarin is essential. It is hard to choice which online-school is better to attend, so I ask some friends who live in china, they suggest me Hanbrindge Mandarin school . is anyone who attend class on their website? Can you give me some advises?
August 13, 2015
I had that feature in another program to grade myself... but the criteria was subjective because it was dependendent on my answering honestly
September 25, 2014
Amazing. Maybe you can add some functions that grade each character you know. You will get a list to review.
September 24, 2014
Show more
Want to progress faster?
Join this learning community and try out free exercises!