Online Grading System in PHP, MySQL and Bootstrap

Grading System Entity Relationship Diagram

Online Grading System in PHP, MySQL and Bootstrap

This article will provide you with the list of database tables in developing a grading system. The grading system utilized the Rapid Application Development as the Model for the development of the system. Features of the grading system will also be discussed and as well as the list of software components used for the design and development of the grading system.

Database Design

Online Grading System Database Tables

Online Grading System Database Tables

List of Database Tables

  • tbladmin
  • tblclass
  • tblschoolyear
  • tblstudent
  • tblstudentclass
  • tblstudentgrade
  • tblsubjects
  • tblteacher
  • tblteacheradvisory
  • tblyearlevel

Database Tables with entities and attributes

The image below shows the different tables of grading system with their respective entities or fields, it also shows the connection of the different tables or commonly known as entity relation diagram.

Grading System Entity Relationship Diagram

Grading System Entity Relationship Diagram

Software Components

PHP

PHP: Hypertext Preprocessor is a widely used, general-purpose scripting language that was originally designed for web development to produce dynamic web pages.

Bootstrap

Bootstrap is the most popular front end frameworks currently. It is sleek, intuitive, and powerful mobile first front-end framework for faster and easier web development. It uses HTML, CSS and Javascript.

Javascript

JavaScript is a lightweight, interpreted programming language with object-oriented capabilities that allows you to build interactivity into otherwise static HTML pages.

AJAX

AJAX stands for Asynchronous JavaScript and XML. AJAX is a new technique for creating better, faster, and more interactive web applications with the help of XML, HTML, CSS, and Java Script.

Ajax uses XHTML for content, CSS for presentation, along with Document Object Model and JavaScript for dynamic content display.

MySQL

MySQL is an Open source database, enabling the cost-effective delivery or reliable, high performance and scalable Web-based and LAN based database applications.

Online Grading System in PHP, MySQL and Bootstrap

Online Grading System in PHP, MySQL and Bootstrap

Features of the System

The system can be accessed by three types of users, the administrators which have a full control and can access all modules of the grading system. The teachers account where they can view the list of their students by class and they can also encode the grades of their students individually. Lastly, the student account where the students can view their grades.

This section will present and briefly describe the different modules of grading system

Administrator can access the following modules:

1. Dashboard – this serves as the homepage of the admin panel after the login process.

The image below shows the dashboard of the grading system. with the dashboard feature, the admin has a glimpse or overview of the systems statistics and records.

Grading System Dashboard

Grading System Dashboard

2. School Year Module – the administrator can add, update, delete and search for school year information.

Grading System School Year Module

Grading System School Year Module

3. Year Level Module – the administrator can add, update, delete and search for year level information.

Grading System Year Level Module

Grading System Year Level Module

4. Encoding of Subjects Module – the administrator can add, update, delete and search for subject information. Information includes the subject code, description and the year level.

Grading System Encoding of Subject Module

Grading System Encoding of Subject Module

5. Encoding of Class Module – the administrator can add, update, delete and search for class information. Information includes the class name, school year and year level.

Grading System Encoding of Class Module

Grading System Encoding of Class Module

6. Encoding of Teacher Information – the administrator can add, update, delete and search for teacher information. Information includes the name of the teacher, contact, address, username and password.

Grading System Teacher Encoding Module

Grading System Teacher Encoding Module

7. Teacher Class Module – this is the module where the administrator assigns a subject to a teacher.

Grading System Teacher Advisory and Class Module

Grading System Teacher Advisory and Class Module

8. Encoding of Student Information – the administrator can add, update, delete and search for teacher information. Information includes the name of the student, contact, address, username and password.

Grading System Student Encoding Module

Grading System Student Encoding Module

9. Student Class Module – this is the module where the administrator adds a student to a specific class.

Grading System Student Class Module

Grading System Student Class Module

10. Backup/Restore Database Module – this is a module wherein the administrator can create a backup copy of the entire database of the grading system.

Grading System Database Maintenance Module

Grading System Database Maintenance Module

Teacher Panel

1. Masterlist – this is a module where in the teachers can view the list of students per class and subject.

Grading System Masterlist Module

Grading System Masterlist Module

2. Student Grade Encoding Module – this is the module wherein the teacher can input the grades of the students.

Grading System Grade Encoding Module

Grading System Grade Encoding Module

Student Account

1. Grade Viewing Module – the image below shows the module where the students can view their grades.

Grading System Grade Viewing Module for Students

Grading System Grade Viewing Module for Students

Methodology

This chapter presents the system development method employed by the researchers in conducting the study, the discussion in regards for the Software development procedures.

SDLC

The researchers will use Rapid Application Development methodology in the development of proposed system. Figure 1.0 presents the Rapid Application Development methodology. The developments of the system were time boxed, delivered and then assembled into a working prototype.

Rapid Application Development of Grading System

Rapid Application Development of Grading System

Figure 1.0 the Rapid Application Development of Grading System

Figure 1.0 shows the different phases in Rapid Application Development. Requirement capture phase includes planning analysis phase. The quick design phase consist of logical and the physical design phase.

Planning and Analysis

Planning and analysis phase determined based on the type of architecture that the system is designed. The End-users suggestions are also being considered for the better outcome and usability of the proposed system

In this phase, the researchers will conduct an interview and survey to the target beneficiary of the system. In conducting a research interview and survey, the researchers provide tool such as questionnaire. It is followed by data gathering in order to identify the desired and needed features to be included in the proposed system.  After gathering data, the researchers analyse the possible problem based on the needs and requirements of the user.

System Design

After all the Planning and analysis were met, the system design will take place. The researcher will make sure that the Overall design and User Interface (UI) as prescribed by the End-user are met. This part covers the physical and logical design of the developed system. The screen layout of the proposed system will show in this page. The data design and the architectural design of the system will also be viewed in this page.

The data design contains the Entity-Relation Diagram (ERD) and the data dictionary. The ERD is a database design tool that provides graphical representation of database table, the columns in table  and the relationship between tables. A data dictionary is a collection of description of the data object or items in a data model for the benefit of programmer and others who need to refer them.

Coding

The proposed system will be constructed during this phase. The researchers evaluated the system design and the data gathered during the data gathering stage. With these data, the researcher made sure that the application met all the criteria as stated in the objectives of the study.

The researchers will use Visual Basic as the programming language and MariaDB/MySQL for the backend or the database of the project.

Testing phase

Expert Testing

In this phase, we will perform series of testing to check for any possible problems that may occur during implementation and operation of the software and if the specification has been met. We will use McCall’s Software Quality Model Standard as our Measuring tool in the expert testing which was evaluated by three (3) IT Expert, to check the system’s reliability.

User Acceptance Testing

The researcher prepares the system for final testing.  The researcher once again let the users explore and test the system.  After the test is done, again the researcher distribute questionnaire to the users to rate the system. For user acceptance testing, we will provide a system evaluation questionnaire for our respondents. The questionnaire will be validated by three (3) Experts.

Implementation

During this phase, the system will be installed in the IT/ICT office of the college. Proper implementation procedure should be imposed to ensure system operability.

Implementation Plan

The requirements for the proposed Electronic Grading System for Mount Carmel College IT:

  1. Software Requirements
  2. Operating system (OS). Windows 7, 8, 10
  3. Visual Studio Runtime
  4. MariaDB/MySQL Server
  5. sql connector
  6. People Requirements
  7. Staff/Personnel- They are the people who are in charge in record keeping. They must learn how to use the system since they are the ones assigned for encoding and retrieving data as well as the reports needed.

Maintenance

During the maintenance phase, errors or defects may exist, which would require repairs during additional testing of the software. Monitoring the performance of the software is also included during the maintenance phase.

Comments

comments