Say It Right Series
speak chinese like a native

The tools and the recipe for cooking up your own character point entries...

Posted by henning July 12, 2008 in the Group General Discussion.

Tags: tools, characters, character points, dictionaries

Here is my method of generating the character groups.


1. Identify structural relationships to other characters:


2. Based on the basic pronounciation variations identified with the tool hunt down more characters using Google Pinyin:

Enter the Pinyin and work down to the most obstruse characters. Also try variants...


3. Find out about the meaning with the dictionaries of your choice, of course the cool:


4. For the main radical, traditional/simplified variants and the meaning of more obstruse characters you have the indispensable:


5. Important is definately the frequency:


6. Gather everything, e.g. with MS Excel. Build a formula for generating some HTML that puts the data together and adds colors.

The boundaries I use are: Frequency

< 2,000 --> green

< 4,000 --> orange

< 6,000 --> brown

< 10,000 --> blue

>= 10,000 --> red

Here is my formula I am using

Note: N is the column with the frequency data:

IF(N3<2000;"<font color=green>";IF(N3<4000;"<font color=orange>";IF(N3<6000;"<font color=brown>";IF(N3<10000;"<font color=blue>";"<font color=red>")))) &G3 &IF(H3<>"";" ( "&H3&" )";"")&"@Pron: " &J3&"@Main radical: "&K3&"@Frequency: "&N3&"@Meaning: " &L3&IF(M3<>"";"@Examples: "&M3;"")&"@@</font>"

The placeholder for the linebreak here is the @-character which can be automatically replaced later, e.g. in Word with proper CPod-compatible linebreaks.


Note that the HTML is only interpreted correctly after a re-edit of the post.

Comments (24) RSS

loading... Updating ...

New lesson idea? Please contact us.