Education Evaluation System

Overview

The Education Evaluation System is an online comprehensive assessment and mastery-tracking system designed to evaluate students' progress in any course. Students can enroll in multiple courses, which can represent textbooks, online courses, or any structured learning material. The system integrates an interactive mastery framework, gamification elements, and psychological engagement strategies to enhance motivation and learning efficiency. It supports various question types, personalized learning paths, and real-time progress tracking, ensuring an adaptive and engaging assessment experience.

Technologies Used

Back-end

Laravel (PHP)

Database

MySQL (Secure & relational data storage)

Front-end

Vue.js (Inertia.js), Tailwind CSS

API Communication

Inertia.js

Security

Authentication (Laravel Breeze), Data Encryption

Category	Technologies
Back-end	Laravel (PHP)
Database	MySQL (Secure & relational data storage)
Front-end	Vue.js (Inertia.js), Tailwind CSS
API Communication	Inertia.js
Security	Authentication (Laravel Breeze), Data Encryption

Features & Functionalities

Flexible Course Structure

✅ Courses are structured as units → lessons → skills but allow flexible mapping—lessons, units, and skills can belong to multiple courses.
✅ Each skill is assessed through targeted exercises, while quizzes, unit tests, and course tests evaluate broader mastery.

Comprehensive Question Bank

✅ All questions are stored in a centralized question bank and randomly selected for skill assessments.
✅ Supports various question types, including multiple-choice, fill-in-the-blank, short answer and many more.
✅ Allows question reuse across multiple courses to eliminate redundancy.

Multilingual Support (English & Arabic)

✅ Fully supports both English and Arabic for content and assessments.
✅ Some questions are available in both languages, enabling seamless cross-language assessments.
✅ Language-independent skills (e.g., mathematics) allow shared questions across courses.

Engaging & Interactive Experience

✅ Gamification elements (points, badges, progress milestones) enhance motivation.
✅ Instant feedback helps students understand mistakes immediately.

Admin & Instructor Management

✅ Educators can create, manage, and modify courses, units, lessons, and tests.
✅ Ability to create and select questions from the question bank for assessments.
✅ Monitor student progress with real-time analytics and reports.

Scalability & Security

✅ Supports multiple courses per student, allowing seamless enrollment and tracking.
✅ Secure and scalable infrastructure designed to handle a large number of students and courses.

System Architecture

The system follows an MVC (Model-View-Controller) architecture using Laravel for backend logic and Vue.js with Inertia.js for a seamless single-page application (SPA) frontend experience. The database is structured with normalized tables for efficient data handling.

Database Design

The database is designed using a relational model to support multilingual courses, flexible learning structures, and adaptive question selection.

🔹 Main Database Tables

users

Stores user data, including roles (student, instructor, admin).

courses

Contains course details and metadata.

units

Defines course units, which group related lessons.

lessons

Holds lesson content and associated skills.

skills

Represents specific learning skills, linked to lessons.

questions

Stores all question types for assessments.

student_progress

Tracks user progress for each skill, lesson, and course.

assessments

Stores quiz, unit test, and course test results.

Table Name	Description
users	Stores user data, including roles (student, instructor, admin).
courses	Contains course details and metadata.
units	Defines course units, which group related lessons.
lessons	Holds lesson content and associated skills.
skills	Represents specific learning skills, linked to lessons.
questions	Stores all question types for assessments.
student_progress	Tracks user progress for each skill, lesson, and course.
assessments	Stores quiz, unit test, and course test results.

📌 Example Table: questions

id

Type: BIGINT

Description: Primary key, unique identifier for each question

skill_id

Type: BIGINT

Description: Foreign key referencing skill table

type

Type: VARCHAR

Description: Stores question type (e.g., multiple-choice, multiple-answer, text-input)

image_url

Type: VARCHAR

Description: URL of an optional image associated with the question

data

Type: JSON

Description: Stores question-related data (text, images, multi-language support, etc.)

is_active

Type: BOOLEAN

Description: Flag to indicate whether the question is active or inactive

created_at

Type: TIMESTAMP

Description: Timestamp for when the question was created

updated_at

Type: TIMESTAMP

Description: Timestamp for when the question was last updated

Column Name	Type	Description
id	BIGINT	Primary key, unique identifier for each question
skill_id	BIGINT	Foreign key referencing skill table
type	VARCHAR	Stores question type (e.g., multiple-choice, multiple-answer, text-input)
image_url	VARCHAR	URL of an optional image associated with the question
data	JSON	Stores question-related data (text, images, multi-language support, etc.)
is_active	BOOLEAN	Flag to indicate whether the question is active or inactive
created_at	TIMESTAMP	Timestamp for when the question was created
updated_at	TIMESTAMP	Timestamp for when the question was last updated

Main Routes

/users/{id}/progress

Method: GET

Description: View user progress

/courses

Method: POST

Description: Create a new course

/units

Method: POST

Description: Create a new unit

/lessons

Method: POST

Description: Create a new lesson

/skills

Method: POST

Description: Create a new skill

/questions

Method: GET

Description: List all questions

/skills/{skill_id}/questions

Method: GET

Description: List questions for a specific skill

/assessments

Method: POST

Description: Create a new assessment

/progress

Method: GET

Description: List all progress records

Endpoint	Method	Description
/users/{id}/progress	GET	View user progress
/courses	POST	Create a new course
/units	POST	Create a new unit
/lessons	POST	Create a new lesson
/skills	POST	Create a new skill
/questions	GET	List all questions
/skills/{skill_id}/questions	GET	List questions for a specific skill
/assessments	POST	Create a new assessment
/progress	GET	List all progress records

Role & Contributions

💡 Full-stack Developer
✅ Developed backend APIs and integrated RESTful services for course management, user progress tracking, and multilingual support.
✅ Built dynamic forms for managing lessons, units, and question banks, enabling smooth admin operations.
✅ Optimized database schema for managing diverse educational content (courses, skills, assessments) and user data.
✅ Created an intuitive front-end using Tailwind CSS for responsive design and Vue.js for dynamic course navigation.

Achievements & Impact

✅ Reduced content management time for instructors by automating lesson and quiz creation.
✅ Improved user progress tracking, leading to better personalized learning paths.
✅ Enhanced multilingual support, making the platform accessible to English and Arabic-speaking users.
✅ Created efficient search and filtering systems for courses, units, and lessons.

Future Enhancements

🚀 Implement AI-based question suggestion engine to assist instructors in creating assessments.
🚀 Introduce real-time collaboration features for group projects and discussions.
🚀 Enable integration with external learning tools for expanded content delivery.