sms based s tudent m arks i nformation s ystem
DESCRIPTION
SMS Based S tudent M arks I nformation S ystem. TEAM Members. PUSHPA LATHA.U K.S.CHAKRAVARTHY VISHNU PRIYA.E P.SUNIL KUMAR. INTRODUCTION. - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: SMS Based S tudent M arks I nformation S ystem](https://reader034.vdocuments.us/reader034/viewer/2022051401/56814a8e550346895db79c62/html5/thumbnails/1.jpg)
SMS Based Student Marks
Information System
![Page 2: SMS Based S tudent M arks I nformation S ystem](https://reader034.vdocuments.us/reader034/viewer/2022051401/56814a8e550346895db79c62/html5/thumbnails/2.jpg)
TEAM Members
• PUSHPA LATHA.U• K.S.CHAKRAVARTHY• VISHNU PRIYA.E• P.SUNIL KUMAR
![Page 3: SMS Based S tudent M arks I nformation S ystem](https://reader034.vdocuments.us/reader034/viewer/2022051401/56814a8e550346895db79c62/html5/thumbnails/3.jpg)
INTRODUCTION
Student Marks Information System (SMIS) is a application software
designed to introduce a conductive and structured information exchange
environment for integrating students, parents, teachers and the
administration of a school or college.
These software systems enable educational institutions to supervise student-
related activities such as
keeping records of tests or examinations conducted,
attendance,
details of marks scored,
particulars of everyday school attendance
![Page 4: SMS Based S tudent M arks I nformation S ystem](https://reader034.vdocuments.us/reader034/viewer/2022051401/56814a8e550346895db79c62/html5/thumbnails/4.jpg)
SCOPE
Student’s complete marks and attendance details are entered in
this system by the administrator. The student registration should
contain the information (like semester marks, attendance details
etc). This is saved in the database. SMIS can be useful in many
areas like
Universities, colleges, institutions.
Private and government sector industries .
![Page 5: SMS Based S tudent M arks I nformation S ystem](https://reader034.vdocuments.us/reader034/viewer/2022051401/56814a8e550346895db79c62/html5/thumbnails/5.jpg)
EXISTING SYSTEM
Existing system includes paper works made by human so the time
taken to maintain all these details are very long and also tedious to
implement.
There are more number of ways are there to know a students mark in
the modern world.
Few of them are getting a newspaper result, website related
marks/results and going to the college directly or making a phone
call to the institute.
![Page 6: SMS Based S tudent M arks I nformation S ystem](https://reader034.vdocuments.us/reader034/viewer/2022051401/56814a8e550346895db79c62/html5/thumbnails/6.jpg)
Limitations of EXISTING SYSTEM
NEWSPAPER
The system is not an online system.
RESULTS ON WEBSITES
COLLEGE VISIT
CALL TO INSTITUTE
![Page 7: SMS Based S tudent M arks I nformation S ystem](https://reader034.vdocuments.us/reader034/viewer/2022051401/56814a8e550346895db79c62/html5/thumbnails/7.jpg)
PROPOSED SYSTEM
The proposed system is based on mobile phone.(This project is
supported by a range of Nokia phones start from 5110 to latest
models.)
Here you have to type your exam register number and then send
short message service (SMS) to the institute number, that
institute number must be connected to a system through a data
cable.
![Page 8: SMS Based S tudent M arks I nformation S ystem](https://reader034.vdocuments.us/reader034/viewer/2022051401/56814a8e550346895db79c62/html5/thumbnails/8.jpg)
ADVANTAGES OF THE PROPOSED SYSTEM
No mistakes are done regarding students marks and attendance details
Availability of information from a single source
Without any time delay the student’s marks and attendance details are send through the SMS to the mobile.
Monitoring student-related activities.
The proposed system overcomes the drawbacks (like college visit or calling the institute person to know their results) of the existing system.
![Page 9: SMS Based S tudent M arks I nformation S ystem](https://reader034.vdocuments.us/reader034/viewer/2022051401/56814a8e550346895db79c62/html5/thumbnails/9.jpg)
FEASIBILITY STUDY
![Page 10: SMS Based S tudent M arks I nformation S ystem](https://reader034.vdocuments.us/reader034/viewer/2022051401/56814a8e550346895db79c62/html5/thumbnails/10.jpg)
Types of FEASIBILITY
1. Economical Feasibility
2. Operational Feasibility
3. Technical Feasibility
![Page 11: SMS Based S tudent M arks I nformation S ystem](https://reader034.vdocuments.us/reader034/viewer/2022051401/56814a8e550346895db79c62/html5/thumbnails/11.jpg)
ECONOMICAL FEASIBILITY
Economic Feasibility means the cost of understanding project
and it should less cost than the existing system.
Economic analysis is the most frequently used method for
evaluating the effectiveness of a new system.
More commonly known as cost/benefit analysis, the procedure
is to determine the benefits and savings that are expected from a
candidate system and compare them with costs.
![Page 12: SMS Based S tudent M arks I nformation S ystem](https://reader034.vdocuments.us/reader034/viewer/2022051401/56814a8e550346895db79c62/html5/thumbnails/12.jpg)
If benefits outweigh costs, then the decision is made to design
and implement the system. An entrepreneur must accurately
weigh the cost versus benefits before taking an action.
Cost Based Study: It is of 2 types
1. Development costs
2. Operating costs.
Time Based Study:
This is an analysis of the time required to achieve a
return on investments.
![Page 13: SMS Based S tudent M arks I nformation S ystem](https://reader034.vdocuments.us/reader034/viewer/2022051401/56814a8e550346895db79c62/html5/thumbnails/13.jpg)
OPERATIONAL FEASIBILITY
Operational feasibility is a measure of how well a proposed system solves the problems.
Operational Feasibility means users should support the project.
It identified opportunities during scope definition and how it satisfies the requirements identified in the requirements analysis phase of system development.
![Page 14: SMS Based S tudent M arks I nformation S ystem](https://reader034.vdocuments.us/reader034/viewer/2022051401/56814a8e550346895db79c62/html5/thumbnails/14.jpg)
TECHNICAL FEASIBILITY
Project feasibility focuses on project management and overall
coordination. When evaluating proposals, the following project
feasibility items should be considered and evaluated.
System Performance
System Interfaces
Development Processes
Risk Assessment
Security
Failure Immunity
![Page 15: SMS Based S tudent M arks I nformation S ystem](https://reader034.vdocuments.us/reader034/viewer/2022051401/56814a8e550346895db79c62/html5/thumbnails/15.jpg)
Software Requirements Operating System : Windows XP/2003 or
Linux/Solaris
Programming Language : .NET
User Interface : HTML
Web Browser : Internet Explorer 4.0
IDE/Workbench : Visual Studio 3.5
Database : Microsoft Access
Toolkit : MMIT (Microsoft
Mobile Internet Toolkit).
![Page 16: SMS Based S tudent M arks I nformation S ystem](https://reader034.vdocuments.us/reader034/viewer/2022051401/56814a8e550346895db79c62/html5/thumbnails/16.jpg)
Hardware Requirements
Processor : Pentium III Processor
Hard Disk : 40GB
RAM : 256MB
Processor clock speed : 700 MHz Clock Speed
![Page 17: SMS Based S tudent M arks I nformation S ystem](https://reader034.vdocuments.us/reader034/viewer/2022051401/56814a8e550346895db79c62/html5/thumbnails/17.jpg)
SYSTEM DESIGN
![Page 18: SMS Based S tudent M arks I nformation S ystem](https://reader034.vdocuments.us/reader034/viewer/2022051401/56814a8e550346895db79c62/html5/thumbnails/18.jpg)
MODULES
Student register entry form
Student mark entry form
Student attendance details
View register details
View mark details
![Page 19: SMS Based S tudent M arks I nformation S ystem](https://reader034.vdocuments.us/reader034/viewer/2022051401/56814a8e550346895db79c62/html5/thumbnails/19.jpg)
DATA FLOW DIAGRAMS
![Page 20: SMS Based S tudent M arks I nformation S ystem](https://reader034.vdocuments.us/reader034/viewer/2022051401/56814a8e550346895db79c62/html5/thumbnails/20.jpg)
ADMIN SMIS
STUDENT MARKS
STUDENT ATTENDANCE
![Page 21: SMS Based S tudent M arks I nformation S ystem](https://reader034.vdocuments.us/reader034/viewer/2022051401/56814a8e550346895db79c62/html5/thumbnails/21.jpg)
COLLEGEAdmin STUDENT
MARKS ENTRY
STUDENTATTENDANCE
STUDENT REGISTER
DATABASE
Parent
Final System Diagram
![Page 22: SMS Based S tudent M arks I nformation S ystem](https://reader034.vdocuments.us/reader034/viewer/2022051401/56814a8e550346895db79c62/html5/thumbnails/22.jpg)
UML Diagrams
![Page 23: SMS Based S tudent M arks I nformation S ystem](https://reader034.vdocuments.us/reader034/viewer/2022051401/56814a8e550346895db79c62/html5/thumbnails/23.jpg)
USECASE Diagram
UserEnquriy of marks
CollegeAccepting the request
Admin Sending the sms
![Page 24: SMS Based S tudent M arks I nformation S ystem](https://reader034.vdocuments.us/reader034/viewer/2022051401/56814a8e550346895db79c62/html5/thumbnails/24.jpg)
ACTIVITY Diagram
User
If regdno is valid
Receive sms from user
Send reply
exit
![Page 25: SMS Based S tudent M arks I nformation S ystem](https://reader034.vdocuments.us/reader034/viewer/2022051401/56814a8e550346895db79c62/html5/thumbnails/25.jpg)
CLASS Diagram
User
name : string
id : number
address : string
receiveSms()
edit()
delete()
college
name : string
id : address
address : string
sendsms()
marks
sno : varchar2
total : number
total()
create()
admin
id : number
name : string
receivesms()
sendsms()
update()
modify()
attendence
no.workingdays : number
no.presentdays : number
no.absentdays : number
update()
delete()
modify()
insert()
![Page 26: SMS Based S tudent M arks I nformation S ystem](https://reader034.vdocuments.us/reader034/viewer/2022051401/56814a8e550346895db79c62/html5/thumbnails/26.jpg)
SEQUENCE DIAGRAM :user :admin :college
enquiry of marks through sms(sending sms)
give stud details
get the marks
get the marks
:user :admin
:college
1: enquiry of marks through sms(sending sms)
4: get the marks
2: give stud details
3: get the marks
Collaboration Diagram
![Page 27: SMS Based S tudent M arks I nformation S ystem](https://reader034.vdocuments.us/reader034/viewer/2022051401/56814a8e550346895db79c62/html5/thumbnails/27.jpg)
TECHNOLOGIES
.NET : NET is a collection of tools, technologies, and languages that all work together in a framework to provide the solutions.
Common Language Runtime :
Assemblies :
![Page 28: SMS Based S tudent M arks I nformation S ystem](https://reader034.vdocuments.us/reader034/viewer/2022051401/56814a8e550346895db79c62/html5/thumbnails/28.jpg)
.NET FRAMEWORK
![Page 29: SMS Based S tudent M arks I nformation S ystem](https://reader034.vdocuments.us/reader034/viewer/2022051401/56814a8e550346895db79c62/html5/thumbnails/29.jpg)
NAMESPACE• System.IO• System.Collections• System.Windows.Forms• System.Web.UI• System.Threading• System.Mobile.UI• System.Data.OleDb• System.Data.Oracle• System.Data.SqlClient• System.Data.ODBC
NOTE : Here “Using” Keyword is used.
Ex: Using System.Collections Using System.Web.UI Class Finance { ------------ ------------ ------------ }
![Page 30: SMS Based S tudent M arks I nformation S ystem](https://reader034.vdocuments.us/reader034/viewer/2022051401/56814a8e550346895db79c62/html5/thumbnails/30.jpg)
SMS GATEWAY:
• An SMS gateway is a Web site that allow users to send SMS messages from a Web browser to people within the cell served by that gateway.
• An SMS gateway can also serve as an international gateway for users with roaming capability.
Microsoft Mobile Internet Toolkit (MMIT):• MMIT or .NET mobile extends the functionality of .NET
framework and enables to develop mobile applications for mobile devices like cell phones and PDA’s.– web based applications – local applications.
![Page 31: SMS Based S tudent M arks I nformation S ystem](https://reader034.vdocuments.us/reader034/viewer/2022051401/56814a8e550346895db79c62/html5/thumbnails/31.jpg)
CODINGif (DropDownList1.SelectedItem.Text ==
"ATTENDANCE") { OleDbConnection cn = new
OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/httpdocs/App_Data/NCEW.mdb;Persist Security Info=True");
string query = "select * from STUDENT_ATTENDANCE where REGISTRATIONNO='" + TextBox1.Text + "'";
OleDbDataAdapter da = new OleDbDataAdapter(query, cn);
DataSet ds = new DataSet(); da.Fill(ds);
SMS FORM
![Page 32: SMS Based S tudent M arks I nformation S ystem](https://reader034.vdocuments.us/reader034/viewer/2022051401/56814a8e550346895db79c62/html5/thumbnails/32.jpg)
if (ds.Tables.Count != 0) { try { DataRow dr =
ds.Tables[0].Rows[0]; Label2.Text = "By " +
dr["DATE"].ToString() + " for " + dr["WORKINGDAYS"].ToString() + " working days, leaves are " + dr["LEAVES"].ToString();
return; }
![Page 33: SMS Based S tudent M arks I nformation S ystem](https://reader034.vdocuments.us/reader034/viewer/2022051401/56814a8e550346895db79c62/html5/thumbnails/33.jpg)
SEARCH STUDENT
protected void Button1_Click(object sender, EventArgs e) {String cstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("~/App_Data/NCEW.mdb") + ";Persist Security Info=True";System.Data.OleDb.OleDbConnection con = new ystem.Data.OleDb.OleDbConnection(cstr);
string qry = "SELECT REGISTRATIONNO, ADMISSIONNO, STUDENTNAME, DATEOFBIRTH, FATHERNAME, ADDRESS, CONTACTNO, EMAILID, COLLEGENAME, BRANCHNAME FROM STUDENT WHERE (REGISTRATIONNO = '" + TextBox1.Text + "')";
OleDbDataAdapter da = new OleDbDataAdapter(qry, con); DataSet ds = new DataSet(); da.Fill(ds);
![Page 34: SMS Based S tudent M arks I nformation S ystem](https://reader034.vdocuments.us/reader034/viewer/2022051401/56814a8e550346895db79c62/html5/thumbnails/34.jpg)
![Page 35: SMS Based S tudent M arks I nformation S ystem](https://reader034.vdocuments.us/reader034/viewer/2022051401/56814a8e550346895db79c62/html5/thumbnails/35.jpg)
EXECUTION
STUDENT MARKS
STUDENT ATTENDENCE
![Page 36: SMS Based S tudent M arks I nformation S ystem](https://reader034.vdocuments.us/reader034/viewer/2022051401/56814a8e550346895db79c62/html5/thumbnails/36.jpg)
CONCLUSION
• This system as explained in the entire presentation has the most reliable database as on now and user-friendly interfaces with useful tool tips provided for the convenience of the user whenever they are required .
![Page 37: SMS Based S tudent M arks I nformation S ystem](https://reader034.vdocuments.us/reader034/viewer/2022051401/56814a8e550346895db79c62/html5/thumbnails/37.jpg)
FUTURE ENHANCEMENTS
• By providing additional functionality like student-staff interaction.
• We can enhance it by making the same project to work on Internet.