Web Based Grading System for High School using PHP and MySQL

Web Based Grading System
Web Based Grading System
  • Version
  • Download 58072
  • 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

4 Responses to Web Based Grading System for High School using PHP and MySQL

  1. Cardo says:

    why i cannot search on teachers table?

  2. charm says:

    what is the username and password please.. thanks

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.