By using this project we can reduce the manual work of the Class Advisor. INTRODUCTION INTRODUCTION 1. 1 ABOUT THE ORGANIZATION: K. S. Rangasamy College of Arts and Science, Tiruchengode, was started in the year 1995 by the K. S. R Educational and Charitable Trust. Lion. Dr. K. S. Rangasamy MJF, is the President of the Trust and the founding father of KSRCAS. Affiliation was granted to the college in 1995 by the University of Madras. Now the college is affiliated to the Periyar University, Salem.
The College has been recognized by the UGC u/s 2(f). The College has been awarded the prestigious ISO 9001-2000(E) certification by RMTUV. The University Grants Commission, New Delhi has conferred Autonomous status from the Academic year 2009-2010. The project “SMS BASED STUDENT INFORMATION SYSTEM” is a tool which is specially constructed for Department of Computer Science to maintain the full-fledged student profile and to communicate with parents through the communication source called “SMS”. 1. 2 PROJECT DESCRIPTION:
The core objective of “SMS BASED STUDENT INFORMATION SYSTEM “ is to develop an application to maintain student profile which provides a interface for the staff to communicate with parent regarding student attendance, unit test marks and also about extra-curricular and co-curricular activities which are organized by the college, in the form of regular updates via SMS. This project is used individual Class Advisors. He has all rights to enter and edit the name, register number of the students and so on. By using this project we can reduce the manual work of the Class Advisor.
The project “SMS BASED STUDENT INFORMATION SYSTEM “is designed for class advisor to maintain the student profile with the attendance and marks which can be intimated regularly to the parents through SMS. To build this project we have utilized the Microsoft Visual Studio. Net 2005 as front end, which works in . Net framework version 3. 5. The coding language used is Visual Basic . Net. The back end used is Microsoft Access 2007. * STUDENT PROFILE * ATTENDENCE MAINTENANCE * MARK MAINTENANCE * EMERGENCY SYSTEM ANALYSIS 2. SYSTEM ANALYSIS 2. 1 EXISTING SYSTEM
The existing system presently follows a tedious job maintaining the information. These are some of the exiting system’s scenarios * Existing system followed paper work for individual module. * Existing system uses manual composition of details. * Student profile is maintained as a separate source of information * Existing system performed transaction through Postal letters and through voice call. * Act of transaction found to be delivered without confirmation. By this existing system follow up leads to a great loss of human work and remains a time consuming one. . 1. 1 DRAWBACKS OF EXISTING SYSTEM The existing system has following disadvantages, * Followed Paper work * Interaction cost was not efficient * No ensured report is present regarding successful transaction * Lacuna in automation * Required huge resource for maintenance * Consumption of time in high rate and report generation was slow The existing system lacks in the accurate report generation quality where it needs a enhancement of using the application over the virtue of trimming the communication gap between the parents and the staff.
The existing system undergoes a huge usage of human work and the time consumption factor also remains a head-ache. To overcome this situation we a have proposed a system which will bring a beneficial environment comparing to the existing system. 2. 2 PROPOSED SYSTEM: The system we have proposed has a communication link over sending the information to the parents through SMS and also maintaining the student profile, mark management system and also the attendance of the students with the felicity of sending the message subsequently. The proposed system reduces the paper work and customizes the four different modules under a single roof of application. * Application automates the attendance maintenance and unit test marks maintenance and circular reports to parent. * Proposed system improves efficiency and presents effective reports. * Ensured transaction using SMS (Short Message Service). 2. 2. 1 ADVANTAGES OF PROPOSED SYSTEM The proposed system has following advantages, * Mark and Attendance records can be consolidated quickly. * Detailed reports can be taken immediately with less input. Absentee reports for each exam can be taken in time. * Helps to prepare continuous assessment report easily. * Parents are informed with attendance and mark details through SMS. * Provisions provided for updating the student profile such as mobile ph. , address… Proposed system follows the work of bringing all the classified information of the student under a single roof of the application. we have included the attendance and the mark analysis as a part of project were enable class advisor to generate automatic subject codes and the subject name as they require in the mark entry part.
The mark analysis to intimate the parents about regular exams those are conducted in regular intervals. The proposed system equips all the possibilities that a class advisor expects to a cardinal relationship with parents. 2. 3 SYSTEM REQUIREMENTS AND SPECIFICATIONS 2. 3. 1 HARDWARE REQUIREMENTS: Processor: Pentium IV 1. 7 GHz Hard Disk Capacity: 80 GB RAM: 1 GB SD Monitor: 15’’ Color Keyboard: 102 keys Mouse: 3 buttons 2. 3. 2 SOFTWARE SPECIFICATION Front-End : Microsoft Visual Studio 2008. Back-End: MS – ACCESS 2007. Operating System: Windows XP SP2
Mobile phone : any mobile having the USB connectivity option 2. 3. 3 ABOUT SOFTWARE 2. 3. 1 THE . NET FRAMEWORK The . NET Framework is a new computing platform that simplifies application development in the highly distributed environment of the Internet. 2. 3. 2 Objectives of . NET FRAMEWORK 1. To provide a consistent object-oriented programming environment whether object codes is stored and executed locally on Internet-distributed, or executed remotely. 2. To provide a code-execution environment to minimizes software deployment and guarantees safe execution of code. . Eliminates the performance problems. There are different types of application, such as Windows-based applications and Web-based applications. To make communication on distributed environment to ensure that code be accessed by the . NET Framework can integrate with any other code. 2. 3. 3 COMPONENTS OF . NET FRAMEWORK THE COMMON LANGUAGE RUNTIME (CLR) The common language runtime is the foundation of the . NET Framework. It manages code at execution time, providing important services such as memory management, thread management, remoting and also ensures more security and robustness.
The concept of code management is a fundamental principle of the runtime. Code that targets the runtime is known as managed code, while code that does not target the runtime is known as unmanaged code. THE . NET FRAME WORK CLASS LIBRARY It is a comprehensive, object-oriented collection of reusable types used to develop applications ranging from traditional command-line or Graphical User Interface (GUI) applications to applications based on the latest innovations provided by ASP. NET, such as Web Forms and XML Web services. The .
NET Framework can be hosted by unmanaged components that load the common language runtime into their processes and initiate the execution of managed code, thereby creating a software environment that can exploit both managed and unmanaged features. The . NET Framework not only provides several runtime hosts, but also supports the development of third-party runtime hosts. VISUAL STUDIO . NET Visual Studio . NET is a complete set of development tools for building ASP Web applications, XML Web services, desktop applications, and mobile applications.
In addition to building high-performing desktop applications, you can use Visual Studio’s Powerful component-based development tools and other technologies to simplify team-based design, development, and deployment of Enterprise solutions. VISUAL BASIC . NET Visual Basic. NET is also compliant with CLS (Common Language Specification) and supports structured exception handling. CLS is set of rules and constructs that are supported by the CLR (Common Language Runtime). CLR is the runtime environment provided by the . NET Framework; it manages the execution of the code and also makes the development process easier by providing services.
IMPLEMENTATION INHERITANCE Visual Basic. NET supports implementation inheritance. This means that, while creating applications in Visual Basic. NET, we can drive from another class, which is known as the base class that derived class inherits all the methods and properties of the base class. In the derived class, we can either use the existing code of the base class or override the existing code. Therefore, with help of the implementation inheritance, code can be reused. CONSTRUCTORS AND DESTRUCTORS Constructors are used to initialize objects, whereas destructors are used to destroy them.
In other words, destructors are used to release the resources allocated to the object. In Visual Basic. NET the sub finalize procedure is available. GARBAGE COLLECTION Garbage Collection is another new feature in Visual Basic. NET. The . NET Framework monitors allocated resources, such as objects and variables. In addition, the . NET Framework automatically releases memory for reuse by destroying objects that are no longer in use. OVERLOADING Overloading is another feature in Visual Basic. NET. Overloading enables us to define multiple procedures with the same name, where each procedure has a different set of arguments.
Besides using overloading for procedures, we can use it for constructors and properties in a class. STRUCTURED EXCEPTION HANDLING Visual Basic. NET supports structured handling, which enables us to detect and remove errors at runtime. In Visual Basic. NET, we need to use Try…Catch…Finally statements to create exception handlers. Using Try…Catch…Finally statements, we can create robust and effective exception handlers to improve the performance of our application. Features of Ms – access 2007 Users can create tables, queries, forms and reports, and connect them together with macros.
Advanced users can use VBA to write rich solutions with advanced data manipulation and user control. Access also has report creation features that can work with any data source that Access can “access”. The original concept of Access was for end users to be able to “access” data from any source. Other features include: the import and export of data to many formats including Excel, Outlook, ASCII, dBase, Paradox, FoxPro, SQL Server, Oracle, ODBC, etc. It also has the ability to link to data in its existing location and use it for viewing, querying, editing, and reporting.
This allows the existing data to change while ensuring that Access uses the latest data. It can perform heterogeneous joins between data sets stored across different platforms. Access is often used by people downloading data from enterprise level databases for manipulation, analysis, and reporting locally. There is also the Jet Database format (MDB or ACCDB in Access 2007) which can contain the application and data in one file. This makes it very convenient to distribute the entire application to another user, who can run it in disconnected environments.
One of the benefits of Access from a programmer’s perspective is its relative compatibility with SQL (structured query language) — queries can be viewed graphically or edited as SQL statements, and SQL statements can be used directly in Macros and VBA Modules to manipulate Access tables. Users can mix and use both VBA and “Macros” for programming forms and logic and offers object possibilities. VBA can also be included in queries. Microsoft Access offers parameterized queries. These queries and Access tables can be referenced from other programs like VB6 and . NET through DAO or ADO.
From Microsoft Access, VBA can reference parameterized stored procedures via ADO. The desktop editions of Microsoft SQL Server can be used with Access as an alternative to the Jet Database Engine. This support started with MSDE (Microsoft SQL Server Desktop Engine), a scaled down version of Microsoft SQL Server 2000, and continues with the SQL Server Express versions of SQL Server 2005 and 2008. Microsoft Access is a file server-based database. Unlike client–server relational database management systems (RDBMS), Microsoft Access does not implement database triggers, stored procedures, or transaction logging.
SYSTEM DESIGN AND DEVELOPEMENT 3. 1 . SYSTEM DESIGN System design is carried out with a eye towards facility and feasibility of system towards class advisor requirements. Here in the system the aspect of improving the physical view of system is also focused. As we have chosen the . net as platform we are able to provide a system which is platform independent and a efficient supportive system. In this project we focused on the automation for a possible extreme were it will increasing the efficiency of the system. In this project we have taken over crystal report concept for the mark analysis phase of the project.
System has covered a brief part of the project considering the project domain. The backend part incarnates the ms-access which allows to builds a easily accessible software in the part of backend access. The feasibility aspect allows build up a software partially fulfilling all the requirements of the class advisor. The system is designed considering the class advisor view and requirement those are specified in the requirement phase. The complete integrated system focusing on the overall build of the system with a result of efficient build and ensured stream of the activity.
The system dealing the system analytical behavior and functional aspects referring the quality factor is also considered. Thus the urge of building the system to improve the efficiency of the software is justified to extent. 3. 1 SYSTEM FLOW DIAGRAM 4. 2 SYSTEM FLOW DIAGRAM Total Hours Attendance Unit test I Unit Test II Model Department Class Name Reg. Number Date Reg. Number Mobile Number Address Class Department Student Name Emergency Mark maintenance Student Profile Attendance maintenance SMS BASED STUDENT INFORMATION SYSTEM SMS SMS SMS 2 DATA FLOW DIAGRAM 3. MODULE DESCRIPTION: The project “SMS BASED STUDENT INFORMATION SYSTEM “is designed for class advisor to maintain the student profile with the attendance and marks which can be intimated regularly to the parents through SMS. To build this project we have utilized the Microsoft Visual Studio. Net 2005 as front end, which works in . Net framework version 3. 5. The coding language used is Visual Basic . Net. The back end used is Microsoft Access 2007. The following are the main modules in the project. * STUDENT PROFILE * ATTENDENCE MAINTENANCE * MARK MAINTENANCE EMERGENCY STUDENT PROFILE: Student profile is our master page were fetch the basic information of a student like batch no, regno, department, mobile number, name, address . This student profile module remains a source of access in various forms where it can be used to easy retrieval of information. The information those are fetched in the student profile are saved accordingly in the Student master table. EMERGENCY: The emergency module holds the task of sending the urgent MS to the parent which can be circular, activities, fee pending information, etc,……..
Here we generate the student mobile number with respect to the student regno from the master page table. This allows gathering the basic information of the student. In the emergency module we have placed the important field MESSAGE. These two fields have to be filled up and the message field should have the characters less than 160. By following send button the message is sent. ATTENDANCE: We follow the system of maintaining the attendance of student for every hour as the log of attendance can be maintained. Here the hour by hour attendance of the student is sent to the parents through SMS.
MARK ANALYSIS The mark analysis module performs the task of maintaining the marks of the student in the accordingly in the database which can be used for future reference and also the marks can be sent to the parents through SMS. We are primarily focusing on the three phases of examination, they are * Unit Test I Entry * Unit Test II Entry * Model Examination Mark Entry Here the Unit test I, Unit test II, model examinations are conducted for every month. As if the results of this examination are not properly sent to the parents. The project SMS BASED STUDENT INFORMATION
SYSTEM allows these results send as SMS to the parents. This module is subjected to generate the subjects which will be varying for every semester. To that note we have designed a form “subject entry”. In this form class advisor has to update the subject name and subject code according to the respective semesters. By this the automatic generation of the subjects is possible when appropriate semester is selected. Thus the mark maintaining task is carried out successfully. MESSAGE SENDING: Message sending scenario follows the following term, they are as follows; AT commands are instructions used to control a modem.
AT is the abbreviation of ATtention. Every command line starts with “AT” or “at”. That’s why modem commands are called AT commands. There are two types of AT commands: 1. Basic commands are AT commands that do not start with a “+”. For example, D (Dial), A (Answer), H (Hook control), and O (Return to online data state) are the basic commands. 2. Extended commands are AT commands that start with a “+”. All GSM AT commands are extended commands. For example, +CMGS (Send SMS message), +CMGL (List SMS messages), and +CMGR (Read SMS messages) are extended commands. Operating Modes
The SMS specification has defined two modes in which a GSM/GPRS modem or mobile phone can operate. They are called SMS text mode and SMS PDU mode. (PDU stands for Protocol Data Unit. ) The mode that a GSM/GPRS modem or mobile phone is operating in determines the syntax of some SMS AT commands and the format of the responses returned after execution. 3. 4. INPUT DESIGN: STUDENT PROFILE The student profile input design is subjected to enter the details like department, section, regno, student name, batch, and address, mobile_number. These are the fields are considered as needed to be filled. ATTENDANCE:
The attendance of the student is updated. It requires filling up with basic details which will be retrieved from the student profile table. In this form we are just required to check the check boxes to add the attendance of the student. The updated attendance can be sent as SMS to the parent at the same time. In the attendance module we have added a term to allow the class advisor to check the overall student attendance. MARK ANALYSIS: Mark management system allows maintaining the entry of the student marks for very unit and model examination. After entering the mark those can be sent as message to the parents.
In the mark entry part we have added the automatic subject generating form which can be fetched in the mark management form. EMERGENCY: Emergency module incorporates the urgent message service were the urgent messages can be sent to parents. Here the regno and mobile_number are loaded when appropriate particulars are filled up properly. 3. 5. OUTPUT DESIGN: STUDENT PROFILE ATTENDANCE: OVERALL ATTENDANCE: MARK ANALYSIS: SUBJECT ENTRY: EMERGENCY: 3. 6. DATABASE DESIGN: The purpose of database design is to identify the major modules in the software and describe its components and interfaces for each major module for the users to understand.
Database design is a crucial factor in the performance of a package, both in terms of system timings and in the case with which the system can be maintained or modified. The database has been designed based upon the entity relationship data model. 1. Login Table Table name: login FIELD NAME| TYPE| SIZE| DESCRIPTION| Name| Text| 8| USER NAME| Password| Text| 8| PASSWORD OF USER| 2. Mark Table Table name: marks Primary key: regno FIELD NAME| TYPE| SIZE| DESCRIPTION| Regno| Text| 10| STUDENT REGISTER NUMBER| Semester| Number| 10| PRESENT SEMESTER |
Examtype| Text| 16| EXAM TYPE LIKE UNIT I,II AND MODEL EXAM| Mark1| Number| 3| MARKS IN SUBJECT 1| Mark2| Number| 3| MARKS IN SUBJECT 2| Mark3| Number| 3| MARKS IN SUBJECT 3| Mark4| Number| 3| MARKS IN SUBJECT 4| Mark5| Number| 3| MARKS IN SUBJECT 5| Mark6| Number| 3| MARKS IN SUBJECT 6| Mark7| Number| 3| MARKS IN SUBJECT 7| Mark8| Number| 3| MARKS IN SUBJECT 8| 3. Student Profile Table Table name: Studentmaster Foreign key: batch Primary key: Regno FIELD NAME| TYPE| SIZE| DESCRIPTION| Regno| Text| 10| STUDENT REGISTER NUMBER| Sname| Text| 30| NAME OF THE STUDENT|
Batch| Number| 10| BATCH YEAR OF THE STUDENT| Dept| Text| 20| DEPARTMENT IN WHICH THE STUDENT | Sec| Text| 10| CLASS SECTION LIKE A,B,C,D,…. | Mobile| Text| 15| MOBILE NUMBER OF PARENT| Address| Text| 30| ADDRESS FOR COMMUNICATION| 4. Urgent Table Table name: urgent Primary key: regno FIELD NAME| TYPE| SIZE| STUDENT REGISTER NUMBER| Regno| Text| 10| STUDENT REGISTER NUMBER| Message| Text| 160| MESSAGE CONTENT| 5. Attendance Table Table name: Department Details Foreign key: Department code FIELD NAME| TYPE| SIZE| DESCRIPTION|
DATE| Date/Time| 10| CURRENT DATE| Regno| TEXT| 30| STUDENT REGISTER NUMBER| hour1| Yes/No| | PRESENT-YES & ABSENT-NO| Hour2| Yes/No| | PRESENT-YES & ABSENT-NO| Hour3| Yes/No| | PRESENT-YES & ABSENT-NO| Hour4| Yes/No| | PRESENT-YES & ABSENT-NO| Hour5| Yes/No| | PRESENT-YES & ABSENT-NO| Hour| Yes/No| | PRESENT-YES & ABSENT-NO| 3. 7 REPORT DESIGN: Here we are going to take report for two modules they are: I) ATTENDANCE II) MARK ANALYSIS: ATTENDANCE: For the attendance form we are going to get report in the form data grid. MARK ANALYSIS: The mark statement is taken in the form of crystal report. 3. CODE DESIGN: STUDENT PROFILE: Imports System. Data Imports System. Data. OleDb Public Class frmStudentEntry Dim con As New OleDbConnection(“Provider=Microsoft. Jet. OLEDB. 4. 0;Data Source=. ksr. mdb”) Dim cmd As New OleDbCommand(“”, con) Dim cmdStudent As New OleDbCommand(“”, con) Dim daStudent As New OleDbDataAdapter Dim ds As New DataSet Dim dr As OleDbDataReader Private Sub frmStudentEntry_Load(ByVal sender As System. Object, ByVal e As System. EventArgs) Handles MyBase. Load End Sub Function CheckInputs() As Boolean Return True End Function Private Sub btnInsert_Click(ByVal sender As System. Object, ByVal e As System.
EventArgs) Handles btnInsert. Click If txtRegNo. TextLength = 0 Or txtName. TextLength = 0 Or txtAddress. TextLength = 0 Or txtMobile. TextLength = 0 Or Cmbbatch. SelectedItem = 0 Then MsgBox(“enter all the fields”) End If If CheckInputs() = True Then cmd. Connection = con cmd. CommandText = “insert into studentMaster values(@regNo,@sName,@batch,@dept,@sec,@mobile,@address)” cmd. Parameters. Clear() cmd. Parameters. AddWithValue(“@regno”, txtRegNo. Text) cmd. Parameters. AddWithValue(“@sName”, txtName. Text) cmd. Parameters. AddWithValue(“@batch”, Val(Cmbbatch.
SelectedItem)) cmd. Parameters. AddWithValue(“@dept”, cmbDept. SelectedItem) cmd. Parameters. AddWithValue(“@sec”, cmbSection. SelectedItem) cmd. Parameters. AddWithValue(“@mobile”, txtMobile. Text) cmd. Parameters. AddWithValue(“@address”, txtAddress. Text) con. Open() cmd. ExecuteNonQuery() con. Close() End If Try cmdStudent. CommandText = “select * from studentMaster where batch=” & Val(Cmbbatch. Text) & ” and [email protected] and [sec][email protected]” cmdStudent. Parameters. Clear() cmdStudent. Parameters. AddWithValue(“@dept”, cmbDept. SelectedItem) cmdStudent.
Parameters. AddWithValue(“@sec”, cmbSection. SelectedItem) daStudent = New OleDbDataAdapter(cmdStudent) ds. Tables. Clear() daStudent. Fill(ds, “stud”) DataGridView1. DataSource = ds. Tables(“stud”) DataGridView1. Refresh() Catch ex As Exception MsgBox(ex. Message) End Try End Sub ATTENDANCE: Imports System. Data Imports System. Data. OleDb Imports System Imports System. Threading Imports System. ComponentModel Imports System. IO. Ports Public Class Form7 Dim cn As New OleDbConnection(“Provider=Microsoft. Jet. OLEDB. 4. 0;Data Source=. ksr. mdb”) Dim cmdRegNo As New OleDbCommand(“”, cn) Dim cmd As OleDbCommand
Dim cmdSelect As New OleDbCommand(“”, cn) Dim daSelect As New OleDbDataAdapter Dim dr As OleDbDataReader Dim ad As OleDbDataAdapter Dim daRegNo As OleDbDataAdapter Dim cmdBatch As New OleDbCommand(“select distinct(batch) from studentmaster”, cn) Dim daBatch As New OleDbDataAdapter(cmdBatch) Dim ds As New Data. DataSet ‘connect your mobile/GSM modem to PC, ‘then go in device manager and check under ports which COM port has been slected ‘if say com1 is there then put com2 in following statement Dim SMSEngine As New SMSCOMMS(“COM17”) Dim i As Integer Private Sub DateTimePicker1_ValueChanged(ByVal sender As System.
Object, ByVal e As System. EventArgs) Handles DateTimePicker1. ValueChanged TextBox3. Text = DateTimePicker1. Value. Day TextBox4. Text = DateTimePicker1. Value. Month TextBox5. Text = DateTimePicker1. Value. Year End Sub Private Sub GroupBox1_Enter(ByVal sender As System. Object, ByVal e As System. EventArgs) Handles GroupBox1. Enter TextBox3. Text = DateTimePicker1. Value. Day TextBox4. Text = DateTimePicker1. Value. Month TextBox5. Text = DateTimePicker1. Value. Year End Sub Private Sub Button4_Click(ByVal sender As System. Object, ByVal e As System. EventArgs) Me. Close() End Sub
Sub gv() Try cmd = New OleDbCommand(“select * from attendence”, cn) ad = New OleDbDataAdapter(cmd) ad. Fill(ds, “attendence”) DataGridView1. DataSource = ds. Tables(“attendence”). DefaultView Catch ex As Exception MsgBox(ex. Message, MsgBoxStyle. Critical, “Error”) End Try End Sub Private Sub DailyentryToolStripMenuItem_Click(ByVal sender As System. Object, ByVal e As System. EventArgs) Me. Show() End Sub MARK ANALYSIS: Imports System. Data Imports System. Data. OleDb Imports System Imports System. Threading Imports System. ComponentModel Imports System. IO. Ports
Public Class entrymarks Dim con As New OleDbConnection(“Provider=Microsoft. Jet. OLEDB. 4. 0;Data Source=. ksr. mdb”) Dim cmd As New OleDbCommand(“select regno,sName,Dept,Batch from studentmaster”, con) Dim cmdBatch As New OleDbCommand(“select distinct(batch) from studentmaster”, con) Dim daBatch As New OleDbDataAdapter(cmdBatch) Dim cmdRegNo As New OleDbCommand(“”, con) Dim daRegNo As New OleDbDataAdapter Dim dr As OleDbDataReader Dim cmdreg As New OleDbCommand(“select distinct(regno) from studentmaster”, con) Dim da As New OleDbDataAdapter(cmd) Dim ds As New DataSet ‘connect your mobile/GSM modem to PC, then go in device manager and check under ports which COM port has been slected ‘if say com1 is there then put com2 in following statement Dim SMSEngine As New SMSCOMMS2(“COM17”) Dim i As Integer Private Sub entrymarks_Load(ByVal sender As System. Object, ByVal e As System. EventArgs) Handles MyBase. Load DisableAll() daBatch. Fill(ds, “batch”) cmbBatch. DataSource = ds. Tables(“batch”) cmbBatch. DisplayMember = “batch” cmbBatch. ValueMember = “batch” cmbDept. SelectedIndex = 0 cmbTestType. SelectedIndex = 0 cmbSection. SelectedIndex = 0 End Sub Private Sub btnLoad_Click(ByVal sender As System. Object, ByVal e As System.
EventArgs) Handles btnLoad. Click If cmbBatch. SelectedIndex = -1 Or cmbDept. SelectedIndex = -1 Or cmbSection. SelectedIndex = -1 Then MsgBox(“Select the fields”, MsgBoxStyle. Critical) Else cmdRegNo. CommandText = “select regno, (sname + ‘(‘ + regno + ‘)’) as sn from studentMaster where [email protected] and [email protected] and [email protected]” cmdRegNo. Parameters. Clear() cmdRegNo. Parameters. AddWithValue(“@btch”, cmbBatch. SelectedValue) cmdRegNo. Parameters. AddWithValue(“@dept”, cmbDept. SelectedItem) cmdRegNo. Parameters. AddWithValue(“@sec”, cmbSection. SelectedItem) Try s. Tables. Remove(“regNo”) Catch ex As Exception End Try daRegNo = New OleDbDataAdapter(cmdRegNo) daRegNo. Fill(ds, “regNo”) cmbRegno. DataSource = ds. Tables(“regno”) cmbRegno. DisplayMember = “sn” cmbRegno. ValueMember = “regno” End If LoadSubjects() End Sub EMERGENCY: Imports System. Data Imports System. Data. OleDb Imports System Imports System. Threading Imports System. ComponentModel Imports System. IO. Ports Public Class Form12 Dim cn As New OleDbConnection(“Provider=Microsoft. Jet. OLEDB. 4. 0;Data Source=. ksr. mdb”) Dim cmdRegNo As New OleDbCommand(“”, cn) Dim cmd As OleDbCommand Dim cmdSelect As New OleDbCommand(“”, cn)
Dim daSelect As New OleDbDataAdapter Dim dr As OleDbDataReader Dim ad As OleDbDataAdapter Dim daRegNo As OleDbDataAdapter Dim cmdBatch As New OleDbCommand(“select distinct(batch) from studentmaster”, cn) Dim daBatch As New OleDbDataAdapter(cmdBatch) Dim ds As New Data. DataSet ‘connect your mobile/GSM modem to PC, ‘then go in device manager and check under ports which COM port has been slected ‘if say com1 is there then put com2 in following statement Dim SMSEngine As New SMSCOMMS(“COM14”) Dim i As Integer Private Sub Button1_Click(ByVal sender As System. Object, ByVal e As System. EventArgs) End Sub
Private Sub Form12_Load(ByVal sender As System. Object, ByVal e As System. EventArgs) Handles MyBase. Load daBatch. Fill(ds, “batch”) cmbBatch. DataSource = ds. Tables(“batch”) cmbBatch. DisplayMember = “batch” cmbBatch. ValueMember = “batch” Try cn. Open() cmd = New OleDbCommand(“SELECT regno,sName FROM studentmaster”, cn) dr = cmd. ExecuteReader While dr. Read ‘ ComboBox1. Items. Add(dr(0). ToString) cmbRegNo. Items. Add(dr(0). ToString()) End While dr. Close() cn. Close() Catch ex As Exception MsgBox(ex. Message, MsgBoxStyle. Critical, “Error”) End Try End Sub TESTING AND IMPLEMENTATION 4. 1 TESTING TECHNIQUES:
SECURITY TESTING: Security testing is implemented in the part of the login section and change password section. For login: User name: (text) Password: (text) change password: user NAME: (text) TYPE PASSWORD: (text) RETYPE PASSWORD: (text) UNIT TESTING: In unit testing, we have to test the programs making up the system. For this reason, Unit testing sometimes called as Program testing. The software units in a system are the modules and routines that are assembled and integrated to perform a specific function, Unit testing first on the modules independently of one another, to locate errors.
This enables, to detect errors in coding and logic that are contained with the module alone. The testing was carried out during programming stage itself. INTEGRATION TESTING: Integration testing is the phase in software testing in which individual software modules are combined and tested as a group. It occurs after unit testing and before validation testing. Integration testing takes as its input modules that have been unit tested, groups them in larger aggregates, applies tests defined in an integration test plan to those aggregates, and delivers as its output the integrated system ready for system testing. . 2. COMPARISON BETWEEN ACTUAL RESULTS AND EXPECTED RESULTS Actual results| Expected results| To initiate the system by giving the user name and password also enable the change the password. | Enter the user name and password to login the system. | In student profile, entering the details of the student and which is showing in data grid. To store the details in DB. | To view the inserted details in data grid and store in the DB. | In student mark system, it automatically generates the name of the student which is already saved in the profile database.
Enable to send the marks to the parent via SMS. | To show the inserted details in data grid and store in the DB. Allows sending the information. | It automatically generates the reg. number of the student, which is already saved in the student profile. | To Validate the fields whether empty or not.. | Whether the text is more than 160 characters is checked. | Check the character size more than 160 or not. | To store the send message content in DB. | Store the sent items in DB| 4. 3. TEST REPORTS: UNIT TESTING OF EVERY MODULE: LOGIN FORM User name: (text) Password: (text)
If any field remains empty it produces test case Test case result: message box pops out informing have to be entered. STUDENT PROFILE REG NO: (ALPHA NUMERIC) NAME: (TEXT) DEPARTMENT: (TEXT) CLASS (TEXT) ADDRESS: (ALPHA NUMERIC) PHONE NUMBER: (NUMBER) TEST CASE RESULT: I) If the regno, class, dept, address, phone number, name remains empty Msgbox appears informing that enter the respective data in the appropriate field. II)Phone number must be 12 digits with the(+).
MARK ANALYSIS: In mark analysis by selecting appropriate batch number, department, semester, section it loads the reg no and also the number subjects in the semester. Then marks are needed to be entered. But they should be below 76. Name with reg. no: combo box selection of register number Type of test: type of the test from the combo box it will be either unit test I, unit test II, models Marks: it should have value less than 76. EMERGENCY: Name with reg. no: combo box selection of register number Mobile number: appears automatically when regno is selected
Message text: text length should be less than 160 4. 4 SYSTEM IMPLEMENTATION The implementation of “SMS BASED STUDENT INFORMATION SYSTEM” is tool for day-to-day usage was to provide a user friendly environment supporting all platforms. Here the implementation of the system with SMS sending option is termed as the easiest follow up. Here the SMS sending methodology id followed as connecting the mobile in com port and configuring it in the coding. After configuring the respective comport number is added in the coding. Thus the system is ready to send the information.
To use the system in the computer environment the knowledge of installation is a essential part. 5. CONCLUSION The “SMS BASED STUDENT INFORMATION SYSTEM” allows to send Student Information through SMS to reduce the manual work of class advisors also sending the activity information to the parents. This system supports in enrolling the student details and the respectively that is to be registered in the project. The attendance depends on the total number of hours and the present hours of the students. The emergency module allows sending the information in the form of simple text which can be considered as the messaging option.
This module can be used daily for sending any current information of the student to the parents. To the end the system has customized the complete student information into a single system which provides a efficient system reducing the work of class advisor. The aspect of the report generation also builds a pillar to prove the efficiency of the project. 6. FUTURE ENHANCEMENTS The project has covered almost all the requirements. Further requirements and improvements can easily be done since the coding is mainly structured or modular in nature.
Changing the existing modules or adding new modules can adding improvements. In our proposed,the project can run in the individual machine and the absent details and exam mark details of each student is send to their parents through SMS in text formats. In feature enhancement the details will be send in voice formats. Use of different unicode language is possible in the future enhancements. BIBLIOGRAPHY 7. 1. REFERENCE BOOKS: 1. Alistair Mc Monnies,“Object-oriented programming in Visual Basic . NET”, Pearson Education, and ISBN: 81-297-0649-0, First Indian Reprint 2004. 2.
Jittery R. Shapiro, “The Complete Reference Visual Basic . NET” Edition 2002,Tata McGraw-Hill, Publishing Company Limited, New Delhi. 3. Robert D. Schneider, Jetty R. Garbus, “Optimizing SQL Server”, Second Edition, Pearson Education Asia, ISBN: 981-4035-20-3 7. 2. WEB REFERENCES: 1. http://vbdotnetheaven. com 2. http://www. codeproject. com 3. http://msdn. microsoft. com APPENDIX 8. 1 SCREEN LAYOUTS: LOGIN FORM: CHANGE PASSWORD FORM: STUDENT PROFILE FORM: ATTENDANCE FORM MONTHLY RECORD OF ATTENDANCE: MARK ANALYSIS SUBJECT ENTRY: REPORT GENERATION FOR MARK ANALYSIS: EMERGENCY: