Category: C#.Net Projects

Introduction to  Computer Science Department Portal Project:

Computer Science Department Portal is a web based tool used for online web based Departmental portal information where it contains three different modules those are Administrator, students and departmental staff. The main aim of this application is to increase the relation between student and Department, get more information and knowledge to students and keep tracking student details.

 It is easy to access for new user, to subscript this tool they need to fill the registration form on index webpage, and then the administrator provides full access to user to enter into the system with his/her login ID and password. Here each registered user can access all information which is displaying on the PHP based tool. This tool maintains the information on central based, syllabus details of different batches of CS Department. Students can also check their previous results, improve their skills using the provided documents and interact with their receptive teacher. Faculties can check the student details (profiles) and attendance on daily wises.

The Departmental portal Major inputs are Faculty details, different study materials, student name, year of study, semester and student attendance .Adobe Dreamweaver is a software to develop and MySQL is for Database to store all details of the users.

The portal contains the client and server architecture where client system need at latest 20GB hard disk with512MB RAM and Server system needs 160GB hard disk with 2GB RAM, this  architecture is runs on internet facility.

This project is runs on any kind of Browser (like IE, Mozilla, and Opera); here the usage of HTTP/HTTPs is communicate to client on internet.

The limitation is GUI is display only English, login on to portal must have user ID and password. 

Download  Project Report on Computer Science Department Portal .

E-learning has become popular these days and number of lecturers and students are attracted towards the online learning methods. E-learning has started its evaluation from distance education methods, where the education is not done at a class room level .

Distance learning has become successful due to many advantages like its flexibility, ease of use and learning from a remote location as well. Even the business aspects has raised a lot in E-learning and lot of returns are achieved based on E-learning business and it is around US$90 billion at the beginning of 2000. 

Mostly e-learning is used by the adults who are already working in some organizations, they are learning for a better qualification with out neglecting their current job and also with out disturbing their earning capability. This e-learning is not only popular for the working employees it is also used by the students and some job searchers also.

In the younger generation e-learning had become a daily requirement as the technology and internet is spread throughout the world . The fact is that e-learning or online learning is generally used by the teenagers. Even though it is popular and most used, e-learning has few limitations.  One of such limitations is learners who don’t have computer proficiency will use e-learning for attaining good knowledge as the e-learning mainly focuses on the computer technologies, but the learners who don’t have good computer skills will feel this as a barrier for them. The other limitation is, in e-learning the physical interaction among the learners will be limited . 

An effective e-learning is studied in this research and in general there are different e-learning models and methods in existence and most of them concentrate on different aspects and a typical high school is designed and implementation procedure is discussed in this research. Moodle is an object oriented e-learning system and this can be used to create an automated online education portal with the use of some customized templates.

The main disadvantage with these templates is that, if there is any issues with respect to programming and also if anything need to be updated it is not possible and in this I research I have given a design and implementation procedure to develop an online high school system similar to the Moodle and with this updating the software programmatically is very easy.

Student Module:

As already discussed, this module mainly concentrates on the retrieving of the existing data from the database or just to update the profile information of the student who logged in into the website. The explanation of the functionality of each tab related to Student module can be explained as below.(Screen shots have been provided in the appendix section for this document for better understanding. )

For proceeding into the website as student login with the given credential for a student.

 Home Tab:

When the Student clicks on this tab then he will be redirected to the Homepage.aspx where in which he can just get an idea of what actually this site is meant for. This page is common for both the Student and Administrator.

Profile Tab:

When the student clicks on the profile tab then he will be redirected to the Stu_editprofile.aspx page where in which the student can view his profile, which was created already during registration. If he/she feels that his/her profile should be changed then he is provided with an edit option which will redirect him to the Registration.aspx page from where he can update his existing profile and then submit that to the database of the school. The fields in this page can be explained as below.

Student Name: Displays the Name of the student as per the existing Data in the school Database.

• Father Name: Displays the Fathers Name of the student as per the existing Data in the school Database.
• Group: Displays the group of the student as per the existing Data in the school Database.
• Batch: Displays the Batch of the student as per the existing Data in the school Database.
• Email ID: Displays the email Id of the student
• Contact Number: Displays the contact number of the student
• Address: Displays the contact number of the students as per the school database.

 Events Tab: When the student click on the vents tab of the main menu then he will be redirected to the Stu_viewevents.aspx from which he can view the events that are going to happen in the period he specified. When the student gives the from data and to date with in which he want to view the events scheduled the list of the events that have been scheduled for that particular period will be displayed to student in  the form of a grid mentioning the event details such as Event Name, Contact person for that event provided the student feels interested in participating in any particular event. The fields used in the page will be explained as below.  

• From Date: Select the from-date of the period in which the student wants to view the events from the calendar control provided.
• To Date: Select the from-date of the period in which the student wants to view the events from the calendar control provided.

Result:Once all the required Data has been filled by the Student,he should click on the Submit button .Then a Data Grid will be displayed containing all the events present in that particular period

 Quiz Tab: When the student clicks on the quiz tab of the menu then he will be redirected to the Quiz1.aspx where the student will be provided with an option to select the course in which he would like to take the test. Once he selects the course then a list of questions will be appearing in front of him to start the test. Once the student finishes the test and clicks on submit button then he can view his score for the exam written. The fields in this page can be explained as below.

Select Course: Select the course for which the student is interested in taking the test from the list of available courses such as Maths, Science and Social.

Result:Once the student have selected the course in which he want to take the test then alist of questions will appear.After finishing the test the student is supposed to click on Submit button up on which the Result containg the score for that test will be displayed as a message. 

Learning Tab: When the Student clicks on the Learning tab of the main menu then he will be redirected to the Learninghome.aspx where in which he can see all the content that was uploaded for online learning. For each and every course that was uploaded there is a tab provided such as Maths, Science, Social etc. When he clicks on any one of the topics available there then he will be redirected to the corresponding course page.

Finally, when the user (either the admin or the student) clicks on the Logout tab then he will be logged out of the “The High School” website.

In addition to all the above there is one more option in this website which the students who doesn’t have their registrations yet into the “The High School” can use to register themselves into the website. This option was provided in the Default.aspx page as a Hyperlink. When the new student clicks on this hyperlink then he will be redirected to the Registration.aspx where he can fill all the required fields and then get his registrations done.

School website project documentation covers detailed explanation on modules and detailed explanation of every module are explained in this topic.

The High School website mainly contains the following tabs in the menu whose functionality will be varying depending upon the roles(Admin and Student).

• Home tab
• Profile tab
• Events tab
• Learn tab
• Quiz tab
• Logout tab

Now each and every Tab of the main menu will be redirecting the user to the different pages depending on the role of the logged in user. Here we have asumed that there is only one Administrator in this website and his login credentials are user Id =1 and pwd=”Admin1”.Rest all user IDs are treated as students.So when ever the user logs in with user id 1 then the system exibits the admin module functionality.For all other user IDs the system Exibits the Student module functionality even though the Menu tab remains the same for both the modules.Let us start describiting the difference in the functionality of each tab for Administrator role and Student role.

Administration Module:

In the Administration Module as already discussed all the insertions of data into the high school data base  will be taking place.The explanation of the functionality of each tab related to Admin module is a below(screen shots have been provided in the appendix of this document for better understanding).

Login into the website as an Administrator(means user id =1 and pwd = Admin1).

Home Tab:

When the Administrator clicks on this tab he will be redirected to Homepage.aspx where in which he can see the information like what actaully this website is meant for.This page is common both for the Administrator and the students.

Profile Tab:

When the Admin clicks on the Profile Tab then he will be redirected to the Registration.aspx from where he can register a new student into the high school database.By giving all the inputs Admin then clicks on the Submit button to insert a new student record into the database.The fields of this page are explained as below. 

• Student Name:Enter the Name of the Student.
• Father Name:Enter the father name of the registereing student.
• Group:Select the group from the available  list of groups such as Maths,Science,Social etc.
• Batch :Enter the year of the course eg:2005
• Email ID:Enter the email ID of the student
• Contact No:Enter the Contact number of the Student
• Address: Enter the Address of the Student.

Reset button is provided to clear all the textboxes that have been filled by the Admin so that the admin can upload one more student.

Result:Once all the Data has been filled by the Admin,he should click on the Submit button .Then a new profile will be inserted into the Database and a Message will be displayed mentioning that the Profile has been created successfully.

 Events Tab:

 When the Admin clicks on the Events Tab then he will be redirected to the EventsCreation.aspx from where he can create a new event into the highschool database.By giving all the inputs Admin then clicks on the Submit button to insert a new event that will happen in future in the school into the high school database.The fields of this page are explained as below .

• Event Title:Enter the title of the event which you want to get displayed to the student such as “Quiz Competeion for the Maths students”.
• From Date:Select the From date of the event i.e. the date on which this event is going to start in the school from the calender control which will appear on clicking the calender image  .
• To Date:Select the To date of the event i.e. the date on which this event is going to end in the school from the calender control which will appear on clicking the calender image  .
• Event For :Enter the specific group name for whom this event is emant for such as Science students ,for all etc.
• Contact Person:Enter the contact person name.
• Contact No:Enter the Contact number of the person in contact.
• Email Id:Enter the Email ID of the contact person.

Result:Once all the Data has been filled by the Admin,he should click on the Submit button .Then a new Event will be inserted into the Database and a Message will be displayed mentioning that the new Event has been created successfully.

Reset button is provided to clear all the textboxes that have been filled by the Admin so that the admin can upload one more Event.

Quiz Tab:

When the Administrtor clicks on the Quiz Tab then he will be redirected to QuizCreation.aspx page from where he can insert a new question into the database for each course selected by him.Here the Administrator is provided with a Dropdown list to select the course for which he wants the questions to be mapped.After giving all the required information to each and every question the Administrator clicks on Submit button to insert the new question into the Database which will be added to the questions list of a particular Course such as Social,Maths,Science etc. The fields of this page are explained as below .

Select Course: Select the course from the list of courses available in the dropdown list for which you want to map the questions that is going to be created.

• Question ID:Accepts an interger as a question ID for the the question which is going to be created.Eg Question ID = 1
• Question:Enter the Actual question which you want to be inserted in the Database for the selected course.
• Answer 1:Enter the first option of the asnwers tothe question.
• Answer 2: Enter the second option of the answers to the question given.
• Answer 3: Enter the third option of the answers to the questions given.
• Answer 4: Enter the fourth option of the answers to the questions given.
• Correct Answer: Enter the exact answer for the given question so that that can be used to calculate the result.

Result:Once all the Data has been filled by the Admin,he should click on the Submit button .Then a new Question will be inserted into the Database and a Message will be displayed mentioning that the new Question has been created successfully.

Reset button was provided to clear all the fields that have been filled by the Admin such that he can insert one more Question into the database by selecting the course from the available list of courses.

Learning Tab: When the Admin clicks on the Learning tab the he will be redirected to the Learninghome.aspx where in which he can see all the content that was uploaded for online learning. For each and every course that was uploaded there is a tab provided such as Maths, Science, Social etc.

 School Website Database Design:

This website was developed using Microsoft SQL Server 2008 as the backend. The database design contains few tables and store procedure as per the requirement. Few tables designed were as below

School_users : This contains the data related to all the users of the website such as the student name, Fathers name, course, batch, email, contact number, address etc.

Courses: This table contains the course id and course name that have been assumed in our website such as Maths, Science, Social etc.

Questions_list: This table contains the questions and the corresponding answers as well as the course_id to which that question belong.

Events_list: This table contains the complete information related to the events of the school, which has been conducted, or going to be conducted in future in the school.

Instead of having inline queries written in the DAL we have created stored procedures for all the necessary functions to get reusability of the created stored procedures and to maintain perfect coding standards throughout the website. The stored procedures created for this school website can be explained as below.

sp_createEvent :This Stored procedure is used to create a new event i.e. to insert an new event into the high school database by the administrator which is going to happen in future.

sp_getevents :This stored procedure is used to retrive the events that have been scheduled during that period when given the from data and to data by the students.

Getquestions : This Stored procedure is used to retrive the questions from the database depinding upon the course seleted by the student for the quiz.Here the iput is Course ID.

Sp-getprofile:This Stored procedure is used to retrive the pofile of a particular student when he click on the profile on the menu tab in his login.

Updateprofile :This stored procedure is used to update the existing profile of any particular student in the student login when even the student feels to uodate his existing profile.