A Brief Executive Summary of the Internship

In order to better complement the theoretical knowledge acquired in class, the intern was required
to go for an academic internship in an organization for a period of six months. The intern was
opportune to learn various web technologies which he at the end built a project about “Online
Registration System”. This is a web application structure that provides a simple set-up of programs
for student enrolment. This project therefore include the process of designing, building and testing
a web application system to be used in a school. The main aim of the project was to create a
working web application which can handle the registration of students in an educational
establishment online using different web technologies like HTML, JAVASCRIPT, CSS, PHP
AND MYSQL as web languaes and Brackets as the programming environment.

i
 TABLE OF CONTENTS

A Brief Executive Summary of the Internship ........................................................................................ i

TABLE OF CONTENTS ..........................................................................................................................ii
LIST OF FIGURES ................................................................................................................................ iii
Definition and interpretation of terms used in the Internship Project. ............................................ iv
CHAPTER ONE ....................................................................................................................................1
1.1 Description of the company/institution ............................................................................................. 1
1.2 LOCATION OF QUODATICS Inc ........................................................................................................... 2
1.3 Aims and Objectives of the Company ................................................................................................ 3
CHAPTER TWO ...................................................................................................................................4
2.1 Overview Of The Internship Project ................................................................................................... 4
2.2 BACKGROUND OF THE STUDY....................................................................................................... 4
2.3 Statement of the problem. ........................................................................................................... 5
2.4 Aims and objectives of the study. ................................................................................................ 6
2.5 Significant of the project ............................................................................................................... 6
2.6 Scope of the project. ........................................................................................................................... 7
2.7 Limitations or weaknesses of the internship project ................................................................... 7
CHAPTER THREE .................................................................................................................................9
3.1 INTERNSHIP PROJECT CONCEPTION .................................................................................................. 9
3.1.1 Registration Form: ....................................................................................................................... 9
3.2 Design and detailing .......................................................................................................................... 11
CHAPTER FOUR ................................................................................................................................ 12
4.1 INTERNSHIP ACHIEVEMENTS AND REALIZATION OF PROJECT ........................................................ 12
4.2 Project planning and scheduling ....................................................................................................... 18
4.2.1 Project planning .................................................................................................................. 18
4.2.2 Project Scheduling...................................................................................................................... 19
4.3 Interpretation and discussion of test results .................................................................................... 20
4.3.1 Testing ........................................................................................................................................ 20
CHAPTER FIVE .................................................................................................................................. 22
5.1 SUMMARY, CONCLUSIONS AND RECOMMENDATIONS ............................................................. 22

ii
 LIST OF FIGURES

Figure 1: Location of Quodatics .................................................................................................... 2

Figure 2: Registration home page ................................................................................................. 12
Figure 3 registration page ............................................................................................................. 13
Figure 4: Acknowledgement page ................................................................................................ 14
Figure 5: Log in Page .................................................................................................................... 15
Figure 6: profile page ................................................................................................................... 16
Figure 7: Student Result Page ....................................................................................................... 16
Figure 8: Student Result Page ....................................................................................................... 17
Figure 9: Student lecture timetable ............................................................................................... 18

iii
Definition and interpretation of terms used in the Internship Project.
• Use case diagram: Is a representation of a user's interaction with a system
• Sequence diagram: Shows object interactions arranged in time sequence PHP: Hypertext
pre-processor
• MYSQL: My structured query language
• MYLSQLI: My structured query language improved
• HTML: Hypertext make up language
• Web Application: Is a software that runs on a remote server.

iv
 CHAPTER ONE
1.1 Description of the company/institution
Quodatics Inc is a child company of Yems Group Incorporated which started as a mustard seed
company in 2006 with just 2 people at mile 3 Nkwen at the time. The parent company Yems Group
was just into web development and hosting, but as time goes by, it started offering different
services.

Yems Group Inc is out with the mission to offer Business and I.T Solutions which foster growth
and sustainability in enterprises and add value to our stakeholders, the environment and the Global
Economy.

Some of the services offered includes:

Website Design and Development; they build fast, robust, simple, cross-platform Websites and
Applications which help their clients achieve their specific objectives.

Digital Marketing; They work with their clients to review their Digital Reputation, identify
appropriate communication channels, Plan and Implement Digital Marketing Campaigns aimed at
increasing their outreach, Brand Recognition & Loyalty and driving Sales.

Corporate Branding and Graphic Design; Yems group believe that people remember brands and
how they make them feel, organizations must be able to establish powerful brands which stand out
and reminds their customers that they’re Number 1. They work with clients to conceive brands,
develop brand strategies, design and create Brand Gadgets, messages and tools with the aim of
improving Brand Recognition, Loyalty and driving Sales.

Over time as the Company grew, It gave birth to a child Company (Quodatics inc) and passed over
all the above mentioned services to the child company.

1
 1.2 LOCATION OF QUODATICS Inc
Quodatics is situated at first off license junction Ndamukong bamenda

Bayelle Catholic church

Mile 2 Junction
Nkwen

New road junction Total Nkwen

Junction

Bayelle credit
union

First Off license

Ndamukong

QUODATICS Inc
KEY

BUILDINGS

Figure 1: Location of Quodatics ROUND ABOUT

DIRECTIONS

2
1.3 Aims and Objectives of the Company
In an increasingly connected world, being present (via website or application ) on the World
Wide Web is becoming more than a necessity.

Enterprises need tools to ease or fully automate some of their processes or day to day tasks
which when done manually are tedious, costly and most often than not, error-prone.

Quodatics Inc is therefore aimed at building fast, robust, cross-platform websites and
Applications which helps their clients achieve their specific objectives.

3
 CHAPTER TWO
2.1 Overview Of The Internship Project
Student online registration system is a web application to manage all day to day operations
for a university. Online registration system is a structure that provides a simple set-up of programs
for student enrolment. It is an approach that enables colleges and universities to better supervise a
growing number of enrolments digitally.

This system also allows you to reap the benefit of a massive cost reduction in your annual
enrolment and registration process. No more paper to lose, no more trying to figure out what the
student wrote. Instead, you end up with clear validated data that is ready for your establishment
and your students.

In today's economy, many schools are looking for ways to save money. Student online registration
system is a combination of money and time saving modules which have proven to reduce the
amount of paper forms in every day school administration, speed up registration, and greatly
overhead. This system is easy to understand and learn with an intuitive interface and modular
design.

2.2 BACKGROUND OF THE STUDY.

The field of Information technology has improved tremendously in the past decade with
the invention of all kinds of new technologies for example e- commerce, e-learning and online
registration to mention just a few. The proposed model is to implement online registration system
with the overall view of improving efficiency in the registration process. The need to speed up the
process of registration at institutions of higher learning is more vital and need is there to automate
the process itself and move away from manually visiting the school

for the process. This has wasted much time for students and money as they sometimes travel only
to register and some have failed to meet the stipulated time frame

There are a lot of chronological steps that need to be followed in the manual registration process
chances are high that mistakes can be made for instance students can register a course that is not
being currently offered that semester or registration of a course which a student would have failed
the prerequisite course. Some higher institute of learning will complain on time lost during the

4
first weeks of a semester because students spend time in long queues trying register thereby failing
to attend lectures since teaching would have commenced yet students will be still registering. This
internship report presents my experience in developing. deploying and running an online student
registration system. In this system, students register for their departments online, which are
processed automatically to provide a set of reports to the administrative staff at the office, where
the information is used. Most aspects of student registration and enrolment such as prerequisites
and minimum qualification the maximum number of courses a student can do per semester, etc.
are checked automatically reducing the burden (time and pressure) of the advisers and the
administrative staff.

I have also come to discover that with manual registration systems, it takes more effort and
physical space to keep track of paper documents, to find information and to keep details secure.
When mistakes are made or changes or corrections are needed, often a manual transaction must be
completely redone rather than just updated. With manual or partially automated systems,
information often has to be written down and copied or entered more than once Systemization can
reduce the amount of duplication of data entry. Some of the problems faced by manual systems
include:

• Inconsistency in data entry, room for errors, miskeying information.

• System is dependent on good individuals. Time consuming and costly to produce reports.
• Lack of security.
• Duplication of data entry.
• Paper wastage.
• Handwriting misinterpretation.

With all that has been said, it brought me to one question; does systemisation has such benefits,
why aren't all schools or establishments running on fully integrated systems. All of these issues
and more can be solved by bringing in a computerized system to manage the information flow.

2.3 Statement of the problem.

The need to utilize time wisely for those students who travel just to register at the institution and
who find the unbearable queues just to collect a form that one has to move around to get it signed
and sometimes finding the responsible personnel not in the office at the time of need. This brings

5
more frustration especially when one has a lot of work to do other than being at the institution to
register. The need to do all this process at the comfort of one's home or work place thereby
maximizing the time one puts on personal issues during the vacation time. There is a notable loss
of time of the lectures on the first days when those who registered late could not attend the lectures
in a bid to finish off the registration process. The aspect that the Information Technology is seen
as another great supporter of the environment friendly development, this system by getting rid of
the manual paper work would have complied with the Green IT initiative.

2.4 Aims and objectives of the study.

Student enrolment has been a tedious process for both the students and parents. They have to fill
out the same information over and over. Sometimes, skipping very important questions and papers
invariably get lost forcing them to fill it all out again. For you, it means that staff or volunteers are
required to try and figure out exactly what those parents wrote and hand enter it into your student
information system. Hopefully they entered it correctly. This system also allows you to reap the
benefit of a massive cost reduction in your annual enrolment and registration process. No more
paper to lose, no more trying to figure out what the student wrote. Instead you end up with clear
validated data that is ready for your establishment and your students.

The principal goals of this project was:

• To create an an online registration system

• To develop an accurate and easier way of registration.
• To generate reports needed for enrolment.
• To provide a user friendly enrolment web application in managing enrolment of old and
new students.
• To analyze the impact of an online registration system in an educational establishment

2.5 Significant of the project

Gone are the days of long registration queues and paper forms to sign up or register in an
institution. An increasing number of colleges and institutions both large and small are embracing
online registration services as an added value for both them and their participants, Online
registration not only improves efficiencies and eliminates unnecessary paperwork, it also

6
maximizes participation and improves marketing capabilities while allowing participants to sign
up when and where it is most convenient for them from any internet-enabled device.

The significance of taking student online registration are:

• Save time: opening, entering and sorting out illegible or inaccurate forms can be very time
consuming, so just by eliminating these processes off your duties you are set to get at least
4 less administrative work hours per week.
• Centralize data processing 24/7: collect student data, view number of students that have
been registered into the system, assign students with user name, create student account and
manage student profile with the database.
• Set up online surveys: To get to know better your participants interests and measure your
participants experience at the event. A good online registration system will also integrate
an online survey tool
• Improve marketing efforts: with the ability to e-mail the database via a central
management system, organizers will not only notify participants of future events, but also
track their open rates and response.
• Detailed reporting: The system should provide an insightful reporting into payments
received and due, refunds given, multi- event analysis and all other reporting tools essential
to efficiently manage a successful event.
• Customized online registration: A good online registration provider will permit full
customization of your event registration page to the look and feel you want to give it.

2.6 Scope of the project.

This online registration system is a portal type that covers the major processes in the registration
system, namely registration and enrolment of students and file maintenance such as list of enrolled
students in different year levels and departments. Administrators have total access to the system,
view students records that are officially enrolled and generate or print records of the students,
search student profile information and viewing subjects at any semester.

2.7 Limitations or weaknesses of the internship project

This application has many merits but never the less; it has it own demerits, which are listed below:

• This system does not cover the computation of Students grades,

7
• Class scheduling.
• Viewing of teachers and paying of fees,
• Not accepting any online payments, Can be manage only by an I.T skilled person,
• It can only operate for application purposes, Must have access to the internet.

8
 CHAPTER THREE
3.1 INTERNSHIP PROJECT CONCEPTION
3.1.1 Registration Form:
• Fill in all information necessary to enroll in the institution
• After you will receive an acknowledgement message confirming your registration.

Student Profile:

• Students can see their lecture timetable

• Students can see school notifications
• Students can send a message to the administrator and get feedback through e-mails.
• Students can see their results

3.2 Characteristics of materials used

With the popularity and advancements in web technology, it is imperative for every business to
have a website and one which is highly functional and visually attractive. The process through
which a good website, mobile apps or other similar platforms are created is known as web
development. One of the most integral aspects of web development is web programming that is
achieved with the help of programming languages, Web development languages are the platforms
through which instructions are communicated to a machine and actions are pursued.

In other to realized the project, various web programming languages and and a local serve was
used. They include:

• PHP
The term 'PHP' is used to define PHP Hypertext Processor language that is a free
server-side scripting language that has been designed for not just web development but also
as a general-purpose programming platform This is a widely used language that was
created in the year 2004 and now powers over 200 million websites worldwide. Some
popular examples of websites powered by this platform include Facebook, WordPress, and
Digg.com.
• CSS:
9
 Cascading Style Sheets is rather a markup language. When paired with HTML, CSS
allow a developer to decide and define how a web page or a website will eventually look
or how it will appear to the visitors of the web platform. Some of the elements which CSS
has an impact on include font size, font style, the overall layout, the colors and other design
elements.
• JavaScript
JavaScript is one of the most popular and dynamic programming languages used
for creating and developing websites. This language is capable of achieving several things
including controlling the browser, editing content on a document that has been displayed,
allowing client-side scripts to communicate with users and also asynchronous
communication. It was developed by Netscape and borrows a lot of its syntax from C
language. JavaScript is used very widely and effectively in creating desktop applications
as well as for developing games.
• MYSQL
MySQL is an Oracle-backed open source relational database management system
(RDBMS) based on Structured Query Language (SQL). MySQL runs on virtually all
platforms, including Linux, UNIX and Windows. Although it can be used in a wide range
of applications, MySQL is most often associated with web applications and online
publishing.
• MAMP
MAMP is the commercial, professional frontend for the classic local server
environment: MAMP. With MAMP PRO you can create a separate host for each of your
web projects. Install WordPress with only one click and after completion of your page,
publish it directly from MAMP PRO on your live server. This is just a small part of what
you can do with MAMP PRO.
• BOOTSTRAP
Bootstrap is a free and open-source CSS framework directed at responsive, mobile-
first front-end web development. It contains CSS- and JavaScript-based design templates
for typography, forms, buttons, navigation and other interface components.
• HTML

10
 Hypertext Markup Language is the standard markup language for documents
designed to be displayed in a web browser. It can be assisted by technologies such as
Cascading Style Sheets and scripting languages such as JavaScript

3.2 Design and detailing

While designing the web application portal a three tier architecture for application
development was followed. The presentation tier occupies the front end design of the
application. It relates to every entity with which the user interacts. It accepts user inputs
and actions, and then sends this information to the data tier through the application tier for
further processing. The student course registration portal accepts input in the form of
student's personal detail, student's registration details, faculty details etc. The second tier is
application tier, it serves as an intermediary to the presentation tier and the data tier. It
applies business logic to the input received from the presentation tier. The business logic
is applied combining the information collected from upper and lower layers of the three
tier architecture. When a student or a faculty member asks for a report to be retrieved, on
the basis of this command data is fetched from the database and the required business logic
is applied and finally a report is displayed to the user. The third and final tier is the data
tier which is concerned with the design of the database to be used with the web application.
It is concerned with maintaining central servers and its information. The data tier is kept
independent of application servers and business logic to promote data security. The
database is developed using MySQL keeping in mind the authenticity concerns of different
users. All the necessary primary keys and access controls are depicted with utmost care.

11
 CHAPTER FOUR
4.1 INTERNSHIP ACHIEVEMENTS AND REALIZATION OF PROJECT
• System Development

The system was developed successfully resulting in the following below, a brief of the entire
solution.

• Home Screen

The figure below shows the home screen of the application. It is also possible to view the web site
of institution from the home screen of the application and also know more about the institution

Figure 2: Registration home page

From the home screen above, it is possible for a new student to register into the institution as well
as it is also possible for existing students to sign into the accounts.

• The registration page

12
This is a form whereby students are expected to fill in necessary information for their enrolment
in the institution. On this, students are also expected to send in all the necessary documents to be
sure that they completed college education. The figure below show the registration page

Figure 3 registration page

• Acknowledgement page

After filling all the necessary requirements at the registration page, the system send you a message
telling you: your information has been receive you are now registered into the institution.

13
Figure 4: Acknowledgement page

When this message is shown, it means you have access and an account in the system. You can log
into this account by typing your user name and password.

• The login page

In other for a student to have access to his or her account, he or she is expected to log in to the
system using your user name(first name) and a password. When this information is entered, you
will be taken to the student profile account.

14
Figure 5: Log in Page

• The profile page

In this page, a student can view his or her personal data. Students can also get updates from events
around the institution such as social activities. In addition, students also have the possibilities of
communicating with the institution by sending messages and the institution can also get back to
the student via e-mails.

15
Figure 6: profile page

Figure 7: Student Result Page

16
Figure 8: Student Result Page

Still on the student profile page, it is also possible for a student to get access to his or her result
from the navigation bar. The figure below shows the result page of a student for both the exams
marks and continuous assessment marks. From the above picture, results are obtain from the school
database. Once information or result is updated into the database, it automatically appears on the
student profile of page.

Still on the student profile page, students have access to school notification and updates, and their
respective lecture time table. The figure below shows the lecture time table on the student page.

17
Figure 9: Student lecture timetable

4.2 Project planning and scheduling

4.2.1 Project planning
While planning, the web application portal a three tier architecture for application development
was followed. The presentation tier occupies the front end design of the application. It relates to
every entity with which the user interacts. It accepts user inputs and actions, and then sends this
information to the data tier through the application tier for further processing. The student course
registration portal accepts input in the form of student's personal detail, student's registration
details, faculty details etc. The second tier is application tier, it serves as an intermediary to the
presentation tier and the data tier. It applies business logic to the input received from the
presentation tier. The business logic is applied combining the information collected from upper
and lower layers of the three tier architecture. When a student or a faculty member asks for a report
to be retrieved, on the basis of this command data is fetched from the database and the required

18
business logic is applied and finally a report is displayed to the user. The third and final tier is the
data tier which is concerned with the design of the database to be used with the web application.
It is concerned with maintaining central servers and its information. The data tier is kept
independent of application servers and business logic to promote data security. The database is
developed using MySQL keeping in mind the authenticity concerns of different users. All the
necessary primary keys and access controls are depicted with utmost care.

4.2.2 Project Scheduling

This section of the project explains the different stages involved in this project from building the
Web Application and approximate duration. Several stages have been identified in the planning
and scheduling of this project, which are:

• Coding:

This project was build using HTML, HTML5, JS, PHP, MYSQLI. Theses programming languages
help in the functionality of the system.

• Designing:

Web programming has various designing methodology. To actualise this project, different types
of web design methods where used such as CSS, jQuery and Bootstrap.

• Hosting:

This project was hosted locally using MAMP server and the database was also created using the
above mention server. Tables where created, relationship, and later on connected to the to the
database using php and mysqli functions.

• Maintenance:

This stage is very important for this project to last for long. maintenance stage is the longest stage,
involves the ongoing maintenance of the project. Maintenance may require personnel to return to
an phase to perform an update. A project of such nature without maintenance stage will mean the
future of the project is not guaranteed. It will mostly concern the technical team at the different
levels involved in the administration. This team will be drilled on how to use some web languages
and hardware diagnostic tools to troubleshoot the web application.

19
4.3 Interpretation and discussion of test results
Interpretation and discussion of tests results Development of Student registration system has
greatly simplified previously complex tasks. Manual work is reduced to a large extent. The task
of maintaining huge data can now be accomplished with a few button clicks. Previously, the system
was hectic for both faculty and the students but now that it is accessible anywhere, registration
process has been simplified. The database is maintained on a central server, so that it can be
accessed anywhere inside the university by authorized personnel. Different departments can access
the data whenever required. Also, the process being simple and easy to use any student or faculty
with minimum computer knowledge can use the application easily. The user can print the final
registration card and keep the information safe with him/her. Also, this detail can be saved as a
PDF file anywhere on the computer. Further, In future we would like to recommend certain
valuable additions to the project. The most important is allowing students to submit the fees online.
This can be achieved using the services of an online payment system portal. This addition would
further reduce the student requiring, visiting the college premises physically. It would completely
automate the given system. Also, a system to digitally sign the documents can also be implemented
in future. This would enable the faculty and registrar to acknowledge the documents more securely
and reduce the security risk to valuable personal information. Entering student grades at semester
end is also recommended to be implemented in the future. Finally we can say that the Online
Student Course Registration System for Student is ready for implementation and will surely
provide the students and every entity associated with it a better experience. Although the project
is complete and ready for implementation there is always room for improvement. As this system
depends upon computer hardware, and with more and more student entries into the database there
will be constant need to update server storage. To make the system more secure, In future digital
acknowledgement signatures and SSL encryption can be implemented.

4.3.1 Testing
The compiled project was tested thoroughly using different usage environments like different
browsers, Operating Systems, hardware components and different sets of data. The web
application was found to be working conveniently. However, latest versions of the browser,
Operating System and hardware components of the computer are recommended for best results.

20
21
 CHAPTER FIVE
5.1 SUMMARY, CONCLUSIONS AND RECOMMENDATIONS
According to Smith (2002), technology, organization and people must cooperate and support one
another to optimize the performance of the entire system. Integrating the role of information
systems in the registration process of students helps to identify, correct defects, problems, and
inefficiencies. In this way, an institution can monitor as well as address its students' complaints
and develop quality improvement solutions that will increase client satisfaction. This proposed
system if implemented will allow students to register remotely without having to be physically
present on campus. This would be a huge improvement in service to students as well as cutting off
cost for the University.

Implementing the Online Registration System, the registration procedure has been simplified.
Previously student had to go door to door in order to get the documents acknowledged from the
concerned officials whereas

the currently developed system offers an efficient way to perform these operations. The students
can access the registration portal online either from a computer or a smart phone, and fill the
necessary information and submit it for further approval. This web application provides us with
ease of access, user friendliness and transparency. On the other hand, from organizations
viewpoint, it helps in maintaining transparency, data consistency, data accessibility and easy
maintenance.

Implementation of the proposed system will reduce the workload of all those involved as the data
can be now managed with proper authentication and authorizations instead of being hard copied
and accessible to everyone. This system will largely save the precious time of Deans, Advisors
and Accounts Officers, Instead of explicitly signing every document; they just have to
acknowledge entries online with the click of a mouse. All the technologies i.e. PHP, Apache and
MySQL used for current system design are open source and hence freely available for download.
PHP provides a strong platform for creating the visual front-end of the web application and PHP
combined with HTML provides a very flexible development environment. For the purpose of
fulfilling Web Server requirements XAMPP was used, which is again Open Source and is

22
supported across multiple platforms. In order to maintain visual consistency jQuery was used for
simpler implementation of certain features. For constant testing, analysis and execution needs,
Firefox and google Chrome web-browsers were used. With a combination of all these technologies
i was able to create a web application environment that is efficient and consistent enough.

The primary objective this internship project and development was to automate student registration
procedure. It has been achieved successfully and the system is tested to be working efficiently.
Online application of the whole system helps easy access to the system anywhere. Physical
presence of the student is not required. The time taken for process completion is now largely
reduced. After registration the database is automatically updated at the end of process completion
removing the hassle for department officials who had to enter the data manually. As the database
is managed through MySQL, data duplication is eliminated and thereby reducing chances of error.
Also data can be now be easily retrieved, edited and printed whenever required. Authentication
based access proves to be more secure than manual system. The data is maintained on a central
server and is distributed among different departments as per requirement and copies of this
database are maintained on backup servers. Also, database access is authorized and cannot be
viewed or edited by unauthorized personnel. So, this automated and computerized system is safe,
fast and user friendly.

23