I am studying Chinese / Mandarin in Shanghai. I need help creating an excel spreadsheet that will help me learn to translate and recognize Chinese Characters
The excel sheet will allow me to add on each row.
a) Chapter of book
b) The book. I have 3 books
c) The Chinese Characters (I have added the Chinese Language version to my PC to allow me to do this)
d) The Pinyin (The alphabet version of the Chinese Character)
e) The English Translation of the Character...
I then need the ability to create Random test exams in a separate sheet based on the following criteria, from a user friendly interface that will generate test sheets.
There needs to be 2 types of test
a) Select Random Chinese Characters based upon book, collection of books (or all books) and chapter or selection of chapter (or all chapters)
The test will contain
For each row - the Number and the Chinese Character, with a answer "cell" where I will type the English Translation in the answer
b) Select Random English Translation words based upon book, collection of books (or all), chapter, or selection of chapters (or all chapters)
The Test will contain
For each row - The number and the English Word with an answer "cell" where I will type in the Chinese Character answer
The test will contact the number
Tests will either be:
10 Questions
20 Questions
50 Questions
100 Questions
All
Each test must include random selctions from each of the criteria...
eg If I select book 1 - Chapters 1, 2, 3 the test will contain questions for each chapter
The Excel spreadsheet will also be able to compare my answers to the test and provide a score of my success... The results sheet will contain:
Chinese Character
Pinyin
English Translation
My Answer
Correct / Incorrect indicator
Score Summary at the top of the page - eg 1 of 10 correct 10% Success
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
I run Windows Vista and Excel 2007