TESDAli: A Streamlined TESDA Assessment Application Management System

TESDAli is a Streamlined TESDA Assessment Application Management System developed to apply the concepts learned in the course COMP 010: Information Management, with a specific focus on database integration. This system enhances the efficiency of handling assessment applications by simplifying the submission, tracking, and management processes, providing a seamless experience for users.

Table of Contents

1. Features
2. Screenshots
3. Tech Stack
4. Installation
5. Usage
6. Database
7. Disclaimer

Features

• Efficient Management: Streamline and organize TESDA assessment applications seamlessly for improved efficiency.
• Real-Time Dashboard: Monitor application statuses and progress in real-time with an intuitive dashboard.
• Database Integration: Create, read, update, and delete records efficiently with reliable database integration.

Screenshots

Tech Stack

• Python: The primary programming language used.
• Streamlit: The main framework used to build the web application.
• MySQL: Database engine for storing and managing application data.
• Pandas: For handling and displaying tabular data.
• Seaborn: For data visualization.
• Plotly: For interactive plots.

Installation

1. Clone the repository:

   git clone https://github.com/your-username/tesdali.git
   cd tesdali

2. Create a virtual environment and activate it:

   python -m venv venv
   source venv/bin/activate  # On Windows use `venv\Scripts\activate`

3. Install the required packages:

   pip install -r requirements.txt

Usage

1. Run the Streamlit application:

   streamlit run app.py

2. Open your web browser and navigate to http://localhost:8501 to view the application.

Database

The application uses a MySQL database to store the form data. The database schema includes the following tables:

• Learners: Stores personal and contact details of the applicants.
• Application: Stores application-specific details.
• Work_Exp: Stores work experience related to the national qualifications

Each table's schema is defined in the database_manager.py file.

Contributors

• Chynna Mae Doria - GitHub | LinkedIn
• John Lloyd Legaspi - GitHub | LinkedIn
• Paul Angelo Macaraeg - GitHub | LinkedIn
• Kyla Mae Valoria - GitHub | LinkedIn

Disclaimer

The form provided for this project was revised and includes solely the first page of the original document. It does not represent the official form being used by TESDA.