SUMMER TRAINING reporting are used ppt.pdf

Summer internship report

1. STUDENT
MANAGEMENT SYSTEM Presented By Dishank Rao
Enrollment number: 05314812723

2. INTRODUCTION Why this project?
Manual student record management is slow & error-prone.
Colleges need digital solutions for efficiency.
What does it do?
Role-based system for Admin, Faculty, Students.
Stores and manages data like courses, marks, and attendance.
Generates reports and exports data in CSV format.

3. OBJECTIVES Automate student, course, marks, and attendance management.
Provide role-based dashboards (Admin, Faculty, Student).
Generate reports with CSV export.
Learn application of Python GUI + Database integration.

4. TECH STACK PYTHON 3.11
PYQT5 (GUI)
SQLITE3 (DATABASE)
IDLE (IDE)
CHATGPT (AI CODING ASSISTANT)

5. SYSTEM
ARCHITECTURE

6. DATABASE DESIGN
ENTITY-RELATIONSHIP (ER) DIAGRAM OF STUDENT MANAGEMENT SYSTEM
DATABASE: SQLITE3
5 MAIN TABLES:
USERS
STUDENTS
COURSES
MARKS
ATTENDANCE

7. FEATURES – ADMIN MANAGE STUDENTS, COURSES, USERS.
VIEW AND GENERATE REPORTS.
EXPORT TO CSV.

8. FEATURES – FACULTY UPDATE STUDENT MARKS.
RECORD ATTENDANCE.
VIEW PERFORMANCE SUMMARIES.

9. FEATURES – STUDENT VIEW PROFILE DETAILS.
CHECK MARKS & ATTENDANCE.
GRAPHICAL PROGRESS BARS.

10. SCREENSHOTS

11. TESTING & RESULTS LOGIN TESTED WITH VALID/INVALID INPUTS.
CRUD OPERATIONS TESTED (ADD/UPDATE/DELETE).
REPORT GENERATION TESTED.
RESULTS: ALL FEATURES WORKING SUCCESSFULLY.

12. LIMITATIONS DESKTOP-ONLY (NO WEB/CLOUD ACCESS).
SQLITE NOT SCALABLE FOR BIG INSTITUTIONS.
GUI IS BASIC (PYQT STANDARD).
AI USED ONLY AS CODING ASSISTANT, NOT PREDICTIVE.

13. FUTURE SCOPE WEB & MOBILE INTEGRATION.
CLOUD DATABASE SUPPORT.
AI-BASED STUDENT PERFORMANCE PREDICTIONS.
INTEGRATION WITH LMS (MOODLE, GOOGLE CLASSROOM).

14. EXTRA PROJECT –
FANTASY CRICKET APP MINI PROJECT BUILT FOR INTERNSHALA.
FEATURES:
CREATE FANTASY TEAMS.
POINTS CALCULATION SYSTEM.
SIMPLE INTERFACE USING PYTHON

15. CONCLUSION SUCCESSFULLY DEVELOPED A STUDENT MANAGEMENT SYSTEM USING PYTHON, PYQT5 & SQLITE.
IMPLEMENTED ROLE-BASED DASHBOARDS FOR ADMIN, FACULTY, AND STUDENTS.
GAINED HANDS-ON EXPERIENCE IN DATABASE DESIGN, GUI DEVELOPMENT, AND TESTING.
LEARNED HOW TO USE AI TOOLS (CHATGPT) AS CODING ASSISTANTS IN REAL PROJECTS.
DEMONSTRATED SKILLS IN BUILDING A PRACTICAL, WORKING SOFTWARE APPLICATION.

16. THANK
YOU