online grade submission

PHILIPPINE ADVENT COLLEGE
SCHOOL OF COMPUTER STUDIES

Thesis Proposal

ONLINE GRADE SUBMISSION AND INQUIRY SYSTEM

Proponent: JIRALD P. VIDAL
ESAU S. CAIRAS JR.
REY A. LADIAO
CRISELA GUMALAL
CHAEL JACOB
IRESH C. DAAS

Course: Bachelor of Science in Information technology

School Year: SY 2013-2014

ABSTRACT

Online Grade Submission and Inquiry System has now become a part of our institution. Time to time Grade submission and inquiry online will contribute considerable aspects. Online users should be registered first to create their individual accounts for submission and inquiry. The registrar, teachers and students will have their user name and password. They will use their own password for privacy as well as to recognize individuals and at the same time they can be able to submit, for teachers, inquire grades, for registrar and students. This system holds multiple accounts that can be use at the same time, anytime, anywhere online. All users of the system will be able to change their own user names as well as their passwords any time without losing any records.
This system is an instrument that allows teachers to list students, who enrolled to his/her subject, add, delete and submit their grades. By the use of our grades evaluator made from MS Excel, solving grades will be more easy and fast.

KEY WORDS: Online, Inquiry,

1.1 BACKGROUND OF THE STUDY

A lot of parents are neither aware nor updated on their child’s performance in school; they did not know the grades that their child had received. Usually, students do not want to show their grades to their parents or their parents live in a distance place that is why they do not have the chance to show their grades even if they like to do so. These are the main reason why we had created this project. Base on our research, nowadays, universities like FEU, DLSU, AdU, UST, UPHS and ADMU use Online Grade inquiry , they had a common objective and those are:
For the parents to be updated on their child’s performance and to avoid children bluffs about their grades. It is not good to hear, but that is the reality. The ONLINE GRADE SUBMISSION AND INQUIRY SYSTEM that we had designed is easy to use that is why there is no reason for the parents to worry not to be able to use this just because they do not usually use computer and internet.
The ONLINE GRADE SUBMISSION AND INQUIRY SYSTEM is an absolute system consists of a series of fields like The Registrar’s Account for Students registration, creating account and Changing Registrar’s account like password and inquiring how many students are registered. Teacher’s Account for creating their account, registering their students and submission of students grades. Lastly, it has Students fields in which the students will create their account to be able to inquire their grades. This system provides quality security assurance and fast processing way of inquiring grades most especially for the benefits in the part of the students. This system has its security measures to ensure the liability and legality of all data’s being put to the system.

TECHNOLOGY APPLICATION CONTEXT

Online Grade Submission and Inquiry System is the software application that some schools, colleges and universities like FEU, DLSU, ADU, UST, UPHS and ADMU use

STATEMENT OF THE PROBLEM

1. No online submission of grades. What is the advantage of having online grades submission?
2. No online grades inquiry. What is the advantage of having an online grades inquiry?
3. Lose of grade sheets. Consume a lot of paper works.
4. Manual grades computations.
5. -----

HYPHOTHESIS OF THE PROBLEM

a. Through Developing online for grades submission will became one of great tool appropriate for teachers- for them to submit grades online. one of the advantage of this system is for incase teachers are tired of going to the registrar’s office to submit grades or he/she want to submit it from his/her office, home or met emergencies which will not able him to go to (RO) , through the use of online/internet he/she can now submit those grades.
b. By having online for grades inquiry, it will serves as additional asset in this institution that will allows both students as well as their parents to access or look for the grades which will not take much time searching grade sheets. The advantage is. It will help the parents to be updated on their child’s performance and to avoid children bluffs about their grades. It is not good to hear, but that is the reality. The ONLINE GRADE INQUIRY that we had designed is very user friendly that is why there is no reason for the parents to worry not to be able to use this just because they do not usually use computer and internet.
c. No more worry of losing grade sheets, carrying heavy folders of grade sheets because by this project, all data’s being put by users will be stored in data base. This project will serves as your grade sheets.
d. We developed programmed Microsoft Excel sheets that will automatically generate average, for your easy and convenient grades computations without using your papers, pens and calculators. No manual computations anymore.

OBJECTIVES OF THE STUDY

General Objectives: This study aimed to develop an Online Grades Submission and Inquiry System.
Specific Objectives: Specifically, this study aimed to:
1. To make, Provide another helpful way in submitting and inquiring grades through the use of online/internet.
2. Help teachers submit grades for in case the teacher is far away from his/her school, still he/she can submit his or her students’ grade through internet.
3. Help Students inquire their grades easily without appearing to the registrar’s office.
4. Help you inquire, submit grades and visit your account any time you want.
5. This system will also help parents who want to monitor, check the status of their sons/daughter’s school subject grades and to insure whether their sons/daughter’s has a pass or a failed grades.
6. Make automatic computations of grades. Our system includes programmed Microsoft Excel for fast and easy computations without using papers, pens and calculators manually.
7. Make easy and reliable the period of inquiry.
8. Design a system that is secured which cannot be modified or retrieved by unauthorized person.

SIGNIFICANCE OF THE STUDY

The purpose and goal of this system is to fulfill a better system in case of far situation and will serve as reliable and easy in submitting and inquiring grades of the students in this institution.

The user interface of our system provides ease through its organization interface and functionality. The role of our system provides efficiency in keeping, gathering, submitting and inquiring of student’s grades. The system will have three parts, the REGISTRAR’S account, TEACHER’S account and STUDENT’S account. The registrar’s in charged will login in a REGISTRAR’S account using username and password, while the teachers will login in a TEACHER’S account using username and password and the students also will login in a STUDENT’S account to provide security of the system. This study is very accurate for those parents who are in abroad or provinces, very Accurate for teachers and students. We have thought of Online Grade submission and Inquiry, because we want the parents to be updated on their children’s school grades as well as their performance. Some working students are not able to see their class cards, because of lack of time. Through its Online Grade Inquiry will help them see their grades any time.
The system will give this institution better processing way in submitting and inquiring grades student’s data when they are far away or in other places.

SCOPE AND LIMITATIONS OF THE STUDY

This ONLINE GRADE SUBMISSION AND INQUIRY SYSTEM has its scope and its limitations. Its scope is the following:

1. First this online system can be access by our first authorized user, the registrar. Because this system has security parameters for the safety of all data being put to this system.
2. Teachers for submission.
3. Students for inquiry.

Here are the systems limitations.
1. Registrar/ Admin of this institution can access this system, but he/she will not be able to change student’s grade.
2. Teachers can only list and submit grades for his/her student.
3. This system is design only for student registration, creating accounts, changing accounts, student listing, submission and inquiry.
4. For inquiring of grades, students and registrars are able to access or look for it.
5. Only enrolled students in this school are able to create and inquire grades. If you are student with account, you can only look for your own grades or records. You will not be able to see your classmate’s records.
6. This system is not for social purposes.

METHODOLOGY

Study of ONLINE GRADE SUBMISSION AND INQUIRY SYSTEM as follows:

A. Collecting Information

Through collecting information from registrar, deans, teachers, students and internet, it comes up in our mind that we must create another way of submitting/inquiring grades.

B. Observation

By observing, it helps us what our goal and purposes made off. Each of our group members has their own observation about ONLINE GRADE SUBMISSION AND INQUIRY SYSTEM.

C. Data analysis

Combine the weight of the collecting information and observation.

D. Documentation

The result of the system has been achieved the system structure, as evaluated will be documented. These steps will continue until the desired system will be obtained.

3.1.1 Development of an Online Grade and Inquiry System

E. Designing the content of the Online Grade and Inquiry System

Content of the proposed system was determined through interviews with the instructors, analyzing the subject and conceptual design, flow of the system were identified, review of the course outline, wysiwyg programs and course handouts. Programs and topics to be included in the system were selected. Using the WYSIWYG for creating and designing web page is very user friendly; you just drag and drop— until finished design will show.

A. Testing phase

This is the phase where student registration, create account, change account, student listing, submission of grades, grades inquiry was test. And occurred problems were identified.

B. Implementation and User feedback
C. The implementation of the system was done through intensive testing and user feedback gathering to ensure that the system runs to its purpose.

3.2 OPERATIONAL FRAMEWORK

Figure 1.

1. How to submit grades to the registrar through online?

2. How to inquire the grades of the students through online?

3. What are the kinds of accounts to be made in order to access the website?

4. Why we have to create an account?

1. To submit grades to the registrar. Go to “teacher’s account” and “submission of grades”. Then log in the teachers username and password. Then fill in all the required fields and click update.

2. To inquire the grades of students. Go to “student’s account” and “Inquiry”. Input your I.D number and hit the button search to search your name and input your password then click the button OK. Then input the first school year you had attended up to the last year attended, then click search.

3. The kinds of accounts to be made are the following:
a. Registrar’s Account
b. Teacher’s Account
c. Student’s Account

4. We have to create an account for security assurance for the website.

Cost and benefits

Cost
a. P1
BENEFITS

Having

DATA DICTIONARY

System:

ONLINE GRADE SUBMISSION AND INQUIRY SYSTEM

Date:

Analyzed by:
Group 3

Entity Relationship Name:

Registrar Create Account
Entity Relationship Description:

Consist of (Username, Password)

Database Name: finaldb
Table Name: tbl_registrar
Attribute
Name
Field name
Format
Description

Primary key?

Can be null?

USERNAME
UNAME
Alphanumeric
Name of End-user no No
PASSWORD
REGPASS
Alphanumeric
Registrar Password no No

Entity Relationship Name:

Registrar Student Registration
Entity Relationship Description:

Consist of (IDNUM, NAME)

Database Name: finaldb
Table Name: tbl_reg
Attribute
Name

Field name
Format
Description
Primary key?
Can be null?

ID No..
IDNUM
numeric
ID number of Student yes No

NAME
NAME
alphanumeric
Name of Students

no

No

Entity Relationship Name:

Teacher Create Account
Entity Relationship Description:

Consist of (Username, password)

Database Name: finaldb
Table Name: tbl_teacher
Attribute
Name

Field name
Format
Description
Primary key?
Can be null?

USERNAME
UNAME
alphanumeric
Username of the teachers no No

PASSWORD
TEACHERPASS
alphanumeric
Password of the Teacher

no

No

Entity Relationship Name:

Teacher Student listing
Entity Relationship Description:

Consist of (SEMESTER,SCHOOL YEAR,COURSE NO., DESCRIPTIVE TITLE, UNITS,TIME, DAY, NAME OF INSTRUCTOR, ID NO., and NAME OF STUDENT)

Database Name: finaldb
Table Name: tbl_listing
Attribute
Name

Field name:
Format
Description
Primary key?
Can be null?

SEMESTER
SEMESTER
alphanumeric
Present semester, consist of first, second, and summer yes No

SCHOOL YEAR FROM
SYF
alphanumeric
School year started by the sem.

yes

No
SCHOOL YEAR TO
SYS
alphanumeric school year ended by the sem. yes no
COURSE NO.
COURSENUM
alphanumeric
Course number of the subject yes no
DISCRIPTIVE TITLE
DISCRIPTIVE
alphanumeric
Descriptive title of the subject yes no
UNITS
UNITS numeric Units of the subject no no
TIME
DTIME alphanumeric Time schedule of the subjects classes yes no
DAY
DDAY alphanumeric Day schedule of the subject classes yes no
NAME OF INSTRUCTOR
INSTRUCTOR
alphanumeric
Instructor/instructress name no no
ID No.
IDNUM
numeric
Id number of the student yes no
STUDENTS NAME
NAME
alphanumeric
Name of the student no no

Entity Relationship Name:

Teacher Submission of Grades
Entity Relationship Description:

Consist of (SEMESTER,SCHOOL YEAR,COURSE NO., DESCRIPTIVE TITLE, UNITS,TIME, DAY, NAME OF INSTRUCTOR, ID NO., NAME OF STUDENT, GRADE, and REMARKS)

Database Name: finaldb
Table Name: tbl_listing
Attribute
Name

Field name:
Format
Description
Primary key?
Can be null?

SEMESTER
SEMESTER
alphanumeric
Present semester, consist of first, second, and summer yes No

SCHOOL YEAR FROM
SYF
numeric
School year started by the sem.

yes

No
SCHOOL YEAR TO
SYS
numeric school year ended by the sem. yes no
COURSE NO.
COURSENUM
alphanumeric
Course number of the subject yes no
DISCRIPTIVE TITLE
DISCRIPTIVE
alphanumeric
Descriptive title of the subject yes no
UNITS
UNITS numeric Units of the subject no no
TIME
DTIME alphanumeric Time schedule of the subjects classes yes no
DAY
DDAY alphanumeric Day schedule of the subject classes yes no
NAME OF INSTRUCTOR
INSTRUCTOR
alphanumeric
Instructor/instructress name no no
ID No.
IDNUM
numeric
Id number of the student yes no
NAME OF STUDENT
STUDENT
alphanumeric
Name of the student no GRADE
GRADE
numeric
Grades of the student no no
REMARKS
REMARK alphanumeric Remarks of the grades consist of passed or failed. no no

Entity Relationship Name:

STUDENTS Create Account
Entity Relationship Description:

Consist of (ID NO., USERNAME AND PASSWORD)

Database Name: finaldb
Table Name: tbl_student
Attribute
Name

Field name
Format
Description
Primary key?
Can be null?

ID NO.
IDNUM
numeric
Id no. of the student yes No

USERNAME
UNAME
alphanumeric
Username of the students

no

No
PASSWORD
STUDENTPASS alphanumeric Password of the students no no

TECHNOLOGY APPLICATION CONTEXT

a. WYSIWYG 7 Web builder
b. Microsoft Excel
c. Xampp
d. MySql database

Definition of Terms
WYSIWYG 7 web builder
Web builder 7 is a WYSIWYG which means “What You See is What You Can Get” program used to create webpage. WYSIWYG means that the finished page will display exactly the way it was designed. The program generates HTML “Hyper Text Markup Language” tags while you point in click on desired function; you can create a webpage without learning HTML. Just drag and drop objects to the page position then anywhere you want and when you are finished publish it to your web server (using the build in publish tool). Web builder give you full control over the content and layout of your webpage.
Microsoft Excel
A spreadsheet program from Microsoft, part of their Microsoft Office suite of productivity tools for Microsoft Windows and Macintosh. Excel is probably the most widely used spreadsheet in the world.
XAMPP
Is an easy to install Apache distribution containing mysql, php and pearl.

MYSQL database
It powers the most demanding web, ecommerce and online transaction processing (OLTP) applications. It is a fully integrated transactions—safe, ACID compliant database with full commit, roll back, and crash recovery and row level locking capabilities. MySql delivers the ease of use, scalability, and performance that has made MySql the world’s most popular open source database. Some of the world’s most trafficked website like Facebook, Google, ticket master, Ebay rely on MySql for their business critical applications. (http://www.mysql.com/products/enterprise/database/).

WORKING BIBLIOGRAPHY

1. (http://www.pablosoftwaresolutions.com/html/wysiwyg_web_builder.html)
2. (http://www.mysql.com/products/enterprise/database/)
3. (http://www.Google.com)
4. (http://www.papercamp.com/group/online-grade-inquiry-system-local-study-review-of-related-literature/page-0)
5. (http://www.mcmaster.ca/uts/online_grades/upload_submit.html)

Bibliography: 1. (http://www.pablosoftwaresolutions.com/html/wysiwyg_web_builder.html) 2. (http://www.mysql.com/products/enterprise/database/) 3. (http://www.Google.com) 4. (http://www.papercamp.com/group/online-grade-inquiry-system-local-study-review-of-related-literature/page-0) 5. (http://www.mcmaster.ca/uts/online_grades/upload_submit.html)