Web Based Grading System for High School using PHP and MySQL

Web Based Grading System
  • Version
  • Download 58326
  • File Size 5.04 MB
  • File Count 1
  • Create Date June 30, 2017
  • Last Updated June 30, 2017

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

Comments

comments

, , , , , , , , , , , , , , ,

Post navigation

4 thoughts on “Web Based Grading System for High School using PHP and MySQL

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.