Driving School Slot Booking and Lesson Tracker

Learning to drive in India runs on paper registers and phone calls: students call the school to book a slot, instructors keep lesson progress in notebooks, and nobody can see at a glance who is ready for the RTO test. Slots get double-booked, lessons are forgotten, and test-day failures come as a surprise. A driving school is really a scheduling business with a training pipeline underneath, which makes it an excellent web project — it needs real booking logic (day, time, instructor, car), a structured curriculum with graded milestones, and two very different user views. This project builds that as a working portal: a student dashboard with the next lesson, a slot-booking flow with instructor choice, and a 12-lesson tracker where each lesson carries the instructor's grade and remarks. A test-readiness meter aggregates the grades into the RTO skills that matter — parking, hill starts, lane discipline — so the student knows precisely what to practise before the test.

1. The school admin configures instructors, dual-control cars, working days and slot capacity in the backend.
2. A student signs up with their learner's licence number and enrols in the 21-day LMV course.
3. On the booking page the student selects a day from the week strip; the app shows that day's time slots with remaining capacity, disabling full ones.
4. The student picks an instructor and confirms; the booking is written with a unique ID and appears on the dashboard and weekly schedule.
5. After each lesson the instructor records a grade (A–D) and a short remark against that lesson number; the next lesson unlocks.
6. The readiness engine maps lesson grades to RTO test skills and renders the test-readiness meter with specific weak areas.
7. When all 12 lessons are graded, the portal flags the student as test-ready and the school can assign an RTO test date.

Tech stack:

• HTML5, CSS3, JavaScript (frontend)
• PHP 8 / Laravel (backend API)
• MySQL (bookings, lessons, grades)
• Blade templates + REST endpoints
• Canvas/SVG progress visuals

• [Slot booking engine] Students pick a day, time slot and instructor from live availability; booked-out slots are disabled automatically and double-booking is prevented at the data layer.
• [Instructor profiles] Each instructor card shows experience, rating, languages and assigned car, so students can choose who teaches them.
• [12-lesson graded syllabus] A structured curriculum from cockpit drill to mock RTO test; every lesson unlocks in sequence and carries the instructor's grade and written remark.
• [RTO test-readiness meter] Lesson grades aggregate into the skills examiners actually test — parking, hill starts, lane discipline — shown as a readiness percentage with weak areas highlighted.
• [Student dashboard] Next lesson card with pickup point and car details, weekly schedule timeline, course progress ring and instructor remarks in one view.
• [Rescheduling flow] Booked lessons can be rescheduled to another open slot with one action, and the change reflects everywhere instantly.
• [Mock test records] Theory mock scores and 8-track practical results are stored per student, feeding the readiness calculation.

• Complete portal source code (frontend + backend)
• MySQL database schema with migration scripts
• Seeded demo data: school, instructors, cars, bookings, graded lessons
• Booking engine with double-booking prevention logic
• Lesson tracker and RTO test-readiness scoring module
• Project report PDF (system design, ER diagram, booking logic, test cases)
• PPT presentation for final review
• Viva Q&A preparation document (scheduling conflicts, role-based access, readiness algorithm)

• The demo runs on seeded data for one school branch; multi-branch management is future scope.
• Payments for course fees are out of scope — the portal tracks bookings and lessons, not billing.
• SMS reminders are shown as a notification log in the demo; a real SMS gateway needs the buyer's own provider account.
• Instructor grading is manual input in the demo; no automated driving assessment is claimed.
• The readiness meter is a weighted aggregation of instructor grades (design logic), not a certified predictor of RTO results.