You are bidding on a job to review a set of 10,000 search terms to determine which ones will make good How-to article titles. If this project goes well, there is the possibility for additional work of a similar nature. The file has 5 fields in it: a primary key, a link to a Google search for the keywords, a raw title, a cleaned title, and a column for you to make your judgment about the keyword. For the clean column, the "how to" was removed from the raw title and the capitalization was fixed by machine. Your job will be to carefully read each clean title and decide if it makes a good article title or not. If the keyword can be used as is with no modifications as an article title(i.e., is spelled correctly, follows good English grammar, doesn't involve sexual or illegal content), you will mark a "Y" in the column adjacent to the title. If the keyword is a duplicate of another keyword, you will mark a "D" next to it. If the keyword cannot be used because it unclear, or ungrammatical or misspelled in any way, you will just mark those as "N". In addition, you should mark as N any words that involve sexual acts (i.e., no touching of breasts or genitals - but hugging and kissing are OK) or are violent criminal acts (murder, carjacking, etc.). Each of the keywords has a Google search link for it; you should use this whenever you do not know what the keyword means. To be considered for this work, you must complete the brief practice test in the attached .zip file. This test has 40 keywords in it and should take no more than 5 minutes. Also included in this file is a set of example keywords we have completed to use as a guide. To complete the test, simply read the Clean title, determine if the words would make sense and would be grammatical if they followed the phrase "How to", and mark Y, D, or N in the appropriate column. The example file includes explanations, but you do not need to use them in your test.
## 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
.xls or .csv files