Online Grading System Capstone Project Document

Technology was the one that control the business industries today; it could make human works easy and efficient. The different system was made for different purpose. Having a system to an organization was one way to have an innovation it is the start of having an efficient work for every employees and client. We as student conducted study on our school on how can we help the student and the instructor to have an efficient output in having a grade of a student online and generating reports of the students and instructor, and help the instructor put the prelim, midterm, and final grades of the student online.

They want an innovation that could benefit both students and school. Human was never contented of technology, and other services, Now a days companies was always formulating some ideas and techniques to full fill the needs and wants of the people. We also as a student’s we are never contented, us always want improvement especially in services. Improvement that could benefits our own school. And as an information system student, we the proponents gather information and formulating ideas and propose the ABC COMPANY ONLINE GRADING SYSTEM. We propose this system because it will be effective in a way

That the faculties enable to encode the grades through this system. This system is one way of helping the registrar to work more efficient and it is one way of helping the Students to have a web based grading inquiry.

Background of the Study.

People formulating ideas to invent or to have strategic methods to make some best solutions and innovation to their business .and we as an IS student we conduct some study on our school and we ask some feedback from the students regarding on the how they give the grading system from registrar office to students on ABC Company . As an information Ssystem student we formulated some ideas and we proposed the online grading system that would make their lives easier.

The current system was stand-alone system, and it can only access by the registrar office. They use the old system for many years but as time passed by student want more effectively and efficiently grading system that they can access anytime. There are some situations that if they want to get there grades on the day of enrollment, the registrar cannot accommodate all of the students, and the another problem is they cannot give the grades of a student if it is incomplete. The proponents propose an Online Grading System. It is accessible to phones and this system will really help them in a way that they don’t need to fall in line on the registrar office. The proponents provide a system that is very helpful for the information system instructor and students because in this system the instructor can encode also there grades through online like quizzes, eexam and some other activities by using the current standard grading system of the school.

Statement of Objective

The study intended to provide an easier way to release the grades of the student every last semester .To design and develop the a grading online information system that can be able to access the grades of student of ABC Company , the current system will be upgraded into online so that it could access by students anywhere.it also aim that the teacher can encode the grades of the students online.

Conceptual Framework

A conceptual framework is an analytical tool with several variations and contexts. It is used to make conceptual distinctions and organize ideas. Strong conceptual frameworks capture something real and do this in a way that is easy to remember and apply.

Input Process Output

Encoding the teacher load and students subject

Calculating of Prelim, Midterm, and Final Grades

Population reports and filtering different subject reports, teachers, student load

Figure 1.0 Conceptual Framework of the System

Scope and Delimitation of the Study

The study has also a scope and its limitation that they are deal with. The study has their different function and uses. The scope and delimitation will discuss separately

Scope of the study

Our study has consisted only the grades of the students every last semester, the study will be more focusing on providing the grades of students and they can print it out. The faculty can encode the Prelim, midterm and final grades of the students through online.The system will have the reports of the population in the school specifically courses, the name of the students and the Teachers load.The filtering of the subjects, It will provide the grades of every current semester .It will provide its own id number for user.

Delimitation of the study

The study has their own limitation will be discuss by the following; this study does not cover the subject evaluation and the ranking of the dean’s list. The enrolment record of the students does not cover of our system.

The schedule of student and accounts does not cover by our study and it will not provide the grades of the students on his past grades. It does not also provide the grades to be authenticated for the scholars or other purposes. They have to go to the registrar, for authentication. If the instructor submitted wrong grades of the student, the grading information system is not reliable in the human error. Only registered ID numbers are qualified to inquire their grades and it will not cover the instructor’s schedule.

Significance of the study

Everything that the proponents created has its significance and importance. The proponents were created an online grading system for ABC Company – Fortune Towne Campus only for Bachelor of Science in Information system instructor and students only.

The study will benefit as follows:

The Proponents – we will be the one who can benefit the system because we made this system for our thesis project.

School- the school could also benefits from this system in a way that they can help them in accreditation of the school

Faculty- They has an access to the system because they can record the prelim, midterm and final grades of the students through online.

Registrar – it will lessen their work on the time of realizing the grades, and only small amount of the students will get their grades on that day, and the admin could generate the report.

Students – This system could provide their grades anytime they want it could also help them to save time because they don’t need to go on the registrar office.

Definition of term (Conceptual) (Operational)

Database

– A collection of pieces of information that is organized and used on a computer.

– Database also called electronic database, any collection of data or information that especially organized for rapid search and retrieval by a computer. Database is structured to facilitate the storage, retrieval, modification, and deletion of data and conjunction with various data-processing operations (“Database,” n.d.)

Encode

To put information of someone to database

– convert into coded form. Using this technique makes it possible to encode and transmit recorded video information. ((“Ed,” n.d.)

Internet connection

an electronic communication network that connect computer networks and organizational computer facilities around the world

– Internet connection option varies by internet service provider and by region. Customer should consider some of the following factors before selecting an internet package: speed or bandwidth, cost, availability, reliability, and convenience. In order to determine what internet plan is right for you (“Internet Connection,” n.d.)

ABC COMPANY Online Grading System

– A system that is made by the proponents to make innovation on school.

– software description computer studies society, online grading system is an system that that uses internet that allows faculty to manage class grades and submit grades. (“ABC COMPANY Online Grading System,” n.d.)

Proponents

The name of the group who made the system-A person who advocates theory proposal, or course of action ((“Ed,” n.d.)

Registrar

An official record or a keeper of records: as an officer of an educational institution responsible for registering students, keeping academic records, and corresponding with applicants and evaluating their credentials.

-An official responsible for keeping a register of official records. She/he is also the chief administrative officer in the university. ((“Registrar,” n.d.))

Semester

– One of two usually 18-week period that make up an academic year at a school or college.

-A half year-term in a school or university, especially is North America, typically lasting for fifteen to eighteen weeks ((“Ed,” n.d.)

Update

A change or addition to computer software that includes the most recent information.

-An update is a software file that contains fixes for problems found by other users for the software developer. Installing an update fixes the code and prevent the problem and happening on your computer.

Because updates fix problems with a program. They are usually free and available through the program or the companies’ websites ((“Update,” n.d.)

Research Literature

In this chapter discuss the related study of the local and foreign literature that used the same system. We gathered this information from sites that they are using now a day for their own school or companies.

Related concept

(Local Related Concept)

The enrolment and registration System (ERS) is a system developed by the University Information Technology Centre (UITC) to computerize the enrolment processes in the University. The latest module of the ERS is the Students Report of Grades Module that allows students to verify their grades and the faculty members to preview their grading sheets through the TUP website. . (n.d.). Https://Www.Tup.Edu..Ph

Terms and Conditions

TUP reserves the right to suspend or cancel any account without due notice. The use of this application is intended only to help students or faculty members in viewing their grades or their grading sheets, respectively. The official records for rating slips and grading sheets can only be issued by the Registrar’s office. (“Terms and Condition,” n.d.)

(Local Related Concept)

Asia Pacific College online Inquiry

This leads students to the flowchart viewer, grades viewer, registration, and subject offering viewer.

Online Alumni Search

The Alumni Search is intended for companies interested in hiring APC alumni. It is intended as an initial background investigation for our alumnus. The official record and full details must be requested at the office of the College Registrar. The student number shown on the documents presented is required as entry point for the Alumni Research. This system is still in the process of updating its database. For further assistance, please direct your inquiries at. (“Asia Pacific College Online Inquiry,” n.d.)

(Foreign Related literature)

What is class base?

Class base is an online education database providing information on education systems and academic institution around the world

About University Rankings

Class base are university rankings are a web ranking that indicates the importance of the Global online presence of colleges and universities rather than these two indicators. Online presence is a good indicator of the significance, popularity and breadth of content provided by an institution on the web. More popular and respected institution tends to rank higher as a result.

Class base rankings are calculated using web services such as Alexa, Bing, and goggle. These services use proprietary algorithms to determine the importance of a specific institution online presence, which means we have no direct influence over the rankings our methodology is tailored toward anyone looking for a quick overview of the academic institutions in different Countryy.

The Lovely Professional University (2011) promotes a culture of paperless University. The day to day administration and most of the University procedures are carried out online. The University Management System (UMS), an online portal of University, is one such innovative step of the University to provide vital information regarding academics and other University logistics for assisting the University students, their parents and the staff.

According to Wikipedia (2014), in the past, universities and large school districts in particular have created their own bespoke student record system. One such example in the Repository of Student Information (ROSI) system at University of Toronto. With growing complexity in the business of educational establishments, most organizations now choose to buy customizable software, and increasing numbers are buying software as a service (SAAS). Most student information systems in use today are server-based, with the application residing on a central computer server, and being accessed by client application at various places within and even outside the school. (“Class based University Ranking,” n.d.)

Synthesis

The group was conducted an interview on some students of the school and research some information in the internet who use also an online grading system. We also gather data, all the information on how they put this kind on concept about the system from other schools. This information also helps us to conduct ideas that could help the school and the students. We put all our ideas and combine to have this kind of system.

We as an Information system students propose Online Grading System that could help our own school to have a grading system that is accessible from the students. The system is the easy way to look and have their grades using online. The Proponents proposed also this system to provide a starting point for college to consider their online encoding of grades and it will also help to provide the number of reports of the student, subject, teacher and overall population of the school.

Reated System

Methodology

In this chapter, introduce the research strategy and techniques applied by the proponents. The proponents give the interrelation between the different sections of the chapter. This chapter defines the different data gathering procedures and research methodology that were used and upgraded online system. The system development life cycle (SDLC) may discussed by the proponents by an easier way and understand manner through basic process are as follows; Planning Phase ,Analysis Phase, Design Phase, Development Phase, Testing Phase, Implementation Phase, and Maintenance Phase. This stage may discuss further about the online grading system. The Proponents Use Laptops with the operating System of windows 7and we used sublime to edit text in html; for the design development the proponents used also CSS in order to make the system clear and easy to access. The proponents use PHP for server side scripting language and the proponents use MySQL for database.

Planning Phase

.The proponents found that the school has a problem encountered by the students of ABC Company by getting there grades every last semester. In this stage the Proponents formulating ideas on how to upgrade the system and help the students, faculties and registrar. The proponents gather the ideas of each in every one of them and decided on what are the study tittles of what they are going to propose. After they conduct study on each company, they rank their tittles according on what they will prioritize.

Analysis phase

In this phase, the proponents gathered and processed all the data information that having from the time of interview and survey from the desired Company or client. After the panelist choose the Online Grading Information System we the proponents conducted research on idea in the books and the internet on what we are going to do to made the system successfully. We analyzed what we are going to do on the system and what are the steps that we are going to take.

Design Phase

Iterative and Incremental Waterfall Model

Iterative and Incremental Waterfall Model

In design phase we plan of what kind of looks or what is the best style or art that we will be having on our system. We decided to used iterartive and incremental waterfall model because thae flow of our system is on going process through its end.

The Proponents used various laptops and computer, with the operation system of window 7 and latest version of OS; Sublime text to edit text for HTML; BOOKSTRAP for the markup languages, for the design development, the proponents used CSS in order to make the system clear and easy to access. The proponents used PHP for server side scripting language and MYSQL for database.

Development Phase

The system develop to reached the desire of the client or the company specifically the ABC Company -Fortune Towne (ABC COMPANY -FT) to have an web based recording of prelim, midterm and final grades of the student to also a web based online grading inquiry.

All the information that have been gathered and analyzed the proponents create what will be the face of the system and after that, they start the hand coding, creating table and creating data flow. The proponents are working for the system and it is the stage for making there documentation. This phase we measure what are we have done and what are the development of the system.

Testing Phase

In this phase, the proponents conduct experiments or dry ran to test the efficiency and the effectiveness of the system. It refers about checking

Stage of the system made where able to identify all the errors and malfunctions of the system this test is the bases if the system that made by a proponents is successful and the company or the client would be satisfied. We will conduct the testing in a school which is the user is the teacher and the student. If it is successfully, it depends on

The proponents or the company if they would implement it. The instructor will put the grades on teacher dashboard and the student will

View his/her grades in student dashboard using its own id number and password.

Implementation Phase

After the testing phase run, successfully this would be the time that the proponents take actions to implement the system. The proponents will coordinate on the school to implement the system it should be connected on the goggle to be search and used by the users. The users will be the instructor and the students.

Maintenance Phase

In the maintenance, phase the system need maintenance before end of the semester to update the grades of the students on the database.

The system needs maintenance to maintain the functionality and the have the correct grades information of the students. The admin can also update what are the new subjects offer, courses, and name of the new students on the school. This purpose is relevant for the maintenance of the system, which can be offered functionalities, and performances of the system and every time that the client will addressed the proponents in updating and enhancing the existing system.

User’s Acceptance Survey

In this section, discuss the target population or a set of person that could benefits from this study. The proponents target to help the school, the student, the registrar and instructors. The proponents target the students in a way that they will provide an accessible online grading for them, and through this system they can get there grades even if the some of the instructor did not submit the grades yet. For the instructors the proponents design a system that could record the prelim, midterm, and final grades. The admin or the registrar, this system could help the admin to see the population reports of the school specifically the teachers load, number and the name of the students in the specific course, year, and section

Figure 3.1: Gantt chart

Gantt Chart

Requirements Specification

Operational Feasibility

This study aims to develop the different functionalities of the system:

Program Environment

Front End

In front, end is the system architecture for the users. The front end is where the users input there information when they do not have an account yet and if they have already, they can log in in front end. In this study the proponents used PHP language for scripting while HTML, and BOOTSTRAP for users interphase .The proponents use CSS style for design. It has only one log in which can identify the user level

Back End

In the back end is the server side of the system. The proponents used MySQL for database. And PHP for coding the system. MySQL is a database system used with PHP. It is a database system used on the web. A database system runs on a server. It is ideal for both small and large applications. MySQL is very fast, reliable, and easy to use. It supports standard SQL. It compiles on a number of platform, it is also free to download and use. MySQL is responsible for data storing of the system.

Technical Feasibility

Hardware Specification (Minimum Requirements)

Software Specification (Minimum Requirements)

System Architecture

In system architecture, display the network structural design of the system where in the users can access the system through internet based.

System Architecture

Cost Benefits Analysis

The cost benefits analysis or CBA is the estimated price or value of money of the benefits and costs of the system in order to determine whether it is profitable and worth for investment.

Table 3.0 Developmental Cost

Developmental Cost Duration Monthly Cost Total Amount
Programmer 24,000.00
System Analyst 30,000.00
Project Manager 33,000.00
Internet Connection (PLDT) 11,400.00
Electricity .00 3,000.00
=101,400.00

Table 3.0 shows the total developmental Cost of the propose system. It indicates proponent’s salary and the cost researching.

Table3.1 Operational Cost

Operational Cost Duration Monthly Cost Total Amount
Electricity 6,000.00
Maintenance Fee 12,000.00
Internet Connection (PLDT) 22.800.00
=40.800.00

Table 3.1 shows the operational cost of the propose system. It contains the maintenance cost and expenses in using then propose system.

Table 3.2 Developmental and Operational Cost

Total Amount
Total Developmental cost
Total Operational Cost

This table shows the total amount of the developmental cost and the operational cost of the system.

Table 3.3 Benefits of the System

Benefits of the System (Annually) Total Amount
Efficiency of work/output of employee
Work Management of employee
Internet connection (PLDT)

Table 3.3 shows the benefits of the system.

Table 3.4 Cost benefits Analysis

Cost Benefit

This table above shows the Cost Benefit Analysis or CBA of the proposed system. Each figure has a corresponding data as shown in the table given. The Payback Period came out as 3.96 with an ROI or Return of Investment of 26%.

Data Dictionary

In this table represent, the database of the system .It includes the database of the students, semester, users, school year, course, and grade.

Table 3.1: Data Dictionary

Admin

Column Type Null Default Comments
Id Int(11) No None
Id num Int(11) No None
Password Varchar(100) No None
Fname Varchar(100) No None
Lname Varchar(100) No None
Mname Varchar(100) No None
Birth Int(11) No None
Status Varchar(100) No None
Gender Varchar(100) No None

Course

Column Type null Default Comments
Id Int (11) No None
Courseid Varchar(30) No None
Description Varchar(300) No None

Exam

Column Type null Default Comments
Id Int(11) No None
Idnum Int(11) No None
Term Varchar(100) No None
Subject Varchar(100) No None
Score Int(30) No None

Notification

Column Type null Default Comments
Id int(11) No None
Position Varchar(100) No None
Message Varchar(100) No None

Prospectus

Column Type null Default Comments
Id Int(11) No None
Coursecode Varchar(30) No None
Year Varchar(30) No None
Semester Varchar(30) No None
Subject Varchar(30) No None

Student

Column Type Null Default Comment
Id Int(11) No None
Fname Varchar(30) No None
Lname Varchar(30) No None
Mname Varchar(30) No None
Idnumber Varchar(30) No None
Password Varchar(30) No None
Course Varchar(10) No None
Yearlevel Varchar(30) No None
Section Varchar(10) No None
Gender Varchar(30) No None
Status Varchar(30) No None
Bday Varchar(30) No None

Student Subject

Column Type Null Default Comment
Id Int(11) No None
Subject Varchar(30) No None
Section Varchar(30) No None
Course Varchar(30) No None
Level Varchar(30) No None

Subject

Column Type Null Default Comment
Id Int(11) No None
Subject_id Varchar(30) No None
Title Varchar(30) No None
Unit Varchar(30) No None

Teacher

Column Type Null Default Comment
Id Int(11) No None
Fname Varchar(30) No None
Lname Varchar(30) No None
Mname Varchar(30) No None
Idnumber Varchar(30) No None
Password Varchar(30) No None
Work Varchar(30) No None
Gender Varchar(30) No None
Status Varchar(30) No None
Bday Varchar(30) No None

Teacher Subject

Column Type Null Default Comment
id Int(11) No None
Teacher Varchar(30) No None
Subject Varchar(30) No None
Section Varchar(30) No None
Course Varchar(30) No None
Level Varchar(30) No None

User

Column Type Null Default Comment
Id Int(11) No None
Idnumber Varchar(30) No None
Password Varchar(30) No None
Position Varchar(30) No None

Data Flow Diagram

Data Flow Diagram

Data Flow Diagram

Figure 5.0: data flow diagram of the system

Entity Relationship Diagram

ERD

Figure6.0: Entity Relationship Diagram

Presentation, Data Analysis and Presentation of Data

The Chapter will exhibit the results of the User’s Acceptance Survey conducted for the system of ABC Company -Fortune Towne, Online Grading System that will be implemented at the current School.

Presentation

The proponents demonstrate how to use the system to the specific users, which is the student, and the user. In addition, after they know how to use the system they will be given the user’s acceptance survey sheet, which is, they will evaluate how much the system is helpful and efficient. Proponents discuss what system all about and they demo on how to use the system in every users in conducting survey.

Data Analysis

After the proponents conducted survey they collected, they collected each data information and analyzed the evaluation of respondent and their different comments on the system.

Characteristic of Respondent

Every people has different characteristic and impression after the proponents present the system to them some are satisfied and others want some improvement that would make the system more creative and much more easy access to them of some data works.

Frequency of Respondents

Table4.0

Respondents Frequency
Admin
Instructor
Student

The table shows the number who has been answered the user’s acceptance survey. The researchers got the total number of respondent who evaluated the system.

Reliability of the System

The data information who gathered by the proponents have undertaken by acceptable approach through using the Yamane’s Formula in order.

e=level of precision 0.05(5%)

Solution:

n=29.92

This solution explains the summation of getting the example size (n) of the population that will be taking the users acceptance survey.

Interpretation of Data

The user’s has given a user’s acceptance survey which they can evaluate how system is really useful, this survey has a questions for each of the system quality performance requirements. Regarding the following the effectiveness or the (functionality of the system) the efficiency or the (usage simplicity) the quality, timeless and productivity. It has a number that indicate how they satisfied in the system the rating scale are 1-5 a score of 1 is very dissatisfied, 2 dissatisfied, 3 neutral, 4satiesfied and 5 for very satisfied

Rating Scale

Range of mean Verbal Interpretation
4.21-5 Very satisfied
3.21-4.20 Satisfied
2.61-3.40 Neutral
1.81-2.60 Dissatisfied
1.00-1.80 Very dissatisfied

This table shows the range of mean and its verbal interpretation.

Table 4.1: survey result for effectiveness

Effectiveness

Question 1 Question 2 Question 3 Question 4 Total
Mean 4.467

This table above show effectiveness as a whole has an average mean of 4.325 interpreted as very satisfied the sub categories of which like competences and accuracy of the system.

Table4.2: survey result for effectiveness

Efficiency

Question 1 Question 2 Question 3 Question 4 Total
Mean 4.6

The table above shows the efficiency average weighted means 4.52 interpreted as very satisfied the sub categories of which like ease of use. The ability of user to easily perform required task.

Table 4.3: survey result for Quality

Quality

Question 1 Question 2 Question 3 Question 4 Total
Mean 4.6

The table above shows the efficiency average weighted means 4.12 interpreted as satisfied. The table represent the evaluation of the users how satisfied they are in the quality of the system.

Table 4.4: survey result for Timeless

Timeless

Question 1 Question 2 Question 3 Question 4 Total
Mean 4.23

The table above shows the efficiency average weighted means 4.12 interpreted as very satisfied. The subcategories of which like system accessibility the system is accessible to users as long they have internet connection.

Table 4.5: survey result for Productivity

Productivity

Question 1 Question 2 Question 3 Question 4 Total
Mean 3.40

The table above shows the efficiency average weighted means 4.12 interpreted as satisfied. The subcategories of which like user’s assistance providers that users with procedural documentation to minimized operational errors.

Summary Of findings, Conclusion, and Recommendation

This chapter present the summary of research work of undertaken the conclusion drawn and the recommendations made as an outgrowth of this study.

Summary Of findings

This study conducted to have and Online Grading System in this school which is the student can see their grades through the id number that is generated by the system and at the same time to have an filtering in the instructor which is they can filter the . And its paper less because the students don’t need to go to the registrar office and have to fall in line to get their grades. This system is also helpful for them to be more efficient because the student can easily access their grades even they are not in school. Online Grading System is to taking up the current grading system to web. The main purpose is to view the grades of the student using internet and it can filter the population or the load of the teacher. It is designed to instructors to input the prelim, midterm, and final grades on the web and to have an automatic calculation easy and detailed.

Conclusion

To sum up the proponents found that the system is functional and accessible when you have internet connection the system incorporates a database that shall handle all information with regards to the students and its transaction process. The system can help the students to get the information from the actual source at their own convenient time through online. It gives the user to acquired reliable Online Grading System on the internet

Recommendation

From the findings and conclusions of the study, the following recommendations are requested:

  1. The school should purchase domain name that could help the user to find the ip address easily
  2. The system should have a pop up alert to know if the process has successfully done.
  3. Have a security make it with password