We are seeking a skilled developer to create a testing application for our school. The primary objective is to design a web app that effectively evaluates students across various subjects through multiple-choice questions (MCQs), storing question banks, and writing test results into a Google spreadsheet.
Key Responsibilities:
Develop a testing web application. Implement features to store and manage question banks and test results on MySQL. Ensure the app can record test results to a Google Sheet. Create a user-friendly interface allowing students to input details like name, grade, subject, and type of test (intermediate or grade test). If intermediate, an additional field for the topic should be available. Design an interface for teachers to upload question banks and answer keys. This should support uploaded texts and images for students to work with on corresponding questions categorized by grade, subject, and test type. The system should support uploads from multiple Google accounts.
Essential Skills and Qualifications:
Proficient in web development. Experience with MySQL for database management and backend services. Familiarity with integrating Google Sheets into applications. Strong understanding of user interface design and user experience principles. Excellent problem-solving skills and attention to detail.
Project Budget and Timeline:
Budget: $1000.
Completion Timeline: 3 weeks.
Details:
1. The questions with answers should be uploaded in sets in a predefined format, not one by one unless a question has a picture. All questions are MCQ with only one correct answer, 1 point each for scoring. The correct option will be provided. The student’s mark is calculated as a percent of the points he scored out of the total (e.g., out of 20 for 20-question tests).
2. The teachers should be able to edit or remove questions from the question bank.
3. The system should pick a certain number of questions randomly from the bank for each test (normally, 20 for the intermediate tests and 40 for the grade tests).
4. All subjects will have intermediate (unit or chapter) tests and grade tests for each grade from 1 to 10. Some subjects (Humanities) will have a lower range of grades: 7-8, 7-10 or 9-10.
5. For the intermediate English assessment, there will be skill tests instead: Vocabulary, Comprehension, Spelling, and Grammar. Vocabulary tests will have exceptions in terms of the format of the questions to upload: we will upload the list of words in an Excel file with definitions. The system should reshuffle the questions and answers and generate questions automatically, assigning random definitions of other words for 3 incorrect options in MCQ.
6. The test webpage should require a password for teachers to unlock access to the test (you can place it simply in the scripts so I can change it myself occasionally).
7. The files should be deployed with a dedicated website on my server. +MySQ. .
Budget: $1,000
Posted On: January 31, 2024 03:48 UTC
Category: Full Stack Development
Skills:Web Application, MySQL, JavaScript, Python, Web Development
Country: Singapore
click to apply
Powered by WPeMatico