Web Based Grading System for High School using PHP and MySQL

Web Based Grading System
Web Based Grading System for High School using PHP and MySQL

Version
Download 56164
Total Views 0
Stock
File Size 5.04 MB
File Type zip
Create Date June 30, 2017
Last Updated June 30, 2017
Download

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

One Response to Web Based Grading System for High School using PHP and MySQL

  1. Cardo says:

    why i cannot search on teachers table?

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.