A professional, interactive online course platform with authentication, progress tracking, and Google Sheets backend integration.
Course Website: https://jaymehta12110.github.io/UAV-Course/
- User registration and login system
- Password hashing for security
- Session management
- Google Sheets backend for user data
- Auto-pause when switching modules
- Progress tracking per video
- Module descriptions and metadata
- Multiple choice questions
- Instant feedback with explanations
- Pass/fail system (80% required)
- Score tracking and analytics
- Real-time progress synchronization
- Google Sheets backend storage
- Visual progress indicators
- Module completion tracking
- Automatic certificate upon completion
- Personalized with student name
- Selective module certificate
- Downloadable as pdf
- Mobile-friendly interface
- Works on all devices
- Visit: https://jaymehta12110.github.io/UAV-Course/
- Click "Login" or "Register"
- Create an account or login
- Start learning!
Admin Tools:
admin-password-reset.html- Reset user passwordsclear-cache.html- Clear browser cache/logoutSYSTEM_RESET_GUIDE.md- Complete reset instructions
course/
βββ index.html # Landing page
βββ course.html # Main course interface
βββ css/
β βββ styles.css # Course page styles
β βββ landing-styles.css # Landing page styles
βββ js/
β βββ auth.js # Authentication system
β βββ course.js # Course logic
β βββ quiz.js # Quiz functionality
β βββ certificate.js # Certificate generation
β βββ contact.js # Contact form
βββ data/
β βββ course-data.json # Course content
βββ backend/
β βββ google-apps-script.js # Backend API
βββ admin-password-reset.html # Admin tool
βββ clear-cache.html # Cache clearing tool
βββ SYSTEM_RESET_GUIDE.md # Reset instructions
βββ README.md # This file
- Open
admin-password-reset.html - Enter user email
- Enter new password
- Click "Reset Password"
Users can clear their local cache:
- Open
clear-cache.html - Click "Clear All Data"
- User will be logged out
- Can login again to restore progress from backend
See SYSTEM_RESET_GUIDE.md for detailed instructions on:
- Clearing all users from backend
- Resetting browser cache
- Starting fresh with same URLs
- Preventing auto-login
All content is in data/course-data.json:
{
"course": {
"title": "Your Course Title",
"description": "Course description..."
},
"modules": [
{
"id": 1,
"title": "Module Title",
"videoUrl": "https://www.youtube.com/embed/VIDEO_ID",
"type": "video"
}
]
}{
"type": "quiz",
"questions": [
{
"question": "Your question?",
"options": ["A", "B", "C", "D"],
"correctAnswer": 0,
"explanation": "Why this is correct..."
}
]
}The course uses Google Sheets as a database:
Spreadsheet ID: 1EToB-Hs0GLOnB3Egi55fxKdeFTOC-Fg8p0BP9jiEvmc
Sheets:
Users- User accountsProgress- User progress data
Backend API: https://script.google.com/macros/s/AKfycbxz-4ZhhhuSxBWs8cZ5NMnBlHf-Q_PdYwhxWjQOizXSP69U9l4EqkJYWWu7YMQctXUkTw/exec
- Open Google Apps Script
- Copy code from
backend/google-apps-script.js - Deploy as Web App
- Update URL in
js/auth.jsif changed
Edit css/styles.css or css/landing-styles.css:
:root {
--primary-color: #0064A4;
--accent-color: #F47E3C;
--success-color: #28a745;
}body {
font-family: 'Your Font', sans-serif;
}- Platform: GitHub Pages
- Repository: jaymehta12110/UAV-Course
- URL: https://jaymehta12110.github.io/UAV-Course/
git add .
git commit -m "Your update message"
git push origin mainChanges go live automatically in 1-2 minutes.
- β Password hashing (SHA-256)
- β Secure session management
- β Backend data validation
- β HTTPS encryption (via GitHub Pages)
- β No passwords stored in frontend
Fixed! Videos now auto-pause when switching to quizzes or other modules.
Keep These:
README.md- Main documentationHOW-TO-RUN.md- Setup instructionsSYSTEM_RESET_GUIDE.md- Reset proceduresQuiz_2.md,Quiz_3.md,Quiz_4.md- Quiz content
Admin Tools:
admin-password-reset.html- Password managementclear-cache.html- Cache managementcleanup-docs.bat- Documentation cleanup script
Potential improvements:
- Email verification
- Password recovery via email
- Advanced analytics dashboard
- Course completion certificates via email
- Multi-language support
Educational use.
Course Content: UAV Design & Cyber-Physical Systems Platform: Custom-built with HTML, CSS, JavaScript Backend: Google Apps Script + Google Sheets Hosting: GitHub Pages
For detailed reset instructions, see: SYSTEM_RESET_GUIDE.md
For admin tools, use: admin-password-reset.html or clear-cache.html
Live Site: https://jaymehta12110.github.io/UAV-Course/