Sample Internship Report

1. Objectives

Our Student Management System aims to develop the automated system of administration of students including student new recruitment, student attendance, and student examination and looking up the student profile in details and this automated system is web-based intranet system.

1.1 Business Problems

In the past, all these modules mentioned above were kept track by administrator and lecturers in manual and all the necessary data were stored in files. As a result, data may be lost and times for keeping track of these modules were consumed. Moreover, all the users cannot easily access these units and also cannot easily maintain the records of applicants and students systematically.

1.2 Project Scope

“Student Management System” covers:

 Can automate in recruiting new applicants for new batch
 Auto-generate in calculating Aptitude Test and Interview grade in advance.
 Selection of new applicants can be easily and automatically done in exact results.
 Able to calculate particular student’s attendance percentage and also able to easily generate report for overall attendance percentage of all students.
 Automatically generate the student’s grade in details and individual records can be kept in central database.
 Can easily maintain each and every applicant and student records in advance.
 In every phase, system can easily export data for back-up and can easily generate the reports for official use.


1.3 Project Impact

With the computerized system, the following improvement in process is expected:

 Communication between administrator and lecturer possible in an easy way
 Lecturer can evaluate the students simply
 Automatic calculation of examination results
 Turnaround time for creating reports would be shorten
 Easy allotment of students for SA Course


1.4 Project Goals

 Our project goal is to make the users friendly in use of the system and support the needs of current organization.
 Every manual task is already transformed into automated system and easy to use and time-saving.
 Communication between lecturers and administrators is becoming effective.
 All the error-prone conditions are reduced by this system and can get clear and exact results of data in every phase.
 All the users can have access this system from own client machine and can easily generate the reports for official use.
 Student management system is very much reliable for future enhancement and further development.

2. Project background

Our team members were commissioned to build a computerized system for XXX to build a system for Graduate Diploma in System Analysis. The computerized project is undertaken to improve the manual system. The computerized system needs to address some of the issues faced by the manual system such as

 Information stored in various places
 Long lag time to create reports
 A lot of effort spent keeping manual records up to date
 Difficult to manage the students to select aptitude test, record their mark for aptitude test, interview selection, final selection for SA
 Student attendance was marked manually
 Manual calculation was done for examination grade, cap point, total mark and required grade if the students failed to meet the minimum appoint
 Manual entering of lecturer comments

And this computerized system needs to be web-based intranet application that can be accessed by anywhere in the organization. And future maintenance and further development will be able to need to perform in this computerized system.


3. Project details

3.1 Nature of assignment domain
Our project mainly consists of five sections- Recruitment Attendance, Examination, Maintenance, Look-up details. To present in details

Student Recruitment System
This system is designated for recruiting new applicants for new batch and this system will be mainly accessed by administrator. This system includes starting from importing new applicant excel file and passing through the phases of aptitude test mark entry/selection, interview grade entry/selection, final SA Student selection, entry of matric no and nus email etc. In every step, the administrator can generate report and also can export the data out for back-up.

Student Attendance System
This system is designated for saving and tracking of the attendance of the SA students from the latest batch and this system will be mainly accessed by administrator. This system includes saving the attendance, modifying the attendance, viewing the attendance report and exporting the attendance to excel file. At the end of the semester, administrator can view the percentage of the attendance of all the SA students.

SA Maintenance System
This system is designed for adding new Lecturer, Administrator and source of information. And this system is used by SA administrators. There are also include amend and delete for lecturers, Administrators, SA applicants, SA students. Their profile details can be amended if there is any changes and can also been deleted if there is duplicate data or profile is no more needed.

Student Look-up details
This system is designated for reviewing particular student’s profile details including student’s profile, working experiences, education background, examination details. Moreover, this system is mainly used by SA lecturers and there is a module for adding new comments for particular students by lecturers. Then, lecturers can review the comments of lecturers. Finally lecturers can generate the report out for official use.

Student Examination System
This system is designed mainly for Graduate Diploma in Systems Analysis (SA).This application is mainly used by the administrator. The program mainly used to import the excel file which contains student details such as name, matric no, citizenship, education and mark for each paper. the program will calculate Grade point for each paper, overall Cap point, Required grade if the student failed to meet minimum appoint in the semester and total mark. Another phase of this application is to back up every data to excel file through exporting.

3.2 Job Responsibilities

In Student management system, there are five main sections namely student recruitment system, student attendance system, student examination system, student maintenance and student look up details. We all shared our workloads as follows:

Student Recruitment System - XXXXX

Student Attendance System - XXXXX

Student Examination System - XXXXX

Student Maintenance System - XXXX

Student Look up Details - XXXXX and XXXXX

Student Analysis - XXXXX


3.3 Software used

Being a web-based intranet application, our student management system needs such technologies and tools that we have shown as follows:

 Microsoft Visual Studio 2005
 Microsoft ASP.Net 2.0 using C#
 Internet Information Services (IIS)
 Microsoft Office 2003 ( Excel )
 Rational Rose
 Microsoft Project Plan

3.4 Project Statistics

In our Student Management System is based on 3-tier architecture and used Unified Modeling Language (UML).

Number of System Use case : 24 system use cases

Number of Screens created : 54 screens including reports

Number of tiers used : Presentation Layer
Business Layer
Data Layer
Report Layer


4. Deliverables given to organization

The following items are the necessary deliverables given to organization.
 Project Plan
 Business Use Case Model Survey
 Business Object Model Survey
 Requirement Specification( Functional Requirement )
 Requirement Specification( Non-Functional Requirement )
 UI Design
 Analysis Models
 Design Models
 Relational DB Design
 Code
 Test Case and Test Result
 Running Application

5. Accomplishments

We all achieved every task and phase that we defined in project plan. According to our project plan, there were no milestones mXXXed in every phase. It is sure to say that we can perform what user needs in our system. Finally, we can successfully release the final running software and perfectly passed through every User Assessment Test phase. Therefore, we can conclude that we’ve successfully done every task required for our student management system.

6. Innovation

We’ve successfully applied what we have learnt in our institution. Also, we can enhance our skills and abilities that can make us boost in our technical skills. And also we became understandable and gained many experiences how to negotiate relationship between users and clients. Problem solving is our major achievements in this period of application project. Therefore, we fully understand the whole SDLC and two sorts platform such as client-server and internet-based technologies.

7. Challenges

We faced a lot of challenges during this project but we took it as a self learning motivator. Initially we started developing the system in windows platform but to meet up with the user requirements we had to change it into web platform. For this, the main problem is time constraint. System Integration process was quite cumbersome as programmers used independent coding techniques and terminologies. This was responsible for an increased time spent during the integration process and reduced the time available for testing. Database structure had to be frequently updated as a few requirements were overlooked during the database design process. Also, initially, there was no centralized database used by individual programmers which led to inconsistencies in certain data retrieval functions. Quality control was tightened for the coding process to make sure that individual programmers conformed to the original UI specification and programming standards. Form/ report names, methods and controls were standardized to ensure that a common standard was practiced by everyone. UI specification was also expanded to include even the minute details. Every team members were required to document and submit the respective variable names, methods and controls before handing it over for final integration which helped to ease the required integration effort.