pdf file

E-yojna Assistance and computerization of Swarnjayanti Gram Swarozgar Yojana through it:

Analysis, Development and Implementation
 

 

 

 

 

 

Researcher

Dhiren B. Patel

 

 

 

 

 

Guide

Prof. B. V. Buddhdev

Professor and Head of MCA,

Computer Engineering Department,

L.D. Engineering College,Ahmedabad.

 

 

 

 

 

 

A Thesis prepared for Ph.D. in Computer Science, Gujarat Vidyapith

2005

 

 

 

 

 

 

Computer science Department

Mahadev desai samajsava mahavidyalaya

 

pdf file

ABSTRACT

 

          Before Independence, there was a wide difference between the poor and the rich in Indian society. This was originated specially due to analysis of different kinds of works for different groups (“Varna Vyashtha”). In this system, your work is fixed from your birth and your income against your work from the total productions of village is definite

Therefore there wasn’t unemployment. Not only this, there was a system in which the rich people gave some amount and grains to people doing some works on occasion and festival’s days. In this way poor people got the benefits from society. Now a day, this system does not exist. So the government declares different Yojnas and the poorer will take benefit of these yojnas.

 

          Approximately more than 70 % people of total population of India live in villages. Considering this fact the Ministry of Rural Development (MoRD), Government of India declares and implements different yojnas to uplift the lower level or poorer. Besides this, new yojnas are also added time to time as per requirement. Government also closes the yojnas which are already finished and not required. The fund required for these yojna’s is fulfilled by the Government and International Banks (Global Banks).

 

          The Ministry of Rural Development (MoRD) is divided in three different divisions. They are as follow:

(1) Department of Rural Development (DRD)

(2) Department of Land Resource (DoLR)

(3) Department of Drinking Water Supply  (DDWS)

 

          The State Rural Development Department (SRD) at state level, District Rural Development Agency (DRDA) at district level, Taluka Panchyat at Taluka level and Gram Panchyat at village level are working to assist the Ministry of Rural Development.

 

          The procedure to integrate and maintain these works from people by the Government is going to be complex and expensive. There are inventions of various technical instruments like computers, internet and mobile phone. There are possibilities that these technologies can reach to common people of society. Therefore the E-Government projects are started to reduce the complexity of various yojnas of Government with the help of computer, internet and the mobile phone.

 

          A model developed by the use of the latest instruments which make various government dealings (transaction) transparent, fast, accurate through use of Government information and communication technologies, is called E-Government.  Thus with the help of E-Government, a model can be prepared through which Government’s activities and works become simple, fast, effective and quick replying.

 

          There are many yojnas running by the Government of Gujarat. It is difficult for common people to know about the yojnas which satisfy their requirement. Therefore the people reduce their requirement and gain less benefit by selecting another yojna instead of those which are more useful for their requirement. Thus the common people will not take suitable benefit due to lack of information about various yojnas. So it is very important to prepare a procedure which will take information about people into computer and do necessary procedures for taking decision about better yojna.

 

          Considering the main aim of yojnas, that is, to uplift of backward class people, almost all yojnas, are mainly for schedule tribe, schedule caste and baxi punch people. Some yojnas are for specific castes only. While in other yojna some percentage of reservation for specific castes is compulsory. The women, physically handicapped people, people living below the poverty level and families having poor economical conditions are also covered in many yojnas.

 

          In E-Yojna Assistance, people or group want to take advantage of yojna then it is necessary to know the caste, sex, physical disability and economical conditions. In some yojnas, it is necessary to know whether people or group belongs to self-help group or milk mandli (agency). Knowing these types of facts E-Yojna Assistance try to study (calculate) presently running yojnas and give proper guidance for better selection.

 

          The people or group requires mostly subsidy or loan from the yojnas. The following are the basic causes for their requirement.

-        For earning.

-        To increase working capital for small scale business.

-        To build residence.

-        To buy fertilizer, insecticide, pesticides, and seasonal seeds.

-        During failure of crops.

-        For study and higher education of their sons/daughters.

-        Social occasions of families.

 

Besides these, loan or subsidy is required for the group work like

-        To construct roads.

-        Well & tube well construction and repairing (to take it interior).

-        To purchase required instruments for milk agency.

-        Street light, road light.

-        Primary school.

-        Public library.

-        Public latrine.

 

          Thus we can conclude that the loan given to particular man is less than that given to group.

          A model has to be prepared through which, a common man can understand about yojna which is more useful as per his requirement without taking the help of other. A use of computer to take decision is not final one. But computer can be helpful for solving their difficulties in yojna’s selection procedure.

 

          A list is prepared about beneficiaries of all yojna. Also a list is prepared about information regarding the users of these yojnas and what is a minimum requirement for use of yojna. If a person uses yojnas as per required parameters, then list shows the information about benefit (subsidy, loan) of that yojna. In case there are more than one useful yojnas for person, it is good to show information about next yojna when he/she does not select first yojna. The procedure is continued till a person selects a specific yojna.

 

The Yojnas selected for study are as follow:

(1)      Swarnjayanti Gram Swarozgar Yojana (SGSY)

(2)      Indira Awaas Yojana (IAY)

(3)      Credit-Cum-Subsidy Scheme for Rural Housing

(4)      National Social Assistance Programme (NSAP)

(5)      Employment Assurance Scheme

(6)      Development of Bee Keeping for Improving Crop Productivity

(7)      National Physically Handicapped Finance and Development           Corporation

(8)      Pre-Matric Scholarship to the children of those Engaged in Unclean Occupations

(9)      Pre-Matric Scholarship for other Backward Classes

(10)    Grain Bank

 

          After studying the information regarding the various yojnas, the factors affecting these yojnas are as follow:

 

1)    Member of SHG                

2)    BPL                         

3)    Schedule Caste        

4)    Schedule Tribe

5)    Female

6)    Physically Handicap

7)    For Group

8)    Farmer

9)    Maximum subsidy

10)  Maximum Loan

11)  Housing subsidy/Loan

12)  Training subsidy

13)  Age

14)  Yearly Income

15)  Educational Qualification.

16)  Technical Qualification

17) Technical Experience

18)  Work Experience

19)  Education & Study Standard

20) Staying in hostel

21)  Working Days/Year

22)  Family wise number of person getting work

23)  Time Limit

24)  Person from drought prone, desert, tribal and hilly area

25)   Unclean Occupations

 

In this study, various tabulated information are prepared as follow.

-        List of essential/compulsory factors for yojna’s selection.

-        List of optional factors for yojna’s selection.

-        List of economical benefit for yojna’s selection.

-        List of all yojna and all effecting factors.

-        List of all yojna and maximum weighted indexes of all effecting factors.

-        Table of standard about yojna’s selection.

 

          To prepare the weighted index table, all points are mentioned in detail. Above mentioned points are also useful to prepare factors & its weight value for new yojnas in future.

 

          In the study The answers (information) generated from this mathematical model using mathematical information by traditional difficulties are explained using three different examples.

 

          To find shortest path from the graph showing weighted cost to each path is normal practice. Like this, a graph is also prepared to show the yojna and its factors relationship (weight). It is easier to understand graph showing information about weight.

 

          Implementing this prepared model, information from people is gathered about the affecting factors of yojna. This information is converted to a simple form so that common people can understand.  Here all forms are prepared in regional language (in Gujarati). The people from out of Gujarat State are also living in Gujarat. Therefore the first form of E-Yojna Assistance is designed in such a way that it display this in Gujarati or Hindi language.

 

          The information regarding various forms of E-Yojna Assistance is given. Besides these, information about different tables like form_table, yojna_name_tab, field_name_tab, type_name_tab, weight_table, parameter, yojna_info and all_calc_tab are also shown.  E-Yojna Assistance calculates from Information gathered from people and from database of yojna information. It is explained with the help of program codes.

                                                                         

          There are two possibilities after completion of calculation. To see the information generated from calculation or to see the list of selected yojna after calculation. Normally people desire to see the list of selected yojna after calculation. Both possibilities are explained using the program code.  In second choice, yojnas are listed either in ascending or descending order of calculated weight value. One can see the information about the loan and subsidy value for particular yojna, when one can change the yojna selection from drop-down list.

 

          The complete details regarding a specific yojna is available by selecting a yojna from the list prepared by E-Yojna Assistance. People and officers need not remember the changes which are made off and on in yojnas. After looking selected yojna’s information if that yojna is appropriate for them then they can see the selected yojna website (if website is prepared).

 

          Information regarding the E-Yojna Assistance System is prepared in the form of Algorithm flow. So that one can use this algorithm flow to make changes in future.

 

          A person can get more benefit if yojna selected by E-Yojna Assistance is being computerized. In the study, instead of computerizing all yojnas, Swarnjayanti Gram Swarozgar Yojana (SGSY) is computerized. The primary information regarding Swarnjayanti Gram Swarozgar Yojana (SGSY) and primary information regarding Self-help group (an important factor of this yojna), is given. After that the information regarding the computerization of Swarnjayanti Gram Swarozgar Yojana (SGSY) is also given.

 

          Swarnjayanti Gram Swarozgar Yojana (SGSY) computerization is divided in seven menus. They are as follow

-        Administrator

-        New Member or group

-        Loan application

-        TDO

-        Meeting

-        Report

-        Difficulties

 

          An administrator menu is again divided in six submenus. They are as ‘District’, ‘Taluka’, ‘Village’, ‘BPL information’, ‘Yojna Fund’, ‘Bank’. The ‘Yojna fund’ is again subdivided into ‘Allocation of yojna fund’ and ‘payment of yojna fund’. The ‘Bank’ is also subdivided into ‘Bank information’ and ‘Bank A/c Information’

 

          The ‘New member or group’ menu is also divided into ‘New Member’ or ‘New Group’. The ‘Meeting’ menu is divided into three submenus. They are

·       Information before group meeting.

·       Information after group meeting.

·       Group meeting analysis.

The ‘Report’ menu is also divided into ‘Loan form’ and ‘TDO form’.

 

          Information about computerization design of Swarnjayanti Gram Swarozgar Yojana (SGSY), various forms and affected database tables is given. The distribution of amount as per village can be achieved automatically, if we enter the amount granted for allocation and paid by Central and State Government.

 

          The first time users of this system should provide the full information regarding these. But when user uses this system next time, the information that is entered before is utilized. In this way the system saves time. As per example, if a person required a loan, then he/she should fill up the form for the earlier given information. But he/she will make changes in the already filled form.

 

          To make ‘self-help group’ more simple, the various information about group meeting are stored in this system. They are as follow

-        Points of group meeting.

-        Number of present members in meeting.

-        Number of members accepting or rejecting the meeting points.

Also evaluation process of self-help group’s is prepared.

 

          If computerized complete system is implemented then it is good. But currently by protocol, printed form on paper is only accepted at Government office. The facility is also provided in this system to print the duly filled prepared form. Via ‘Report’ option of the system, one can print a form with the help of ‘Loan Form’ and ‘TDO form’

 

          The ‘Unicode’ is used to display the form in Gujarati during the study. The Unicode Gujarati font ‘Shruti’ is used for Gujarati language. The Unicode Hindi font ‘Mangal’ is used for Hindi language. Microsoft Visual Studio .Net 2003(Microsoft Development Environment 2003 Version 7.1.3088 and Microsoft .Net Framework 1.1 version 1.1.4322) is used for preparing all programs. VB.NET language is used to prepare ASP.NET programs. A form can be easily made with Visual Studio. A form is saved as Unicode (UTF-8 with signature) - Codepage 65001 when UNICODE is used in the form.

 

          A multilingual facility of ASP.NET is used to display the First form of E-Yojan Assistance either in Gujarati or Hindi. It is explained how resource file is prepared and how the information is written in resource file while using Gujarati or Hindi Language. How to use this prepared resource file is also explained. Once prepared resource file we have to use in program that is explain with the code.

 

          Normally Crystal Report is used to prepare the report in ASP.NET. This is also explained how to use this facility. Crystal report has some limitation, for example after filling information in a Swarnjayanti Gram Swarozgar Yojana (SGSY) loan forms, we required report of that information in Gujarat. It is not possible by crystal report but it is solved by normal ASP.NET form.

 

          HTML objects are used in place of WEB form objects in all most all forms. The reason for using HTML objects is mentioned. To get quick response without accessing server, Java script is used in many forms. As per example while filling the Swarnjayanti Gram Swarozgar Yojana (SGSY) loan form, the amount is to be given for three different loans but when any one of amounts is entered then the total amount is to be displayed in form as words. This requirement is achieved by function using Java Script which convert the figure to word in Gujarati.

 

          Normally a common person is going to use the computerized Swarnjayanti Gram Swarozgar Yojana (SGSY). So a special facility of audio sound is provided. An audio sound facility is used for information while filling the field of the loan form for Swarnjayanti Gram Swarozgar Yojana (SGSY). Logic is also developed so that a common man can hear total amount while filling the loan form. The code for audio sound is explained in study report.

 

          The hardware and software used in this system is explained. Initially to use open source software, a program development is started in JSP. Due to various difficulties in the Java technique, later on the system is developed using the ASP.NET of VB.NET language. Microsoft Visual Studio .NET 2003 is used for that purpose.