Student Result Analysis Report Generator
Student Result Analysis Report Generator
Student Result Analysis Report Generator
INTRODUCTION
Student report generator is a web based application designed and engineered for
colleges that need to manage results across multiple branches students that need to track,
manage and report results. This application can run on any kind of operating system. At a
time we can see all the years result in a single sheet and we can see the individual
candidate’s results separately.
ADMIN:
The admin is responsible for uploading the tsheets generated. He can add
the subject marks and make any kind of modifications like storing, updating,
deleting. Apart from the regular results, the supplementary results can also be
uploaded by the admin.
STUDENT:
Student must be an authenticated user of the college to access this
application. The student can view the semester marks,individual subject marks
and aggregate till the current semester. The student can also make a
comparative analysis with the results generated.
FACULTY:
Faculty must also be authorized users of the college. Faculty can view the
class result, subject wise result. The percentages of students pass/fail in a
subject can be viewed. The total marks (internal, external and both) can be
calculated.
HEAD OF THE DEPARTMENT:
Head of the department must be an authorized user. The HOD can view
subject wise, class wise, branch wise, year wise, marks. Also a comparative
result analysis can be made on these results generated.
TPO:
TPO must be an authorized user. The TPO can view the aggregate
semester marks and make a comparative analysis. TPO can also view the
number of students having backlogs (if any).
COMPANY:
To view the marks semester wise and also backlogs. Compare the
aggregate according to the requirement.
PRACTICES:
Storing and retrieving the unorganized data.
Segregating the data based on a particular college ID.
Further segregating the data subject wise.
Providing the result in a single pattern only( standard pattern- internal
marks, external marks, total marks)
LIMITATIONS:
The data generated in t-sheets is not in understandable manner.
The t-sheets occupy more space.
When a search is made, more time is taken to filter the data and give the
result.
The database tables that are required for the proposed system should be maintained
by software.
The fraud cases and error reports are also to be correctly maintained by the user
interface.
Validations at both browser side and server side are to be made interactively.
Uploading T-sheets.
Add subjects and upload student details.
Update the student’s database.
Uploading the supplementary results.
Uploading T-sheets:
Admin can upload the T-sheets
Add subjects and upload student details:
Admin can add Subject details and also add student details.
Update the student’s database:
This privilege enables the administrator to update his/ her details
Once applicant enters the valid user id and password he/she will be provided with the
following services.
Security Issues: In this system unauthorized users cannot access the data and
cannot perform any operation, because the system does not allow them to login. So
security is provided.
User Interface: The system is designed in such a way that instructions are given
clearly to navigate through the System. Warnings and error messages are provided
throughout the system.
Problem requirement analysis The process is order and more nebulous of the two, ideas
with understanding the problem, the goals is to fulfill the constraints posed by the client
Requirement specification Here the focus is on specifying what has been found in the
process of analysis such as representation, specification languages and tools and also
checking the specification are addressing during the activity. The requirement phase
terminates with the production of the validate SRS document, producing SRS document is
the basic goals of this phase.
Software requirement specification is the medium through which the clients and
users’ needs are accurately specified. It forms the basis of software development. SRS
should specify all the parties and operations involved in the system.
System Specification
The java is the object oriented that provides the much functionality with it standards.
In three the J2SE and J2ME are providing the features for development of the software
application. In J2SE (java2 standard edition) is core java that involves in the concepts like
exception, threading, applets, swings those are used for developing the basic programming
concepts. And J2SE (java2 enterprise edition) is advanced java that involves in the
concepts like java script, servlet, java server pages, java databases and providing dynamic
contents to the applications. The features of java give the security and simple development
of applications.
This project will be developed using the technologies like Java, JSP, Servlets,
HTML, CSS, JavaScript, SQL and Web for all which I need to fetch knowledge on all of
them in order to code for the project. Also I’ll be learning clearly about Software
Development Life Cycle.
2.5 User Documentation
This document also includes a user manual which assists the new user to go about the
project, he can even get the online help which caters the needs of a new user and makes
this project more user friendly, a step by step approach online makes it easy to use
software for a user.
JAVA
Initially the language was called as "oka" but it was renamed as "java" in
1995.primary motivation of this language was the need for a platform independent (i.e
architecture neutral) language that could be used to create software to be embedded in
various consumer electronic devices.
Java Architecture
Java provides portability by compiling the byte code for the for the java virtual
machine, which is then interpreted on each platform by the run-time environment. Java
is a dynamic system, able to load code when needed from a machine in the same room
or across the planet.
Simple
Java was designed to be easy for the professional programmer to learn and to use
effectively. Learning java will oriented features of C++. Most of the confusing concepts
from C++ are either left out of java or implemented in a cleaner,more approachable
manner. In java there are a small number of clearly defined ways to accomplish a given
task.
Object Oriented
Java was not designed to be source-code compatible with any other language. This
allowed the java team the freedom to design with a blank state. Once outcome of this
was a clean usable, pragmatic approach to objects. The object model in java is simple
and easy to extend, while simple types, such as integers, are kept as high-performance
non-objects.
Robust
The multi-platform environment of the web places extraordinary demands on a
program, because the program must execute reliably in a variety of systems. Java is
strictly typed language; it checks your code at compile time and runtime.
Servlet/Jsp
A servlet is a generic server extension.A java class that can be loaded dynamically to
expand the functionality of a server. Servlets are commonly used with web servers
where they can take the place CGI scripts.
JDBC
Any relational database one can write a single program using the JDBC API, and the
JDBC is a java API for executing SQL , Statements(As a point of interest JDBC is a
trademarked name and is not an acronym, nevertheless , JDB is often thought of as
standing for java Database Connectivity.
The next step in analysis is to verify the feasibility of the proposed system. “All
projects are feasible given unlimited resources and infinite time“. But in reality both
resources and time are scarce. Project should confirm to time bounce and should be
optimal in there consumption of resources. This place a constant is approval of any
project.
Technical feasibility
Operational feasibility
Economical feasibility
“T-sheets” uses the web technologies, which is rampantly employed these days
worldwide. The world without the web is incomprehensible today. That goes to proposed
system is technically feasible.
3. DESIGN
UML Diagrams:
3.1.Use Case Diagram:
3.1.1 Use case diagram for Admin
Login
Uploading Tsheets
upload student,
Hod,Faculty,TPO details
Add subjects
Admin
Updates
Uploading the
supplementary results
Logout
View Profile
Viewing semester
wise marks
Viewing aggregate of
all the semesters
Student
Viewing subject
wise marks
Making comparative
analysis
Logout
Viewing class
result
Viewing subject
wise result
Calculating the
percentage
Hod
Faculty
Viewing year
wise marks
Viewing branch
wise marks
Making comparative
analysis
Logout
Viewing aggregate
semester wise
Company
TPO
View the backlogs
semester wise
Comparative
analysis
Logout
User/Id/Password
Uploading Tsheets
Updates
Lopgout
User/Id/Password
Lopgout
User/Id/Password
Lopgout
User/Id/Password
Lopgout
User/Id/Password
Comparative analysis
Lopgout
User/Id/Password
Lopgout
Logout
Making comparative
Viewing subject wise marks
Viewing semester Viewing aggregate analysis
wise marks of all the semesters
Logout
Making comparative
Calculating the percentage
Viewing subject analysis
Viewing class result.
wise result
Logout
Making comparative
Viewing subject Viewing class Viewing year Viewing branch analysis
wise marks wise marks wise marks wise marks
Logout
Comparative analysis
Viewing aggregate semester wise Viewing the details of backlogs(active).
Logout
Separate login to view the marks View aggregate semester wise View the backlogs semester wise
Logout
Uploading Tsheets
Uploading the s
upplementary results
Logout
Viewing semester
wise marks
Viewing aggregate of
all the semesters
Viewing subject
wise marks
Making comparative
analysis
Logout
Calculating the
percentage
Making comparative
analysis
Logout
Viewing subject
wise marks
Making comparative
analysis
Logout
Viewing aggregate
semester wise
Comparative analysis
Logout
Logout
Uploading Tsheets.()
Add subjects and upload student details()
Update the students database()
Uploading the supplementary results()
Faculty
Student
Name:Varchar(20)
Name:Varchar(20) Useriid:varchar(20)
Useriid:varchar(20) password:varchar(20)
password:varchar(20) mobile:int(10)
mobile:int(10) Email:varchar(50)
Email:varchar(50)
Viewing class result.()
Viewing semester wise marks() User Viewing subject wise result()
Viewing aggregate of all the semesters() Useriid:varchar(20) Calculating the percentage ()
Viewing subject wise marks() password:varchar(20) Making comparative analysis()
Making comparative analysis()
Login()
HOD
TPO
Name:Varchar(20)
Useriid:varchar(20) Name:Varchar(20)
password:varchar(20) Useriid:varchar(20)
mobile:int(10) password:varchar(20)
Email:varchar(50) mobile:int(10)
Email:varchar(50)
Viewing subject wise marks()
Viewing class wise marks() Company Viewing aggregate semester wise()
Viewing year wise marks() Viewing the details of backlogs()
Viewing branch wise marks() CompanyName:Varchar(20) Comparative analysis()
Making comparative analysis() Useriid:varchar(20)
password:varchar(20)
mobile:int(10)
Email:varchar(50)
Separate login to view the marks()
View aggregate semester wise()
View the backlogs semester wise()
Uploading Tsheets.()
Add subjects and upload student details()
Update the students database()
Uploading the supplementary results()
f:Faculty
s:Student
Name:Varchar(20)
Name:Varchar(20) Useriid:varchar(20)
Useriid:varchar(20) password:varchar(20)
password:varchar(20) mobile:int(10)
mobile:int(10) Email:varchar(50)
Email:varchar(50)
Viewing class result.()
Viewing semester wise marks() u:User Viewing subject wise result()
Viewing aggregate of all the semesters() Useriid:varchar(20) Calculating the percentage ()
Viewing subject wise marks() password:varchar(20) Making comparative analysis()
Making comparative analysis()
Login()
h:HOD
t:TPO
Name:Varchar(20)
Useriid:varchar(20) Name:Varchar(20)
password:varchar(20) Useriid:varchar(20)
mobile:int(10) password:varchar(20)
Email:varchar(50) mobile:int(10)
Email:varchar(50)
Viewing subject wise marks()
Viewing class wise marks() c:Company Viewing aggregate semester wise()
Viewing year wise marks() Viewing the details of backlogs()
Viewing branch wise marks() CompanyName:Varchar(20) Comparative analysis()
Making comparative analysis() Useriid:varchar(20)
password:varchar(20)
mobile:int(10)
Email:varchar(50)
Separate login to view the marks()
View aggregate semester wise()
View the backlogs semester wise()
4. SAMPLE CODE
5. SCREENS
6. TESTING
The following are the various test cases that test various components of the project.
Introduction
Software testing is a critical element of software quality assurance and represents the
ultimate review of specification, design and code generation.
TESTING OBJECTIVES
To ensure that during operation the system will perform as per specification.
TO make sure that system meets the user requirements during operation
To make sure that during the operation, incorrect input, processing and output
will be detected
To see that when correct inputs are fed to the system the outputs are correct
To verify that the controls incorporated in the same system as intended
Testing is a process of executing a program with the intent of finding an error
A good test case is one that has a high probability of finding an as yet
undiscovered error
The software developed has been tested successfully using the following testing
strategies and any errors that are encountered are corrected and again the part of the
program or the procedure or function is put to testing until all the errors are removed. A
successful test is one that uncovers an as yet undiscovered error.
Unit Testing
Unit testing is essentially for the verification of the code produced during the
coding phase and the goal is test the internal logic of the module/program. In the
Generic code project, the unit testing is done during coding phase of data entry forms
whether the functions are working properly or not. In this phase all the drivers are
tested they are rightly connected or not.
Integration Testing
All the tested modules are combined into sub systems, which are then tested. The
goal is to see if the modules are properly integrated, and the emphasis being on the
testing interfaces between the modules. In the generic code integration testing is done
mainly on table creation module and insertion module.
Validation Testing
This testing concentrates on confirming that the software is error-free in all respects.
All the specified validations are verified and the software is subjected to hard-core testing.
It also aims at determining the degree of deviation that exists in the software designed
from the specification; they are listed out and are corrected.
System Testing
This testing is a series of different tests whose primary is to fully exercise the
computer-based system. This involves
7. DEPLOYMENT
USER MANUAL:
If you (end user) want to enter into the form, then if you are existing user then
you should enter through login form which checks for authorized users. If you are new
user then you have to register your details through registration form with your own
identification name and password, which gives you a unique identification to you.
The Java is a new rapidly using platform that specifies application developed in the
highly distributed environment of the Internet. The java is design to fulfill the following
objectives.
To provide a consistent object-oriented programing software whether object
code is stored and executed locally, executed locally but internet distributed or
executed remotely.
To provide a code-execution environment that minimizes software deployment
and versioning conflicts.
To provide a code-execution environment that guarantees safe execution of
code, including code created by an unknown or semi-trusted third party.
To provide a code-execution environment that eliminates the performance
problems of scripted or interpreted environment.
To make developer experience consistent across widely varying types of
applications, such as windows-based applications and web based applications.
To build all communications on industry standards to ensure that code based on
the java can integrate with any other code.
8. CONCLUSION
9. BIBLIOGRAPHY
Websites
www.eci.gov.in
www.google.com
www.apeci.com
www.askjeeves.com
10. APPENDIX
GLOSARY:
API Application Programming Interface