CHAPTER ONE

1.0 INTRODUCTION TO SIWES

Students Industrial Work Experience (SIWES) is it is fondly called is a skill training programmer
designed for students of technology based institutions of higher learning which includes
Polytechnics, Colleges of Education and Universities in order to meet the demands of the
employers of labor. The scheme became fully effective in 1985 and since then it has been
managed by the Federal Government of Nigeria.

1.1 SIWES AIMS AND OBJECTIVES

The scheme is aimed at the following;
1. To provide the students with an opportunity to apply their knowledge in real work
situation thereby bridging the gap between college work and actual work.
2. To access the student’s interest and suitability for occupation they have chosen.
3. To make the transition from school to the world of work easier and to enhance the
students contact for later job placement.
4. To enhance industry’s satisfaction with certificates from institutions of higher
learning.
5. To expose students more to their field of study.
6. To expose the students to work methods not taught in the institution and provide
access to the production equipment not normally available in the college
environment.

1.2 JOB SPECIFICATION FOR COMPUTER SCIENCE DEPARTMENT

Computer Science as a department has varieties of job specifications of which few are listed
below.
Software Development
1. Web Development
2. Database Administrator
3. Computer Networking
4. Network Analyst and Administration
5. Server Administration
6. CCTV installation.
1
 CHAPTER TWO
2.0 ORGANISATION HISTORY
Xpat Integrated System is located at Onikolobo opposite Abeokuta Girls Grammar School
(AGGS) Abeokuta, Ogun State is an information and communication technology firm that
provides services like Software Development, Web Development and Database Management and
IT Consultancy.
Xpat Integrated System is made up of two main departments which are Web Department and
Programming Department which is sub divided based on language specified for each department
which are C# and Java. All these departments work together to achieve a reputable, brilliant and
intelligent solution in information technology.
Xpat Integrated System was founded by Mr. Akintunde Akinwunmi in the year 2012. The
Operation section of the organization is headed by Mr. Fayipe Taiwo and Mrs Fatokun
Adebukola as the Account Manager. It’s sub-divided into Training sections which is monitored
by Mr. Akinwunmi Oladele.
The Training Sections consist of the following department:
1. Software Department
2. Web Department
3. Database Department
Each department above has its own area of specialization which reduces workload and also to
avoid redundancy of function. The function is of each section with the organization include the
following:
1. Software Department: This is sub-divided into C#.net development department and Java
development. It involves both development and deployment of desktop applications. This
department consists of programmers which include Mr. Olabode Oyinkansola for C#.net
Programming and Mr. Showole Sheriff for Java Programming,
2. Web Application Department: This department sees to all development of web service
applications and mobile applications respectively using different frameworks. It involves
both development and deployment of web service applications. This department is head
by Mr Akinwunmi Oladele
3. Database Department: This department specializes in the installation and configuration of
database servers and services within and outside the organization which is monitored by
Mr. Olabode Oyinkansola.

2
All the departments listed above also train interested individuals to a professional level based on
the individual’s area of interest
2.2 ORGANISATION CHART

MD/CEO

TRAINING MANAGER SERVICES OPERATIONS

MANAGER MANAGER

TEAM LEAD,
TEAM LEAD, TEAM LEAD, TEAM LEAD,
MAINTENANCE TEAM LEAD,
TRAINING PROJECTS ADMIN
DEPARTMENT ACCOUNTS
DEPARTMENT DEPARTMENT

RECEPTIONIST
TRAINING
FACILITATORS
TEAM LEAD, TEAM LEAD, TEAM LEAD,
SOFTWARE HARDWARE NETWORKING

MOBILE APP STANDALONE COMPUTER SECURITY TEAM

TEAM APP TEAM NETWORK (Intercom,
TEAM CCTV…etc)

WEB APP
TEAM

3
2.3 RULES AND REGULATIONS

1. Do not remove /change any of the Computer Components such as the Keyboard, mouse,
monitor or cables.
2. Sitting next to friend who is more likely to distract you is strictly prohibited.
3. Do not plug-in any charger on the mounted switches or removes the computer power cables.
4. Adhere strictly to your lecture time to avoid embarrassment.
5. Always bring your identity card to the class and show it with no hesitation upon request..
6. Noise making and chattering during lectures is highly prohibited.
7. If your assigned system develops fault or malfunctions, do not try to troubleshoot, rather call
the attention of your instructor.
8. Do not linger around the premises if you have no class.
9. Report any act of misconduct to the management.
10. NOTE THAT VIOLATION OF ANY OF THESE SET RULES WILL ATTRACT
APPROPRIATE PENALTY.

4
 CHAPTER THREE
3.1 INDUSTRIAL WORK EXPERIENCE
During the Student Industrial Work Experience Scheme, in C#.net Development Department, I
was taught the history of the programming language and also introduced to the areas of
application of the programming language in which I was able to learn two areas perfectly well
which are:
1. Console Application and
2. Windows Form Application
BRIEFY HISTORY OF C#.NET
C# is a general-purpose, object-oriented programming language. It was developed by a team led
by Anders Hejlsberg of which the most recent version is C# 7.2, which was released in 2017
along with Visual Studio 2017 version 15.5. During the development of the .NET Framework,
the class libraries were originally written using a managed code compiler system called Simple
Managed C (SMC). In January 1999, Anders Hejlsberg formed a team to build a new language
at the time called Cool, which stood for “C-Like Object Oriented Language". Microsoft had
considered keeping the name "Cool" as the final name of the language, but chose not to do so for
trademark reasons. By the time the .NET project was publicly announced at the July 2000
Professional Developers Conference, the language had been renamed C#, and various class
libraries had been ported to C#.
C#.NET CONSOLE APPLICATION
During the period attached to learning the console application i was able to understand the basic
keywords attached to C# as a language the control structure which include the conditional
statement and iteration statements. Also, I was able to run my C#,net code using Developer’s
Command Prompt instead of the conventional Visual Studio IDE and also change the
background color of Command prompt and also the foregroundcolor instead of using command
prompt commands like
Color 02
Color 02 will change the background color to black and the foregroundcolor to green. In order to
achieve this with C# console I will write the following lines of code
using System;
public class Xpat{
public static void Main (string[] args)

5
{
Console.Clear();
Console.BackGroundColor = ConsoleColor.Black;
Console.ForeGroundColor = ConsoleColor.Green;
Console.ReadKey();
}
}
C#.net is very case sensitive that is why some of my syntax above happens to be lowercase and
the other in uppercase.
C#.NET CONSOLE CONDITIONAL STATEMENT
The conditional statement used must time by me happens to be the IF STATEMENT which
syntax goes thus;
if(condition) {
//struct
}
Syntax for IF ELSE STATEMENT
if(condition){
//struct
}
else{
//struct
}
Syntax for IF ELSE IF ELSE STATEMENT
if(condition){
//struct
}
else if(condition){
//struct
}
else{
//struct
}

6
C#.NET CONSOLE ITERATION STATEMENT
The iteration statement used must time by me happens to be the FOR STATEMENT which
syntax goes thus;
for(start;condition; stop){
//struct
}
At the end of this program, I was able to write and develop console applications example are:
1. Console Text To Speech Application
2. Stimulation Of An Automated Teller Machine.

C#.NET WINDOWS FORM APPLICATION

After the period for console application lapse i was introduced to the Graphic User Interface
(GUI) which is the windows forms. My instructor tends to take me in more advanced way as an
upcoming developer who tends to know the basics. I was introduced to the controls which are of
different types and perform different operation some of the controls I worked with are
1. Trigger Control: These controls are used to perform operations when triggered by
creating an event for the them example is Button, CheckBox, RadioButton etc.
2. Data Control: These controls are used to handle users data example of such are
DataGridView, ListView etc.
3. Input Control: These are the controls used by me to accept certain input from the user
which are in varieties of forms examples are TextBox, RichTextBox, ComboBox
CheckBox, RadioButton etc.
4. Output Control: These are the controls used to give a certain output to user after
processing a certain input or a means of intro example include Label, TextBox etc.

3.2 PRACTICAL AND ASSIGNMENT PERFORMED.

One of the lists of practical and assignment done during the SIWES period are:
1. Connecting To Database From C# using MySqlConnector
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
7
using System.Threading.Tasks;
using System.Windows.Forms;
using MySql.Data.MySqlClient;

namespace Airline_Reservation_System
{
class Database
{
MySqlConnection Connection = new MySqlConnection(); MySqlCommand Command;
MySqlConnectionStringBuilder Builder; string Query; MySqlDataReader Reader;
//
// Method To Create The DataBase Connection
//
public void ConnectDatabase()
{
Builder = new MySqlConnectionStringBuilder();
// Connection.Database = "Airline";
Builder.Server = "localhost";
Builder.Database = "Airline";
Builder.UserID = "root";
Builder.Password = String.Empty;
Connection = new MySqlConnection(Builder.ToString());
try
{
Connection.Open();
}
catch (Exception ex)
{
MessageBox.Show("Unable To Connect " + ex.ToString());
}
}
//

8
 // Method To Insert Into Table Awareness
// Creating Notice....
//
public void InsertValue(string aware,int id)
{
try
{
Query = "insert into awareness values (@awareness_text,@id)";
Command = new MySqlCommand(Query, Connection);
Command.Parameters.AddWithValue("@AWARENESS_TEXT", aware);
Command.Parameters.AddWithValue("@ID", id);
Command.ExecuteNonQuery();
MessageBox.Show("Notice Has Been Updated Successfully", "AirLine Reservation
System",MessageBoxButtons.OK,MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show("Error In Inserting Details " + ex.ToString());
}
}

9
2.0 Airline Reservation System Using GUI

APPLICATION SCREENSHOT:

Fig 1.0

This the first screen of my application which is called the SPLASH SCREEN this introduce the
user to the application being launched

Fig 2.0

10
This the second screen of the application named airline reseravtion system which is also the
welcome page.

Fig 3.0

This the book flight page where client details are requested for in order to reserve an airline seat
on their behalf.

11
 Fig 4.0

These the page in which admin adds a new flight information and also update the status of a
particular flight to show if it’s available or not.

3.3 CHALLENGES

The main difficulty encountered while working on my project was when I want to link my
project to the database and also my instructor told me to redesign my interface which took me a
lot of time before coming up with this.

12
 CHAPTER FOUR

4.1 PROBLEM ENCOUTERED

The major problems encountered was lack of finance, i.e inability to pay the Training Fees on
time, Trying to debug codes when certain work is given, and lastly lack of personal system
during the early weeks of the training.
4.2 RECOMMENDATION
With all the experiences I have gained during my training and some skill that I have acquired.
Therefore, I am recommending the Student Industrial Work Experience Scheme (SIWES) to the
entire Science Student in every institution not to take it with levity.
4.3 CONCLUSION
Many things were learnt during the Three month of my Student Industrial Work Experience
Scheme at Xpat Integrated System. The whole training period was very interesting, instructive
and challenging. Through this training I was able to gain new insights and more comprehensive
understanding about the real industry working condition and practice. I am very sure that the
Siwes program has achieved its entire primary objectives. It’s also the best way to prepare
Students to face the real life Scenario. In short my programming career as just started.
Also, SIWES is a core course every student must study in all institution in order to give the
student industrial knowledge about their various discipline and in building their profession.

13