Online Grading System

judgedrunkshipΔιακομιστές

17 Νοε 2013 (πριν από 3 χρόνια και 9 μήνες)

105 εμφανίσεις

Online Grading System

Team 2:


Chandrika Parasuraman


Manjushree Sanglikar


Pratima Pillarisetti


Arundhati Shenoy

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. It
is a role based access system where every user login
is authenticated by means of a user name and
password with which he/she will be able to login to
his/her respective pages and use the system as
required.


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.

System Actions by Administrator


Add/Remove user accounts (for student/instructor)


Associates courses to students for the current period


Manage the roles for the user


Manage course records




Administrator

Login

User_proj

table

Unauthorised

Add,Edit,

Delete details

Add,Edit,

Delete details

Student table

Instructor table

Username

Password

Validates

Not Validates

Student Information

Instructor Information

Data Flow Diagram for Administrator

Login Web Page

Administrator Interface

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


Instructor

Logins

User_proj

table

Username

Password

Validates

Unauthorised

Not

Validate

Add,Edit,Delete

& Views Class

Average

Student_grade,

Period table

Data Flow Diagram for Instructor

Instructor Interface


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

Student

Login

User_proj table

Username

Password

Validates

Unauthorised

Views grade &

Summary

Student_grade,Period

table.

Not Validates

Data Flow Diagram for Student

Student Interface

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.

Entity Relationship Model

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]



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



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 ]



Student Course


-
Student ID



-
Course ID



-
Period ID


Database Schemas


Separate interfaces depending on the type of the user
logged in


All data validations done when new data is being
entered


All data that are specific to a user type made available


Database normalization done where appropriate

Software and Hardware


Software Used:


-

Oracle SQL (10.2.0.1)


to store the data


-

JSP, Java 1.5 and Servlets
-

front end and the
business logic.



Hardware Used:


-

Rohan is a SunFire 4800 running Solaris 10

Source Code and Web Info


The code and website is located at


/home/ma/514.01/masc1101/apache
-
tomcat
-
5.5.27/webapps/OnlineGradingSystem



Our website runs on Port 8080


Home Page:


http://rohan.sdsu.edu:8080/OnlineGradingSystem

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


Enhance this application to include departments other
than Computer Science.


Add a pop up calendar interface


Post new announcements related to the university
available to all the users