Web Based Grading System for High School using PHP and MySQL

Web Based Grading System for High School using PHP and MySQL

Database schema

tblschoolyear (id, schoolyear)

tblyearlevel (id, yearlevel, description)

tblsubjects (id, subjectname, description, yearlevelid)

tblstudent (id, lname, fname, mname, contact, address, username, password)

tblclass (id, classname, schoolyearid, yearlevelid)

tblstudentclass (id, classid, studentid)

tblteacher (id, lname, fname, mname, contact, address, username, password)

tblteacheradvisory (id, teacherid, classid)

tblstudentgrade (id, studentid, schoolyearid, subjectid, classid, adviserid, 1stgrading, 2ndgrading, 3rdgrading, 4thgrading, gradeaverage, remarks )

Functionality by User Category

Administrator

• Manage (Create, Update, Delete) School Year
• Manage (Create, Update, Delete) Year Level
• Manage (Create, Update, Delete) Subjects
• Manage (Create, Update, Delete) Students
• Manage (Create, Update, Delete) Classes
• Manage (Create, Update, Delete) Teachers
• Set Advisory (Teacher to Class)
• Backup Database

Teacher

• Login to System
• Change username and password
• Select school year, class and subject, then list of students for that class will be displayed
  • Example: school year: 2016-2017, class : 1A, subject: math1

Student

• Login to System
• View Grades

You may visit our Facebook page for more information, inquiries, and comments. Please subscribe also to our YouTube Channel to receive  free capstone projects resources and computer programming tutorials.

Hire our team to do the project.