370 likes | 507 Views
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.
E N D
TEAM Members • PUSHPA LATHA.U • K.S.CHAKRAVARTHY • VISHNU PRIYA.E • P.SUNIL KUMAR
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
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 .
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.
Limitations of EXISTING SYSTEM • NEWSPAPER • The system is not an online system. • RESULTS ON WEBSITES • COLLEGE VISIT • CALL TO INSTITUTE
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.
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.
Types of FEASIBILITY • Economical Feasibility • Operational Feasibility • Technical Feasibility
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.
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.
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.
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
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).
Hardware Requirements • Processor : Pentium III Processor • Hard Disk : 40GB • RAM : 256MB • Processor clock speed : 700 MHz Clock Speed
MODULES • Student register entry form • Student mark entry form • Student attendance details • View register details • View mark details
A data-flow diagram (DFD) is a graphical representation of the "flow" of data through an information system. DFD’s can also be used for the visualization of data processing (structured design). Context Diagram STUDENT MARKS SMIS ADMIN STUDENT ATTENDANCE
STUDENT REGISTER Parent STUDENT MARKS ENTRY Admin COLLEGE STUDENT ATTENDANCE DATABASE Final System Diagram
User Enquriy of marks College Accepting the request Admin Sending the sms USECASE Diagram
User If regdno is valid Receive sms from user exit Send reply ACTIVITY Diagram
admin id : number name : string receivesms() sendsms() update() modify() attendence User no.workingdays : number name : string college marks no.presentdays : number id : number no.absentdays : number name : string sno : varchar2 address : string id : address total : number update() address : string receiveSms() delete() total() edit() modify() sendsms() create() delete() insert() CLASS Diagram
:user :admin :college enquiry of marks through sms(sending sms) give stud details get the marks get the marks SEQUENCE DIAGRAM Collaboration Diagram
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 :
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 { ------------ ------------ ------------ }
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.
SMS FORM CODING if (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);
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; }
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);
EXECUTION STUDENT MARKS STUDENT ATTENDENCE
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 .
FUTURE ENHANCEMENTS • By providing additional functionality like student-staff interaction. • We can enhance it by making the same project to work on Internet.