Online Exam Application Development -React/Next/Express.js with MY SQL (Advanced)

Do not bid before reading all sections below. • Your bid must include: o Total number of User Interfaces (UI) o Approximate number of Database Tables o Number of Milestones you plan to divide the project into (please research yourself and convey) • Final delivery expected in 5–7 milestones • First milestone: Static site hosted with CMS for dynamic content • Incomplete bids or vague timelines will be rejected • 80% of requirement provided, 20% will be provided on each milestone, so expect some change say 20% • After each milestone one week time to test the module, after successful completion, no errors and accepted then only payment will be made. ________________________________________ Capability & Qualification Check Only bid if your team satisfies all of the following: 1. You have prior experience in developing Online Exam or Learning Management Systems 2. Your company assigns a dedicated Project Manager (PM) 3. Your team includes: o Frontend and backend developers o Testers o UI/UX resource (if needed) 4. You understand exam domain concepts like: o Domain Weightage o Future, Random and Required Questions o Question bank management o Question versioning o Very familiar with online exam systems by AWS, Azure, Udemy Practice test, etc ________________________________________ Pre-requisites for Each Milestone Before starting any milestone, vendor must submit: • Business Requirement Document (BRD) • Technical Specification Document • Test Cases and Testing Plan • Entity Relationship Diagram (ERD) with: o Primary keys o Foreign keys o Indexes o After milestone completion: • Submit screenshots for both front end and DB test cases executed showing the results in table/column level • Code walkthrough showing: o SEO implementation o Security practices o Use of reusable components o Standards followed At no point should there be High or Medium priority defects affecting functionality. Only minor Low-priority issues like typos are temporarily acceptable. ________________________________________ Tech Stack • Frontend: React.js, [login to view URL], Tailwind CSS • Backend: Node.js or PHP (vendor to propose) • Database: MySQL, All tables have audit date, capture user activity, details, IP address etc • CMS: Required for landing page, blog, and general content • Security: Secure REST APIs, JWT/Session handling, CAPTCHA or Robot check • Hosting: Deployment-ready for mapped domain hosting ________________________________________ Exam Domain Knowledge Required Bidders must demonstrate domain knowledge in: • Subscriber registration and management • Exam assignment, attempt tracking, auto-evaluation • Question bank creation and version control • Exam result analytics (user-level and global) • Exam retake policy enforcement • Static + dynamic dashboards • Course and certification tracking ________________________________________ Project Manager Requirement • A dedicated PM must be assigned by the vendor • PM will: o Coordinate between developers, testers, and client o Be the sole point of contact o Ensure timely and quality deliverables ________________________________________ Project Description Develop a complete Online Examination System for subscribers, with a dynamic CMS, secure Admin Panel, and advanced Exam Management Module, where subscriber’s login and purchase course, exams, download contents, watch videos, read contents, take exam, review previous exam, analyse their performance through Dashboard. Key Modules: • Subscriber-facing online exam system • Admin panel to create provider, certification, question and exam etc • CMS for dynamic content • Real-time result analytics - exam review and exam analytics by various filter • Blog system for publishing educational content Initial deployment will include static landing page, later replaced with a CMS-powered version. ________________________________________ Milestone Breakdown with Acceptance Criteria Milestone 1: Landing Page with CMS Integration • Static site hosted with about, product, services, and footer • Admin can manage all content via CMS (no dev involvement) • Blog system: create blog, upload image, publish dynamically Acceptance: • CMS demo (create/edit pages) • Blog creation demo • Testing screenshots ________________________________________ Milestone 2: Authentication Module & User Profile • Login, Logout for both Admin and Subscribers • Features: o Remember Me o Forgot Password via email o Reset password o Robot check on login o Login attempt throttling or lockout mechanism • My Profile: First Name, Last Name, User Name, email, photo update, change password, last login, activity tracking, achieved certificates, Order history (future scope) • View your downloads, order, your favourites, purchase etc • View announcements and notifications Acceptance: • Functional auth cycle demo • Profile update demo • CAPTCHA and forgot password validation • Testing documentation ________________________________________ Milestone 3: Full Exam Management Module (Core) • Provider creation • Certification Creation • Create/Edit questions manual, bulk upload questions, associating exam type • All possible validations while creating and uploading questions • Various question types  Single Choice, Multiple Choice, True or False, Drag & drop • Review questions, and approve questions by admin • Version control on questions (track when questions are edited), old exam, new exam – might have different questions for same certification exam type – say Practice Test 1 • Negative marking defined at the exam level (not per question) • Exam Creation • Course Creation • Instructor setup module • Manage – All admin module with features such as Unpublish/Discard questions, exam, certification provider and instructor etc. • Live exam module with time tracking with skip, review, prev, next, end exam etc • Exam attempt features: o Timed exams o Navigation o Auto-save answers o Filter-based reviewing • Anti-Cheat recommendation and implementation • Custom Test generation by subscribers • Exam result generation with score breakdown by domain etc(Score analysis by user) • View past exams and attempt history • User vs global performance comparison • Attempt stats, time taken, accuracy, pass/fail ratios • Secure Audit Log of Exam Activity • Immutable logs for all exam events (start, submit, timeout) • Logs tagged with exam ID, subscriber ID, IP, and timestamps • Exportable for audit or legal purposes Dashboard Features: • Exam Dashboard: o Exam attempts o Results o Filter by domain, incorrect answer, correct answer, skipped, delayed answer o Sophisticated filter by question complex type, most incorrect question, most time taken question by all subscribers etc, o Acceptance: • Admin exam creation and question management • Subscriber exam attempt with timer • Exam review and result generation demo • Screenshot evidence of dashboard features ________________________________________ Milestone 4: Dynamic CMS-based Landing Page • Clean UI replacing temporary static page • Elegant Landing Page, Navigation Bar with menus and submenus are all dynamic content featured • Blog area, Services, Product pages—all CMS-driven • Mobile-responsive, SEO-compliant, fast-loading • All course listed with dynamic filters • All certifications and exams listed • Special Programs listed • Testimonial before footer • Dynamic Footer Section • My course Page • Subscriber dashboard page for tracking purpose • View exam and course progress • Course view (purchased, ongoing, completed) • Certification Generation • Auto-generate certificate for successful candidates -Includes: name, exam title, score, completion date, certificate ID • Downloadable from user profile and admin dashboards Acceptance: • Live CMS-powered landing page • Admin demo of content management • Testing screenshots for responsiveness and SEO Milestone 5: Dashboard and Performance Analytics Admin Dashboard • Track Subscribers: Total count, active vs inactive, recent signups • Course Purchased: List with subscriber, date, course name • Exam Purchased: Purchased exams with filters by date, category, subscriber • Certification Completed: Summary and downloadable logs of completed certifications • Most Active Certifications: Based on user completions and traffic • Most Active Exams: Based on participation, attempts, and average scores • Most Active Subscribers: Ranked by login frequency, exam participation, engagement • Most Active UI Sections: Tracks which pages/modules are used most (e.g., "My Courses", "Take Exam") • Peak Days/Times: Heatmap or list of highest traffic periods by date/time ________________________________________ Final Code Delivery & Quality Checklist • Every delivery must include: o BRD, Tech Spec, ERD, and test reports o Screenshots for milestone testing o Code walkthrough for:  SEO practices  Security  Standards and reusability  UI/UX through figma tool  Robust and strict validation, cannot click next or submit button  All Mandatory fields have * button  Admin tables necessary for pausing exam etc  Alert table for all messages – to follow all such best practices • All core features must be functional with: o Zero high/medium priority defects o Minor typos or UI tweaks allowed temporarily

Project ID: 39694478