University of Information Technology

Faculty of Software Engineering

Final Exams Management Project

Description

• Final Exams Management is my first solo-project written by Java. This project is very easy to use, it takes only 5 minutes to get familiar.

Functions

• Add, edit or delete a scheduled exam (included subject's code, subject's name, room, date, shift, number of candidates, number of examiner).
• Search for exam's information.
• Make a report of number of subjects, scheduled rooms, assigned examiners, which room has less candidates, which room has most candidates, how many exams have been carried on compare to a static date.
• Sort exam's information by subject's name. Make a report of number of scheduled room, number of candidates, number of assigned examiners of that subject.
• Refresh the result table.

Table interface

Mã Lớp	Tên Môn Học	Ngày Thi	Ca Thi	Phòng Thi	Số Sinh Viên	Số Cán Bộ Coi Thi	Xếp Loại
SE214.I11	Công nghệ phần mềm chuyên sâu	2019-01-02	1	C113	48	2	Đạt
SE215.I11	Giao tiếp người máy	2019-01-10	3	C114	54	2	Không Đạt

User Interface

System requirement

Minimun specs

• CPU: Intel® Celeron® processor 743 (1.3Ghz, 1MB L2 Cache)
• VGA: Intel® GMA 4500M Up to 1695 MB DVMT
• RAM: 4GB
• Disk required: Less than 50MB
• Microsoft SQL Server Management Studio (MSSMS) 18 installed or others database manager.
• Apache NetBeans IDE installed
• Internet access.

Installation

• Step 1: Download SourceCode. It will be a zip file named FinalExamsManagement.zip. Unzip it you'll have 2 files: SQLQuery1.sql and another zip file, unzip it and you'll have a folder named QuanLyLichThiCuoiKy.
• Step 2: Run Apache NetBeans IDE. When NetBeans was opened, go to File -> Open Project (or press Ctrl+Shift+O), browse for the folder QuanLyLichThiCuoiKy, click on Open Project.
• Step 3: Double click on SQLQuery1.sql file. Connect to your MSSM18, press Ctrl+A and then press F5 or click on Execute button to create database.
• Step 4: On Apache NetBeans, on the left-hand side panel, navigate to QuanLy.java, and then hit Run Project or F6.
• Step 5: Feel free to use the application.

Built with

• Microsoft SQL Serrver Management Studio
• Apache NetBeans IDE 11.2
• Java SE Development Kit 13
• Microsoft JDBC Driver for SQL Server

Author

Nguyễn Đức Minh Nguyên (StudentID: 17520823) - University of Information Technology

SourceCode

• Click here to download SourceCode

Project Completed

Vietnam National University (VNU)

University of Information Technology (UIT)

Faculty of Software Engineering (SE)