Graphical Representation of Student Performance and Project Reporting System

Abstract:

This project can implement features like: The first feature is “Graph”, it shows the graphical representation of the student’s performance (attendance and aggregate). The second feature is the “Projects”, here all the project titles with description are stored in the database so that it will be helpful to our juniors and it also helps to know if the new projects are colliding with existing.

Existing System:

  • In our college, the projects are stored in the CDs so there is a problem in accessing.
  • In our college website, the student’s performance is not shown clearly.

Proposed System:

In our application, we are introducing “Graphs” and “Projects”.
Graphs – Here the student’s performance(like attendance, marks) is shown in charts. Where bar graphs are aggregate in semester wise and curve graph for attendance.
Projects – Here all the projects are stored, we create a hyperlink of all the project titles when we click on it the page will be redirected to the project description. There is a search bar where we can search any project by the project’s name or by guide’s name or by the year and duplication of projects can be eliminated.

Modules of Project

Modules Description

Back End: Database, which stores the student details and list of projects with their description.
Front End: User interface, where the client can view charts and project lists.
Middle End: It is the logic or Java code which retrieves data from the database(backend) and display it in the form of charts and it also displays the project lists so that it is easy to access rather than from the CDs.

Methodology/Algorithm/tools

  • We used MySQL for storing student information and list of projects with descriptions.
  • Java language for coding the logic and HTML & CSS for designing the page.
  • Morris.js chart, JChart are the packages helpful for projecting the charts.
  • Every project title is hyperlinked to its description.

UML Diagrams:

Use Case Diagram:

Class Diagram:

Sequence Diagram:

Activity Diagram:

Screen Shots:

Dataset

Our data set includes student’s details of our college like every semester marks, attendance percentage and details of all the projects done by students of CSE.

Conclusion

In this project, we showed the students performance in the form of charts so that it is easy to know the student’s overall performance.
This project also consists the details of all the projects done by the CSE students in our college.

College Information Management System (CIMS) Application

College Information Management system (CIMS) application that effectively manages the storage and retrieval of information on the internal network of a college. In other words, it is a web application for a college.

How a College Functions?

    There are many activities that take place in a college. They are below

  • Admissions: The traditional process of admission requires a student to collect the admission forms, fill them and submit them to the college.
  • Student Enrollment: The student applications are screened and those found suitable are called for an interview and finally selected. 
  • Planning and recording schedules: It is necessary that every college prepares its own academic timetables for:
    1. Classes for each course.
    2. Sports and games.
    3. Extra curricular activities such as competitions and cultural activities.
    4. Meetings and seminars held to review academic schedules teaching strategies and other requirements of the college. 
  • Staff recruitments: the college periodically recruits Teachers, Professors, and Non-teaching staff members. Records on their salaries leave the position, etc., need to be maintained by the college.

As listed above the CIMS application should allow performing all the activities and if possible additional activities in a more easy and efficient manner. This application should be highly scalable and customizable for different types of colleges depending on their requirements.

The application should have an interface for accessing and retrieving data about students and staff and the college itself.

  1. A database management system in which data can be stored safely, while also being easy to access.
  2. A website for the college where outsiders can obtain information about the college.
  3. A central server that controls all the information of the college and also hosts the website of the college.
  4. An internal communication system for exchanging information, scheduling meetings and conferences. 

The following list gives an overview of what CIMS may contain.

This is abstract information about a college process.

Admissions for staff and students

  • Academic details – attendance, exams, marks.
  • Complete fee details, course wise and student wise.
  • Exams – performance.
  • Library Management.
  • Staff: Teaching, Non-Teaching.
  • Leave: Students, Employee
  • Attendance Students, Employee
  • Courses – currently offering, new courses.

Miscellaneous

  • Timetable
  • Curriculum scheduling
  • Calendar 

Reports

  • Student academic report
  • Student TC details
  • Leave Reports
  • Pay Slip
  • Library Report
  • Department wise report
  • Full Academic report 

Planning intranet for a college Requirements   Data management between departments of a college.

Every college has staff and students and all the data related to students and staff that are maintained in college records in the form of files. Similarly, the college maintains the daily activities such as timetable, year wise curriculum, and examination schedules. Maintaining such huge data for years the college needs

  • Manpower
  • Space in the office to maintain shelves, cabinets, and racks
  • Good administration strategy
  • Perfect organization
  • Ease of use
  • Efficient data retrieval 

That is we need to have an environment that is organized with numbered file cabinets. In such a system every folder has its place.

But maintaining such an extensive file system is not possible manually and it is also not cost effective.

Now the question is what makes it easier to maintain such data?

The solution is computerizing the management system.

  • Online website.
  • Internal file management.
  • Keep track of student and staff files.
  • Library management system.
  • Scheduling conferences, news, and announcements.

In order to develop the intranet, we need to do analysis about the requirements of the college system. After the analysis, we need to design the structure flow and model of our Intranet Project. We then need to write programs in Java and integrate to test and deploy the Intranet for a college.

What are the analysis and design, what does it include? 

Analysis:                   

This deals with an investigation of a whole product part by part. It is the abstract separation of a whole into its constituent parts for study. The analysis of any particular project is the paramount requirement before any other operation

Design:

It is a preliminary or initial sketch indicating the basic plan required to execute the project.

Think of what we need to build.

Identify the data needed to be organized in the INTRANET.

  • Student data
  • Staff data
  • Books data

Student Data:

Students may be categorized into two types. An enrolled student and a new student to enrol. The fields that specify the students are as follows.

Admitted Students

  • Personal information
  • Name
  • Parent
  • Address
  • Contact information
  • Date of birth
  • Gender
  • Academic information
  • Admission number
  • Course joined
  • Date of joining
  • Remarks

 Application form for new students

Personal information

  • Name
  • Parent
  • Address
  • Contact information
  • Date of birth
  • Gender

Academic information

  • Applied date
  • Previous college information
  • Previous degree details
  • Course applied for
  • Percentage of marks
  • Application id
  • Application mode (online/offline)
  • Nationality

Official details

  • Accept/Reject
  • Remarks
  • Application mode 

Staff data:

The staff may be categorized into two types, teaching, and non-teaching staff.

Personal and general details

  • Name
  • Gender
  • Nationality
  • Contact information (permanent/present)
  • Application mode
  • Professional job experience
  • Income details

Book data:

Managing the data concerning books is called Library management.

Student Details

  • Student identification number
  • Student name
  • Student address
  • Date of issue of the book
  • Phone number

Book Details

  • Book code
  • Book name
  • Price
  • Number of copies
  • Author
  • Publication
  • Edition
  • Course
  • Transactions
  • Book code
  • Student identification number
  • Date of issue
  • Due date
  • Date of return

Conferences, meetings, news

  • Date
  • Time
  • Purpose
  • Audience
  • Place

 Others

  • Website data
    1. College history
    2. Curriculum
    3. Courses offered
    4. Achievements
    5. Contact information

  Designing the project

    This includes

  • Finalizing the flow
  • Establishing relations
  • Designing the GUI
  • Organizing the data management

Plan for flow

  • Login
  • Main window
  • Options to view students, staff, library, schedules
  • Student
    1. Admitted
      • Select a classroom from list
      • Next, Previous, Add, Save, Modify, Home, Search.
    2. New Admissions
  • Next, Previous, Home, Update Status, View all.
  • Staff
  1. Select a department
  • Next, Previous, Add, Save, Modify, Home, Search, View all.
  • Library
    1. List of the category of books.
    2. Available books.
    3. Check whether the book is available or with the student.
    4. Ability to issue books and note down the details.
  • Schedules
    1. Calendar
  1. List of schedules.
  • Web
  1. Homepage
  2. Links to admission form, course details, contact information, etc. 

WORKING MODEL OF CIMS

  • Login dialogue for CIMS
  • Main page
    1. Student details
    2. Employee details
    3. Library details
    4. Payroll
    5. Attendance
    6. College information
    7. Course information
    8. Latest happenings
  • If we click on Student link
    1. Admission details
    2. Course information
    3. Academic details
  • If we click on Employee Link
  1. Personal information
  2. Course responsibilities
  3. Academic details
  • If we click on Attendance link
    1. A screen with two options, student lists or employee lists with present or absent status appears.
  • If we click on the library link
  1. Books Available for Issue
  2. New books to add
  3. Status of books
  4. Return books with fine (if any)
  • If we click on college link
    1. Just shows the college details
  • If we click on course information
  1. Course details
  2. Subject details
  • Latest happenings
    1. Calendar
    2. Timetable
    3. Holidays
    4. Notice
    5. News and announcements
  • Other pages

Web page: A home page with the following links

  1. About us
  2. Courses
  3. Admissions
  4. List of students
  5. Staff
  6. Contact us
  7. Library
  8. Administrator

Food Ordering Management System PHP & MySQL Project

Summary of the System: 

There is a lot of scope online food ordering business and we can tap it to the max extent possible as everyone has access to an online ordering facility via the internet. Food business usually will have high demand and hence online business prospect for food ordering should be profitable.  We will provide an easily accessible interface wherein the customer can view and place the order easily.

The customer can register initially with minimum details and will be allowed to check the menu items before ordering them, adding them to cart and submit the order. The system records the details in MySQL database so that it will be easy to retrieve later. The users of the system also include employee/admin who will handle info related to product addition and assigning vehicle for placed orders.

Problem Statement:

The food business in restaurants is being carried out in the same fashion for so many decades. In the restaurants, when the customers visit, they will read the large menu cards which just has the name of the item and price. They have to decide in moments time and place the order just to wait in the queue for getting the ordered items on their table. Sometimes, the waiting time is so huge that the customers will actually lose interest in the item. Moreover, some customers will be in their office or busy to come physically to the restaurant and eat.

To ease the process of ordering the items, giving a description of each item and getting the item on the table the online food ordering system is designed. Some of the common problems are listed below.

The general problems faced while ordering food physically in a restaurant are listed below.

  1. Viewing the complete description of the menu item before ordering.
  2. Placing the order standing in a queue.
  3. Waiting for the customer’s turn to get the food.

These hurdles will be avoided by placing the order online

Users of the System:

The users of the system include the customers and the employees. The employees of the system are responsible for updating the menu items as well as the delivery of the item to a particular address. The customers will visit the website, check for the items available in the menu, order for one or more items in the menu. All the activities such as ordering items online, delivery of the items by employees, the vehicle used to deliver the items etc. will be recorded in the database for all the events.

Users of the database:

The top-level management who owns the food business will be using the database. They can try to infer details like

  1. what is the most demanded item?
  2. Which item is not ordered at all?
  3. What amount of business is made on daily basis?
  4. How the delivery of items is being carried out? etc.

Use Cases:

Use case diagram for Customers

Use case Diagram for Employees

The architecture of the Application 

Entities and its Attributes:

The main entities identified in the system are listed below.

  1. Customer [Attributes -> cid, name, email, pwd, phno, address]
  2. Employee [Attributes -> eid, name, phno, email, password]
  3. Orders [Attributes -> oid, pid, cid, odate, quantity, delivery status, vehicle]
  4. Products [Attributes -> pid, name, description, price, file]
  5. Vehicle [Attributes -> vid, status,vehicle_number]
  6. Cart [Attributes -> id, cid, pid, qty, status] 

Logical Design: 

The identified entities along with the attributes in the system are listed in Section 1. The tables that are designed are given below.

Customer Module:

The customer table consists of below details

  1. cid {primary key} [type : int auto_increment] assigned for each unique customer.
  2. name [type : varchar(30)] represents name of the customer
  3. Email [type : varchar(30)] represents email of the customer
  4. Pwd [type: varchar(30)] used for saving password of the customer
  5. Phnno [type : int(11)] is used for saving phone number of customer
  6. Address [type : text] used for saving the address of the customer

This table is used to get the details of customers

Employee Module:

Employee table is used to save

  1. eid {primary key} [type : int auto_increment] assigned for each unique employee.
  2. name [type : varchar(30)] represents the name of the employee.
  3. Phno [type : int(15)] is for saving phone number of employee
  4. Email [type : varchar(32)] saves the email info of an employee
  5. Password [type : varchar(32)] will save password of employee

Orders Module:

Order table used to save

  1. oid { primary key } [type : int auto_increment] assigned for each order.
  2. pid { foreign key references products: pid } .
  3. Cid [foreign key references customer: cid]
  4. Quantity [type : int (25) ] represents the quantity of the ordered product.
  5. Odate [type : datetime] represents a timeframe of the products ordered by the customer
  6. Quantity [type : int (11)] provides the quantity ordered by the customer
  7. Delivery status [type : tinyint(1)] saves the delivery status whether delivered or pending
  8. Vehicle [type : int(11)] helps in assigning vehicles. foreign key references: vehicles vid

Products Module:

Products tables used to save

  1. pid {primary key} [type : int auto_ioncrement ] assigned for each product.
  2. name [type : varchar(20)] represents the name of the product.
  3. description [type :text] represents the description of the product.
  4. Price [type : double(10,5)] saves the price of the product ordered
  5. File [type : text] saves the image of product ordered

Vehicle Module:

Vehicle table used to save

Vehicle [Attributes -> vid, vehicle number]

  1. vid {primary key} [type : int auto_increment] assigned for each vehicle.
  2. Status [type : int(11)]
  3. Vehicle number [type: varchar(30)] saves the registration number of the vehicle assigned for delivery

Cart Module:

Cart table used to save

Cart [Attributes -> id, cid, pid, qty, status]

  1. Id {primary key} [type : int auto_increment] assigned for each cart
  2. Cid foreign key references customer id from the customer table
  3. Pid foreign key references products table
  4. Qty saves all quantities related to products added in cart
  5. The status will save delivery status

Entity-Relational diagram:

Download Food Ordering Management System PHP & MySQL Project Source Code.

College Bus Tracking System Java Project

INTRODUCTION:

  • The college bus tracking system helps users to know the bus location so that the users don’t get delayed or don’t arrive at the stop too early.
  • In order to overcome increased waiting for time and uncertainty in arrival, we have come with this project.

Objective:

  • The main goal is to find the location of the bus so that the users do not get delayed.

EXISTING SYSTEM:

  • Location of the bus is not known, thus we need to ask the bus information for respective persons.
  • Long time waiting for the bus.
  • Chances of missing bus.

PROPOSED SYSTEM:

  • We are expecting to find the location of the bus and let the users know the location.
  • so that one can manage their time efficiently and reach their stop just before the bus arrives or take an alternate means of transport if they miss the bus or they are running late.

UML Diagrams:

Use Case Diagram:

Sequence Diagram:

Class Diagram:

Activity Diagram:

Output Screens:

Home Page:

Add Tracking Details:

View Map:

Output Screen names:

  • Home Page
  • Admin Login Page
  • Admin Home Page
  • View Users & Activate Page
  • Add Bus Route Page
  • Track Bus Details Page
  • Driver Login Page
  • Driver Home Page
  • View My Route Details Page
  • Add Tracking Details Page
  • User Registration Page
  • User Login Page
  • User Home Page
  • View My Profile Page
  • View Bus Routes Page
  • View Map Page
  • Track Bus Details Page
  • Map Page

College Information Management System (CIMS) Project Synopsis

The project College Information Management System (CIMS) deals with the maintenance of information over a network within the college. The college system has gone through a vast transformation particularly in the last decade. While adopting, IT seems to be the best choice towards enhancing efficiency, it becomes necessary for college systems to face the challenges imposed by the e-vulnerabilities.

This product ensures instant and secure information maintenance in colleges.

This project is capable of maintaining the following details:

Student: The traditional process of admission requires a student to collect the admission forms, fill them and submit them at the college. CIMS enables the student’s to enroll them in the college. The student’s performance is also maintained and can be securely recovered by the college administration.

Staff: The admission process of staff requires them to fill out the application and submit to the college.CIMS maintains the complete details of the staff like department, attendance, and payroll.

Library: The library management enables the book registration process, book transaction process, to know the book status.

Attendance: CIMS maintains the complete attendance details of the student and the employee

Courses: The course details like presently offering, new courses etc are maintained by the system. Fee details like course wise, subject wise, are also maintained. Individual subject details like date of commencement, maximum marks, pass marks are also maintained.

College information: college information like history, calendar, holidays, timetable, news, and announcements are maintained.

Apart from this College Information Management System project allows the information available over the college internal network and provides information access to the entire spectrum of campus users that includes college staff such as administrators, faculty, librarians, etc. CIMS also avails the web interface to provide the college information on www. This allows the students and other users to search for information about the college online. The web also allows the students to register online for the college. Hence this project helps a college function in a very smart way. Due to the lack of time, CIMS does not enable to work on multi-branched educational institutions. It can be easily be implemented.

Project work description

This project of CIMS addresses all the vulnerable aspects and meets the requirements of various fields like college administration, staff and student enrollment, library management, latest happenings, course details, etc.

The system was developed in Java using swing, AWT packages, exception handling and event handling with interaction to a database in MS Access.

Modules:

This College Information Management System project is subdivided into the following modules or partitions.

• Employee
• Student
• Library
• Course
• Attendance
• Latest happenings
• Payroll management
• Web page

System Design Phase:

DFD

 

Student Admission:

Student application:

Staff Admission:

Payroll management:

DFD for Employee & Leave:

DFD for Advance and Attendance:

Library Management Systems & Library Transactions

Latest happening:

FUNCTIONAL DESCRIPTION OF PROJECT

When the package is started a dialog box is displayed by asking for a password on the correct entry of the password the user is allowed to enter into the main menu frame. A colorful welcome wish is displayed on the front window.

It has the following options:

  1. Employee details.
  2. Student details.
  3. Library management.
  4. Payroll management.
  5. Attendance.
  6. Web Page.
  7. Course information.
  8. Latest Happenings.
  9. About college

Employee

This window is used to maintain the Employee details.

On clicking the Employee menu item, it gives a window, which allows the user to add, view, modify and delete the employee details by clicking their corresponding buttons.

This module deals with the input of data from the user and storing the data in the database.

While adding an employee, the employee code is generated. The user has to enter the personal details, select the designation and select the department name etc.

Student

This window is used to maintain the Student details.

On clicking the Student menu item, it gives a window, which allows the user to add, view, modify and delete the student details by clicking their corresponding buttons.

This module deals with the input of data from the user and storing the data in the database.

While adding a student, the student ID is generated. The user has to enter the personal details, select the designation and select the department name etc.

Library

This window is used to maintain the Library details like the following:

  • Transaction [issue, return].
  • New Book registration.
  • Searching for a book.

On entering the Library details, to add the information of a book the user has to enter the book code, book name, author, publication, edition, date. The user also has the options to view, delete the book details whenever required. All the above-mentioned features have been extensively handled.

Payroll

This window is used to get the monthly Pay slip of an employee.

On entering the Pay slip window, the user has to supply the employee code. The system will calculate the net amount by calculating all corresponding calculations.

The calculations are displayed in their corresponding boxes and now pay slip is ready to take the printout by just clicking the print button.                                                                                        

Course details

This window is used to know the details about the courses, which the college is offering like the course ID, course duration, course fee, and any other information. It also gives the user the freedom of entering new courses, which the college will offer.

Latest information

This window will help the user know about the happenings in the college like the following:

  • Calendar
  • Time-table
  • News and announcements
  • Holidays
  • Notices

By choosing any of the above options the user can know about the related. He is also given the freedom of editing any changes to the data. 

Attendance

This window will have two options like

a) Student

b) Employee.

When we choose one it will show the details of the attendance of the selected candidate.

Web page

When we click this option the web page of the college will open and it has all the features, which the stand-alone application has.

About

This will show a window, which has a text field that shows the college history.

Conclusion:

This package has established a model for College Information Management.

This package is completely computerized and maintains the details of all students and employees like Student and Employee details, Leave, Advance, Admissions, Course details, Library Management, Attendance Specification, Latest Information, college web page, it also generates reports for all employees and students as needed, like Salary Summary, Department Wise Salary and Total Leaves took by an employee, marks obtained, attendance, library transactions, etc. by a student.

This package is so designed that all calculations are automatically generated for college management system.