Automated Grading System in Visual Basic and MySQL
Statement of the Opportunity
The purpose of this study is to propose an Automated Grading System in Visual Basic and MySQL for Information Technology Department Listed below are the opportunities that can be obtained when using Automated Grading System.
- Speed in processing grades of the student.
- Accuracy in calculating the grades of the student.
- Security of the records.
- Less of paper will be use.
- No hassle for the faculty in processing and calculating the grades.
- Less or Error-Free system.
Scope and Limitation of the Study
The study was limited only on calculating and processing the grades of the students using the grading criteria desired by the faculty. Each faculty have a choice to make their own grading criteria in each subject.
Statement of the Expected Solution
The following are the expected solution by the researchers based on the opportunities stated.
- There is a need to improve the processing and calculating the grades of the student in terms of speed and accuracy.
- There is a need to have a security in the records of the students.
- There is a need to propose a new system for Information Technology Department to have an Automated Grading System in Visual Basic and MySQL
Systems Functionality
Some of the faculty of Information Technology Department are using an old fashioned style or traditional grading system which is the manual method of calculating the grades of the students in order for them to solve the preliminary, mid-term and final grades of the students. In traditional grading, the faculty determine the grading criteria for assignments, projects, activity, exam, etc before the course begins. Students are expected to follow the syllabus and complete the tasks presented. The grades of the student receives is a reflection of how well he or she completed the pre-determined syllabus. In this system, students are expected to follow a path that reflects the syllabus.
Sample Physical Data Flow Diagram
Project Dictionary
Name: Administrator
Aliases: administrator
Description: Person that has a full access in the system.
Related Data Element: ID, Username, Password
Permissible Range and Length in Characters: 9999, x(20), x(20)
Name: Faculty
Aliases: faculty
Description: Person who makes the grades of the students.
Related Data Element: F_ID, LastName, FirstName, MiddleName, Address, Contact, Username, Password
Permissible Range and Length in Characters: 9999, x(30), x(30), x(30), x(50), x(11), x(20), x(20)
Name: Student
Aliases: student
Description: Person who studies a particular academic subject.
Related Data Element: S_ID, LastName, FirstName, MiddleName, Address, Sex, Contact, Year, Section
Permissible Range and Length in Characters: 9999-9999, x(30), x(30), x(30), x(50), x(6), x(11), x(3), x(1)
Name: Subjects
Aliases: subjects
Description: A branch of knowledge studied by the students.
Related Data Element: ID, Subjectcode, Subjectname
Permissible Range and Length in Characters: 999, x(10), x(50)
Name: Faculty Subject
Aliases: facultysubject
Description: Subjects handled or hold by the faculty.
Related Data Element: ID, Subjectcode, Yearlevel, Section, Criteriacode
Permissible Range and Length in Characters: 9999, x(10), x(3), x(1), x(3)
Name: Student Subject
Aliases: studentsubject
Description: Subjects taken by the students.
Related Data Element: ID, Subjectcode, Yearlevel, Section
Permissible Range and Length in Characters: 9999-9999, x(10), x(3), x(1)
Name: Grading Criteria
Aliases: gradingcriteria
Description: Criteria used by the faculty in solving the grades of the students.
Related Data Element: ID, Criteriacode, Criterianame, PercentageEquivalent
Permissible Range and Length in Characters: 9999, x(3), x(20), 99
Name: Students Grade
Aliases: studentsgrade
Description: Grades indicating performance of the student.
Related Data Element: ID, Lastname, Firstname, Criterianame, Score, Period
Permissible Range and Length in Characters: 9999-9999, x(30), x(30), x(20), 99, x(10)
Systems Feasibility
The propose system which is the Automated Grading System in Visual Basic and MySQL allows each faculty to make his/her own grading criteria in each subject and process the grades of the students. There is no hassle for the faculty to calculate the grades of the students because it will be calculated by the system. This system is error-free and less of paper will be used. Through this system, students can view the details of their grades.
