OUARED-A/LSQLv1

LSQL: Learning analytics solution for monitoring and analyzing the students'behavior in SQL lab work

Learning analytics dashboard Side to help teacher 👨‍🏫 SQL learning environment Side to assist student 👨‍🎓.

Features ✔️

• Simple to use
• Fast and beautiful design
• We used material design & UX library to build this application
• We used MVC design pattern
• Password hashed *... and more

Libraries used

• JFoenix (Material design)
• ControlsFx (UX)
• FontawesomeFx (Icons)
• Connector/J (JDBC)
• Webcam-capture (download)

Technology used

• JavaFX

Requirements

• Java version 8
• IDE like Intellij IDEA or other
• MySQL database

How to use the application

1. Download the repository files (project) from the download section or clone this project by typing in the bash the following command:

   git clone https://github.com/HouariZegai/LSQLApp.git

2. Open it in Intellij IDEA and download the libraries used (montioned above) and add it in the project.

3. Import & execute the SQL queries from the Database folder to the MySQL database.

4. Run the application :D

Outlook for evolution and improvement 💡

• Put the multiplatform application (Desktop, Android & Web).
• Deploy the application in online mode.
• Increase interactivity between user and application.
• Developed the back-end of the chat module (communication between user, send message, audio or video call, send files ...).
• Add a part of education (read books, courses, ...) linked by traceability.
• Add a part of QCM (put multichoix questions).
• Auto evaluation.

Screenshots

Login

Home

![](Screenshots/home.PNG img home">

Practical work

Traceability

Traceability > Student

Traceability > Question

Guide

Manage Question

Manage Account

Settings

Further improvements

If you wish, you're welcome to participate in the Explain-Tun or to make suggestions !

Authors Anonymous