INDUSTRIAL ATTACHMENT REPORT Submitted by
KAPPO OBAFEMI SETONJI MATRIC NO: 070541027 COURSE CODE: CSC 299
AT IBA LOCAL COUNCIL LCDA, IBA Period of Attachment: 3.11.2008 – 30.1.2009
TO The Department of Computer Science
Lagos State University, Ojo 2009/2010
SUMMARY This Industrial Attachment Report describes the experience of my attachment with IBA LOCAL COUNCIL DEVELOPMENT AREA between 22, Nov 2011 to 15, April 2011. Iba LCDA is a among the new 57 local councils created during the Asiwaju Bola Ahmed Tinubu regime as the Lagos state Governor in 2006. It has an IT department that manages their network and resources (hardwares) and also Software that would be used in the development of many network facilities within the office premises and also a lso to connect with other LCDAs and the state secretariat at Alausa.
During the attachment, we were required to familiarize ourselves with network Simulations data structures and hardware resources an d also configuration of a
small network. Our team managed to make headway even as the office managed minimum amount of information technology as most of their works where based on account transactions and mails forwarding. Most of our jobs were done using Microsoft Office application but Excel was more required
because we had to balance accounts. This is to put you through on how to create a balance sheet using Microsoft Excel.
ACKNOWLEDGEMENTS I would like to acknowledge MR. SAMUEL ODU for his supervision of the Industrial Attachment, for his support of the project and for his confidence in allowing us have freedom in our research and development endeavors. I would also like to especially thank MR BADRU for his expert knowledge and great Willingness to help and to work hand-in-hand with us, without which we would not have made such headway in our research.
Lastly, I would like to acknowledge my fellow workmates Tobiloba Badru, Omotayo Erinle, and Segun Joshua whom have been on the same team with me and whom I had the pleasure of working with.
Industrial Attachment Programme SIWES is an acronym, which means Student Industrial Working Experience Scheme. The scheme was introduced by ITF in early 1970s in order to overcome the problems of inadequate practical skills preparatory for employment in industries by Nigerian graduates of higher institutions. The Scheme exposes students to industrial based skills necessary for a smooth transition from the theoretical aspect to the practical world. It gives students of higher institutions the opportunity of being familiarized and exposed to the needed experience in handling machinery and equipment which are usually not available in their institutions. Participation in SIWES becomes necessary pre-condition for the award of diploma, NCE and degree certificates in specific disciplines in the universities, colleges and polytechnics across the country, in order to comply with the educational policy of the country. Besides, the program being part of the curriculum of institutions of higher learning as part of the
needs for a successful completion of the degree, diploma and NCE program. As part of this program, students are to undergo training within a minimum duration of four months for polytechnics and colleges of education, and six months for the universities in various industries and organizations depending on their fields of study to give them a practical feel of the knowledge they have acquired in school. One of the major problems of this program is the inability of students to secure placement in a suitable company where they can obtain good machinery and working experience that is related to their discipline. Even in situations where a good company with the availability of the right work environment is obtained, students often find themselves being used for menial jobs. This also has led to the school requiring every student to submit a written SIWES report on completion of their program in addition to the log book where the student records their day to day activities from the beginning to the end of the SIWES program to the department. This attachment is scheduled to be from 3 November 2008 to 30 January 2009.
AIMS AND OBJECTIVES OF SIWES According to Federal Government in its Gazette of April 1978, the aim objectives of SIWES are as follows:1. To prepare student for the work situation they are likely to meet after graduation
and
provide
student
an
opportunity
to
apply their theoretical knowledge in real work situation.
2. To expose students to the working environment so as to learn the method and techniques in handling equipment and machineries that may not be available in their school.
3. To provide opportunity to student to put their knowledge into practice there by bridging the gabs between the class work and the real-life application.
4. Provide an-avenue for the students in high institution to acquire industrial skills and experience in their respective course of study.
COMPANY Iba LCDA is among the new 57 local councils created during the Asiwaju Bola Ahmed Tinubu regime as the Lagos state Governor in 2006. The council was headed by Hon. Toyin Isiaka Suarau as the Executive Chairman and Princess Ramota Oseni Adeyeri as his Vice Chairman.
Excel Tutorial Excel is a spreadsheet. That means that it is a software package that can be used to do a lot of mathematical calculations in table format. It can also do a number of other things. In the course of the worksheets for this course, we will use Excel for a number of things. We will use it for practice problems, explorations, and projects. We will start off looking at some of the basics of Excel as the Industrial Training Officer Commenced(ITO). At the top of Excel you will see the menu bar.
The menu bar contains many of the same menus as do other Microsoft programs. Just below the menu bar, you will see toolbars. Exactly what you see on the toolbar may vary, depending on how your particular computer has been set up.
Again, many of the items on the tool bars will be the same as in other Microsoft programs.
Now on to some things that are more Excel specific. The main units for work in Excel are the "cells." These are the boxes that in which you will enter your data or text. Each cell has an "address" made up of a column letter and a row number. The one at which the arrow is pointing in this picture is cell A1. The cell addresses are important for finding data and for doing calculations.
The column names start with A, B, C, and on to Z. The next is AA, then AB, on to AZ. Then follow BA, BB, and so on until we finally get to column IV. That is a total of 256 columns. The rows range from number 1 to number 65536. That gives us a total of 16,777,216 cells on each work sheet. The line below the tool bars is called the command line.
The command line shows the things you will type in cells. Each Excel worksheet contains three or more "sheets." When the program opens, you will generally be on Sheet 1. You can move from one sheet to another using the "tabs" at the bottom of the Excel screen.
Entering Data
Entering data or text into a cell is simply a matter of clicking on the desired cell and typing the desire input. You can always use the tool bars to make numbers or text in bold type or italics or various sizes.
The place where Excel comes in really handy is in doing arithmetic that you may find of interest with such a chart. For example, suppose you wanted a column to the right of Dave that shows the total cars sold by the four salesmen in each month. Putting a heading on that column for Monthly Sales and click on cell G4, where we would want the sales total for January. Any time you want Excel to do a calculation, you will start by typing an equal sign (=).
Then, you want to tell Excel what calculation you want done. In this case, we want the data in cells C4, D4, E4, and F4 added together. There are several ways to do this. One would be to simply type "=C4+D4+E4+F4." For short sums like this one, that is not a bad way to go. However, suppose we wanted to add up numbers from 25 columns. Typing in the address of each individual cell would be very tedious and time consuming. Instead we can use some built in functions. Since we are interested in adding the data values, the command "sum" will be the one we want. The syntax for the command, when wanting to add a group of cells from a particular row or column is as follows. We want to add all of the entries in row 4 from column C to column F so we type
=sum(C4:F4)
Excel has many, many built in functions. We will look at others as we make our way through these exercises and tutorials. A discussion of some of the more common ones is at the end of this tutorial.
Notice that Excel highlights the cells you are referencing. Next, hit enter and you will see the sum.
What we want to do next is the same thing in row 5, then row 6 and row 7. There are two ways to do that. The most obvious way is to go to cell G5 and type "=sum(C5:F5)" and repeat the process in rows 6 and 7. That will definitely work. Again, however, Excel has a way that makes it easier when you want a sequence of cells to have commands identical (except for row or column address) to that of
another cell. Click on the cell containing the formula you want to replicate. In this case, that is G4. Hold the shift key down and use the down arrow to highlight the other three cells in which you want the identical formula used.
Now, on the menu bar, click on Edit, then choose Fill.
We want to fill the cells down from the starting point so choose Down. Once you do that you will see the sums materialize in each cell. The "Fill" command takes whatever is in a cell and copies it to the highlighted cells. If it is a formula, "Fill" will adjust the formula to apply it to the various rows or columns occupied by the highlighted cells.
If you were to click on any of cells G5, G6 or G7 and look at the command line, you would see the formulas for each row.
As practice, see if you can put commands in row 8 that will allow you find the total sales by each of Allan, Bob, Charlie and Dave, and the total of the monthly sales for the four months. You should end up with something like this.
Notice three buttons on the right hand side of the second tool bar. The first button allows you to put borders around cells. The second allows you to color the cells. The third allows you to change the text color.
Another item that will also be helpful is another means of formatting cells. If you right click on a cell, a menu of options will come up.
From that menu, choose Format Cells.
From this window you have a number of options for doing different things to cells. "Border" will allow you to put borders of varying thicknesses around cells. Experiment with these as well. You can do a wide variety of things to make your spreadsheets look more attractive.
Notice on our spreadsheet, the words "Monthly Sales" do not fit in their column. Move the cursor on to the line between column headings G and H. It should change into a cross-like shape. Click and hold the left mouse button. Slide that line to the right to widen the column.
Putting all of this together with some other formatting from the tool bars gives something like this.
This is enough to get you started in Excel so Mr. Samuel Odu said.
FINDINGS / PROBLEMS ENCOUNTERD IN SIWES LOCATION The following, were the findings/problems encountered at during my training 1.
None payment of allowance to students.
2.
None visitation of Industrial training Fund (ITF) representative based supervisors to students on attachment was absent.
3.
None provision of accommodation to I.T students industrial work experience scheme (SIWES) is very important and can never be over emphasized. The impact of students educational advancement in environments therefore it needs to be taken seriously.
As part of its aims and objective to expose students work method and techniques in handling equipments and machines that are found in the university. It therefore prepares students to what they are likely to meet after obtaining the bachelor degree. It would do the students a whole lot of good if the (NUC) and industrial training fund (ITF) can continue and implement or sustain the continuity of this program.
ADVICE FOR THE FUTURE PARTICIPANTS Since knowledge is indispensible, future participants of SIWES program should; 1. Use the opportunity to acquire possible knowledge of the industry that they might require in future during the program.
2. Not be after the dividends or stipends but be all out to please those that are above them in authority, and also to develop lasting personal relationships with the members of staff. If they do these things, they will enjoy the benefits that the SIWES program has to offer. I wish them all the best.
ADVICE FOR SIWES MANAGERS It is obvious that SIWES has done their best in putting the programs together but there is also room for improvement. On this note, I will like to make some suggestions that will be of relevance for the advancement of the scheme.
1. Laxity in handling the SIWES program by not keeping setting standards should be dealt with.
2. SIWES should try as much as possible to provide places of attachment for the future participants by sending recommendation letters to various companies, not withstanding population density.
3. SIWES managers should do all in their powers to ensure that the students are visited and monitored during SIWES period.
4. SIWES managers should make sure that students allowances are paid to them in due time. This will go a long way in the improvement of the output quality and efficiency of the graduates in the society.
OVERALL BENEFITS OF THE SIWES PROGRAMMES
1. It helps in the improvement of the technical know-how of the student. 2. It increases the students’ efficiency and output quality in industries. 3. It helps the students acquire practical skills needed in industries. 4. It exposes the students’ academic learning and theoretical knowledge in practical
form.
5. It increases the students’ productivity in the industries after graduation.
RECOMMENDATION Students Industrial Work Experience Scheme (SIWES) is
very important and can
never be over emphasized. The impact of students educational advancement is enormous therefore it needs to be taken seriously.
As part of its aims and objectives to expose students to work method and techniques in handling equipments and machines that are not found in the University. It therefore prepares students to what they are likely to meet after obtaining the bachelor’s degree. It would do the students a whole lot of good if the (NUC). And industrial training fund (ITF) can continue and implement or sustain the continuity of this program.
CONCLUSION The SIWES has positively contributed to my training and my future based on my experience during the program I have gained more knowledge related to theoretical knowledge as little as it may seem to be, but I know by the grace of God I can make fortunes out of this.
KAPPO OBAFEMI SETONJI 070521027
