Sms Based Student Information System Essay Example

Sms Based Student Information System Essay Example Sms Based Student Information System Essay Sms Based Student Information System Essay 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 has only one user called Class Advisor. 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. 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 Att endance 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 Studios 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 programmers 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. Thats 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 amp; ABSENT-NO| Hour2| Yes/No| | PRESENT-YES amp; ABSENT-NO| Hour3| Yes/No| | PRESENT-YES amp; ABSENT-NO| Hour4| Yes/No| | PRESENT-YES amp; ABSENT-NO| Hour5| Yes/No| | PRESENT-YES amp; ABSENT-NO| Hour| Yes/No| | PRESENT-YES amp; 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 fr mStudentEntry_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= amp; Val(Cmbbatch. Text) amp; and [emailprotected] and [sec][emailprotected] 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. Dis playMember = 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 [emailprotected] and [emailprotected] and [emailprotected] 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 F orm12 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. 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:

An Overview of the Animal Welfare Act

An Overview of the Animal Welfare Act The Animal Welfare Act (AWA) is a federal law that was passed in 1966 and has been amended several times since then, notably in 2006. It empowers the Animal Care program of the USDA’s Animal and Plant Health Inspection Service (APHIS) to issue licenses and adopt and enforce regulations meant to protect the basic welfare of creatures kept in captivity. The law can be found at the official United States Government Publishing Office under its proper bill title: 7 U.S.C.  §2131. The Animal Welfare Act protects certain animals in certain  facilities but is not as effective as animal advocates would like. Many complain about its limited scope, and some even argue that animals are entitled to rights and freedoms equal to humans and should not be owned or used in any regard. Which Facilities Are Covered by the AWA? The AWA applies to facilities that breed animals for commercial sale, use animals in research, transport animal commercially, or publicly exhibit animals. This includes zoos, aquariums, research facilities, puppy mills, animal dealers, and circuses. The regulations adopted under the AWA establish minimum care standards for animals in these facilities, including adequate housing, handling, sanitation, nutrition, water, veterinary care, and protection from extreme weather and temperatures. Facilities that are not covered include farms, pet stores, hobby breeders, and places that commonly hold pets as well as quasi-commercial animals like milk cows and bure-pred dogs. Without the protection guaranteed to animals in other facilities and industries, these animals sometimes suffer harsh treatment- though animal rights groups often step in to defend these creatures. The AWA requires that the facilities  are  licensed and registered or their AWA-covered activities will be shut down. Once a facility is licensed or registered, it is subject to unannounced inspections. Failures to comply with AWA standards can lead to fines, confiscation of the animals, license and registration revocation, or cease and desist orders. Which Animals Are and Are Not Covered? The legal definition of the word â€Å"animal† under the AWA is â€Å"any live or dead dog, cat, monkey (nonhuman primate mammal), guinea pig, hamster, rabbit, or such other  warm-blooded  animal, as the Secretary may determine is being used, or is intended for use, for research, testing, experimentation, or exhibition purposes, or as a pet.† Not every animal kept by these facilities is covered. The AWA has exclusions for birds, rats or mice used in research, livestock used for food or fiber, and reptiles, amphibians, fish, and invertebrates. Because 95 percent of the animals used in research are mice and rats and because the nine billion land animals slaughtered for food in the U.S every year are exempted, the vast majority of animals used by humans are excluded from the AWA’s protection. What Are the AWA Regulations? The AWA is a general law that does not specify the standards for animal care. The standards can be found in the regulations that are adopted by APHIS under the authority granted by the AWA. Federal regulations are adopted by government agencies with specific knowledge and expertise so they can set their own rules and standards without getting Congress bogged down in small details. The AWA regulations can be found in Title 9, Chapter 1 of the Code of Federal Regulations. Some of these regulations include those for the indoor housing of animals, which specify minimum and maximum temperatures, lighting, and ventilation. Regulations for animals kept outdoors maintain that the creature must be sheltered from the elements and offered food and clean water regularly. Also, for facilities with marine mammals, the water must be tested weekly and animals must be kept with a compatible animal of the same or similar species. In addition, a minimum tank size is required, depending on the size and types of animals housed. Participants in â€Å"swim with the dolphins† programs must agree in writing to the rules of the program. Circuses, which have been under constant fire since animal rights activism increased in the 1960s, must not use deprivation of food and water or any kind of physical abuse for training purposes, and animals must be given a rest period between performances. Research facilities are also required to establish Institutional Animal Care and Use Committees (IACUC) that must inspect the animal facilities, investigate reports of AWA violations, and review research proposals to â€Å"minimize discomfort, distress, and pain to the animals.​ Criticisms of the Animal Welfare Act One of the biggest criticisms of the AWA is the exclusion of rats and mice, which make up the majority of the animals used in research. Similarly, since livestock is also excluded, the AWA does nothing to protect farmed animals. There are currently no federal laws or regulations for the care of animals raised for food. Although there are general criticisms that the housing requirements are insufficient, some animal rights advocates claim that the regulations for marine mammals are especially inadequate. Marine mammals in the wild swim for miles each day and dive hundreds of feet deep in the open ocean, while tanks for porpoises and dolphins can be as small as 24 feet long and only 6 feet deep. Many of the criticisms of the AWA are directed against the IACUCs. Since IACUCs tend to include people who are affiliated with the institution or are animal researchers themselves, many advocates question whether these committees can objectively evaluate research proposals or complaints of AWA violations.

Dispute settlement mechanism in the WTO and developing countries Essay

Dispute settlement mechanism in the WTO and developing countries - Essay Example The purpose of this paper is to examine the mechanism of the world trade organization to settle the disputes that occur between the parties of the organization. Research will compare the system of GATT and the WTO system to settle disputes. In addition; it will explain how the system works. Also it will show the benefits that the system provides for developing countries. And it will be some cases of the disputes that the system remedied. The increasing predominance of the capitalist system, globalization and the consequent reduction of the world into some form of global village have resulted into the fast integration of the world’s economic system. This development is characterized by countries engaged in constant bilateral and multilateral relationships as they deal with each other with the highly dynamic and freer flow of goods and services in the international market in addition to the internationalization of production. David Held (1999) argued that historical evidence at both the world and country levels demonstrate that the higher level of trade today is inevitable – from the Classical Gold Standard period to the postwar growth in trade.1 An illustration of the growth of global trade is demonstrated in fig. 1. This phenomenon was made possible by the advances in modern technology, transportation and communications as well as the global trade liberalization that have paved the way for a highly evo lved economic system. Central to globalization is the World Trade Organization, the international body that institutionalized the world trade system. It is this organization that has worked to increase trade between countries by ensuring that tariffs, state control systems are lowered and protectionism by governments on domestic industries is eliminated. The environment that is created by the modern economic system often breeds conflict as countries navigate the complexities of trade. As nation-states become naturally enmeshed and interdependent

Marketing Internationally Essay Example | Topics and Well Written Essays - 2000 words

Marketing Internationally - Essay Example r a business can only be successful globally if the management takes into account other factors that are related to the change in the geographical location of the product. Factors such as culture, economy and politics can have a huge impact on the launch of product in a foreign market (Balmer, 2001). Hence the paper reinforces the concept that marketing research is not only limited to research related to the product but it is also related to research relating to all the factors that are going to have an effect on the product launch feasibility in the new geographical area (Kotler & Keller, 2011). Since the paper deals with formation of the basis of the new business idea, we will discuss the marketing research for the idea in detail i.e. discussion regarding launch of an existing product in a completely new geographical area. Hence the components of marketing research have been discussed below in detail. The chosen product is Fiber One bar from the American company Fiber One working under the General Mills. The selected location for the launch is Pakistan. Fiber One bar has been introduced in the industry as a product for health conscious people as it offers taste of chocolate and less calories at the same time. It is a very famous product in USA in the female population. The reason for selection of Pakistan for the product launch is the current changing trends in the country, within a few geographical areas of the country, a certain demographic segment is showing interest in purchasing healthy products due to which local stores are offering exported products that have been brought through unprofessional procedures (General Mills (USA), 2011). Based on all these evidences, a strong need for this product has been identified and the observable factors give very high probability of the product’s success in the market. However, there is a very high chance of failure of the product if proper analysis of the country isn’t carried out. We have identified the

Bissell Vacuum Cleaner Quality Analysis Essay Example for Free

Bissell Vacuum Cleaner Quality Analysis Essay The market for vacuum cleaners is more globalized compared to laundry and kitchen appliances market. The need for vacuum cleaner models differs across various markets. Over the last few years the vacuum cleaners market witnessed a large number of advances in terms of lightweight vacuums driven by smaller and efficient motors. The market for bagless vacuum cleaners is witnessing continuous growth, with North American households accounting for the highest share of bagless vacuums market. The current consumers prefer vacuums featuring bagless and multi-surface cleaning. The following are few vacuum cleaner brands under the low price segment. A comparison is made based on criteria like key features, price and consumer ratings. These criteria should allow us to rank the brands in terms of value for money. From the listings it is easy to understand that the Bissell 3-in-1 Stick Vac Bagless Vacuum has received a four star rating and also priced the cheapest among the other brands. The Bissell Vacuum cleaner is definitely a winner as it fulfills consumer needs and stands out as a very good purchase for price sensitive consumers. The next in line is Eureka Quick-UP Bagless Stick Vacuum which has also received good consumer ratings but is much more expensive than its other competitor. References 1. www.walmart.com 2. http://www.pellresearch.com/Household-Vacuum-Cleaner-Manufacturing.htm

life lessons :: essays research papers

  Ã‚  Ã‚  Ã‚  Ã‚  Since I was young until now, I have learned a lot of life’s lessons. And some I go by, and some I use once and then get rid of them. But there are ones that I keep for a short time, and keep for a long time, because you never know when they will come in handy.   Ã‚  Ã‚  Ã‚  Ã‚  The ones that I have still, they are good ones. I keep the good ones, and just forget the bad ones, because why keep lessons that will not help get you some where or get you out of a jam. Having little good life lessons is a lot better than having a lot of great life lessons or a lot of bad life lessons.   Ã‚  Ã‚  Ã‚  Ã‚  There is one main life lesson that I use all the time. And it is, to never be a quitter, because being a quitter is worse than losing. Being a quitter is even worse than being a loser. Cause, who would want to be called a quitter their whole life. I would rather spend extra time trying to get it down and done, then be a quitter. Cause if you quit at one thing, most will quit every time a roadblock is in their way.   Ã‚  Ã‚  Ã‚  Ã‚  Life lessons are good for people. They can help you more than they can hurt you. They really don’t hurt you, because they are like warnings for the bad stuff out in the world today. They are just little helpful hints. They are especially helpful when you are in the time of need. If a life’s lesson hurts you, you are using them in the wrong way.  Ã‚  Ã‚  Ã‚  Ã‚     Ã‚  Ã‚  Ã‚  Ã‚  I think the more life lessons you get and keep is good for your self-character. They show good character about you to other people. Because you don’t want to have badly self image. Because if other people see it as a bad self image, then you will try so hard to make it look like a good self image, and that you have good character, then it will make you look self absorb.

Letter of Advice… Interpersonal Communication Essay

This a great article with good advice on how to communicate with your husband, wife or partner for the future. Without Communication there will not be a happy and long lasting result in a marriage. Within reading this article I was able to relate the knowledge with my own marriage of 5 long years. Learning how to communicate within listen as well as my tone and other forms to communicate has been susceptible for us. There has been along hard battle to fight through my ordeal, but the lessons of reading and responding with the actions have been very tolerable. I have had a very bad problem beening lonely after my children went to college and after I closed my business. Drawing more to my husband, I felt he was pulling away from me. There was not a day went by that I feel deeper in a depression without communicating that with him, I just assumed he would have noticed. Now after talking the problem out and with quality time as well things are much better. Being able to relate to â€Å"Many couples think they are communicating with each other†, they are wrong at times, because I was that person. Within the statement, â€Å"Romantic relationships begin with a lot of sharing and excitement, (Terri Orbuch) I feel this is very true, because that’s why you get married. But, as time goes on other things take place within priorities before you mate. I blame this on life sometimes. Self-disclosure really is an important key to having satisfaction in a marriage even or a relationship, because it is an act of verbally or nonverbally revealing information about you to others. Within revealing your true thoughts and self you may allow other people to know the â€Å"real you† and not your public personality, which often leads to building the relationship to higher levels of communication. Self-disclosure is what your spouse will be entitled to that knowledge. When it comes to gender differences, there really is a level of expression that women and men have to different. When you make a connection and are able to understand how interpersonal communication works, you are better able to express and reveal information about the inner you. I have noticed that my husband keeps a lot of things bottled up on the inside and I really try to get him to talk about things. But within recognizing my husband’s stand on issues, I don’t push too hard. Gender roles are even greater over the years as men and women both have trouble in expressing their feelings, but if we learn to communicate better things will be easier. After all, we just want to be loved and cared for by our spouse. Unfortunately, I believe I have loved, lost, and lived to love again through our time together. I believe with time, exploring, and the use of self-disclosure that my husband and I will find our way back to an exciting new beginning to share with our extended family through generalization. I fit into the category because many relationships are typical. All arguments and issue seems to be the same, only to be in a different scenario. Communication plays a valuable role in our relationships one that leads to a long-lasting and healthy marriage. Some good advice is to make the best of every opportunity while having fun and loving the person you are with right now.