Git Product home page Git Product logo

houarizegai / lsqlapp Goto Github PK

View Code? Open in Web Editor NEW
109.0 1.0 20.0 19.78 MB

Desktop application that helps teacher ๐Ÿ‘จโ€๐Ÿซ in practical work (TP) to evaluate the student ๐Ÿ‘จโ€๐ŸŽ“, and help students to learn SQL (structure query language) - Learning by doing.

License: MIT License

Java 95.35% CSS 4.65%
javafx javafx-application sql-application java desktop-application learn-sql learning-labs

lsqlapp's Introduction

Learn SQL Application - SQL ุจุฑู†ุงู…ุฌ ุชุนู„ู… ู„ุบุฉ ุงู„ุฅุณุชุนู„ุงู…

Desktop application ๐Ÿ’ป to help teacher ๐Ÿ‘จโ€๐Ÿซ in practical work (TP) to evaluate the student ๐Ÿ‘จโ€๐ŸŽ“.

License MIT

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

Problematic ๐Ÿ˜Ÿ

  1. Lack of tools to establish a student knowledge base.
  2. Lack of traceability.
  3. We can not judge the efforts of each student (people who work and who doesn't work).
  4. Lack of time to evaluate the student.
  5. Problem of manual entry in practical work.

Objectives ๐Ÿ˜ƒ

  1. Gives a portable solution and H24 work to gain this understanding.
  2. Automate manual stains.
  3. Archive students essays at the time of TP.
  4. Help the teacher to evaluate the student.

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

login img

Home

App home screenshot

Practical work

img connection screenshot

Traceability

screenshot

Traceability > Student

screenshot screenshot screenshot screenshot screenshot screenshot

Traceability > Question

screenshot screenshot screenshot

Guide

img guide

Manage Question

screenshot of manage question screenshot of manage question screenshot of manage question screenshot of manage question

Manage Account

screenshot of manage account screenshot of manage account screenshot of manage account screenshot of manage account

Settings

screenshot of settings screenshot of settings screenshot of settings screenshot of settings screenshot of settings

Chat

screenshot of chat screenshot of chat 2

About

screenshot about

Contributing

If you want to contribute to this project and make it better with new ideas, your pull request is very welcomed. If you find any issue just put it in the repository issue section, thank you.

.ุณุจุญูŽุงู†ูŽูƒูŽ ุงู„ู„ูŽู‘ู‡ูู…ูŽู‘ ูˆูŽุจูุญูŽู…ู’ุฏููƒูŽุŒ ุฃูŽุดู’ู‡ูŽุฏู ุฃูŽู†ู’ ู„ุง ุฅูู„ู‡ูŽ ุฅูู„ุฃูŽ ุงู†ู’ุชูŽ ุฃูŽุณู’ุชูŽุบู’ููุฑููƒูŽ ูˆูŽุฃูŽุชู’ูˆุจู ุฅูู„ูŽูŠู’ูƒูŽ

lsqlapp's People

Contributors

houarizegai avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.