Please DO NOT apply if:
1. You are not experienced with the above technologies or prefer something else.
2. If your account is associated with an agency.
3. If you need a design and cannot do it yourself (it’s really simple, no fancy stuff).
4. You cannot complete it within the below budget and timeline.
5. If you prefer calls (brainstorming, discussing etc) over typing and getting answers to your questions.

Project Overview
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), managing question banks, and writing test results into a Google spreadsheet.

Key Responsibilities:
Develop a testing web application. Implement features to 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 the technigies mentioned in the title. 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: 1 month.

Details:
1. The questions with answers should be uploaded in sets in a predefined format (MS Word and Excel), or one by one if a question has a picture. All questions are MCQ with 4 options and 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.
5. For the intermediate English language 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 be able to reshuffle the questions and answers and generate questions automatically, assigning random definitions 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 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: February 25, 2024 09:23 UTC
Category: Full Stack Development
Skills:Web Application, MySQL, Django, Python, Web Development, Figma, Flutter, UX & UI

Country: Singapore

click to apply