STUDENT MARKS ANALYZING SYSTEM
[Link] STATEMENT:
Student marks analyzing system has to be developed for analyzing obtained by the
students who scored in Semester Examination The System should provide following
functionalities
1. The System obtains following information’s from the faculty generates report Roll No,
Name, Department, Semester, Marks obtained in each subject.
2. The total for each student should be calculated and ranked based on total and pass in all the
subject appeared.
3. The Final report should display rank, percentage, Class, Pass/Fail Status for each student.
[Link] DESCRIPTIONS:
2.1MODULES:
[Link]
2.student_mark
[Link] report
2.2MODULE DELIVARABLES:
1. Login
Basic Flow: This use case starts when the Faculty wishes to Login to the Student Marks
Analyzing
System.
1. The System requests that the Faculty enter his/her name and password
2. The Faculty enters his/her name and password
3. The System validates the entered name and password and logs the Faculty into the System
Alternative Flows: Invalid Name/Password
If, in the Basic flow, the Faculty enters an invalid name and/or password, the system displays
an error message. The Faculty chooses to either return to the beginning of the Basic flow or
cancel the login, at which point the use case ends.
Pre-Conditions: None
Post-Conditions: If the use case was successful, the Faculty is now logged into the system. If
not, the system State is unchanged.
2. Student_Mark
Basic flow: The Faculty uses this usecase to enter marks for each student. The faculty enters
the following details namely Roll No, Student Name, Department, Marks for each student.
Alternative Flows: If faculty not entered any details or invalid marks then gives error
Message
Pre-Conditions: The Faculty must logged into the system
Post-Conditions: If this Use case was successful, Student Mark Analysis Report will be
generated for
the Student.
[Link] Report
Basic flow: The Actor uses this usecase view the Report .The report contains the following
details Namely Roll No, Student Name, Marks in each subject, total, class, Pass/Fail Status,
No of subjects failed, Rank.
Apart from this there is a separate report Overall Pass percentage of class, No of students
cleared in First class, Overall Top 3 persons of the class.
Alternative Flow: If the Marks is not entered for all the students the use case will ask the
faculty to the enter the marks.
Pre-Conditions: The Faculty must entered marks for all the students in a class.
Post-Conditions: None
[Link] DIAGRAMS:
[Link] Diagram:
No of students
Mark
Staff Total
Student
Average
Grade
3.2 Activity Diagram
No of Students
Analyse
marks
Fail Pass
Total Marks
Calculate
Average
Give grade
3.3 Class Diagram
Student Staff
name : String name : String
regno : integer dept : String
dept : String
Calculate()
get_result() 1..* 1 Average()
get_subjects() Result()
3.4 Sequential Diagram
admin server gui database
details entry
entered field
store data
ask message
ask message
ask message
enter compute marks
submit marks store
display
display
display
3.5 Collaboration diagram
1: details entry
7: enter compute marks
server
admin
6: ask message
12: display
5: ask message
11: display
2: entered field
8: submit marks
3: store data
9: store
databas
gui
e
4: ask message
10: display
3.6 Component Diagram of student info System
stud info
system
vb db
result cheking
details entry
marksheet entry
3.7 Deployment Diagram of Student info System
application
server
printer db
pc gui
4. DATABASE DESIGN
Database name: student
Table name:marks
Fields Data type
student name text
register number integer
Pqt integer
Daa integer
Mup integer
Se integer
Os integer
Total integer
Percentage double
Result text
5. IMPLEMENTATION:
FORM1 (Login form)
Coding:
Private Sub Command1_Click()
if [Link]=”student” and [Link]=”itdept” then
[Link]
Else
msgbox|(“Please enter correct user name and password”)
end if
End Sub
Private Sub Command2_Click()
End
End Sub
FORM2 (Entry form)
Coding:
Private Sub Command1_Click()
Dim total, per, result
[Link]
[Link]("sname") = [Link]
[Link]("regno") = [Link]
[Link]("m1") = [Link]
[Link]("m2") = [Link]
[Link]("m3") = [Link]
[Link]("m4") = [Link]
[Link]("m5") = [Link]
total = [Link] + [Link] + [Link] + [Link] + [Link]
[Link]("total") = total
per = (total / 5) * 100
[Link]("per") = per
If ([Link] > 49 And [Link] > 49 And [Link] > 49 And [Link] > 49 And
[Link] > 49) Then result = "pass"
[Link]("result") = result
[Link]
MsgBox ("record saved")
[Link]
End Sub
Private Sub Command2_Click()
End
End Sub
FORM3 (Display Students)
Coding:
Private Sub Command1_Click()
End
End Sub
[Link]:
Test case ID: Test_01
Test priority
(Low/Medium/High):Medium
Module name: login
Test title :verify login with valid username and password
Precondition: user has invalid username and password
S.N TEST STEPS EXPECTED ACTUAL STATU NOTES
O S
RESULTS RESULTS
1 Provide valid User should The user is able to Success -
move to next
User name Be able to
Entry
login
2 Provide valid User should be The user is able Success Incase of wrong
password
Able to To login Password was
given an error
Login Successfully
Message box
was
displayed
3 Click login User should be User name and Success Incase user gives
able to navigate to password is wrong entry the
next page after validated and next sign in page
validation page is displayed remains active
4 Click signup User should be User navigates to success -
able to navigate to the signup page
next page where where his user
user enters his name and
credentials password is
validated
RESULT:
The Student marks analyzing system was designed and implemented successfully.