Development of College Information System
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
seminar topics
Active In SP
**

Posts: 559
Joined: Mar 2010
#1
24-03-2010, 07:34 PM


Title of the project and implimentation
Development of College Information System

Abstract of the project and implimentation
This project and implimentation is aimed to design a College Information System, which is a web oriented application allows to access the whole information about the college, staffs, students, facilities. It can streamline the administration of an Institution in all areas and involves many administrative work and co-ordination, as well as to perform various operations like admissions, payroll generations, student management, staff management, library management, infrastructure management, report generation, etc This application provides a virtual tour of Campus. Here you will get the latest information about the students and staffs. This generic application designed for assisting the students and staff of the Institute regarding information on the courses, subjects, classes, assignments, grades and timetable and etc.
Use Search at http://topicideas.net/search.php wisely To Get Information About Project Topic and Seminar ideas with report/source code along pdf and ppt presenaion
Reply
seminar surveyer
Active In SP
**

Posts: 3,541
Joined: Sep 2010
#2
23-12-2010, 01:43 PM

Introduction

With the fast changing technology, today an organization has become surprisingly large and sophisticated operation. Technologies often have an important role to play and are the key to success in competing with the world. Thus the working approach of the people has changed a lot. Now a day’s time and money matters a lot. So we need to fully automate our existing manual system, and thus comes the concept of computerization. Online College Information System is one of them. This includes various section of a college like Student profiles, profiles, Job Section etc.

Website Design
A good website design must meet three needs. They are referred as AAA website configuration. Authentication- Verifying a User’s Identity. Authorization- Specifying permissions for a user. Accountability- Monitoring a User’s activities.

OBJECTIVE
The process of planning, designing and implementing computer system is called a project and implimentation. Online College Information System caters to student and Job Seeker spread across the globe to find their suitable College for studies and get College information living in a remote place. To maintain each and every information related to the College. Online College Information System is developed to computerize and thereby automate the entire everyday work process. The demand of this type of system is growing day by day. It is built to cover all the areas of college oriented data transaction. The system also aims at giving every job Seeker user a store place where he/she can upload their Resume. It is basically online based application and it is a database application developed using SQL Server and front end using ASP .NET.  To make the system fully user-friendly.  To make the system fully scalable.  To make the system fully front-end administrator.


Problem Details:
This problem is designed in a manner such that it provides a common platform for student to find their suitable College for studies. First the visitors of the site will not to get registered to the online college information system to use its facilities. Only those student and faculty have own personal account where the user can share Student Forum, Recent Notice and more college information. This system provides a platform where any user can search and find their suitable College for studies and online application for admition the college. The system also provides a forum for each community where community members can post new topics. Leaving all these, user can report abuse to the administrator about any aspect of the system or about any user. If the administrator finds any such wrong, admin can either give warning or delete the user’s account forcefully.

Project Category:
This project and implimentation basically systems with online support and it is based on managing the database of the online application, student, faculty, cources,recent notice, Student Forum records. It is divided with two parts one is server part and the other part is client part.So, the category of this project and implimentation is online college information system developed using ASP .NET with database that is SQL Server.

Scope:
As we have mention earlier that the objective of the project and implimentation is to cover-up the loopholes exists in handling “Online College Information System”. The scope of the project and implimentation is to find out main issues we are covering in our project and implimentation and to find out main function of our project and implimentation. The ‘Online College Information System’, we have developed can connect student all over the world. Using our website one can extend his worldwide network by sitting at home. It also provides an excellent search facility which will be helping student to search their best college. Students can share their thoughts & ideas by creating their community & using forums.

Software Requirment Specification:
(Tools/Environment used)
Requirement specification is done in order to understand the problem the software system is to solve. For large system that have many features and that have many features and that need to perform many different tasks, understanding the requirements of the system is a major task. The emphasis in requirement analysis is on identifying what is needed from the system, not how the system will achieve its goals. This task is complicated by the fact that there are often at least two parties involved in software development a client and a developer. The developer usually does not understand the issue involved in software system. This is a communication gap, which has to be adequately bridge requirement analysis.

Problem Analysis or Understanding Requirement Specification
In the problem analysis, the analyst has to understand the problem and its context. Such analysis typically requires a through understanding of the existing system, part of which has to be automated. A clear understanding is needed of the important data entities in the system, major centre where action is taken, the purpose of the different action that are performed and the inputs and outputs. This requires interacting with clients and end users, as well as studying the existing manual procedures. With the analysis of the current system, the analyst can understand the reason for automation and what affects the automated system might have.


Hardware & Software Requirements:-

Software

Specification

1. Front end 2. Backend

ASP.NET SQL Server (2005)

3. Compiler

ASP.Net compiler Converted into Intermediate code

4. Operating System

Windows XP (S.P2)

Hardware
1. Monitor
2. Mouse
3. Keyboard
4. RAM 5. Processor
6. Mother Board
7. Floppy drive
8. CD drive
9. Hard disk

Specification SAMSUNG 17” color Model - Sync Master 753s Input – 12/6 volt Output – 12/6 volt SAMSUNG Type – Optical Wheel Mouse Points – Normal select Button – Right handed normal Select Files & Folder – Double click to Open an item (single click to select) INTEX Name – standard 101/102 key Type – QWERTY Input language – English (U.S). To turn off caps lock press CAPS LOCK key 256 MB 2.7 GHz ASUS SONY 3.25” SAMSUNG 52X SEGATE 40G.B.

Analysis and Design
The proposed Online based system specifically designed for college where various courses are running. With the fast changing technology, today college has become surprisingly large and sophisticated operations. Technologies often have an important role to play and are the key to success in competing with the world. A need for the development of Web site is to success in competing with the world. A need for the development of Web site is to help employee of that college and also for students. By this system faculty can make an idea about student’s various status like their academic details, their personal details, and their academic performance and employee can check their own details and can make report by just mouse clicking. The information of various courses can be obtained by this system. I wish to obtain this online computer application to serve as the online college information system for smooth running various operation. There are three phase of feasibility study. They are:Behavioral Feasibility: It includes the training of the user staff on the system. The data entries screen that is designed as much simple as possible and the data entry job for user is depend upon user level. But the higher-level user has to enter data in many forms like online application details, student details, faculty details, recent notice, and student forum etc. Employee have different category there is faculty and the other one is administrative employee. Training of 2 hours will be sufficient for low-level user. But here training of is required more as much their user level is high. Technical feasibility: Evaluating the hardware and supporting software determine it. It provides reliable security measures, which protect the data and the package from accidental of deliberate threats that could cause unauthorized modifications, disclosures of destruction of the data and protection of the
information system by the use of various data access permission that is given by super level user that is in database mode and network mode and password. Every level user has different data access permission that is given by super level user. It has two parts one is server part and the other one is client part. It provides input of data at anytime with the ability to update records in the system if user has sufficient privilege given by administrator. It provides effective means of producing hard copies of information of student and faculty information is kept for future scope for this system. It provides online application details, student details, faculty details, and courses details. It obtains greater speed and accuracy in handling data and generating reports. It provides records for each user who logged into the system and duration this provides another type of security by this administrator can keep user working status.

Economic feasibility:
It is also known as cost/benefit analysis, which determines to what extent a new system is cost effective. Undoubtedly this system is cost effective because new proposed system is required fewer students whose can produce huge output by using this system very quickly.

Project Resources:
Privilege is the sole feature, which user’s accessibility to different modules of the system. Different privilege is assigned to different roles such as moderator, general user, and college student. Message passing using student forum is an important feature of the system. Resume uploading is an additional feature given to the users. Student forum creation is the feature, which facilitates user to create a discussion platform to share new ideas or views.



Analysis and Design
The proposed Online based system specifically designed for college where various courses are running. With the fast changing technology, today college has become surprisingly large and sophisticated operations. Technologies often have an important role to play and are the key to success in competing with the world. A need for the development of Web site is to success in competing with the world. A need for the development of Web site is to help employee of that college and also for students. By this system faculty can make an idea about student’s various status like their academic details, their personal details, and their academic performance and employee can check their own details and can make report by just mouse clicking. The information of various courses can be obtained by this system. I wish to obtain this online computer application to serve as the online college information system for smooth running various operation. There are three phase of feasibility study. They are:Behavioral Feasibility: It includes the training of the user staff on the system. The data entries screen that is designed as much simple as possible and the data entry job for user is depend upon user level. But the higher-level user has to enter data in many forms like online application details, student details, faculty details, recent notice, and student forum etc. Employee have different category there is faculty and the other one is administrative employee. Training of 2 hours will be sufficient for low-level user. But here training of is required more as much their user level is high. Technical feasibility: Evaluating the hardware and supporting software determine it. It provides reliable security measures, which protect the data and the package from accidental of deliberate threats that could cause unauthorized modifications, disclosures of destruction of the data and protection of the
information system by the use of various data access permission that is given by super level user that is in database mode and network mode and password. Every level user has different data access permission that is given by super level user. It has two parts one is server part and the other one is client part. It provides input of data at anytime with the ability to update records in the system if user has sufficient privilege given by administrator. It provides effective means of producing hard copies of information of student and faculty information is kept for future scope for this system. It provides online application details, student details, faculty details, and courses details. It obtains greater speed and accuracy in handling data and generating reports. It provides records for each user who logged into the system and duration this provides another type of security by this administrator can keep user working status.





Server side Requirements:
Operating System: Windows XP Server: IIS (Internet Information Services) Database: SQL Server

Client Side Requirements: Browser: Internet Explorer 6/7
17

Time Estimation:SEQUENCE TASK NAME DURATIO (ESTIMATED) DURATION (ACTUAL) START DATE (ESTIMATE D) START DATE (ACTUAL) END DATE (ESTIMATED) END DATE (ACTUAL)

A

Feasibility Study Project Planning

2days

2days

15/02/2010

15/02/2010

16/02/2010

16/02/2010

B

4days

4days

17/02/201 0
21/02/2010

17/02/2010

20/02/2010

20/02/2010

C

Requirement Analysis

2days

2days

21/02/2010

22/02/2010

22/02/2010

D E F G

Design Coding Unit Testing Integration & System Testing

15days 20days 2days 7days

15days 20days 2days 7days

23/02/2010 10/03/2010 31/03/2010 2/04/2010

23/02/2010 10/03/2010 31/03/2010 2/04/2010

9/03/2010 30/03/2010 1/04/2010 10/04/2010

9/03/2010 30/03/2010 1/04/2010 10/04/2010


GNATT CHART REPRESENTATION:-

Actual Time

Slack Time

A
S E Q U E N C E

B

C

D

E

F

G

15/02/2010

17/02/2010

21/02/2010

23/02/2010

10/03/2010 31/03/2010

2/04/2010

DATE


Monitoring and Controlling:Monitoring and controlling is always an important issue throughout the development of our project and implimentation, Online College Information. The major points upon which the monitoring and controlling of our project and implimentation is based on are as follows:

Periodically project and implimentation review meeting among the team members has taken place to ensure smooth execution of the project and implimentation work. A project and implimentation schedule has been planned for every member of the team. The schedule contains work given to each member and actual work done.



System Design:-

The entity relationship data model is based on a perception of a real world that consists of a collection of basic object, called ENTITIES & of RELETIONSHIPS among these objects. An Entity is an object in real world that is distinguishable from other objects.

ENTITY

ELLIPSE

RELETIONSHIP SET

LINK ATTRIBUTE TO ENTITY & ENTITY TO RELATIONSHIP SET MULTIVALUED ATTRIBUTE

DERIVED ATTRIBUTE

TOTAL PARTICIPATION

WEAK ENTITY SETS



Program Structure
(Entity Relationship Diagram)
cname age lname dob M fname Applicant School/college age lname dob 1 M Employee/Faculty applicant M gendre Job category Selected as board 1 faculty M 1 1 student board password 1 register sid 1 Dept_id department Dept_name Faculty_reg M salary joining 1 uses 1 designation M cid cname having Stu_reg eid 1 passwd 1 M cid 1 session dept cname duration Blood group M Student Applicant M Selected as Phone no Apply for Father’s name College/ university marksgra school gendre IS A courses address 1 Admission cid lname view cid M courses firstname eligibility duration fees

fname capply

fname

Online job

Apply for

markstwe

Selected for

register

studies

courses M

fees

department

eligibility

1 notice department

forum

forum email

Phone no rnotice

Dept_no

Dept_name



Applicant

Online College Information system

Context Level



Online_admsn

Apply for admission

Apply

Applicant

Selection

Login Admin

Conform

Candidate Inform

Admission

LEVEL 0

Onlinejob

Apply for job

Apply

Candidate

Selection

Login Admin

Conform

Selected Candidate Inform

Interview

Candidate for job

LEVEL 0


Online_admsn

Register/Apply Apply system 1.0 Student Apply Authentication

Login Selection system 2.0 Authentication Inform Selected Applicant Admin

Admission System 3.0 Student details Stu_reg

LEVEL 1

Onlinejob

Register/Apply Apply for job system 5.0 Faculty/Employee Authentication

Login Selection system 6.0 Authentication Inform Selected candidate for interview Admin

Take admission

Interview System 7.0

Call for interview

Candidate

Selected for Job emp_reg Faculty Profile 8.0

LEVEL 1

Faculty Query process 2.0

Student

Delete Admin Update

Forum 2.1

Submit Query/FAQ Confirm

Notice/information Processing 2.2 Suggestion

Accept

LEVEL 2



course

Course 2.3

Update
Admin Notice 2.4 Student

Delete
Faculty

Faculty

Profile 2.5 Student

Update

Delete
Admin

LEVEL2


File Design (Table structure):The name of the database is CIS. It consists 7 tables. They are online_admsn, stu_reg, emp_reg, Recent_notice, suggbox, cources, and onlinejob. Online application contains about application details:

Online_admsn
Attribute Name
firstname lname fname gender age dob bloodgrp address phone capply cid markstwe school board marksgra college/university

Data type
Varchar Varchar Varchar char Number date char Varchar Varchar Varchar Varchar Number Varchar Varchar int Varchar

Field Size
50 50 50

Constraints

2

3 100 15 10 8 3 40 30 3 40



student registration contains about student details

Stu_ Reg
Attribute Name
sid passwd conpasswd name father_name gender age dob bloodgrp address phoneno session: cid cname dept

Data type
int varchar varchar Varchar Varchar char int date char Varchar Varchar Varchar Varchar Varchar Varchar

Field Size
10 50 50 50 50

Constraints

2

3 100 15 10 8 20 20



Faculty Table contains about faculty details

Faculty/Employee Registration
Attribute Name eid passwd conpasswd name gender age dob address phone email designation
salary joining department

Data type Number Varchar Varchar Varchar char Number date Varchar Varchar Varchar Varchar Number date Varchar

Field Size 10 50 50 30

Constraints

2

100 15 40 20 20

20



Course Table contains about course details

Course
Attribute Name cid cname duration/year fees/semester eligibility Data type Number Varchar Number Number Varchar Field Size 10 20 2 10,2 20 Constraints

Carrier Table contains about Job details

onlinejob
Attribute Name fname lname sex age dob Data type Varchar Varchar char Number date 2 Field Size 30 50 Constraints



Student Forum Table contains about Comments details Stu_Forum Attribute Name forum Email ID phone _no Data type Varchar Varchar Number Field Size 500 50 10 Constraints

Recent Notice Table contains about Current details information

Recent Notice
Attribute Name rnotice Data type Varchar Field Size 500 Constraints

Suggestion Table Contain about Current suggestion about our college website Suggbox Attribute Name sugg Data type Varchar Field Size 500 Constraints



Project Analysis:The output design is the design of the form on which our desired output is displayed; this has to do with the actual interface. It is considered first in designing because it is the targeted output that would determine the input and the method of processing that would ensure the output. The system provides several reports to answer different queries and these reports are online student application report, Student registration report. There is another output design for this system is Student forum, applicant for job by online. The input form is input document to record information. Administrator receives information various information through various types of form which is linked, to a database. This form is online-based and designed using the manual form as a prototype. The project and implimentation is made user friendly as much as possible. The system has several input forms it is mainly include in client side part where user can interact, which include: Online Application Form Student Registration Form Faculty Registration Form Student Forum Form Online Application for Job Form The System has another part that is Server part, which is controlled by administrator who gives various access permission to clients. The server side contains various forms for starting processes, database connectivity, user information etc.


Details about form design:Server Side Application:It is under main form. Through this we can connect to our database not to the system. We have to enter Database using Connection String. Online Application Form: This form is main form in server side part. Through this form we can enter this system. Various forms are under this form they are database login form, setting form, student Registration form, Faculty form, online job application form etc. Through this form administrator gives access permission to client. Administrator can see the total number of connection logged in this application.



Online job form:


Stu_reg form:



Faculty/Employee form:



Suggestion box form:

Course form:



Forum form:



Client Side Application:First form of this project and implimentation containing project and implimentation name, date, format and the clients are using the menu bar doing their job. Clients can get best information about college before begging the studies. It includes various forms they are online application form, student registration form, faculty registration form, online job application form. Online application information is used for accepting student master details that is unchangeable details about student data. Checking validation for student registration form. Front Page:



This form contains information about online application:

This form contains information about student registration:


This form contains information about faculty/employee registration:

This form contains information about online application for job:



his form contains information about Forum:

This form contains information about suggestion related to our college:



This form contains information about student profile:

This form contains information about faculty/employee profile:



This form contains information about Various Course:

This form contains information about sitemap/location:



Module
ModApi contains various API functions which are used to get system information, like machine name, system folder name, version etc. It also contains API function to manage the GUI applications. ModDatabase contains functions related to database operation like database path, open database, close database, etc. ModNetwork is used to establish the connection between server application and client application. It contains various functions and procedures to manage the network activity. ModStart contains the main function that runs at first when the application starts. This module also contains various and procedures for character, integer, string that is validation checking.



CODING
/************ Online Application for Admission ****************/
using using using using using using using using using using using using using System; System.Collections; System.Configuration; System.Data; System.Linq; System.Web; System.Web.Security; System.Web.UI; System.Web.UI.HtmlControls; System.Web.UI.WebControls; System.Web.UI.WebControls.WebParts; System.Xml.Linq; System.Data.SqlClient;

namespace CIS { public partial class onlapp : System.Web.UI.Page { SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;Initial Catalog=cis;Integrated Security=True;Pooling=False"); protected void Page_Load(object sender, EventArgs e) { } protected void Button2_Click(object sender, EventArgs e) { TextBox1.Text = ""; TextBox2.Text = ""; TextBox3.Text = ""; TextBox4.Text = ""; TextBox5.Text = ""; TextBox6.Text = ""; TextBox7.Text = ""; TextBox8.Text = ""; TextBox9.Text = ""; TextBox10.Text = ""; TextBox11.Text = ""; TextBox12.Text = ""; TextBox13.Text = ""; TextBox14.Text = ""; }



protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { if (DropDownList1.SelectedItem.Text == "MCA") { TextBox9.Text = "MCA_56"; TextBox13.Visible = true; TextBox14.Visible = true; } if (DropDownList1.SelectedItem.Text == "MBA") { TextBox9.Text = "MBA_57"; TextBox13.Visible = true; TextBox13.Visible= true; } if (DropDownList1.SelectedItem.Text == "BCA") { TextBox9.Text = "BCA_58"; TextBox13.Enabled= false; TextBox14.Enabled = false; RequiredFieldValidator13.Enabled = false; RequiredFieldValidator14.Enabled = false; } if (DropDownList1.SelectedItem.Text == { TextBox9.Text = "BBA_59"; TextBox13.Enabled = false; TextBox14.Enabled = false; RequiredFieldValidator13.Enabled = RequiredFieldValidator14.Enabled = } if (DropDownList1.SelectedItem.Text == { TextBox9.Text = "BHM_60"; TextBox13.Enabled = false; TextBox14.Enabled = false; RequiredFieldValidator13.Enabled = RequiredFieldValidator14.Enabled = } if (DropDownList1.SelectedItem.Text == { TextBox9.Text = "PGDM_61"; TextBox13.Visible = true; TextBox14.Visible = true; } if (DropDownList1.SelectedItem.Text == { TextBox9.Text = "BOPTM_73"; TextBox13.Enabled = false; TextBox14.Enabled = false; RequiredFieldValidator13.Enabled = RequiredFieldValidator14.Enabled = } if (DropDownList1.SelectedItem.Text == "BBA")

false; false; "BHM")

false; false; "PGDM")

"BOPTM")

false; false; "BTTM")

50

{ TextBox9.Text = "BTTM_62"; TextBox13.Enabled = false; TextBox14.Enabled = false; RequiredFieldValidator13.Enabled = false; RequiredFieldValidator14.Enabled = false; } if (DropDownList1.SelectedItem.Text == { TextBox9.Text = "BSHM_63"; TextBox13.Enabled = false; TextBox14.Enabled = false; RequiredFieldValidator13.Enabled = RequiredFieldValidator14.Enabled = } if (DropDownList1.SelectedItem.Text == { TextBox9.Text = "BMS_64"; TextBox13.Enabled = false; TextBox14.Enabled = false; RequiredFieldValidator13.Enabled = RequiredFieldValidator14.Enabled = } if (DropDownList1.SelectedItem.Text == { TextBox9.Text = "BSCM_65"; TextBox13.Enabled = false; TextBox14.Enabled = false; RequiredFieldValidator13.Enabled = RequiredFieldValidator14.Enabled = } if (DropDownList1.SelectedItem.Text == { TextBox9.Text = "BIRM_66"; TextBox13.Enabled = false; TextBox14.Enabled = false; RequiredFieldValidator13.Enabled = RequiredFieldValidator14.Enabled = } if (DropDownList1.SelectedItem.Text == { TextBox9.Text = "HM_67"; TextBox13.Enabled = false; TextBox14.Enabled = false; RequiredFieldValidator13.Enabled = RequiredFieldValidator14.Enabled = } if (DropDownList1.SelectedItem.Text == { TextBox9.Text = "CSE_68"; TextBox13.Enabled = false; TextBox14.Enabled = false; RequiredFieldValidator13.Enabled = RequiredFieldValidator14.Enabled = } "BSHM")

false; false; "BMS")

false; false; "BSCM")

false; false; "BIRM")

false; false; "hotel managment")

false; false; "Btec-CSE")

false; false;



if (DropDownList1.SelectedItem.Text == { TextBox9.Text = "IT_69"; TextBox13.Enabled = false; TextBox14.Enabled = false; RequiredFieldValidator13.Enabled = RequiredFieldValidator14.Enabled = } if (DropDownList1.SelectedItem.Text == { TextBox9.Text = "EC_70"; TextBox13.Enabled = false; TextBox14.Enabled = false; RequiredFieldValidator13.Enabled = RequiredFieldValidator14.Enabled = } if (DropDownList1.SelectedItem.Text == { TextBox9.Text = "EEE_71"; TextBox13.Enabled = false; TextBox14.Enabled = false; RequiredFieldValidator13.Enabled = RequiredFieldValidator14.Enabled = } if (DropDownList1.SelectedItem.Text == { TextBox9.Text = "AERO_72"; TextBox13.Enabled = false; TextBox14.Enabled = false; RequiredFieldValidator13.Enabled = RequiredFieldValidator14.Enabled = } }

"Btec-IT")

false; false; "Btec-EC")

false; false; "Btec-EEE")

false; false; "Btec-Aerospace")

false; false;

protected void Button1_Click(object sender, EventArgs e) { conn.Open(); SqlCommand cmd = new SqlCommand("insert into online_admsn values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + DropDownList2.Text + "','" + TextBox4.Text + "','" + TextBox5.Text + "','" + TextBox6.Text + "','" + TextBox7.Text + "','" + TextBox8.Text + "','" + DropDownList1.Text + "','" + TextBox9.Text + "','" + TextBox10.Text + "','" + TextBox11.Text + "','" + TextBox12.Text + "','" + TextBox13.Text + "','" + TextBox14.Text + "')", conn); cmd.ExecuteNonQuery(); conn.Close(); Label1.Text = "Your application have been submited/We will contact you soon"; TextBox1.Text TextBox2.Text TextBox3.Text TextBox4.Text = = = = ""; ""; ""; "";



TextBox5.Text = ""; TextBox6.Text = ""; TextBox7.Text = ""; TextBox8.Text = ""; TextBox9.Text = ""; TextBox10.Text = ""; TextBox11.Text = ""; TextBox12.Text = ""; TextBox13.Text = ""; TextBox14.Text = ""; }

} }

/**************Student Registration****************/
using using using using using using using using using using using using using System; System.Collections; System.Configuration; System.Data; System.Linq; System.Web; System.Web.Security; System.Web.UI; System.Web.UI.HtmlControls; System.Web.UI.WebControls; System.Web.UI.WebControls.WebParts; System.Xml.Linq; System.Data.SqlClient;

namespace CIS { public partial class stureg : System.Web.UI.Page { SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;Initial Catalog=cis;Integrated Security=True;Pooling=False"); protected void Page_Load(object sender, EventArgs e) { } protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { if (DropDownList1.SelectedItem.Text == "MCA") { TextBox11.Text = "MCA_56";



TextBox12.Text = "IT"; } if (DropDownList1.SelectedItem.Text == { TextBox11.Text = "MBA_57"; TextBox12.Text = "managment"; } if (DropDownList1.SelectedItem.Text == { TextBox11.Text = "BCA_58"; TextBox12.Text = "IT"; } if (DropDownList1.SelectedItem.Text == { TextBox11.Text = "BBA_59"; TextBox12.Text = "managment"; } if (DropDownList1.SelectedItem.Text == { TextBox11.Text = "BHM_60"; TextBox12.Text = "managment"; } if (DropDownList1.SelectedItem.Text == { TextBox11.Text = "PGDM_61"; TextBox12.Text = "IT/managment"; } if (DropDownList1.SelectedItem.Text == { TextBox11.Text = "BOPTM_73"; TextBox12.Text = "btec/managment"; } if (DropDownList1.SelectedItem.Text == { TextBox11.Text = "BTTM_62"; TextBox12.Text = "managment"; } if (DropDownList1.SelectedItem.Text == { TextBox11.Text = "BSHM_63"; TextBox12.Text = "managment"; } if (DropDownList1.SelectedItem.Text == { TextBox11.Text = "BMS_64"; TextBox12.Text = "IT"; } if (DropDownList1.SelectedItem.Text == { TextBox11.Text = "BSCM_65"; TextBox12.Text = "managment"; } if (DropDownList1.SelectedItem.Text == { TextBox11.Text = "BIRM_66";

"MBA")

"BCA")

"BBA")

"BHM")

"PGDM")

"BOPTM")

"BTTM")

"BSHM")

"BMS")

"BSCM")

"BIRM")



TextBox12.Text = "managment"; } if (DropDownList1.SelectedItem.Text { TextBox11.Text = "HM_67"; TextBox12.Text = "managment"; } if (DropDownList1.SelectedItem.Text { TextBox11.Text = "CSE_68"; TextBox12.Text = "IT"; } if (DropDownList1.SelectedItem.Text { TextBox11.Text = "IT_69"; TextBox12.Text = "IT/btec"; } if (DropDownList1.SelectedItem.Text { TextBox11.Text = "EC_70"; TextBox12.Text = "btec"; } if (DropDownList1.SelectedItem.Text { TextBox11.Text = "EEE_71"; TextBox12.Text = "btec"; } if (DropDownList1.SelectedItem.Text { TextBox11.Text = "AERO_72"; TextBox12.Text = "btec"; } }

== "hotel managment")

== "Btec-CSE")

== "Btec-IT")

== "Btec-EC")

== "Btec-EEE")

== "Btec-Aerospace")

protected void Button2_Click(object sender, EventArgs e) { TextBox1.Text = ""; TextBox2.Text = ""; TextBox3.Text = ""; TextBox4.Text = ""; TextBox5.Text = ""; TextBox6.Text = ""; TextBox7.Text = ""; TextBox8.Text = ""; TextBox9.Text = ""; TextBox10.Text = ""; TextBox11.Text = ""; TextBox12.Text = ""; } protected void Button1_Click(object sender, EventArgs e) { conn.Open();


SqlCommand cmd=new SqlCommand("insert into stu_reg values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "','" + TextBox5.Text + "','" + DropDownList3.Text+ "','" + TextBox6.Text + "','" + TextBox7.Text + "','" + TextBox8.Text + "','" + TextBox9.Text + "','" + TextBox10.Text + "','" + DropDownList2.Text+ "','" + DropDownList3.Text+ "','" + TextBox11.Text + "','" + TextBox12.Text + "')",conn); cmd.ExecuteNonQuery(); conn.Close(); Label1.Text="Registration Successfuly"; TextBox1.Text = ""; TextBox2.Text = ""; TextBox3.Text = ""; TextBox4.Text = ""; TextBox5.Text = ""; TextBox6.Text = ""; TextBox7.Text = ""; TextBox8.Text = ""; TextBox9.Text = ""; TextBox10.Text = ""; TextBox11.Text = ""; TextBox12.Text = ""; } }

/*****************Faculty/Employee Registration******************/
using using using using using using using using using using using using using System; System.Collections; System.Configuration; System.Data; System.Linq; System.Web; System.Web.Security; System.Web.UI; System.Web.UI.HtmlControls; System.Web.UI.WebControls; System.Web.UI.WebControls.WebParts; System.Xml.Linq; System.Data.SqlClient;

namespace CIS { public partial class empreg : System.Web.UI.Page { SqlConnection conn=new SqlConnection(@"Data Source=.\SQLEXPRESS;Initial Catalog=cis;Integrated Security=True"); protected void Page_Load(object sender, EventArgs e) {



} protected void Button1_Click(object sender, EventArgs e) { conn.Open(); SqlCommand cmd = new SqlCommand("insert into emp_reg values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "','" + TextBox5.Text + "','" + DropDownList2.Text + "','" + TextBox6.Text + "','" + TextBox7.Text + "','" + TextBox8.Text + "','" + TextBox9.Text + "','" + TextBox10.Text + "','" + TextBox11.Text + "','" + DropDownList1.Text + "')", conn); cmd.ExecuteNonQuery(); conn.Close(); Label1.Text = "Registration Successfuly complet"; TextBox1.Text = ""; TextBox2.Text = ""; TextBox3.Text = ""; TextBox4.Text = ""; TextBox5.Text = ""; TextBox6.Text = ""; TextBox7.Text = ""; TextBox8.Text = ""; TextBox9.Text = ""; TextBox10.Text = ""; TextBox11.Text = "";

} } }

/**************************Employee/Faculty Profile*************************/
using using using using using using using using using using using using using System; System.Collections; System.Configuration; System.Data; System.Linq; System.Web; System.Web.Security; System.Web.UI; System.Web.UI.HtmlControls; System.Web.UI.WebControls; System.Web.UI.WebControls.WebParts; System.Xml.Linq; System.Data.SqlClient;

namespace CIS {


public partial class emp_profile : System.Web.UI.Page { SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;Initial Catalog=cis;Integrated Security=True"); protected void Page_Load(object sender, EventArgs e) { conn.Open(); SqlDataAdapter da = new SqlDataAdapter("select eid,name,age,gender,address,phone,email,designation,salary,joining,depertment from emp_reg", conn); DataSet ds = new DataSet(); da.Fill(ds); GridView1.DataSource = ds; GridView1.DataBind(); conn.Close(); } } }

/*******************Student Profile*****************/

using using using using using using using using using using using using using

System; System.Collections; System.Configuration; System.Data; System.Linq; System.Web; System.Web.Security; System.Web.UI; System.Web.UI.HtmlControls; System.Web.UI.WebControls; System.Web.UI.WebControls.WebParts; System.Xml.Linq; System.Data.SqlClient;

namespace CIS { public partial class stuprofile : System.Web.UI.Page { SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;Initial Catalog=cis;Integrated Security=True;Pooling=False"); protected void Page_Load(object sender, EventArgs e) { conn.Open(); SqlDataAdapter da = new SqlDataAdapter("select sid,name,fname,gender,age,dob,bloodgrp,address,phone,session,cname,cid,dept from stu_reg", conn); DataSet ds = new DataSet(); da.Fill(ds); GridView1.DataSource = ds;



GridView1.DataBind(); conn.Close(); } } }

/******************Courses****************/
using using using using using using using using using using using using using System; System.Collections; System.Configuration; System.Data; System.Linq; System.Web; System.Web.Security; System.Web.UI; System.Web.UI.HtmlControls; System.Web.UI.WebControls; System.Web.UI.WebControls.WebParts; System.Xml.Linq; System.Data.SqlClient;

namespace CIS { public partial class cource : System.Web.UI.Page { SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;Initial Catalog=cis;Integrated Security=True;Pooling=False"); protected void Page_Load(object sender, EventArgs e) { conn.Open(); SqlDataAdapter da = new SqlDataAdapter("select * from course", conn); DataSet ds = new DataSet(); da.Fill(ds); if (!this.IsPostBack) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { DropDownList1.Items.Add(Convert.ToString(ds.Tables[0].Rows[i]["cname"])); } } conn.Close(); } protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { conn.Open(); SqlDataAdapter da = new SqlDataAdapter("select * from course where cname='" + DropDownList1.SelectedValue + "'", conn);



DataSet ds = new DataSet(); da.Fill(ds); GridView1.DataSource = ds; GridView1.DataBind(); conn.Close(); } protected void Button1_Click(object sender, EventArgs e) { conn.Open(); SqlDataAdapter da = new SqlDataAdapter("select * from course", conn); DataSet ds = new DataSet(); da.Fill(ds); GridView1.DataSource = ds; GridView1.DataBind(); conn.Close(); } } }

/********************Suggestion Box******************/
using using using using using using using using using using using using using System; System.Collections; System.Configuration; System.Data; System.Linq; System.Web; System.Web.Security; System.Web.UI; System.Web.UI.HtmlControls; System.Web.UI.WebControls; System.Web.UI.WebControls.WebParts; System.Xml.Linq; System.Data.SqlClient;

namespace CIS { public partial class suggbox : System.Web.UI.Page { SqlConnection conn=new SqlConnection(@"Data Source=.\SQLEXPRESS;Initial Catalog=cis;Integrated Security=True"); protected void Page_Load(object sender, EventArgs e) { } protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { conn.Open();



SqlCommand cmd = new SqlCommand("insert into suggbox values('" + TextBox1.Text + "')", conn); cmd.ExecuteNonQuery(); conn.Close(); TextBox1.Text = ""; Label1.Text="your suggession have been posted"; } } }

/******************Resume*******************/
using using using using using using using using using using using using using using System; System.Collections; System.Configuration; System.Data; System.Linq; System.Web; System.Web.Security; System.Web.UI; System.Web.UI.HtmlControls; System.Web.UI.WebControls; System.Web.UI.WebControls.WebParts; System.Xml.Linq; System.Data.SqlClient; System.IO;

namespace CIS { public partial class resume : System.Web.UI.Page { SqlConnection conn=new SqlConnection(@"Data Source=.\SQLEXPRESS;Initial Catalog=cis;Integrated Security=True"); protected void Page_Load(object sender, EventArgs e) { } protected void Button1_Click(object sender, EventArgs e) { conn.Open(); SqlCommand cmd = new SqlCommand("insert into onlinejob values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + DropDownList1.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "')", conn); cmd.ExecuteNonQuery(); conn.Close(); Label2.Text="your details posted sucessfuly/We will contact soon"; if (FileUpload1.PostedFile.FileName == "") {



Label1.Text="Please Select a file"; } else { string file = Path.GetFileName(FileUpload1.PostedFile.FileName); FileUpload1.SaveAs("C:\\Documents and Settings\\test\\My Documents\\Visual Studio 2008\\Projects\\CIS\\CIS\\Uploded resume\\" + file); Label1.Text="File upload successfully"; } TextBox1.Text TextBox2.Text TextBox3.Text TextBox4.Text } protected void Button2_Click(object sender, EventArgs e) { TextBox1.Text = ""; TextBox2.Text = ""; TextBox3.Text = ""; TextBox4.Text = ""; } } } = = = = ""; ""; ""; "";

/*****************Student Forum***************/
using using using using using using using using using using using using using System; System.Collections; System.Configuration; System.Data; System.Linq; System.Web; System.Web.Security; System.Web.UI; System.Web.UI.HtmlControls; System.Web.UI.WebControls; System.Web.UI.WebControls.WebParts; System.Xml.Linq; System.Data.SqlClient;

namespace CIS { public partial class stuforam : System.Web.UI.Page { SqlConnection conn=new SqlConnection(@"Data Source=.\SQLEXPRESS;Initial Catalog=cis;Integrated Security=True;Pooling=False"); protected void Page_Load(object sender, EventArgs e) { conn.Open();



SqlDataAdapter da = new SqlDataAdapter("select * from stu_forum", conn); DataSet ds = new DataSet(); da.Fill(ds); GridView1.DataSource = ds; GridView1.DataBind(); conn.Close(); } protected void Button1_Click(object sender, EventArgs e) { conn.Open(); SqlCommand cmd = new SqlCommand("insert into stu_forum values('" + TextBox1.Text + "','"+TextBox2.Text+"','"+TextBox3.Text+"')", conn); cmd.ExecuteNonQuery(); SqlDataAdapter da = new SqlDataAdapter("select * from stu_forum", conn); DataSet ds = new DataSet(); da.Fill(ds); GridView1.DataSource = ds; GridView1.DataBind(); conn.Close(); TextBox1.Text = ""; TextBox2.Text = ""; TextBox3.Text = ""; } protected void Button2_Click(object sender, EventArgs e) { TextBox1.Text = ""; TextBox2.Text = ""; TextBox3.Text = ""; } } }



TESTING
The testing phase involves the testing of the developed system using various kinds of data. An elaborated testing of data is prepared and a system is tested using the test data. While testing, errors are noted and corrections remade, the corrections are also noted for future use. SYSTEM TESTING Testing is a set of activities that can be planned in advance and conducted systematically. The proposed system is tested in parallel with the software that consists of its own phases of analysis, implementation, testing and maintenance. Following are the tests conducted on the system. UNIT TESTING During the implementation of the system each module of the system was tested separately to uncover errors within its boundaries. User interface was used as a guide in the process. MODULE TESTING A module is composed of various programs related to that module. Module testing is done to check the module functionality and interaction between units within a module. It checks the functionality of each program with relation to other programs within the same module. It then tests the overall functionality of each module.



INTEGRATION TESTING Integration testing is a systematic technique for constructing the program structure while conducting tests to uncover errors associated with interfacing. The objective is to take unit-tested module and build a program structure that has been dictated by design. ACCEPTANCE TESTING The software has been tested with the realistic data given by the client and produced fruitful results. The client satisfying all the requirements specified by them has also developed the software within the time limitation specified. A demonstration has been given to the client and the end-user giving all the operational features. IMPLEMENTATION PHASE The implementation is the final and important phase. It involves User training, system testing and successful running of the developed system. The users test the developed system when changes are made according to the needs. The testing phase involves the testing of the developed system using various kinds of data. An elaborate testing of data is prepared and system is tested using the tests data. Implementation is the stage where theoretical design turned into a working system. Implementation is planed carefully to propose system to avoid unanticipated problems. Many preparations involved before and during the implementation of proposed system. The system needed to be plugged in to the organization’s network then it could be accessed from anywhere, after a user logins into the portal. The tasks that had to be done to implement the system were to create the database tables in the organization database domain. Then the administrator was granted his role so that the system could be accessed. The next phase in the implementation was to educate the system. A demonstration of all the functions that can be carried out by the system was given to examination department person, who will make extensive use of the system.


MAINTENANCE
Maintenance is the enigma of system development. It holds the Software Industry captive, typing up programming resources. Maintenance seems to account for 60% of all effort put into software. Organizations which are maintenance-bound often found it difficult to avoid building a backlog application that may ultimately paralyze the company.

Why the software should be maintained?
Most software has a longer operational life. Many software systems were built under different technological constraints than hold now. Most software systems have had to migrate to new hardware & software environments.

What could be implemented?
Most of the requirements as specified in the problem details were successfully implemented.

What could not be implemented? Provide a more secure system by encrypting the user-id, password while saving in the database. Though email address format checking is done Email address Existence-checking is not done. Inviting people who is not part of the system is not done.


FUTURE SCOPE
The ONLINE COLLEGE INFORMATION SYSTEM has tremendous potential for the future enhancement & growth. Many more excellent features can be added to the system by the use of new technologies & hereby providing the user a lot of new facilities. The scope of the project and implimentation in future would be discussed on the basis of two aspects. Addition of new features:Some of the features that is acceptable here: Connecting to other ‘Online college’ systems. Provide more security by encrypting the user & password.



CONCLUSION
The System is supposed to posses the following features:
Very user-friendly. Fully GUI based. Runs efficiently on a cheap hardware and software platform. Increase accuracy and dependability of the system. Increase speed of processing / operation of the system. In short, we can conclude that the software is very much user friendly and would be easy to use for anybody with a meagre computer knowledge.



BIBLIOGRAPHY
We consulted the following site for our project and implimentation work: google.com javascriptkid.com syngresssolutions hungryminds.com wrox.com

The books from where we got help are as follows: “Professional ASP.NET 2.0 “by Bill Evjen Scott Hanselman Farhan
Muhammad Srinivasa Sivakumar Devin Rader
“ASP.NET Database Programming” Hungry Minds, Inc. Publishing Company Limited. By Jason Butler and Tony Caudill




Reply
seminar ideas
Super Moderator
******

Posts: 10,003
Joined: Apr 2012
#3
05-05-2012, 10:13 AM



to get information about the topic "filetype ppt college information system" full report ppt and related topics refer the link bellow

topicideashow-to-development-of-college-information-system

topicideashow-to-college-information-system-ppt

topicideashow-to-ivr-application-for-college-information-system?pid=83678#pid83678
Reply

Important Note..!

If you are not satisfied with above reply ,..Please

ASK HERE

So that we will collect data for you and will made reply to the request....OR try below "QUICK REPLY" box to add a reply to this page

Quick Reply
Message
Type your reply to this message here.


Image Verification
Please enter the text contained within the image into the text box below it. This process is used to prevent automated spam bots.
Image Verification
(case insensitive)

Possibly Related Threads...
Thread Author Replies Views Last Post
  Development of an Online Course Portal for a campus seminar topics 5 6,164 31-10-2016, 02:29 PM
Last Post: jaseela123
  Developing a web application to transfer image and patient information project report maker 2 4,977 17-03-2014, 03:03 PM
Last Post: MichaelKa
  Detecting Anomalous Insiders in Collaborative Information Systems project girl 1 793 11-11-2013, 10:22 PM
Last Post: Guest
  online college admission system project and implimentation in asp net with code project girl 7 5,656 15-10-2013, 07:23 PM
Last Post: Guest
  Information Theoretic Framework of Trust Modeling and Evaluation for Ad Hoc Networks seminar projects maker 0 356 26-09-2013, 02:08 PM
Last Post: seminar projects maker
  STUDENT INFORMATION SYSTEM IN JAVA project topics 22 14,430 23-09-2013, 09:07 PM
Last Post: Guest
  CAMPUS SMS INFORMATION SYSTEM pdf seminar projects maker 0 507 20-09-2013, 01:24 PM
Last Post: seminar projects maker
  Development Of A Repository And Search Engine For Alumni Of College seminar surveyer 8 5,644 19-09-2013, 09:47 AM
Last Post: seminar projects maker
  Dental Biometrics: Human Identification Based On Dental Work Information pdf seminar projects maker 0 380 13-09-2013, 04:28 PM
Last Post: seminar projects maker
  Development of a Novel Voice Verification System using Wavelets pdf seminar projects maker 0 398 12-09-2013, 01:15 PM
Last Post: seminar projects maker