- create main page with user login, admin login and register user links - create user register page and user login page - On main landing page, display all apps, displaying them as a grid that is searchable - Classify the apps eventually, by grade, by application such as learning grammer, games, building vocabulary - In admin account - Leftside menu to display all admin applications - Display dictionary of all words as paginated, searchable data table - Actions: Edit word, set attributes of word - Display attributes of words - Display Synonyms of a word as a paginated, searchable datatable. Allow upload of Synonyms as CSV file - when synoyms are uploaded, each word is also uploaded to dictionary and if its already there, its word_id is taken - synonyms are stored as one-to-many word_ids in database, not as text - Display Antonyms of a word as a paginated, searchable datatable. Allow upload of Antonyms as CSV file - when antonyms are uploaded, each word is also uploaded to dictionary and if its already there, its word_id is taken - antonyms are stored as one-to-many word_ids in database, not as text - Display plural of a word as a paginated, searchable datatable. Allow upload of singular-plural as CSV file - when pairs are uploaded, each word is also uploaded to dictionary and if its already there, its word_id is taken - singular-plural are stored as one-to-one word_ids in database, not as text - Display male-female of a word as a paginated, searchable datatable. Allow upload of male-female as CSV file - when pairs are uploaded, each word is also uploaded to dictionary and if its already there, its word_id is taken - male-female are stored as one-to-one word_ids in database, not as text - Display child-parent of a word as a paginated, searchable datatable. Allow upload of child-parent as CSV file - when pairs are uploaded, each word is also uploaded to dictionary and if its already there, its word_id is taken - child-parent are stored as one-to-one word_ids in database, not as text - Display word-group of a word as a paginated, searchable datatable. Allow upload of word-group as CSV file - when pairs are uploaded, each word is also uploaded to dictionary and if its already there, its word_id is taken - word-group are stored as one-to-one word_ids in database, not as text - Admin wordbuckets - Admin submits a comma separate list of words and assigns it a name and description - In user account, create leftside menu - dashboard - App1: Word search - popup search interface, display all words underneath as paginated, searchable data table. Display search criteria up top with "displaying X out Y words" - table of words should not have action, rather a series of icons displaying the word's synonyms, antonyms, singular-plural, male-female, word-group, parent-child, etc (if available) - users can save the current list of words as a wordlist or wordbucket and give it a name and description - App2: Word buckets - a paginated, searchable datatable showing the wordlist name, description and preview of words with "Read More" as popup - user can edit a wordbucket by adding and removing words or by ordering them by word name or other attribute like word length - App3: Word reminders - User selects a wordlist - User sets frequency: daily, weekly (day of the week) - Time of day: hh + (AM or PM) - Email to send to (multiple emails supported - separate by comma) - Submit. An email gets sent by system to user at chosen frequency and time. Subject: EnglishDB word alarm: word name. Text: Word name, meaning, synonyms, antonyms, singular-plural, male-female, word-group, parent-child, etc (if available) - List of word-reminders to be saved in datatable with option to stop, edit and delete the word-reminder - App4: Flashcards - User selects a wordlist (self-created or by Admin) and clicks on Submit - A web-page gets created with the words tiled in rows and columns like an image gallery. - Hovering over a word displays the meaning - Clicking over a word display a popup with meaning, synonyms, antonyms, singular-plural, male-female, word-group, parent-child, etc (if available) - There are left and right buttons to go to the previous or next word, just like an image browser - The flash cards (one word per page) can be exported into PDF. User can select what properties of the word should be printed - App5: Spelling bee / dictation - App page displays a list of spelling bees completed by user. Name of wordbucket, time taken, score, date and action (redo) - User selects a word bucket that was created by admin, presses on start button - The word is announced alongwith the meaning (text to speech plugin). User gets a button to replay the word and meaning - A text box is provided to enter the word spelling. User clicks on submit and next word is presented until list of words is exhausted. - At the end, the score is displayed and results data is stored in the DB (wordbucket name, time taken, score, date, etc) - App6: Scramble - App page displays a list of spelling bees completed by user. Name of wordbucket, time taken, score, date and action (redo) - User selects a word bucket that was created by admin, presses on start button - A table is displayed with the characters scrambled randomly in first column, user has to enter correct word in textbox in next column - At end, all words are sumbitted and report generated. Results are saved in database as new results (old results are not overwritten). Even scrabble of words is saved for re-rerunning later - App7: Word search grid - App page displays a list of spelling bees completed by user. Name of wordbucket, time taken, score, date and action (redo) - User selects a word bucket that was created by admin, presses on start button - A grid is displayed with the words placed in rows and columns in any order (use specialized software from Github) - User has to find and select the words in the right order - Deal or No Deal - App8: Family feud - App page displays a list of spelling bees completed by user. Name of wordbucket, time taken, score, date and action (redo) - User selects a word bucket that was created by admin, presses on start button - Question (title of word bucket with tag "Family Feud:" removed is displayed - 6 empty text boxes are displayed that need to be filled out by the user - When user clicks submit, the results are displayed and stored - App9: Word antakshari - App10: Q&A bank - Admin defines a series of questions with a single answer word - User selects the question bank, then clicks on start - In a popup, the question is displayed, user has to type in the answer - App11: Bag of words - Admin creates a bag of words representing some place or some situation - User selects a bag of word, then clicks on start - User has to guess and enter the words and get as many of them as the admin provided - Score is number of correctly guessed and spelled words - App12: Synonyms - App13: Antonyms - App14: Word Bingo - Admin defines a set of 30 related words - User selects a bingo card words list, clicks on start - A bingo card of 3 rows by 10 columns is displayed, with 5 random words displayed per row, distributed in random columns - Computer announces a word randomly out of the 30 words, and user has to find it on the card and click on it - If user get corners, they press the corner button, which is displayed as a button outside the card - Similarly is user gets line, they press the appropriate line button - When user gets all words, they press Bingo button - Score is displayed as total number of words pressed, what games were won, how much time it took to complete - App15: Taboo - App16: List of verbs. Give their past, present and future tense - App17: Word meanings. For a bucket of words, the word is displayed, user has to type in the meanings, which are scored againsts words in original meaning. Score is total of guessed meanings (partial scores are added) - App18: Male and female nouns - App19: Parent and child nouns - App20: Sibling nouns - App21: Singular and plural nouns - App22: Fill in the sentence with a word and/or phrase - App23: Multiple choice questions - App24: Pronunciation: For a bag of words, user is displayed a word and has to pronounce it through mic. Using speech2text software, the word is displayed by app. If it matches the seen word, perfect score is given - This app can also be sold to schools in a bulk-license Create a graph of nodes representing words and word-groups, and edges representing relationships such as “meaning”, “antonym”, “synonym”, “belongs to word-group X”, “verb-form”, “plural”, “male-form”, “female-form”. This data should be stored in a relational database, or graph database, or JSON, or NoSQL. It should be queryable and algorithm-scriptable (overconnectivity, interconnectivity, etc) Obtain the synonyms and antonyms from online sources using a scraper. 1. Word search (hits) by a. similarity in spelling / beginning letter (use regular expressions) showing type-ahead search b. similarity in meaning (keywords, semantics) c. synonym / antonym (exact word is input by user) d. word category (exact category specified in type-ahead search. Multiple categories allowed) e. word size (greater than, lesser than, etc) f. by similarity to other words in meaning (thesaurus) 2. Word bucket retrieval for use in other applications a. By word category (exact category specified in type-ahead search. Multiple categories allowed) b. Out of N hits, how many random words should be displayed? 3. Daily word reminders a. word of the day reminders sent daily. Can be set from user control panel 4. Word->meaning (learning mode) a. Given a word entered by user, what is its meaning b. Based on selected bucket of words chosen by user, make a word learning chapter (flashcards with links to go back and forth between words) c. Based on a desired learning series (such as GRE words), a learning chapter is created (flashcards with links to go back and forth between words) d. Display a whole page about a word – its pronunciation, meaning, antonym, synonym, sentences involving the word, presence in word-groups 5. Word->meaning (quiz) a. For a given word, select its meaning from randomly generated meanings in a multiple choice layout b. OR, user has to enter meaning by keyboard, or through speech to text. Input text is matched semantically to determine if answer is correct c. Selection of quiz or word lists can be made on multiple criteria such as GRE, IELTS, Top100, News anchors, Motivational speakers d. Or it could be a custom quiz created by someone and sent as invitation by Quiz Id e. There will be a self mode, challenge mode and group mode 6. Meaning->word (learning mode) 7. Meaning->word (quiz) 8. Synonyms (learning mode) a. given a word, what are the synonyms …. Select one from multiple choices, or all that apply 9. Synonyms (quiz) 10. Antonyms (learning mode) a. given a word, what are the antonyms …. Select one from multiple choices, or all that apply 11. Antonyms (quiz) a. 12. Singular and plural (learning mode) a. what is the singular word for fish b. if a number of fish are swimming together, what are they called? 13. Singular and plural (quiz mode) 14. Male and female (learning mode) a. what is the gender of a word, say cow. Is cow a male or female? b. What is the female for horse? 15. Male and female (quiz mode) a. 16. Word pronunciation (learning mode) a. app presents words on screen of varying difficulty, the correct pronunciation is announced b. application accepts user audio input, and converts to text then checks if the word was correctly pronounced using “speech to text” c. Native voice of OS is used for text2speech and speech2text 17. Word pronunciation (quiz mode) a. user says those words, one at a time b. words are converted to text and matched to spelling of the audio word c. user is graded at various levels of difficulty 18. Sentence speaking (speech to text) a. app presents sentence on screen of varying difficulty, the correct pronunciation is announced b. user says those sentences one at a time c. sentenced are converted to text and matched to text of the audio sentence d. user is graded at various levels of difficulty e. Native voice of OS is used for text2speech and speech2text 19. Written spelling / Dictation (text)? a. app presents audio words basd on random selection from word lists in chosen topics. User selects topics, sub-topics and fraction of questions from each topic b. user has to hear the spellings from the app, and write down the spelling using a keyboard c. multiple people can play it simultaneously and synchronize start times d. user can send same test to someone else as a challenge i. level of difficulty ii. by grade iii. by complexity of word iv. users can create their own tests, save their tests and take tests creating by other users 20. Verbal spelling / Spelling bee a. User is presented with an audio clip of a word b. Audio of user spelling, alphabet-by-alphabet is taken as input 21. Vocabulary builder and flashcards a. word lists as table or grid, with pictures b. every topic or theme has its own background picture 22. Dumb charades a. multiple clues, guess the word 23. Visual word search a. Crossword: words are inscribed in a rectangular / square grid of characters i. words are listed, they need to be found in the maze ii. rules are specified - left to right, up to down iii. can be created by users, words uploaded, arranged, etc. Others can be challenged with a word search created by someone else iv. a variation of this game is – how many words can you find? 24. Bingo with words and word meanings 25. Jumble characters. Unscramble the words 26. Match the opposites 27. Word for image(s) 28. Construct a word from separate bins of letters a. cross out the letters from each bin as the words are constructed b. for example, there are 4 bird names, their letters (1 or more) are scattered across 5 bins. You have to pick the letter(s) from every bin to construct the names of the birds 29. From a set of letters, how many words can you construct in 5 minutes a. There could be conditions, such that every word should have one of the letters b. Compound word games c. Find words partially filled with and partially need to be filled from a chosen list 30. Complete the sentence game a. fill in words to complete a sentence QUIZZES / GAMES / CHALLENGES Games can be built upon pre-chosen word lists, such as by topic, theme, festival, occasion, etc. For every game created, there is a unique id, allowing it to be taken by other users. The statistics of the takers are made available before the test begins, so taker can evaluate themselves.