Description:FIELD OF THE INVENTION
This invention relates to Development and Evaluation of an Intelligent Chatbot System for Student Services.
BACKGROUND OF THE INVENTION
Educational institutions, such as colleges and universities, face a significant challenge in managing the high volume of inquiries from students, faculty, parents, and visitors, especially during peak periods like admissions and registration. Staff are overwhelmed by repetitive questions about schedules, marks, attendance, and campus events, leading to delayed responses, ignored queries, and frustration among users. Traditional manual methods or basic digital systems lack the automation, speed, and personalization needed to efficiently provide accurate information to diverse user groups, resulting in increased workload and poor user satisfaction.
EXISTING SOLUTIONS / PRIOR ART/RELATED APPLICATIONS & PATENTS:
ELIZA: One of the earliest chatbots, developed by Joseph Weizenbaum, used simple pattern matching to simulate conversation but lacked database integration or educational focus.
ALICE: A rule-based chatbot using Artificial Intelligence Markup Language (AIML), supporting basic query responses with around 40,000 categories, widely used for general purposes but not tailored for education.
Chatbot Using Database Knowledge (Bayu Setiaji, 2016): A database-driven chatbot for sentence similarity-based responses, implemented with SQL but limited to static replies without real-time data retrieval.
Present Commercial Practice: Most educational institutions rely on manual staff responses via phone, email, or static FAQ pages on websites, supplemented occasionally by basic chatbots with limited natural language processing (NLP) capabilities (PDF, Chapter 1, page 3).
Shortcomings of the presently available solutions
Limited Personalization: Existing chatbots like ELIZA and ALICE offer generic responses without role-specific access for diverse users (e.g., students vs. parents), failing to address varied educational needs.
Static Responses: Solutions like Bayu Setiaji’s chatbot lack dynamic data retrieval (e.g., real-time marks or schedules), reducing relevance and timeliness.
Low Accuracy and Scalability: Current systems struggle with intent identification and context management, achieving lower accuracy (typically 80-90%) and lacking frameworks for advanced NLP or multilingual support, making them inefficient for complex educational queries.
Manual Overload: Commercial practices heavily depend on human staff, unable to scale with demand, leading to delays and incomplete query resolution.
SUMMARY OF THE INVENTION
This summary is provided to introduce a selection of concepts, in a simplified format, that are further described in the detailed description of the invention.
This summary is neither intended to identify key or essential inventive concepts of the invention and nor is it intended for determining the scope of the invention.
To further clarify advantages and features of the present invention, a more particular description of the invention will be rendered by reference to specific embodiments thereof, which is illustrated in the appended drawings. It is appreciated that these drawings depict only typical embodiments of the invention and are therefore not to be considered limiting of its scope. The invention will be described and explained with additional specificity and detail with the accompanying drawings.
The proposed invention is an intelligent chatbot system designed to streamline student services at educational institutions by automating query handling and providing personalized, real-time information to diverse user groups. Implemented using the Flask web framework and MySQL database.
BRIEF DESCRIPTION OF THE DRAWINGS
The illustrated embodiments of the subject matter will be understood by reference to the drawings, wherein like parts are designated by like numerals throughout. The following description is intended only by way of example, and simply illustrates certain selected embodiments of devices, systems, and methods that are consistent with the subject matter as claimed herein, wherein:
FIGURE 1: SYSTEM ARCHITECTURE
FIGURE 2: ACCESS AND DYNAMIC DATA RETRIEVAL PATHWAYS FOR THE CHATBOT SYSTEM
FIGURE 3: FLOW CHART
The figures depict embodiments of the present subject matter for the purposes of illustration only. A person skilled in the art will easily recognize from the following description that alternative embodiments of the structures and methods illustrated herein may be employed without departing from the principles of the disclosure described herein.
DETAILED DESCRIPTION OF THE INVENTION
The detailed description of various exemplary embodiments of the disclosure is described herein with reference to the accompanying drawings. It should be noted that the embodiments are described herein in such details as to clearly communicate the disclosure. However, the amount of details provided herein is not intended to limit the anticipated variations of embodiments; on the contrary, the intention is to cover all modifications, equivalents, and alternatives falling within the scope of the present disclosure as defined by the appended claims.
It is also to be understood that various arrangements may be devised that, although not explicitly described or shown herein, embody the principles of the present disclosure. Moreover, all statements herein reciting principles, aspects, and embodiments of the present disclosure, as well as specific examples, are intended to encompass equivalents thereof.
The terminology used herein is for the purpose of describing particular embodiments only and is not intended to be limiting of example embodiments. As used herein, the singular forms “a",” “an” and “the” are intended to include the plural forms as well, unless the context clearly indicates otherwise. It will be further understood that the terms “comprises,” “comprising,” “includes” and/or “including,” when used herein, specify the presence of stated features, integers, steps, operations, elements and/or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components and/or groups thereof.
It should also be noted that in some alternative implementations, the functions/acts noted may occur out of the order noted in the figures. For example, two figures shown in succession may, in fact, be executed concurrently or may sometimes be executed in the reverse order, depending upon the functionality/acts involved.
In addition, the descriptions of "first", "second", “third”, and the like in the present invention are used for the purpose of description only, and are not to be construed as indicating or implying their relative importance or implicitly indicating the number of technical features indicated. Thus, features defining "first" and "second" may include at least one of the features, either explicitly or implicitly.
Unless otherwise defined, all terms (including technical and scientific terms) used herein have the same meaning as commonly understood by one of ordinary skill in the art to which example embodiments belong. It will be further understood that terms, e.g., those defined in commonly used dictionaries, should be interpreted as having a meaning that is consistent with their meaning in the context of the relevant art and will not be interpreted in an idealized or overly formal sense unless expressly so defined herein.
The proposed invention is an intelligent chatbot system designed to streamline student services at educational institutions by automating query handling and providing personalized, real-time information to diverse user groups. Implemented using the Flask web framework and MySQL database, the system features:
Menu-Driven Interface for User Interaction: A web-based chatbot offers structured menus tailored to user roles—students, faculty, parents, and visitors—allowing access to educational data such as academic records, schedules, and notices through a hierarchical navigation structure.
Real-Time Data Retrieval from Database: The system connects to a MySQL database via Flask to instantly fetch and display user-specific information (e.g., a student’s marks or a parent’s child’s event updates) based on role-based inputs, authenticated via login credentials.
User-Tested System for Reliable Performance: Iterative testing with sample users refined the system to achieve a 98% navigation success rate and 95% response accuracy, ensuring reliable delivery of educational support across multiple query types.
The chatbot operates by accepting user inputs (e.g., “1.6.1” for marks), processing them through Flask, querying the database, and generating responses with embedded data, all accessible via a web interface.
NOVELTY:
Multi-Role Dynamic Access with Tailored Queries: Unlike generic chatbots, this system provides distinct, role-specific menus for students, faculty, parents, and visitors, dynamically fetching personalized data from a MySQL database, enhancing query efficiency in educational settings
Exceptional Accuracy Through Iterative Refinement: Achieves a 98% navigation success and 95% response accuracy through iterative optimization, surpassing typical chatbot performance in educational contexts by addressing path traversal issues
Scalable Design for Advanced AI Integration: Features a modular Flask-based architecture designed for seamless integration of future NLP advancements (e.g., BERT, GPT) and multilingual support, offering adaptability beyond static or rule-based systems.
ADVANTAGES OF THE INVENTION
Enhanced Efficiency: Reduces response time from days (manual methods) to under a minute by automating queries, unlike static FAQ pages or staff-dependent systems.
Higher Accuracy: Outperforms basic chatbots (e.g., ALICE’s 80-90% accuracy) with 95% response accuracy and 98% navigation success, validated by user testing.
Personalized Access: Provides role-specific data retrieval (e.g., student marks vs. parent notices), unlike generic chatbots lacking user differentiation.
Scalability: Supports future AI enhancements, unlike rigid systems like ELIZA or Bayu Setiaji’s chatbot.
Software Code:
python
CollapseWrapCopy

from flask import Flask, request, jsonify, session
import pymysql

app = Flask(__name__)
app.secret_key = 'your_secret_key'

DATABASE_CONFIG = {
"host": "127.0.0.1", "user": "root", "password": "Mahadev@2003",
"database": "sr_university_db", "cursorclass": pymysql.cursors.DictCursor
}

def get_db_connection():
return pymysql.connect(**DATABASE_CONFIG)

def get_response(user_input):
if user_input == "1.6.1" and session.get('user_id'):
conn = get_db_connection()
with conn.cursor() as cursor:
cursor.execute("SELECT c.course_name, m.marks_obtained FROM marks m JOIN courses c ON m.course_id = c.course_id WHERE m.roll_no = %s", (session['user_id'],))
results = cursor.fetchall()
marks_list = "
Your Marks:

"
for row in results:
marks_list += f"
• {row['course_name']}: {row['marks_obtained']}
"
conn.close()
return marks_list + "

@app.route('/chat', methods=['POST'])
def chat():
user_input = request.json.get('message')
response = get_response(user_input)
return jsonify({"response": response})
 
, Claims:1. A chatbot system for educational services, comprising:
a) a web-based interface configured to provide role-based menus for a plurality of user types, including students, faculty, parents, and visitors;
b) a database module, implemented using MySQL, configured to store and retrieve real-time educational data, including academic records, attendance, and schedules, in response to user queries; and
c) a processing module, implemented using Flask, configured to dynamically generate responses with at least 95% accuracy by navigating a hierarchical menu structure based on user inputs.
2. The chatbot system as claimed in claim 1, wherein the role-based menus are optimized through iterative user testing to achieve a navigation success rate of at least 98%.
3. The chatbot system as claimed in claim 1, further comprising a scalable framework configured to integrate advanced natural language processing models for enhanced query handling and multilingual support.