1 / 20

Online Grading System

Online Grading System. Team 2: Chandrika Parasuraman Manjushree Sanglikar Pratima Pillarisetti Arundhati Shenoy. Project Purpose.

ishana
Download Presentation

Online Grading System

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Online Grading System Team 2: • Chandrika Parasuraman • Manjushree Sanglikar • Pratima Pillarisetti • Arundhati Shenoy

  2. Project Purpose • This is a web-based database application for a university where students and instructors will be able to use the system to perform their related operations like checking and assigning of grades respectively. Designed to be very secure by providing a login feature which authenticates the user by means of a user name and password with which user will be able to login to his/her respective pages and use the system as required.

  3. System Users • Administrator – The user that manages the entire system. • Instructor – The user that assigns the grades for the students and calculates class performance. • Student – The end user who can check his grades and compares his performance with the class.

  4. System Actions by Administrator • Add/Remove user accounts (for student/instructor) • Manage the roles for the user • Manage course records • Manage period records

  5. System Actions by Instructor • Enter student grade for a course • Update student grade for a course • Search for student record (based on student ID or student name) • Run reports to calculate class performance • Run reports to enquire grades for any student in the class

  6. System Actions by Student • View all the courses taken for that particular period • Check grade in the courses • Get transcript (entire grade history) • Compare his/her performance with the class

  7. Database User Entities The Database includes the following main user entities: • User- User ID (primary key)- Password- Role (admin or instructor or student) • Instructor- Instructor ID (primary key)- First Name- Last Name- Phone number- Mailing address- Email address- Job title- Department ID [references Department ID of Department table] • Student- Student ID (primary key)- First Name- Last Name- Phone number- Mailing address- Email address- Department ID [references Department ID of Department table]

  8. Database University Entities The Database includes the following main university related entities: • Grade- Grade ID (primary key)- Grade character (A,A-,B+,B etc)- Grade Value ( A has a value of 4, A- has a value of 3.7 etc.) • Course- Course ID (primary key)- Department ID [references Department ID of Department table]- Course Name- Credits (Number of Units, eg:1, 2, 3) • Period- Period ID (primary key)- Semester (Fall, Spring, Summer)- Year(2008, 2009 etc)- Start Date- End Date • University- University ID (primary key)- University name (SDSU)- Phone number- Mailing address

  9. Database Table Entities • Student Grade- Grade ID [references Grade ID of Grade table ]- Student ID [references Student ID of Student table ]- Course ID [references Course ID of Course table ]- Period ID [references Period ID of Period table ] • Instructor Course - Instructor ID [references Instructor ID of Instructor table ] - Course ID [references Course ID of Course table ]

  10. Database Schemas • Separate interfaces depending on the type of the user logged in • All mandatory fields pre checked • All data that are specific to a user type made available • Database normalization done where appropriate

  11. Subsystems • Login Management : The initial login screen for Online Grading System • User Management : Create/Edit a user account • Report Module : Allows either a student or the instructor to run reports.

  12. Data Flow Diagram

  13. Entity Relationship Model

  14. Login Web Page

  15. Administrator Interface

  16. Instructor Interface

  17. Student Interface

  18. Software and Hardware • Software Used: - Oracle SQL (10.2.0.1) – to store the data - Java and HTML - front end and the business logic. • Hardware Used: - Rohan is a SunFire 4800 running Solaris 10

  19. Source Code and Web Info • The code and website is located at /home/ma/222.01/masc1383/jakarta-tomcat-5/webapps/my_project • Our website runs on Port 64001 • Home Page: http://rohan.sdsu.edu:64001/my_project/ Time_Sheet_Login.html

  20. Future Enhancements • Add more input validations and error messages into the interface • Enhance student interface by providing him with more options to access like assigning tasks, change his password etc • Add a pop up calendar interface • Post new announcements related to the university available to all the users

More Related