Design Testing & Reporting Database
Budget $1500-3000 USD
Job Description:
Current: We have a PHP/mySQL database for online SAT and ACT-type testing and reporting. The database is slow, but it works.
This project is to create a new database using node js and mongo so that the system will be efficient for online testing (for exams like the SAT and ACT exams) and for reporting student results.
The system needs to work for different types of tests (like SAT, PSAT, ACT, and LSAT) and provide a user-friendly online testing system for students to use. It needs to be able to accommodate 5000 students testing simultaneously and then handle and store the data for retrieval and analysis in a robust reporting system. Students can also test using a pen-and-paper format with their data uploaded via csv.
There will be one or two system admin logins for those of us creating the tests on the backend. These admins will need access to everything.
Student registration data needs to be uploaded via csv.
In general, each test has 4 sections of 30-50 questions each. Most questions are multiple choice with 4 or 5 answer choices. Some math questions are free response. Questions (and sometimes answer choices for each question) must be randomized within the section. The quizzes are timed (each individual section has its own timer). There are also timing modifications (so, for example, some students with learning disabilities get 150% of the standard time or double time). So we need to create "types" of students that have specific time modifications associated with them.
Students will be assigned a particular test and can only take that test one time. But, we need to have the ability to reset the exam so the student can re-take it from the beginning if they need to. We also need the ability for students to re-log in and resume testing in the event that their internet goes out, power goes off, etc., while testing.
Students will need a limited login that will allow them access to their test and results.
The testing platform needs to include a dashboard that allows the teacher to have a synchronized start for all students in a group. It needs to track student time and progress so that students can resume testing in the event of an internet failure, etc. Administrators need to monitor real-time usage to see how many students are actively testing, where they are in the test, etc.
Reports analyze student performance individually and/or as a group (for example, all the students at a single school campus or multiple campuses or all students who have taken a particular exam). 2 sample reports are available from the current system. Other reports (such as, a list of students who have not yet tested, etc.) are also needed.
District administrators need to be able to access the database in view-only mode to produce student reports and group reports for their school(s). The "subadmin" users from particular clients will need access to just their client data - to produce reports but not to change anything in the database (like a read-only access).
I attached a more detailed SOW (no highlight = Phase I, blue highlight = Phase II) as well as a document that represents the flow of the current database. The current database is for information, but the new one can be completely different - whatever makes sense.
We need to move the data from the current DB into the new DB so when we run reports it includes the data collected in the current DB.
Awarded to:
89 freelancers are bidding on average $2233 for this job
Good day, For all the tests and questions data, do you want to allow an Admin users to create these tests from backend using some sort of test builder? Does these quizzes have some sort of time period? Also, it will al More
Greetings! I read your job post to create a new database using node js and mongo so that the system will be efficient for online testing. I've some queries it would be appreciated if we can have real time conversation More
Hey Good evening , Just finished reading the brief details and currently going through attached files . I see you have been looking for someone who has experience with these tech stacks MySQL, Linux, PHP, Node.js and More
Hi, We would like to grab this opportunity and will work till you get 100% satisfied with our work. We are an expert team which have many years of experience on PHP, Linux, NoSQL Couch & Mongo, MySQL, Node.js Please More
Hi, Dear client! How is your health? I have worked on similar projects to what you are looking for, and I am confident I can exceed your expectations. I’m web developer with 10+ years rich experience in wordpress , More
Hi. How are you doing? As a highly skilled Web developer, I can help you perfectly. I am very confident with my skills and I'd like to help your business by doing my best. My clients have never been frustrated with my More
Hi there I already checked your requirements in job posting. I also checked your attached file and got what you need. I am an experienced web expert having great experience in NoSQL Couch & Mongo, PHP, Linux, Nod More
Hi. I have read your proposal carefully and very interested in it. I am expert in the fields you have mentioned. You can check my skills from my profile. Everyone says "I can do it", but there are a few who can do it More
Hi, We went through your project description & I am very interesting in your job and it seems like our team is a great fit for this job. We are an expert team which have many years of experience on PHP Lets connect More
Hi. Thank you for your job posting. I have just checked your requirements carefully. It is an ideal match for my skills and experience. I have rich experience in Database management including mysql, oracle. postgresql More
Hi there, How are you? I have gone through your project details. I would like to tell you that l have a great bunch of experience in Node.js, NoSQL Couch & Mongo, Linux, PHP and MySQL. For that I would require from yo More
Hi Kevin G., Good evening! I’ve carefully checked your requirements and really interested in this job. I’m full stack node.js developer working at large-scale apps as a lead developer with U.S. and European teams. I’ More
Hi There. Thanks for giving chance to challenge. I have checked your pdf doc. I am Node.js, MongoDB, Database Expert with experience for 8 years. Please feel free to contact me. Best Regards
Hello Client, How are you? I am Professional Full Stack Developer with 5 years experience. I have lots of knowledge in PHP, Linux, NoSQL Couch & Mongo, MySQL, Node.js, Etc. Please send me a message so we can discuss th More
