Main Body

CHAPTER I INTRODUCTION ___________________________________________________________________________ 1.1 MOTIVATION The “Student Asset” is a project which assists the students in their daily academic life with an interactive and resourceful application which helps to enhance the academic performance of students in an institution. Viewing of syllabus, alerts on classes and announcement notifications are the basic features which will be made available. The student asset will not only be for students but for teachers as well. Students will be able to mark certain subjects or topics as their priority and upload their marks for the respective subjects for reference purpose in order to improve their academic performance. 1.2 PROBLEM STATEMENT At times students tend to lose their focus in class or miss out some classes and hence lose track of syllabus which later leads to poor academic performance. Students sometimes are unable to acquire the required book from the library. Students usually fail to submit the assignment on due date. Majority of the students have problem in keeping track of class’s time-table. 1.3 METHOD The web-based application has been developed using Microsoft ASP.net as the front end and SQL database as back-end. Each authorized person will be given a Registration ID and password, while the other users such as students will only be allowed to view but will be able to alter personal data. Notifications will be given to ensure the students do not miss out on important events. The notification function also assists the teacher and students in making announcements. The students can even view the class time table and download notes uploaded by their teachers. 1.4 EXPECTED RESULTS Using a checklist of topic from the syllabus by the teachers will allow the students to view the completed, current and upcoming topics. The application will allow the students to download important notes, .ppt and .pdf. It will also be able to provide notification for submitting the assignment, upcoming classes, special guest lectures and announcement. CHAPTER II LITERATURE SURVEY ___________________________________________________________________________ 2.1 LIBRARY MANAGEMENT SYSTEM ITCS By: Darren Adams, Sergey Begun, Andrew, Fail, Shawn Hailer, Franklin Lee Published on: April 18, 2007 Objective To create a system that can keep track of library cards, customers, librarians, library locations, books, videos, and the relationships between them. Using Java Server Pages, servlets, and JDBC to develop an Internet-based graphical user interface that allows customers and librarians to access the system remotely. Advantages Video Library included. Virtual as well as physical book available. Disadvantage Poor account management features i.e. it lacks privacy for users. Non-members can easily breach the security. REQUIREMENTS ANALYSIS FOR A STUDENT INFORMATION SYSTEM By: Jilang Pan -BSc Information System & Management Studies Session (2003/2004) Objective Investigate what the current Student Information Systems of three different university schools and produce a detailed requirement specification for the potential new Student Information System of general university school. Advantage On click interface to provide integration of module information, timetabling and coursework schedule to corresponding module. Active User involvement. Collection of feedback to improve the system. Disadvantage Complicated User Interface. Information access Limited. 2.3 ASSIGNMENT & MARKS MANAGEMENT AND THE RESULTS PROCESSING SYSTEM (RPS) By: Raymond Hansen – Student Administration Published on: 12 June 2013 Objective To acquire data from Student management system and Assignment management system, and combine their data to form a Marks and Result processing system. Advantage High-end Security. Assignment date tracking. Automatic percentage calculator. Disadvantage Can only be used in internal evaluation. Inaccuracy in marks distribution. 2.4 SOFTWARE REQUIREMENT AND SPECIFICATION 2.4.1 Development Environment Windows 8.1 pro 64bit Processor : Intel(R) Core(TM) i7-4570T CPU@2.90GHz 2.90GHz 1TB HDD 8GB RAM Microsoft Visual Studio 2010 Microsoft SQL Server 2008 2.4.2 Hardware Requirements Intel Pentium III@1.5GHz and above 256 MB RAM(minimum) and above 2GB free hard disk space or 5GB(recommended) 2.4.3 Software Requirements Microsoft Windows 2000, or above OS. Web browser – Chrome, Mozilla Firefox, opera, Internet Explorer, etc. CHAPTER III USER GUIDE ___________________________________________________________________________ 3.1. LOGIN PAGE Fig: 1.1 The student asset’s login page is used for all user types i.e. students, faculty and admin. For other users who have not registered to our website a link has been provided which would redirect them to our registration page. Upon succession in login the page is redirected to either Teacher interface or Student interface or the Admin interface. 3.2 REGISTRATION PAGE Fig: 1.2 This page as name suggests is for new users, the registration consists of two option for new users. Fig: 1.3 Based on their user type (student or Faculty) they can fill up the form respectively. The Student’s account is prepared immediately whereas due to security reasons the Faculty registration goes though the admin confirmation before an account is allocated to them. An OTP mail is sent to the registered Email ID (university issued email ID recommended). After the OTP is received the Faculty can use it as password to login. Student in the other hand have to confirm account via sent OTP. 3.3 USER INTERFACE Fig: 1.4 The faculty Interface consists of multiple links to different page modules. It also consists of panels showing recent activity and announcements. Fig: 1.5 The Admin Interface is quite similar to teacher interface the difference is admin have been given additional responsibility such as maintaining day order, approving registration etc. The student interface very much simple as it is lower version of the teacher interface. 3.4 SYLLABUS CHECKLIST In the faculty interface of this page the teacher is granted permission to create subject and add topic based on units. It is to be noted that the teacher can only alter and delete the subject he/she has created. Upon adding topic to the syllabus it is by default set as “pending” which refers to the state that the topic haven’t been taught yet, later after the teacher can change the status as “covered” indicating the topic has been covered. Fig: 1.6 As the faculty create the Syllabus the student can view the changes to the subject from their version of syllabus checklist. They aren’t allowed to make changes or create anything here only view. 3.5 TIMETABLE INTERFACE Fig: 1.7 In this interface most of the responsibility lies with the Admin since its admin’s responsibility to upload and update timetable. 3.6 LIBRARY Fig: 1.8 For better understanding of topics and subjects teacher tends to provide reference book as pdf files to students so therefore to widen the distribution of such reference book pdf library is made available for teacher to upload pdf files. Fig: 1.9 Student whereas can only download the provided books, upload privileges is not provided to the students. 3.7 NOTES ARCHIVE Similar to Library teachers can upload .ppt, .doc, .docx files for students to study in notes archive page. Here too student can only download files. The notes archive is kept separate from library to segregate teacher given notes and recommended books. Fig: 1.10 CHAPTER IV CONCLUSION AND TECHNICAL OVERVIEW ___________________________________________________________________________ 4.1 FUTURE SCOPE Depending on the success of our web application we would like to take a step further and design an android application with student forum blog feature, SMS notification and custom event alerts, Marks Calculator, Goal setting etc. 4.2 CONCLUSION Based on the findings and the interactions we had so far with the students of our university we can conclude that we all share common problems such as maintaining study time, submission of assignments on time, tracking of syllabus and class time-table. Hence have developed an application to assist the student to resolve such issues. It is to be noted that “The Student Asset” is only here for assistance and there is no guarantee using this web application will increase a student’s academic performance significantly. 4.3 GANTT CHART April 22 – May 15 April 18-April 21 April 12-April 17 March 21-April 11 Feb 11-March20 Maintenance Testing Implementation Deployment System Design Requirement Analysis Documentation Feb 2-Feb 10 Fig: 2.1 Gantt chart 4.4 USE-CASE DIAGRAM Fig: 2.2 Use-case diagram  4.5 ER-DIAGRAM Fig 2.3 ER-Diagram  4.6 DATA BASE TABLE 4.6.1 Database.mdf Login Table S.No Field Name Data Type Description 1 Type Varchar(50) Indicates the different login types. 2 Name Varchar(50) Store the Name of the Faculty/student name. 3 Reg_ID Varchar(10) Store Reg_ID for checking correct registration ID. 4 Password Varchar(50) Store password corresponding to Reg_ID. Table: 1.1 RequestID Table S.No Field Name Data Type 1 Type Nvarchar(50) Indicates The User Types 2 Fname Nvarchar(50) Name of the Faculty 3 Reg_ID Numeric(10,0) Unique University issued Reg_ID 4 Email varchar(100) University Mail ID 5 Password varchar(50) OTP generated Password 6 Department nvarchar(50) IT, Management, etc. 7 Phone_no Numeric(10,0) Contact no. 8 Status Varchar(20) Indicated the status where the account is approved or not Table: 1.2 Faculty_List Table S.No Field Name Data Type 1 Reg_ID Numeric(18,0) 2 Fname Varchar(50) 3 Password Varchar(50) 4 Email Varchar(50) 5 Department Varchar(50) 6 Phone_no Numeric(18,0) Table: 1.3 Student_List Table S.No Field Name Data Type 1 Reg_ID Varchar(10) 2 Fname Varchar(50) 3 Email Varchar(50) 4 Password Varchar(50) 5 Year_of_Joining Numeric(18,0) 6 Class Varchar(50) 7 Current_sem Varchar(50) 8 Phone_no Numeric(18,0) 9 Department Varchar(10) Table: 1.4 4.6.2 Database2.mdf Library_Books Table S.No Field Name Data Type Description 1 Book_Name Varchar(50) Stores the name of the book 2 Author Varchar(50) It indicates the name of the author of the book 3 Edition Numeric(18,0) Indicates the edition of the book 4 Publisher Varchar(50) Name of the publisher of the book 5 Uploder Varchar(50) Name of the unloader 6 Uploaded_on Datetime Date when the file was uploaded 7 For_class Varchar(50) Recommended to the given class 8 Sem_year Nvarchar(50) Specific class year 9 FileName Varchar(50) Name of the file Table: 1.5 4.6.3 Database3.mdf Anounce Table S.No Field Name Data Type Description 1 Ann Nvarchar(max) Announcement Body 2 Date_added Date Date and time of announcement Table: 1.6 Dayod Table S.No Field Name Data Type Description 1 Days Varchar(50) Order of the day 2 today Varchar(50) Day order setter Table: 1.7 RA Table S.No Field Name Data Type Description 1 Activity varchar(max) Storage for important Activity done 2 Date_added Date Date of the activity performed Table: 1.8 TimeTable Table S.No Field Name Data Type Description 1 Type Varchar(50) Time Table type whether Teacher or Class 2 Name Varchar(50) Name of the Class/Teacher 3 FileName Varchar(50) Name of the file with timetable image Table: 1.9 4.6.4 Database4.mdf Subject_List Table S.No Field Name Data Type Description 1 Subject_Name Varchar(50) Name of the Subject 2 Class Nvarchar(50) Class Name 3 Subject_ID Varchar(50) Unique Subject ID 4 Semester Varchar(50) Semester no. for subject 5 Fname Varchar(50) Name of the Teacher responsible for the subject Table: 1.10 “Subject Name” Table S.No Field Name Data Type Description 1 Unit Numeric(10,0) Unit No. 2 Topic_Name Varchar(100) Name of the topics 3 Status Varchar(15) State of topic whether covered or pending 4 Date Datetime Date when the subject is taught/covered Table: 1.11 REFERENCES Websites https://www.w3schools.com/asp/ ,https://www.tutorialspoint.com/asp.net/ ASP.net Tutorials ( assessed on 13/2/2017) https://www.w3schools.com/css/ , http://www.csstutorial.net/ CSS Tutorials ( assessed on 13/2/2017) http://csharp.net-tutorials.com/ ,http://csharp.net-tutorials.com/ C# tutorials ( assessed on 20/2/2017) https://www.w3schools.com/sql/ SQL Queries for ASP.net ( assessed on 23/2/2017) https://www.tutorialspoint.com/asp.net/asp.net_data_binding.htm Data binding in asp.net using C# ( (assessed on 27/2/2017) https://www.codeproject.com/Articles/7943/Validator-Controls-in-ASP-NET ASP.net validation (assessed on 24/2/2017) https://www.stackoverflow.com/ for multiple code reference. (assessed on 25/2/2017) http://www.c-sharpcorner.com/uploadfile/rekhasingh1610/session-object/ Session Object (assessed on 3/3/2017) STUDENT ASSET STUDENT ASSET 11 11 SRM UNIVERSITY, SIKKIM 16 16 SRM UNIVERSITY, SIKKIM