COMPUTERIZED GRADING SYSTEM WITH SHORT MESSAGE SERVICE SYSTEM FOR BAMBANG NATIONAL HIGH SCHOOL

A Capstone Project
Presented to the Faculty of the
Information and Communication Technology Department
Nueva Vizcaya State University
Bambang Campus
Bambang, Nueva Vizcaya

In Partial fulfillment
Of the Requirement for the Degree of
Bachelor of Science in Information Technology

By:
Von Kaiser O. Lictao
Lyzeth M. Raneses
Vangeline M. Dasalla
Krisna M. Martin

March
S.Y. 2015-2016
Table of Contents

Title Page ii
Table of Contents iii
List of Figures iv
List of Tables v
Chapter I. The Problem and its Background
Introduction 1
Scope and Limitation 5
Objectives of the Project 6
Significance of the Project 7
Chapter II. Review of Related Literature and Studies
Theoretical Framework
Related Literature
Related Studies
Synthesis
Chapter III. Technical Background
Technicality of the Project
Details of the technologies to be used
How the project will work
Chapter IV. Methodology * Environment * Locale * Population of the Study * Organizational Chart/Profile * Requirements Specification * Operational Feasibility * Fishbone Diagram * Functional Decomposition Diagram * Technical Feasibility * Compatibility Checking * Relevance of the Technologies * Schedule Feasibility * Gantt Chart * Economic Feasibility * Cost and Benefit Analysis * Cost Recovery Scheme * Requirements Modeling * Data and Process Modeling * Context Diagram * Data flow Diagram * System Flowchart * Risks Assessment/Analysis * Design * Output and User-Interface Design * Forms * Reports * Data Design * Entity Relationship Diagram * Data Dictionary * System Architecture * Network Model * Network Topology * Security * Development * Software Specification * Hardware Specification * Program Specification * Programming Specification * Deployment Diagram
Bibliography

LIST OF FIGURES

Figure Title Page no.
1 Current System
2 How the Project Will Work
3 Current Organizational Chart
4 Proposed Organizational Chart
5 Fishbone Diagram
6 Functional Decomposition Diagram
7 Gantt Chart
8 Context Diagram
9 Data Flow Diagram
10 System Flowchart
11 Program Flowchart
12 Entity Relationship Diagram
13 Front End and Back End
14 Deployment Diagram

LIST OF TABLES

Table Title Page.no
1 Technologies Used in Developing the System
2 Frequency and Percentage Distribution of Respondents
3 Hardware Compatibility Checking Requirements
4 Software Compatibility Checking Requirements
5 Relevance of the Technologies Used
6 People ware Classification of the Proposed System
7 Software Classification of the Proposed System
8 Hardware Classification of the Proposed System
9 Cost Recovery Scheme
10 Risk Assessment/Analysis
11 Data Dictionary

Chapter I
THE PROBLEM AND ITS BACKGROUND
Introduction
“In order for us to maintain consistency and quality, we must make use of the new technology that is not widely used by different countries, which is computer. As we see, information technology, the application of computer and related technologies have accompanied information age to generation and communication of information.” - Caridad, Melody
Nowadays, in a highly technological society, human productivity is made more efficient through the development of electronic gadgets. Now, with the advent of such modernization in education, one way to globalize the process of research is to realize that technology is advancing at an incredibly fast phase. Computers are not confined to being used for entertainment but its role in education is also vast. Computers with the power of the internet have thrived in aiding communication among people. The telephone system, which is the main communication system that was invented several years ago, had undergone a great improvement, so much that today we have fixed wireless phones, mobile phones and the likes. With the rapid development of mobile phones come several services like the Short Messaging Service (SMS), Multimedia Messaging Service (MMS) and others, which are readily available and add to the usefulness of mobile phones. SMS in particular is widely used in communication, and more recently has been leveraged to provide several services like airline ticketing, banking services, commercial services like share and sell (an added service provided by MTN Nigeria), where subscribers can easily share and/or sell airtime, and several others. SMS is a mobile technology that allows for sending and receiving text or even binary messages to and from a mobile phone. The relative ease of use of SMS makes it possible for a user to learn how to send SMS easily. Schofield and Kubin (2002) argued that small devices could potentially provide better interface for finding information than through page browsing and other means. More than 160 billion SMS are exchanged each month in European countries (Mavrakis, 2004), and according to Resource Shelf (2006), 48.7 billion SMS messages were sent in the second half of 2005, which is up 50% on the six months before that. Nowadays, with 45 million short messages sent in the U.K. alone every day, a mobile phone that has the easiest interface for voice communication is likely to fail the user satisfaction test if it does not provide a reasonably good SMS interface. (Gorienko & Merrick, 2003). The major advantage of SMS is its cost effectiveness, and availability, as most individuals own phone.
When it comes to technology, computers had a great impact to our society. Many businesses sector tries to cope up by upgrading computer system constantly in order to stay competitive with the rapid growth of technology today. There is no doubt that computers will someday become a common asset in all professions. But systems do not often relate expectations. Computerized world is a highly efficient one, which processing the big quantities of data and keeping. The extensive record will not be a problem to a post industrialized society, likewise the unreliable and slow processing and preparing student grades. Computers come in a variety of classification, from small to large, cheap to costly, and personal to multiuser. They engulfed with applications that are suitable and significant to these days. An institution or educational institution that still cannot cope up with these computer breakthroughs is said to be left behind.
Grading is one of the most important activities a faculty member does. Many problems in teaching arise because of grading issues. Grading System plays a key role in management of any school. It is designed to provide incentive rewards for achievement and assist in identifying problems of students. The grade of the student is the degree which determines students who need more improvement and requires more assistance which will help teachers in guiding them towards their development. It also shows where the students excel most so they can improve their skills and aim higher. At the end, it will be the reference for the judgments of whether a student can step up to a higher level of learning. From these reasons, it is clearly concluded how important to make sure that the grades of students are accurately calculated and safely stored in a well-founded database.
Bambang National High School (BNHS) has a large number of student populations. Teachers are experiencing difficulties in getting their report cards because sometimes they were delayed in passing the grades of their students due to heavy workload. Since teachers were using Microsoft Excel Spreadsheet for computing grades of their students, still there are some cases that they need to double check and it is done through manual checking. So, when the students were not informed that their grades were not yet release it would be a waste of time and effort for them in always going back to school just to get their report cards or grades. There are times that the student are not showing or updating their parents concerning about their performance in school. And sometimes the students are imitating the signature of their parents just to assure their teachers that they have showed it to their parents. Since parents are too busy with their schedules they don’t have any available time to go to the school to know and check the performance of their children. The proposed Computerized Grading System of Bambang National High School with Short Message Service provides efficient and accurate grade reports of the student and makes the grading process fast, more consistent and more reliable. To ease the difficulties in knowing the grades, a system using SMS or Short Message Service will be use wherein, each of the student will be acquiring a logon id and which will then be used in viewing their grades. They will just login through their phone using their id number and password then, the administrator will accept the student’s request. When they are already connected to the system, they can now send the keyword for accessing their grades. Implementing this SMS technology in these institutions will relieve these issues and provide further advantages for both institutions and students. This technology offers growth in efficiency, responsiveness, and performance for institutions and makes students well-informed and up-to-date about matters. Since mobile phone seems to be positive feature which most individual possess and take in all places with them, therefore an extremely effective means of transporting information to them quicker and easier.
The proposed Computerized Grading System will also be a convenience for the professors as well, because by this, delayed passing of grade will be prevented. By this, students would not wait for a long period of time just to get their papers processed. In case that a student record is lost, we can easily retrieve it with the help of the system.
Scope and Limitations The proposed project allows for rapid mark delivery as well as storing information regarding on personal and contact details of the student, including their grades. The system can only read and accept excel and MS Word files. Another is that it cannot be used as a storage of hard files (videos, audios, images). In addition, only the IT administrator will be allowed to manipulate and change the record of the student. When it happened that the teacher made mistakes to the given data, the saved file to the database can still be overwritten but the teacher should ask first for the permission of the IT administrator to overwrite it. The teacher is given only 24 hours to validate and recheck the data before it will be released to the students. There would be no alternation of grades once the records are and finalized, so the records will be secured. Upon enrollment, students will be ask for secondary password for future retrieval purposes. With the use of the Short Message Service System (SMS), students can avail their information by sending a keyword. Occasionally, students can only send keywords and short messages to the system. They will acquire logon id from the administrator for using the Short Message Service System and only one account is allowed for each of them. If a student lost his/her registered number, he can retrieve the data by using his/her secondary password. The limit of the messages that the system can send and receive is about 10 messages per second. Then, the maximum capacity of the message is 5 characters. This proposed project will serve as a tool for easier accessibility of grades, both for the convenience of the students and the faculty staffs, as well as the professors.
Project
General Objective of the Study The aim of the project is to develop a grading system that will be used by Bambang National High School to disseminate information of the students and to help the faculty of staff in handling information regarding grades.
Specific Objective of the Study In order to attain the stated general objective the following specific objectives are presented: * Lessen the time in computing grades. * Protect the data from tampering and erasures. * Create logical storage that will prevent the data from getting lost. * Reduce the burden of faculty and staff in distributing information to the students. * Update the users with activities and events of the school by using advisory messages. * Ensure that the information can be kept updated and protected all the time.
Significance of the Project This study is made to find out that the used of Computerized Grading System with Short Messaging Service (SMS) for the Bambang National High School (BNHS) will lessen the time of the transaction of releasing the grade of students. This study is significance to the following:
School. This study will give benefits to the school because a computerized grading system is feasible, economically viable and as accurate as manually grading system.
Faculty and Staff. It can help them to compute and finalized the information in distributing the data.
Students. It can help them to inquire their grades in more efficient way.
Teachers. It can help them to lessen their task in preparing the summary of grades.
Parents/ Guardians. It can help them monitor the grades of their children by using new technology.
Future Researchers. It can help them as a guide to enhance more from their future study. Also, it will equip them with knowledge about the grading system.

Chapter II
REVIEW OF RELATED LITERATURE AND STUDIES The study is generally concentrating on the feasibility of creating a Computerized Grading System with SMS capability for the Bambang National High School. The literatures of this study come from conclusions and generalizations, ideas, books, journals, articles, electronic materials such as PDF or E-Book, and other existing theses and dissertations, foreign and local that are believed to be useful in the advancement of awareness concerning the study. Other unpublished thesis also helped to provide proof that this study is originally and its discussion of fact were also based on recent studies in creating more sources of related information.
Theoretical Framework Theoretically, the main purpose of the system is to create an efficient, fast and reliable Computerized Grading System with SMS System for Bambang National High School.
Computerized pattern grading makes the grading process fast, more consistent, and more reliable than traditional manual grading. However, existing computerized grading systems still require manual calculation of grade rules and then entry into data files. This series of papers describes an automatic method for grading both basic block patterns and adapted patterns, which obviates the need for this.
This research focuses on the development and implementation of an adaptive learning and grading system with a goal to increase the effectiveness and quality of feedback to students. By utilizing various concepts from established learning theories, the goal of this research is to improve the quantity, quality, and speed of feedback as it pertains specifically to the grading of computer skills with a focus on personal productivity software. Feedback has been identified as a key component of successful learning among students. This research builds upon the previous knowledge from the cognitive, behavioral, and resource-based views of learning as well as upon the establishment of grading rubrics. An automated grading system was developed that allows instructors to quickly grade multiple complex computer literacy assignments. Key to the success of the system is the ability of the system to "learn" the correct and incorrect responses and store them for future use. To understand the impact of the system on feedback, three hypotheses were created and experiments were developed to test them. The system was shown to positively affect the quantity of feedback and reduce the time required for grading assignments. No effect on the quality of the feedback comments was shown and may be a subject of further study.
Related Literature
Gabriel Doy (2012) The increasing usage of computers gave way for the birth of a new technological advancement that had assisted teachers to easily compute for grades, the digitization of spreadsheets. The main advantage is speed, since no manual calculations are needed, and confirmation of grade for any further necessary alterations can also be performed more quickly than traditional means. Managing grades had become easier for instructors when using electronic spreadsheets. With the advancement of information technology, the internet suddenly became an important aspect for local and global connectivity. Because the computers around the globe were logically connected through the Internet, communication had been easier with the use of E-Mail, message boards and other communication programs.
According to the Republic Act No. 10175 known as the Cybercrime Law (2012); The State recognizes the importance of providing an environment conducive to the development, acceleration, and rational application and exploitation of information and communications technology (ICT) to attain free, easy, and intelligible access to exchange and/or delivery of information; and the need to protect and safeguard the integrity of computer, computer and communications systems, networks, and databases, and the confidentiality, integrity, and availability of information and data stored therein, from all forms of misuse, abuse, and illegal access by making punishable under the law such conduct or conducts.
In relation to this, the input, alteration, or deletion of any computer data without right resulting in inauthentic data with the intent that it be considered or acted upon for legal purposes as if it were authentic, regardless whether or not the data is directly readable and intelligible.
Related Studies
Caraga State University SMS-Based Grade Inquiry
The university as an educational institution organization has a lot of valuable information which can be provided to students such as grade release, enrollment information and university announcement as a convenient and low-cost mobile communication technology, SMS is experiencing a very rapid growth. Indeed, Philippines lead the Asia pacific region with the highest number of messages sent per user. The Caraga State University SMS based grade inquiry system was proposed to have a more convenient, faster and easier way of transactions. This study is concerned on how to provide a service to students residing in remote areas where internet connection is not available. Since the text based technology is one of the popular ways to access information, it provides the opportunity to save time and money, and in addition it improves the way of communication. It also helps the students access the information in anytime-anywhere basis at their own convenient time. This proposed system enables the student to save time, money and effort by just typing in at their mobile phone the keyword together with their ID number and password. Furthermore, these systems provide a convenient way of inquiring grade with just press and send way. The proposed system is offering the SMS service which can be used by all mobile phones. The user only sends the SMS to the system and the system will reply the answer back to the user as an SMS also. http://www.oppapers.com/essays/Caraga-State-University-Sms-Based-Grade Inquiry/576696
Isabela State University Sms-Based-Grade-Inquiry
The Isabela State University has increased in students’ population and at the same time, the number of works of the registrar and students’ grades to be processed has also increased. One of the responsibilities of the registrars’ office is to keep the students’ grades data secured for their academic records and purposes. The proposed Student’s Grade Inquiry of Isabela State University-San Mateo Campus through Short Messaging Service provides efficient and accurate grade reports. It intends to perform the following operations; study and develop the manual operation of the office of the registrar; find out what are the circumstances causes the delay of releasing of grades; Minimize the time consumed in searching for the grades of the students. http://www.oppapers.com/essays/Sms-Based-Grade-Inquiry/416591 Automation of Grading System in San Sebastian College
“Automation had a notable impact in a wide range of industries beyond manufacturing (where it began). Largely automated telephone switchboards and answering machines have replaced once-ubiquitous telephone operators. Medical processes such as primary screening in electrocardiography or radiography and laboratory analysis of human genes, sera, cells, and tissues are carried out at much greater speed and accuracy by automated systems. Applying automation to Grading systems wherein it will also make a task easy and accurate.
We all know that making an Automated Grading System means making the task for professors in computing and calculating grades will become easy and not only that the professors will have an advantage but the students will also get a gain, because it will also improve accuracy of calculations thus making the what we call “Hula of Grades” will become non – existent in the future of San Sebastian Recoletos.
San Sebastian College Recoletos – Canlubang lacks a centralized grading system. It does not have a standalone program that will accept input, compute grades and print class cards all in a same program.”
Synthesis
The prior researched literature and studies, associated directly and indirectly to the present research provided more insights about the nature and scope of the study, which is the feasibility of a Computerized Grading System with Short Message Service System for Bambang National High School. The campus implies that the existing system they are using causes delay in giving information for the students.
The study of Caraga State University SMS based grade inquiry system was proposed to have a more convenient, faster and easier way of transactions which is likewise the same with this study. Its primary concern is about on how to acquire convenience in getting information/data and how to lessen the burden of accessing information. This proposed system enables the student to save time, money and effort by just typing in at their mobile phone the keyword together with their ID number and password. Furthermore, these systems provide a convenient way of inquiring grade with just one click and it will send right away. The only difference is that students access the information in anytime-anywhere basis at their own convenient time even when they are at home while in the researcher’s study, there’s a limit in the area to which the students can access to the system and it’s only beyond the school premises. Another is that there’s no feature of enrollment information updates that is included within the researcher’s study. But still it gave a great impact to the part of the user because of the improvements brought to us by technology.
In San Sebastian College Automated Grading System study, it pertains to the manual recording of the student’s remarks. This study is advantageous to the researcher’s present study because it gave them an idea on how to improve the manual process of computing the student’s grades by means of technology. In this case, the researcher’s proposed system is much likely related to this study because the researchers are also creating a system like this wherein transaction is fast and at the same time data would be accurate. The only difference is that, they don’t have a centralized grading system and it does not have a standalone program that will accept input, compute grades and print class cards all in a same program. Meanwhile, it is not yet a successful system since it doesn’t have the capability to manage everything in a well-defined way. Therefore, the researcher’s study are much better because it is more convenient and time saving.
The Isabela State University is experiencing many problems regarding on the delay of releasing of grades, manual operation of the office of the registrar etc. These are only some of the problems that they encounter. Excessive numbers of the students is also another reason why students experience delays in getting their grades. In order to lessen the burden, the researcher made a way to resolve it so a system is proposed, it is the Student Grade Inquiry System which is somehow related to this study. This research is the same to what the researchers are doing. The main purpose here is to have a more convenient and easier way of getting information/data. In this study the researchers are focusing on how to administer a more efficient and fast way of accessing information without having delay or burden to the student. The only difference is that, this system is more accurate and reliable since it is much secured and well managed.
According to Cybercrime Law (2012), the input, alteration, or deletion of any computer data without right resulting in inauthentic data with the intent that it be considered or acted upon for legal purposes as if it were authentic, regardless whether or not the data is directly readable and intelligible. Illegal acts upon this will be subjected under case.
The related literature and studies have significant relationship and similarities with the present study in the sense that both are discussing about the benefits of having a computerized grading system that could replace the old system that is used. Likewise, the accessibility of information will be implemented by using the short message service system. Though in some point, there are rules and regulations that must be considered from Republic Act No. 10175 to avoid illegal acts.

Chapter III
TECHNICAL BACKGROUND

Technicality of the Project
Current System

Figure 1. Current System of Bambang National High School
The figure 1 above shows the existing grading system of Bambang National High School which uses Microsoft Excel to store data about grades. The students submits their work to the teachers. Then, teachers will grade the output of their students. The graded output will be submitted to the officer in charge in which he will compile the data submitted by the teachers. Students can only access their data by inquiring directly to the faculty or going to the officer in charge of student records. Details of the Technologies to be Used The scope of this section is about the discussion of the technologies being use in the development of the system. Table 1. Technologies Used in Developing the System Technologies | Descriptions | A. Software | My SQL Server | MySQL -pronounced either "My S-Q-L" or "My Sequel," is an open source relational database management system. It is based on the structure query language (SQL), which is used for adding, removing, and modifying information in the database. Standard SQL commands, such as ADD, DROP, INSERT, and UPDATE can be used with MySQL. | SQLYog | an easy-to-use, compact and very fast graphical tool to manage your MySQL database anywhere in the world. SQLyog is the most powerful MySQL manager and admin tool, combining the features of MySQL Workbench, phpMyAdmin and other MySQL Front Ends and MySQL GUI tools. | Ozeki SMS NG Gateway | Ozeki Message Server 5.6 is a powerful, flexible SMS Gateway application that enables you and your applications to send/receive SMS messages to mobile devices with your computer. It has an easy-to-use user interface, and an excellent internal architecture. The application can use a GSM mobile phone attached to the PC with a phone-to-PC data cable or IP SMS technology to transmit and receive the messages. | Photoshop CS6 | a raster graphics editor developed and published by Adobe Systems for Windows and OS X. Photoshop is an image editing software used by a wide range of media professionals to perform a broad variety of tasks ranging from combining images and photo correction to 3D object creation and even some frame editing for video. | Microsoft Visual Studio 2010 | VB.net-(Visual Basic .NET) is an object-oriented programming language from Microsoft. It is the .NET version of the Visual Basic (VB) programming language. Like all .NET languages, VB.NET uses the Common Language Runtime (CLR) for program execution. VB.NET is substantially different from traditional Visual Basic, which has been the most popular language for developing Windows applications. | B. Hardware | Laptop | A peripheral device used in the development of the application including programming, research and used to facilitate all the needed actions.With the following specifications:Processor Intel® Core™ i3-2400M CPU @ 1.66 GHz (4 CPUs) Storage Devices 500GBMemory 2GB DDR3Monitor LED 1366 x 768 (32 bit) (60Hz) | Mobile Phones | use for the SMS application. | Gateway Short Message (GSM) | 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, allowing SMS communication away from the home network. | GSM Modem | device that enables computers, facsimile machines, and other equipment to communicate with each other across telephone lines or over cable television network cables. In the strictest sense, a modem is a device that converts between analog signals, such as sound waves, and digital signals, which are used by computers. | How the Project Will Work

Figure 3. Proposed Computerized Grading System with Short Message Service System for Bambang National High School
Figure 3 represents the system where it shows how does the work flows and how the process being done. It is systematically/typically designed to make the manual system become more advance and modernize. To start with, students must have an output to be recorded by the teacher. When they are finished getting it, they are going to grade the students based on their output. The recorded grades should be already summarized. Teachers can now submit the remarks of their students to the IT administrator. Then, the administrator will be the one to compile the data to the database. When the information are being loaded, the system will now start to calculate the grades of the students and will generate the output which will be viewed by the students. On the other hand, student’s remarks can only be viewed when it’s already time of releasing the grades. But, in order to view it they will be using a technology which is their mobile phones. Their parents can also view their daughter’s/son’s grades in case they want to see it.

Chapter IV
METHODOLOGY
The purpose of this chapter is to present the methodology of this research as well its verification, validation, and testing. Specifically it discusses the environments specifications and design of the project.
Environment
Locale
This research investigation is conducted at Bambang National High School. As an institution of learning produces students who are knowledgeable, productive, and globally competitive and God-fearing citizens imbued with desirable values, skills, and attitudes and agents of social cultural transformation for the community and country as a whole through a very motivated and inspired teaching and non-teaching staff.
Population of the Study
The researchers conducted a survey regarding on the distribution of respondents. The students and the faculty and staff of Bambang National High School are considered in the study as respondents.

Frequency and Percentage Distribution of Respondents Respondents | Frequency | Percentage | Students | 2,148 | 97.64% | Faculty & Staff | 52 | 2.36% | Total | 2,200 | 100% |

Table 2. Frequency and Percentage Distribution of Respondents The table 2 above shows the distribution of respondents. There are a total of 2,200 respondents who is considered in the survey. Out of the total, 2,148 are students and 52 were Faculty and Staff.
Organizational Chart/Profile
Current Organizational Chart

Figure 4. Current Organizational Chart The organizational chart above displays the current state/rank of every faculty and staff of the school and their respective positions.
Proposed Organizational Chart

Figure 5. Proposed Organizational Chart The organizational chart as seen above shows the proposed version of the school’s faculty and staff positions wherein the other Clerk became an IT Administrator.

Requirements Specifications
Operational Feasibility
Fishbone Diagram

Figure 6. Fishbone Diagram
Figure 6 above shows the fishbone diagram, it is one of the most effective method to track the root cause or problem of the agency or at the area to where the study were being taken which is the school, fishbone method is being used because researcher can determine what problems are going to solve when the system is being implemented. The diagram above shows what are the data gathered by the researchers. It shows the current cause and effect of the current system of the school wherein the 4 long lines are the main problem (Time, Teachers, Environment and Administrator). The medium lines are the sub-problems and the short lines represents the specific problems.
Functional Decomposition Diagram

FDD is a diagram that shows the breakdown structure in smallest component of the system that the researchers are going to develop after studying and analyzing the data that are gathered in feasibility and planning phase. This will help track the functionalities of the system. This diagram shows all the processes of the system.
Technical Feasibility
Compatibility Checking The system can run only in windows operating system. It needs a screen resolution of 1024 x 768 and must have at least 1.66 GHz speed of processor.

Table 2. Hardware Compatibility Checking Requirements Hardware | Specifications | Processor | 1.66 GHz up | Storage Device | 100 GB and up | Monitor | LCD or LED Screen, 1024 x 768 resolution |

Table 3. Software Compatibility Checking Requirements Software | Specifications | Operating System | Windows Operating System | Visual Studio Professional | 2012 | MySQL Server | version 5.6.2 | SQLYog | version 5.6.4 | Ozeki SMS Gateway | version 5.6 |

Table 4. Relevance of the Technologies Used Technologies | Function | Software | Server:Ozeki SMS GatewayMySql Server 5.6.2 | * use in sending and receiving sms (short message service) * use in connecting database to other application * refers to the back end of the system and gathering of all data | Database:SQLYog 5.6.4 | * use to create database and store data * ideal solution for MySQL administration and development | Coding:Visual Studio Professional 2012Ozeki Batch SMS | * use to create the program core of the system * use to view the log details about the sms transactions | GUI:Visual Studio Professional Design 2012Adobe Photoshop CS6 | * use in designing the system * image editing software use by a wide range of media professionals to perform a broad variety of tasks | Hardware | Laptop | * A peripheral device use in the development of the application including programming, research and others which are used to facilitate all the needed actions. |

Schedule Feasibility
Gantt Chart

Figure 8. Gantt Chart Time management is the foundation of conducting the project. By using Gantt chart, researcher follows the scheduled assignment to have a guide and to help them keep in track on what are the things that must be done in every day. In this project we have this specific list to complete our proposed system; Computerized Grading System with Short Service System. We arranged it by week so it can clearly show the breakdown of the entire task we did. We started from the year 2014 and the first thing we did is the selection of group mates and distribution of roles and tasks to each member. After we had our groupings, we’ve started our proposal for the month of December 2014. As soon as we had finished our approval, we began the development of the system as well as the chapters 1-4 and we started it on the 2nd week of December until the month of March 2015.
Economic Feasibility
Cost and Benefit Analysis Table 5. People Ware Classification of the Proposed System People ware | Salary | System Developer | Php 25,000 per monthPhp 25,000 to 50,000 per 1 /complete system | System Administrator | Php 25,000 per month |

Table 5 shows the people ware and their respective salary. System developer is the one who develop a system depending on the client’s request. A one whole system cost for about 25 to 50,000 Php. System Administrator is the one who manage upgrade and maintain the installed system.
Table 6. Software Classification of the Proposed System Software | Cost And Benefit | MySQL Server | Free/ Downloadable | SQLYog | Free/Downloadable | Adobe Photoshop CS6 | Free/Downloadable | Ozeki SMS NG Gateway | Free/Downloadable | Visual Studio Professional 2012 | Free/Downloadable |

Table 6: The table above shows the software classification (MySQL Server, Adobe Photoshop, SQLYog, Ozeki SMS NG Gateway and Visual Studio Professional) that is used in the making of the proposed system which are free and downloadable.
Table 7. Hardware Classification of the Proposed System Description | Cost | Desktop | Php 20,000.00 | Modem | Php 3,000.00 |

Table 7: The table above shows the estimated cost in buying a desktop computer that will be used to run the system.
Cost Recovery Scheme Benefits | Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | Total | Honorarium, Perdiem, Incentive Expenses | [936 ,000] | 936 ,000 | 936 ,000 | 936 ,000 | 936 ,000 | 3,744,000 | Office Supply | [8,000] | 8,000 | 8,000 | 8,000 | 8,000 | 32,000 | Total benefits | | 944,000 | 944,000 | 944,000 | 944,000 | 3,776,000 | Development cost | | | | | | | Server | 20,000 | | | | | 20,000 | Subscription | 20,000 | | | | | 20,000 | Modem | 3,000 | | | | | 3,000 | System software | 25,000 | | | | | 25,000 | Development Labor | 400,000 | | | | | 400,000 | Total Development Cost | 468,000 | | | | | 468,000 | Operational Cost | | | | | | | Hardware | | 25,000 | 25,000 | 25,000 | 25,000 | 100,000 | Electric Utilities | | 20,000 | 20,000 | 20,000 | 20,000 | 80,000 | Maintenance Labor | | 100,000 | 100,000 | 110,000 | 115,000 | 425,000 | Total Operational Cost | | 145,000 | 145,000 | 155,000 | 160,000 | 605,000 | Total Cost | 468,000 | 145,000 | 145,000 | 155,000 | 160,000 | 1,073,000 | Total Benefits - Total Cost | (468,000) | 799,000 | 799,000 | 789,000 | 784,000 | 2,703,000 | Cumulative Net Cash flow | (4680,000) | -331,000 | 1,130,000 | 1,919,000 | 2,703,000 | | Return on investment | 2.55% (2,703,000/1,073,000) | Break-even point | 0.55 years (3 yrs. Of negative cumulative cash flow + [784,000-2,703,000] /784,000 = -2.45) |

Table 8. Cost Recovery Scheme
Table 8 above shows the total cost of the hardware/software used in the development and how long would it take to for the investment to return.
Requirements Modeling
Input
* Students must send keyword to the system to have an access to their grades. * Students must enter their ID number as well as their password whenever they want to log in. * Teachers must submit the grades to the administrator.
Process
* The system must automatically generate and send the students grades whenever they want to see it. * Users must be notified when they make an invalid request in sending the keyword to the system. * Administrator must read the daily log of sms server to check and verify sms transactions.
Output
Performance * The system must receive and send 10 messages per second. * The keyword maximum capacity must be 5 characters.
Control
* The student’s records must be added, updated, or deleted only by the administrator. * The system must provide log-on security at the system application level. * Only teacher can validate the grades.

Data and Process Modeling
Context Diagram
Figure 9. Context Diagram
The diagram shown below shows the whole process of the system.

Data Flow Diagram
The DFD shows the data process of the entire system. It depicts the complete process of the system and its various functions. The diagram consists of entity, flow of data, process and data store. Using this diagram, the researchers were able to visualize how the data should flow through the system.

System Flowchart

Program Flowchart

It is used to describe the flow of data through a particular computer program, showing the exact sequence of operations performed by the program in order to process data. Different graphic symbols are used to represent data input and output, decisions, branches, and subroutines.
Risk Assessment/Analysis Identification | Threats | Preventive Control | Corrective Control | Data | Data Loss | Implement data security policy for confidentiality purposes | Implement recovery plan and create daily back-up | | Data Tampered or Corrupted | Limit the data availability for users | Implement maintenance and create back-up for critical data | System | Server Failure | Inspect the system regularly, secure back-up server | Fix/replace primary server, if back-up server fail | | GSMS not working | Inspect the modem regularly and implement recovery plan | Check the hardware for defect or install new GSMS if server back-up failed | | System stop working | Implement recovery plan and back-up system | Use backup for the system if system failed | Security | Security software corrupted, unauthorized users | Implement security policy, use SSL for securing data | Obtain or update security system software | Virus | Virus infected the data of the system | Install anti-malware software | Change or check the capability of your security software |

Table 10. Risk Assessment Analysis Table 10: The table above shows the possible problems that the system may encounter and its possible solution for every specific problem.
Design
Output and User-Interface Design
Forms
Reports
Data Design

Entity Relationship Diagram

Figure the ERD above shows the relationships of tables in the database. The significance of having an ERD is that we can trace the connections of tables and how normalize the tables is.
Data Dictionary Logon_Info | Field Name | Data Type | Data Format | Field Size | Description | Example | Logon_ID | int | 12345678 | 8 | Unique eight-digit number | 00000001 | Username | varchar | Abc_123 | 32 | Name that uniquely someone to access in the system | admin | Password | varchar | Abc_123 | 32 | Hidden characters to access the system | password |

Student_Info | Field name | Data Type | Data Format | Field Size | Description | Example | Student_Number | int | 12345678 | 8 | Identification of the student | 1236789 | First_Name | varchar | Abc | 30 | First name of the student | Christine | Middle_Name | varchar | Abc | 30 | Middle name of the student | Octavo | Last_Name | varchar | Abc | 30 | Last name of the student | Legaspi | Birth_Day | int | 123 | 15 | Birthday of the student | 10 | Birth_Month | varchar | Abc | 15 | Birth month of the student | December | Birth_Year | int | 123 | 15 | Birth year of the student | 1993 | Gender | varchar | Abc | 10 | Gender of the student | Female | Address | varchar | Abc | 250 | Address of the student | Salinas, Bambang, Nueva Vizcaya | Contact_No | varchar | 123 | 25 | Contact of the student | +639123456789 | Age | int | 123 | 3 | Age of the student | 21 |

Subject_Info | Field name | Data Type | Data Format | Field Size | Description | Example | Subject_ID | int | 12345678 | 8 | Unique eight-digit number | 09823654 | Subject_Desc | Varchar | Abc | 100 | Description of the subject | Heat and Electricity | Subject_Name | varchar | Abc | 20 | Name of the subject | Science |

Grades_Info | Field name | Data Type | Data Format | Field Size | Description | Example | Grades_ID | int | 12345678 | 8 | Unique eight-digit number | 00100200 | Scores | int | 1234 | 10 | Non-decimal numbers | 100 | FirstGrading | float | 12.00 | 50 | Grade in the First grading | 98.10 | SecondGrading | float | 12.00 | 50 | Grade in the Second grading | 92.34 | ThirdGrading | float | 123 | 50 | Grade in the third grading | 89.00 | FourthGrading | float | 123 | 50 | Grade in the fourth grading | 98.24 | Equivalent | float | 123 | 10 | Percentage use in computing grade | 78.90 | FinalGrading | float | 123 | 50 | Total with average | 87.45 | Average | float | 123 | 10 | The mean of grades | 89.0 | Total | float | 123 | 10 | The total grades of the student | 128.9 | Section_Info | Field Name | Data Type | Data Format | Field Size | Description | Example | Sec_ID | Int | 12345678 | 8 | Unique eight-digit number | 00000001 | Sec_Name | varchar | Abc | 32 | Name of the section | Wisdom / A | Year | int | 123 | 2 | Year of the student | 5 |

Table 11. Data Dictionary
Table 11: The table above shows the specific attributes or entity. To further understand the data being saved in the database, the dictionary will help to show the fields of the tables.
System Architecture
Network Model
Network Topology
Security
Logon id and password Any user who uses the system requires to have logon id and password.
Modification
Any changes shall be synchronized and only by the IT Administrator.
Teacher Rights Any information regarding students shall be provided and validate by the teacher only.
IT Administrator Rights IT Administrators shall be able to do changes with the permission of the Head of the School only.
Students Rights Students have the right to know the information they ask with the permission of Administrator only.
Maintenance
Only the IT Administrator has the right to do maintenance with the permission of the Head of the School.
Development
Software Specification * MySQL * SQLYog Enterprise * Ozeki SMS Gateway * Visual Studio Professional 2012 * Adobe Photoshop CS6
Hardware Specification * Computer/Laptop
Processor : 1.66GHz up
Storage : 100 GB up
RAM : 4 GB DDR3
Program Specification * Adding of new student, update and delete information of a specific student. * Student grades will be automatically computed.
Programming Environment

Figure
Deployment Diagram

Bibliography
A. Published Books/Journals/Dissertations
Gabriel, D. (2012). “Computerized Grading System” Retrived from: http://www.studymode.com/essays/Computerized-Grading-System-1371670.html
Gorienko, et. al. (2003). “Grade Encoding and Inquiry system via SMS” Retrived from: http://www.slideshare.net/aitianbao/thesis-in-it-online-grade-encoding-and-inquiry-system-via-sms-technology?related-literature.html
B. Website Sources http://www.studymode.com//essays/Automated-Grading-System-with-SMS-Notification-876893 http://www.studymode.com/essays/SMS-Grade-Inquiry-System-1081115 http://www.oppapers.com/essays/Caraga-State-University-Sms-Based-Grade Inquiry/576696 http://www.oppapers.com/essays/Sms-Based-Grade-Inquiry/416591 http://sissat-grading-system.googlecode.com/svn/trunk/Documentation/Grading%20System%20Documentation.doc.
http://proceedings.informingscience.org/InSITE2007/IISITv4p227-234Adag332.pdf